I have an excel file with my portfolio and I'd like it to automatically update with the latest stock prices (as it is now I copy/paste them every few days at EOD). I know this is possible with DDE & IB but I can't find any documentation on it. Can someone post an example?
Interesting. I also found this: http://twsdde.wikispaces.com/Ticker+Data+Demo for my limited needs I think this will work. I'm going to try when IB comes back online..
click the tab "Application Program Interface". http://individuals.interactivebrokers.com/en/general/education/priorWebinars.php?ib_entity=api Topic: TWS API for Beginners Duration: 30 mins Description: TWS API for Beginners explores the most user-friendly of the API-supported platforms that allow you to write custom applications that link to Trader Workstation data. This webinar will introduce the TWS user to the abilities of the TWS âApplication Programming Interface,â and will focus on the Microsoft Excel® DDE technology interface. It is designed for non-programmers who have some trading knowledge and are comfortable with Microsoft Excel®.