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 "http://ichart.finance.yahoo.com/table.csv?s=TICKER&ignore=.csv". 

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):

Comments