We carried out some changes to our Stock Portfolio Tracker. Initially, we thought automating price update daily with stock symbol from Google Finance was a good idea.
Well it turns out that if your stocks do not belong to a few selected exchanges, you would need to update the prices manually.
So we decide to see if we can get automated price update via Yahoo Finance. Turns out that although it’s awkward we were able to.
So now instead of the 2 other option you have a third and an automated one. Go to Yahoo Finance to look up the symbol of your stock. Copy it and input into the corresponding cell under "Yahoo Quote". So every time you load up the Google Stock Portfolio Tracker you can view your latest gains and losses.
We are thankful that through this method we have a larger number of exchanges ......