yes - u can pretty much use excel graphing to do anything u can imagine - including replicate professional charting packages ( in look, but the key with professional charting packages is the data, not the charting), and get plug ins to save u a lot of the work - best to do a search on google
It is amazing what you can do with excel charts. Microsoft seem to have missed a huge market. If it was easy to get live data in to excel, I would use it all the time. I have read of some people using third party software to import in to excel but it looks a bit too complicated for me. Does anyone use excel for live charts?
Not sure if this website has the answer to your question about overlays but it has helped me a lot.
Much appreciated bigbusiness & Stevet. Trying to solve it by trial & error was driving me nuts. Big business. I think Bonsai does exactly that. He seems to be a clever guy and very helpful.
I have used a live feed to DDE price data into excel for purposes of assessing indices volatility and performing live calculations on risk and bet/deal size and found it ok most of the time subject to the feed data. I have not had the time yet to convert data into charts but this is something I may move to idc. I would appreciate hearing from anyone experienced in this
you can use api/dde links etc to access some charting companies data and there are companies which only supply real time data so u have to hook into their data with your own c, vb program etc, but not much point to replicate a charting package with excel when there are so many good charting packages out there
But with excel you don't have to use the indicators that everyone else is using, you can make your own. I have been doing this for EOD charts and now prefer them to the charting packages I have looked at. I have never got on with conventional indicators but the custom built ones have helped me a lot. It also costs a lot less that the crazy prices for some charting packages.
a lot of people spend a lot of time coming up with their own indicators - and good luck to you if it works for u - but i never met a trader who works that way simply because trading is a herd thing - when u take a position - if it does not work right away - you got it wrong as everyone else should have seen what you saw - so if u have your own one off indicator - who knows - if you are lucky - you might even be right - but mostly when u take that positon - you are going to be the only one hanging your XXXX out in the wind - and when that wind is cold - it is real cold
in trading its not about being right - its about being right just at the point that everyone else agrees - dont be first - be one of the first!
Spot on.With hindsight I have spent so much time fighting with dilatory packages that I could probably have produced one to meet my particular needs in the same time and with less expense. It also gives a better understanding of what the indicators do and how - also how they might be tweaked/adjusted to work better for you
i did not say that i had not met people who talk about success with their own indicators - just that i never met a professional trader who needs or wants anything special like that - but if it works for - good on ya
but are u talking about coming up with special indicators or just using your own system to access and analyse data and automatically issue your open and close orders? - that for sure does work!
IB have socket connections, api and dde for getting data but its only real time sort of direct from exchnges so no historic data, so u miss a tick and its gone forever, and its sampled to cut down a bandwidth, so u dont get it all ( i am not technical except to the level i need to trade)
i guess u might have CQG if u have a satelite feed and they use dde - dont u just love latency? or is it another data supplier
and as you know - you are paying for the good data and the charting package is basically free - and most of the "name" packages have way way too much for a professional trader and enough for gamers to play with for sure, until they decide to stop playing and start trading