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. A link for an editable spreadsheet for the above analysis is below (use save as to edit the spreadsheet): |
KISS for Investing >