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.
Got a credit card? use our Credit Card & Finance Calculators
Thanks to gpadsa,Steffers0,lansdown,Wasron,jfgw, for Donating to support the site
High Yield Investment Trusts - AIC Sector and Yield table (January 23)
-
- Lemon Quarter
- Posts: 2075
- Joined: December 14th, 2022, 10:59 am
- Has thanked: 1849 times
- Been thanked: 1489 times
Re: High Yield Investment Trusts - AIC Sector and Yield table (January 23)
Pretty good timing for me. Thanks.
-
- 2 Lemon pips
- Posts: 130
- Joined: July 29th, 2019, 5:40 pm
- Has thanked: 149 times
- Been thanked: 31 times
Re: High Yield Investment Trusts - AIC Sector and Yield table (January 23)
Really interesting, thanks
Is it easy to pull in total return figures for different periods, 3 and 5 years?
Mick
Is it easy to pull in total return figures for different periods, 3 and 5 years?
Mick
-
- Lemon Quarter
- Posts: 2218
- Joined: November 4th, 2016, 11:06 am
- Has thanked: 416 times
- Been thanked: 813 times
Re: High Yield Investment Trusts - AIC Sector and Yield table (January 23)
MickR wrote: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.
-
- Lemon Quarter
- Posts: 3531
- Joined: November 19th, 2016, 2:02 pm
- Has thanked: 1208 times
- Been thanked: 1294 times
Re: High Yield Investment Trusts - AIC Sector and Yield table (January 23)
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).
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).
-
- 2 Lemon pips
- Posts: 130
- Joined: July 29th, 2019, 5:40 pm
- Has thanked: 149 times
- Been thanked: 31 times
Re: High Yield Investment Trusts - AIC Sector and Yield table (January 23)
Apologies if you already know this but I copied and pasted the whole table into a spreadsheet, then froze the first line and
-
- Lemon Half
- Posts: 5880
- Joined: November 4th, 2016, 11:22 am
- Has thanked: 4235 times
- Been thanked: 2613 times
Re: High Yield Investment Trusts - AIC Sector and Yield table (January 23)
pingfukit! disappeared in a cloud of smokeMickR wrote:Apologies if you already know this but I copied and pasted the whole table into a spreadsheet, then froze the first line and
daveh wrote:MickR wrote: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
Return to “High Yield Shares & Strategies - General”
Who is online
Users browsing this forum: No registered users and 1 guest