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?
