Google spreadsheet for portfolio tracking

Below is a handy Google spreadsheet for tracking dividend stocks. It is build on two functions:

1. Google spreadsheet function GoogleFinance("symbol"; "price") is used to obtain the current stock price.

2. The dividend information is fetched from Yahoo using ImportData-function that points to "". 

In addition to tracking gain/loss, the spreadsheet compares the each investment to a broad index investment to VTI. Over a long time period, this allows for a realistic assessment whether the KISS investment strategy (or the strategy of your choosing) performs in comparison to average market.

Dividend portfolio tracker

A link for an editable spreadsheet for the above analysis is below (use save as to edit the spreadsheet):