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)


The scrip code 500124 represents Dr. Reddy's Laboratories. You can use a Google Docs sheet to track stocks.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.