I created a Stock Portfolio Tracker 5 years ago that allows you to track your portfolio based on transactions and update their prices automatically. It has since become rather popular.
You can check out
my current portfolio, using this portfolio tracker here.
To use it, you can
tune in to the instructions here.
There have been some developments recently, and I would like to update the people who are supporting this Google Spreadsheet.
SGX Stopped Supporting Google Finance
The first thing is that SGX have stopped allowing investors to use GoogleFinance() to get update to date last trading price information of their stocks.
This affected many folks including myself who rely on GoogleFinance to pull latest stock prices.
This means that you either have to rely on manually entering the prices on a frequent basis, or rely on Yahoo Finance.
Problem with Price Retrieval of Yahoo Finance
Prices at ......
MarketXLS would be great to use. I recommend it.
They have regular updates and customer support.
I had moved after Yahoo Finance API had been discontinued.