I have an online share trading account in which I own a number of shares. I want to be able to get the total portfolio value automatically daily. Unfortunately my broker doesn't have an API interface. I think it should be possible to get the value using browser automation such Selenium. I can then get the value through the id of the div tag. Does anybody know what is the best way to achieve this?
Google Docs supports a spreadsheet formula called GoogleFinance. I presume it works for stock markets around the world. I tried the below formula for Dr. Reddy's Laboratories listed in the Bombay Stock Exchange (BSE)