If you are unable to run TWS after installing on a 64 bit system, below are the instructions that will avoid the “missing shortcut” error that you might encounter and allow you to run TWS as expected.
- Install 32 bit Java. (remove any old java installations first)
- Install TWS (followed by the API if you are using it)
- Copy the file “Javaw.exe” from “C:\Program Files (x86)\Java\jre6\bin” and place it in “C:\Windows\System32″
- Now open from the TWS shortcut as normal.
Hi, great work and thanks for the code samples. I’ll be purchasing the automated trading platform when i can. Meanwhile a question. You are getting your data through IB’s TWS via DDE? Does this mean that I have to have an account open with IB? I don’t think that’s going to happen for a while (for me) since they require now $10K to open an account, yes? Is there any other way to secure a DDE link into Excel? I’m guessing that other ways would also involve opening an account with a broker, yes? TIA
As you are researching brokers, you will want to look for their API documentation. There are many brokers with systems in place to integrate with excel, some are easier to work with than others. (Some brokers keep the documentation somewhat hidden and only accessible to developers after submitting non disclosure agreements and personal info. ). However, the most common broker that I am asked to work with is IB. The most common data vendor is esignal with qlink (provides historical and live data for a monthly fee).
Thanks! This was very helpful.
Jan
Thanks a lot for solving a lot of headaches. :)
It works! Thanks a lot!