I have a spread sheet with my current open positions on it.
At the moment I manually update the "Last Price" field at the end of each day to then calculate my % returns etc etc.
I am aware that I can do this automatically by using the IB TWS API. I found a video on youtube (http://www.youtube.com/watch?v=S1KL-sGdgxs) that explains how to set it up.
It involves using a third party Excel plugin. Interestingly, this plugin is no longer listed on the IB software page. This, I find odd.
This Third Party Excel plugin is called IB-Excel Adapter by cyberxpert (http://www.cyberxpert.com/downloads.html)
Anyway; is there any better Excel plugins I should be using? Or a better way to do what I am trying to do?