The comments and my messages were flooded with questions regarding why the prices in my Stock Portfolio Tracker is not updating accordingly.
I created a Free Google Sheet that helps you track your portfolio based on transactions.
You can find out more information in this comprehensive article here. Free Online Investment Stock Portfolio Tracker Spreadsheet.
I am immensely proud of my spreadsheet because back then, you couldn’t really find any spreadsheet that tracked your portfolio based on transactions. Most spreadsheets track your portfolio based on one-time buys, which is unrealistic.
My spreadsheet may give you some ideas on how to design yours.
One of the nice features of the spreadsheet is that it auto-fetch the price of your stock holdings. By default, you can rely on Google Finance’s price quote, but Google Finance’s price quote is only limited to certain exchanges.
In my spreadsheet, I show how you can grab prices from Yahoo....