10-22-2013, 10:02 PM
(10-22-2013, 07:17 PM)Kerim Wrote: Nice spreadsheet, Eric!
I'm pretty proud of my own, but you've got a few columns there that I hadn't thought to include. I especially like the total return column.
I forget, are you reinvesting dividends automatically? If so, how are you factoring those purchases into your spreadsheet?
Also, does google docs have an easy way to import or update the current share price? I use excel and apparently there is a way to do it, but it certainly isn't simple and I haven't been able to make it work despite some hours of effort.
I am accumulating dividends for a directed reinvestment with this account. The second tab shows the dividends received by month for each position and then I show the account cash balance at the bottom of the first page.
I hope to wait until I have about $1000 for a new purchase, but knowing myself the way I do, I'm guessing I buy something before then
