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.