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?
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. http://www.cyberxpert.com/downloads.html
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.