IB with Excel

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


Any tutorials if this is possible? Thanks

 

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

 

I looked through the folders...

can you please explain which file you are refering to?

 

the one with the xls extension.

 

c:\jts\excel

look for twsdde.xls

 

i do not have an excel folder....

???

is there something that I did not turn on?

 

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

 

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.

 

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

 

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.