IB with Excel

Discussion in 'Trading Software' started by z32000, Aug 14, 2007.

  1. 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
  2. just21


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


    I looked through the folders...

    can you please explain which file you are refering to?
  4. Tums


    the one with the xls extension.
  5. c:\jts\excel

    look for twsdde.xls
  6. z32000


    i do not have an excel folder....


    is there something that I did not turn on?
  7. Did you install the API? The Excel file is included with the API and won't work without it.
  8. 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.
  9. 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.

    #10     Aug 14, 2007