High Yield Investment Trusts - AIC Sector and Yield table (January 23)

[daveh]

An attempt to produce the AIC tables that used to appear here in the past posted by IAAG, as I found them quite useful. Data has been selected with a minimum Dividend yield of 3.5%. I used the instructions in IAAG's last posting of the tables here:
viewtopic.php?f=31&t=35760

The table isn't quite how I wanted to look. I'll try a different way of posting the tables next month.

[Tedx]

Pretty good timing for me. Thanks.

[MickR]

Really interesting, thanks

Is it easy to pull in total return figures for different periods, 3 and 5 years?

Mick

[daveh]

Really interesting, thanks

Is it easy to pull in total return figures for different periods, 3 and 5 years?

Mick

Yes you just tick the relevant boxes when you collect the data. I deselected them to make the table smaller. If you follow the link to IAAGs post when he last posted these tables they gave full instructions on how to get the info, which is what I used. I then copied to excel and deleted data for ITs below 3.5% yield , reordered some columns and tried to make it a bit easier to read.

[richfool]

Yes, thank you very much for that, Daveh.

I am able to read the full width of your listing, unlike IAAG's which I could only ever see about 2/3rds of the width of the spreadsheet (on my laptop).

[MickR]

Apologies if you already know this but I copied and pasted the whole table into a spreadsheet, then froze the first line and

[88V8]

Apologies if you already know this but I copied and pasted the whole table into a spreadsheet, then froze the first line and

pingfukit! disappeared in a cloud of smoke

Really interesting, thanks

Is it easy to pull in total return figures for different periods, 3 and 5 years?

Mick

Yes you just tick the relevant boxes when you collect the data. I deselected them to make the table smaller.

It was a slight pain that the table grew to be wider than the screen... an evolutionary effect consequent upon IAAG trying to please everyone by including more and more parameters.
I think for a picklist that is intended as a starting point for further research, this is fine as it is, and thankyou for taking the trouble.

V8