IB with Excel

[z32000]

Is it possible to sync IB with Excel, so I can create spreadsheets with real-time information?


Any tutorials if this is possible? Thanks

 

[just21]

There is an example spreadsheet in one of the tws folders.

 

[z32000]

I looked through the folders...

can you please explain which file you are refering to?

 

[Tums]

the one with the xls extension.

 

[kiwi_trader]

c:\jts\excel

look for twsdde.xls

 

[z32000]

i do not have an excel folder....

???

is there something that I did not turn on?

 

[newbunch]

Did you install the API? The Excel file is included with the API and won't work without it.

 

[z32000]

the api? are you refering to the java based application that is needed in order to run IB?
I have this on 3 computers by the way and on all of them, there is no excel folder.

 

[newbunch]

There is the TWS (Trader WorkStation) software and then there is the API software. You need both.

You can get the API at http://www.interactivebrokers.com/en/control/apicontrol.php?ib_entity=llc

 

[AllenCook]

Do yourself a favor and go to the user manual and I believe the last section is "Application Program Interface" (API) and you will find all the information you need.

Quote from z32000:

the api? are you refering to the java based application that is needed in order to run IB?
I have this on 3 computers by the way and on all of them, there is no excel folder.