Viewing IB TWS data RT in Excel?

Discussion in 'Data Sets and Feeds' started by nravo, Oct 17, 2007.

  1. nravo


    I keep a fairly simple spreadsheet of my trades on Interactive Brokers' TWS, and one of my more tedious chores is updating them, either nightly or weekly. Is there a way to modify my Excel so that the cells with current price data that I plug in manually (and perhaps other cells) are updated in real time from IB? I'm no spreadsheet jockey and haven't a clue about programming, or even VBA, (although I would be willing to learn some newbie steps). Suggestions?
  2. You might look at this page; the first download may help you out. I downloaded it a long time ago but never really had a need to download info into Excel from TWS.
  3. nravo


    Thanks much. I'll give it a look when I return to the States and get a Windows machine, or retry Excel via Windows on a Mac.