I created a google spreadsheet template for tracking dividend income. Thought Iād share it here. This is identical to dividend diplomatās spreadsheet. Been a big fan of their dividend income journey. My goal is to do the same - grow my dividends with sound /dividend champ companies year-on-year.
https://docs.google.com/spreadsheets/d/1JSMp6gfLuBEOu7Wh9eWX8O0QYuOj9MkIAs9NIfUPbQ8/edit?usp=sharing
Disclaimer: These arenāt my actual holdings. 
One adjustment Iād probably recommend is aligning the dates to the tax year to help with the tax return (assuming itās a general account, not an ISA).
Surprising that the dividend yield isnāt on there. Is their strategy to never sell, even when a yield becomes really poor?
Does it include non-US stocks, etfs and funds? Google Docs hasnāt seemed to be able to get the prices for UK-domiciled mutual funds in the last yearā¦
Google took out UK mutual funds.It used to be MUTF_GBP:name_of_the_mutual_fund
@adavid Yep, my spreadsheets have been sad since March 2018.
@ytsruh would your thing get price for eg a Vang lifestrategy mutual fund, (say ACDT / B4PQW15 / GB00B4PQW151 )? Itās been a long time since I used Excel but would give it a try. (Iām asking you because I donāt see a way to get the Stock ābitā in the Data menu when Iām using O365.)
Just a random one your vanguard price seems a little out:p donāt you mean Ā£43 instead of Ā£0.43
I tried to add Aviva but didnt seem to find it?
Yes, you are correct. This is a template. You can replicate it if you want and edit it to fit your requirement. These arenāt my real holdings : - )
I can see youāve manually input the dividend return for Feb and May in CTY.
Is there a technical solution for calculating this return in Google Docs ( i.e. to input the dividend return in the correct column based on the pay date and your holdings)? Or are you doing this manually from company listings / Google / LSE etc.?
Unfortunately, I donāt know how to this programmatically. When I receive my dividends i just input the amount manually.
I would then summarise all of it in another sheet that looks like below. This me allows to compare year on year growth in my dividend income. Iād love to get to a point where my dividend income can sustain my lifestyle one day. In the meantime, re-invest everything back.
With regards to re-investing dividends back. Some brokers allow DRIP but others do not and it can get really expensive. I usually wait until dividends accumulate to say 1K before re-investing back just to make it worthwile with 9 quid commission.Fortunately with FreeTrade, I donāt need to wait for my dividends to accumulate as I can re-invest it with zero to minimal commission.
You could use something like this, which pulls in the price of Vanguardās Ftse global all-cap fund:
=value(SUBSTITUTE(query(IMPORTXML("https://www.hl.co.uk/funds/fund-discounts,-prices--and--factsheets/search-results/v/vanguard-ftse-global-all-cap-index-accumulation","//span[@class='bid price-divide']"),"select* limit 1",0),"p","",1))
Just change the link to whichever fund youāre after.
Example for Lifestrategy 100% in pounds:
=value(SUBSTITUTE(query(IMPORTXML("https://www.hl.co.uk/funds/fund-discounts,-prices--and--factsheets/search-results/v/vanguard-lifestrategy-100-equity-accumulation","//span[@class='bid price-divide']"),"select* limit 1",0),"p","",1))/100
Oh wow, that works! That is clever and thank you very much.
No worries.
When I get around to it: Iāll work out a way of grabbing yield and/or dividend per share from somewhere, so it requires as little manual entry as possible.
You could probably pull in ex-dividend dates, payment dates and so on too.
Iām all ears, if anyone in the hive mindās got any ideas!
3 posts were split to a new topic: Finki
Hey guys (first post!)
Does anyone have a solution to pull the dividends progamatically? Maybe ycharts (but its expensive)?
The super simple Finki API
sorry, I had to
#selfpromotion
There are a few dividend tracker apps out there, does anyone have any recommendations?