The table is shown grouped by AIC sector, and then ranked in descending order of yield for each sector, and also shows relevant Discount or Premium information, along with the 5-year dividend growth-rate for each Investment Trust, and with a new additional column showing the relevant OCF charges including performance fees.
Please note that if anyone wishes to replicate this type of data-set themselves at any time, there are some instructions at the bottom of this post on how to do that...
I've dip-checked the above data, but please do note that it should be used only as a starting-point for further investigation, and it should certainly be the case that you should carry out your own due-diligence on any data that you may use for any subsequent investment decisions that you might wish to make...
A good source to cross-check some of the above data, if anything does look interesting or even suspicious, is the TrustNet website, which also gives yield and discount information for these types of investments - https://www.trustnet.com/
Here are some instructions to be able to generate up-to-date yield-data in the future, using the above excellent AIC website -
1. Open the AIC website (https://tinyurl.com/yawfc9zy)
2. Select the 'AIC Sector Selection' button, and then the 'AIC VCT Sectors' button, and then click the 'Deselect all AIC VCT Sectors' button to remove the VCT data from this list.
3. Also in the 'AIC Sector Selection' area, make sure the tick-boxes for 'Include AIC sector weighted averages', 'AIC weighted averages sorted to top', and also 'Include industry averages' are un-ticked.
4. In the 'AIC Equity Sectors' sections, and also the 'AIC Alternative Sectors', check to make sure that all of the sub-sector boxes are ticked to bring in the data for all of those sub-areas.
5. Select the 'Data points' button, and then in that section, open the 'Additional Data Points' area, and in there, select the 'TIDM', the 'Div cover (yrs)', and the 'Ongoing charge inc Perf fee (%)' tick-boxes.
6. Select the 'Filters' button, and then set the 'Dividend Yield' option to '3.5%+'
7. Underneath this settings-area, you should now have an up-to-date data-table similar to the above, broken down by AIC Sectors.
8. If you want to import that data into a spreadsheet, to perhaps then rank by sector and yield, then you should enable the option to view the data in 'Print Mode' by selecting the 'Save / Print' option, which can be found above the AIC settings area used above, and then selecting the 'Enable Print Mode' button - the AIC data will then be represented on-screen in a way that can be bulk-selected and copied into a spreadsheet.
- Please do note that if you don't select the 'Enable Print Mode' option, and you try to copy the data into a spreadsheet, then it's likely to only copy some of the data...
If anyone wants to investigate any of the Investment Trusts listed on the AIC website any further, for instance if they want to look at the underlying portfolio holdings, then the simplest way to do that is to just Google 'AIC xxxx', where 'xxxx' is the EPIC for the Investment Trust in question. The AIC page for that IT will usually be the first returned hit on that search, and then going to that AIC page and clicking on the 'Portfolio' section of the AIC page will list the underlying data for that IT, which includes quite a lot of useful information regarding the make-up of each income-related Investment Trust. An example here is the 'Portfolio' page for Henderson Far East Income (HFEL) - https://www.theaic.co.uk/companydata/0P00008ZSY/portfolio
Link to September 2021 data - https://www.lemonfool.co.uk/viewtopic.php?f=31&t=31015