I thought I would share my (work in progress) ETF spreadsheet, in case it will help anyone. Has key data which provides a good starting point for picking your weapon of choice
Please don’t sue me if the data isn’t 100% accurate! As always please do your own research too!
I lined up a batch order for the European high dividend ETF (£IDVY). It’s a bit of a hedge against Brexit, and the numbers look nice with a 4.45% dividend yield and the price is not at an all-time high.
Thank you for putting this together for the community. It deserves to be linked:
If I may suggest, I believe it would be better to erase “£” and “,” signs in column G and set currency format instead. First, it will apply those back anyway, but also will allow sorting in ascending and descending order properly. At the moment, it only sorts by the first digit (e.g. ascending order looks like this: £1 < £100 < £2 instead of £1 < £2 < £100) rather than actual volume.
On the face of it HMCH should be in the 1.8% region on a 12 month trailing basis. Last years div about 11p with a current share price of about £6
Looks like a few other function calls you could utilise - feel free to. ukOCF, ftTRANS and ukDividendFrequency look like they’d slide nicely into your spreadsheet. You could add ukDividendPayDate or ExDate or Amount to track latest/upcoming actual dividend payments - could be useful.
Was trying to use dividendamount but had some issues (i think it is pulling through last quarters dividend rather than full years) is there a way to get last years full dividend or TTM?