If you are going to use excel for trading in real time, then I suggest you upgrade to win10 64 bit and install excel 2016 - there is a BIG difference with live data updates! Done a bit a while ago but stopped - am looking at an old VB6 programme now that was brilliant for order entry with e-minis, but will have to spend a good bit of time as my VB6 knowledge is very limited. If you want to easily setup your own trading layout that you can not find anywhere else, then excel is the way to go, as you need no programming language experience. J_S
That sheet is yahoo delayed for setup, as the conditional formatting is a bit tricky when you are not reading static numbers - the numbers and colors change automatically once you change the stock symbol, but depending on the stock price the colors are not consistent. The problem is with the conditional formatting, just didn't sort it out yet. One easy way is to have seperate worksheets, but that might slow up excel, so best to use just 1 and change the stock symbol. For live trading it can be linked to TWS or the IB Gateway - I have linked to both successfly, and even done a custom Time & Sales which works fine - also done a few more chart layouts for daytrading, but will need to dig them out to show you. J_S
If there is anyone with VB6 experience, please let me know, as I will start a new thread to look at getting old VB6 code to link with the current TWS via the API. I have tried to login to an old version of TWS, but with the new security features on my mobile phone - sDSA - it will obviously not work. I might opt out of security to test the old version login, but I have no clue if it will work. Any suggestions appreciated, as I have an old VBA programme that is brilliant for order entry with TWS - all I need to do is get the old TWS and old API working, otherwise it means changing the VBA code or converting it to another code that will link with current TWS, which is way beyond my capabilities. Thx. J_S
I think you have a re-write on your hands....unless you want to decifer IB's DDE implementation......and good luck with that. I once reviewed that code and almost threw-up....it was so bad. Another alternative is going the ActiveX route and implementing the tws.ocx component.
Thx, can you give a brief outline of what would be required to get some VB6 code that originally linked to old version of TWS ( bout 2006/7) working with tws.ocx. I am not a programmer, but dont mind getting someone to do it for me if it is not that big a job? J_S
Forget the old version of TWS....the API has improved somewhat since that time period....it's been almost 10 years. They've fixed a ton of bugs since then.... Unfortunately, it's a big job doing the conversion.
Thought as much, oh well, back to simple old excel I suppose, at least that is easy enough and you can do it yourself, which is good to keep the brain active - much more to trading anyway than some fancy code that just retrieves data and plonks it there in front of you! Pity though, as I always liked Futurestrader software - the person who developed it done so for trading the eminis himself, and it shows in the layout - not like the Gobshites who develop the TWS layouts J_S
Manageable changes. I run tons of add ins in excel 2013 and now 2016 and they work perfectly fine. In fact i write my own add ins as well via excel-DNA and they perfectly work with Excel 2016