Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to johnstevens77,Bhoddhisatva,scotia,Anonymous,Cornytiv34, for Donating to support the site

TJH Portfolio adjustment

For discussion of the practicalities of setting up and operating income-portfolios which follow the HYP Group Guidelines. READ Guidelines before posting
Forum rules
Tight HYP discussions only please - OT please discuss in strategies
uspaul666
2 Lemon pips
Posts: 232
Joined: November 4th, 2016, 6:35 am
Has thanked: 195 times
Been thanked: 111 times

Re: TJH Portfolio adjustment

#372133

Postby uspaul666 » January 1st, 2021, 5:29 pm

HL never created any kind of delete or cancel transaction for carillion, it just quietly removed itself from the portfolio display, I had to create a synthetic sale for zero transaction to make the numbers add up. Irritating.

Breelander
Lemon Quarter
Posts: 4178
Joined: November 4th, 2016, 9:42 pm
Has thanked: 999 times
Been thanked: 1855 times

Re: TJH Portfolio adjustment

#372136

Postby Breelander » January 1st, 2021, 5:44 pm

Carillion was arguably the only time I struck it lucky with what little tinkering i have tried. I sold all my Carillion the day before they were delisted.

tjh290633
Lemon Half
Posts: 8208
Joined: November 4th, 2016, 11:20 am
Has thanked: 913 times
Been thanked: 4096 times

Re: TJH Portfolio adjustment

#383615

Postby tjh290633 » February 4th, 2021, 12:00 pm

I have this morning topped up GSK as it was the highest ranking eligible share in my portfolio. I am aware of the comments made on the thread on GSK and their planned divestment of their consumer division. I added 16.4% to my holding at 1322p. In consequence my top-up table now looks like this:

Top-up          Income                     Cost                
Rank EPIC Rank EPIC % Income Rank Epic % Cost
1 IMB* 1 LGEN 5.85% 1 AV. 4.75%
2 BP.*+ 2 AV. 5.37% 2 PSON 4.43%
3 BATS* 3 BATS 5.37% 3 BP. 4.42%
4 IGG 4 BP. 5.10% 4 RDSB 4.42%
5 VOD* 5 GSK 4.82% 5 LLOY 4.37%
6 TSCO 6 IMB 4.75% 6 MARS 4.33%
7 NG. 7 RIO 4.56% 7 BT.A 4.17%
8 RDSB+ 8 SSE 4.48% 8 MKS 3.99%
9 GSK* 9 VOD 4.33% 9 GSK 3.82%
10 RB. 10 ADM 4.28% 10 PHP 3.79%
11 MKS# 11 NG. 4.15% 11 IGG 3.72%
12 LGEN* 12 IGG 3.78% 12 S32 3.69%
13 BLND 13 UU. 3.76% 13 BLND 3.61%
14 AZN 14 BA. 3.76% 14 BHP 3.50%
15 BA. 15 TATE 3.32% 15 LGEN 3.40%
16 BT.A# 16 PHP 3.19% 16 SSE 3.25%
17 CPG# 17 BHP 3.09% 17 KGF 3.13%
18 LLOY+# 18 BLND 2.63% 18 BATS 3.00%
19 SSE* 19 RDSB 2.58% 19 VOD 2.97%
20 ULVR 20 TSCO 2.57% 20 ADM 2.75%

As I have said in the past, I disqualify any share which, if topped up by 20%, its share of income(*) would exceed 5% and its share of cost (+) would also exceed 5%. I also disqualify any share not currently paying dividends(#).

Consequently IGG is next in line followed by TSCO and NG. The next event is anticipated to be the special dividend from TSCO, and I intend to buy back the shares lost in the consolidation once that is received. I have already taken that consolidation into account in my calculations.

My portfolio now looks like this:

Value                           
Rank EPIC Weight % Median
1 PSON 3.59% 128.0%
2 BHP 3.49% 124.1%
3 AV. 3.47% 123.6%
4 DGE 3.30% 117.7%
5 RIO 3.29% 117.3%
6 IMI 3.28% 116.9%
7 ADM 3.25% 115.6%
8 SSE 3.20% 113.8%
9 LGEN 3.19% 113.6%
10 UU. 3.13% 111.4%
11 S32 3.08% 109.6%
12 TATE 3.05% 108.6%
13 GSK 3.03% 107.9%
14 PHP 2.99% 106.3%
15 BA. 2.91% 103.6%
16 MARS 2.90% 103.3%
17 SMDS 2.87% 102.2%
18 NG. 2.81% 100.1%
19 ULVR 2.81% 99.9%
20 VOD 2.76% 98.1%
21 SGRO 2.72% 96.9%
22 KGF 2.69% 95.6%
23 TW. 2.67% 95.1%
24 BLND 2.63% 93.6%
25 AZN 2.62% 93.2%
26 BATS 2.62% 93.2%
27 IGG 2.58% 91.8%
28 RDSB 2.53% 90.0%
29 BP. 2.49% 88.7%
30 TSCO 2.49% 88.6%
31 RB. 2.26% 80.3%
32 BT.A 2.12% 75.6%
33 CPG 1.98% 70.5%
34 IMB 1.92% 68.3%
35 LLOY 1.72% 61.2%
36 MKS 1.58% 56.1%

TJH

88V8
Lemon Half
Posts: 5768
Joined: November 4th, 2016, 11:22 am
Has thanked: 4097 times
Been thanked: 2560 times

Re: TJH Portfolio adjustment

#383634

Postby 88V8 » February 4th, 2021, 12:49 pm

tjh290633 wrote:I have this morning topped up GSK...

So presumably you are taking the view that even after the pretty much announced divi cut the yield will still be acceptable........

V8

Arborbridge
The full Lemon
Posts: 10367
Joined: November 4th, 2016, 9:33 am
Has thanked: 3601 times
Been thanked: 5227 times

Re: TJH Portfolio adjustment

#383639

Postby Arborbridge » February 4th, 2021, 1:00 pm

88V8 wrote:
tjh290633 wrote:I have this morning topped up GSK...

So presumably you are taking the view that even after the pretty much announced divi cut the yield will still be acceptable........

V8


Yes, interesting. What I admire is the way TJH pretty much takes whatever is the first valid share unless he knows of a very good reason why not. In my case, I spend too long pickering with self doubts.

idpickering
The full Lemon
Posts: 11276
Joined: November 4th, 2016, 5:04 pm
Has thanked: 2468 times
Been thanked: 5762 times

Re: TJH Portfolio adjustment

#383644

Postby idpickering » February 4th, 2021, 1:20 pm

Arborbridge wrote:
88V8 wrote:
tjh290633 wrote:I have this morning topped up GSK...

So presumably you are taking the view that even after the pretty much announced divi cut the yield will still be acceptable........

V8


Yes, interesting. What I admire is the way TJH pretty much takes whatever is the first valid share unless he knows of a very good reason why not. In my case, I spend too long pickering with self doubts.


Me too Arb, obviously, although I'm trying to be less fickle nowadays. Good call Terry IMHO.

Ian.

kempiejon
Lemon Quarter
Posts: 3488
Joined: November 5th, 2016, 10:30 am
Has thanked: 1 time
Been thanked: 1145 times

Re: TJH Portfolio adjustment

#383649

Postby kempiejon » February 4th, 2021, 1:36 pm

Arborbridge wrote:
88V8 wrote:
tjh290633 wrote:I have this morning topped up GSK...

So presumably you are taking the view that even after the pretty much announced divi cut the yield will still be acceptable........

V8


Yes, interesting. What I admire is the way TJH pretty much takes whatever is the first valid share unless he knows of a very good reason why not. In my case, I spend too long pickering with self doubts.


For me the advised impending split of the company and a statement suggesting total dividend amount reduced across the group has been enough to put me off GSK. To be honest, the 7 years without dividend growth was already a red flag but being able to make it through the recently year without a hitch in income made me warm to them as did the 6% plus yield. The announcement and inevitable uncertainty with a possible rump holding made an unknowable future a little too unclear for me to persevere. There's plenty of other picks

tjh290633
Lemon Half
Posts: 8208
Joined: November 4th, 2016, 11:20 am
Has thanked: 913 times
Been thanked: 4096 times

Re: TJH Portfolio adjustment

#383667

Postby tjh290633 » February 4th, 2021, 3:43 pm

88V8 wrote:
tjh290633 wrote:I have this morning topped up GSK...

So presumably you are taking the view that even after the pretty much announced divi cut the yield will still be acceptable........

V8

The dividend cut will be after the split, so who knows?

TJH

tjh290633
Lemon Half
Posts: 8208
Joined: November 4th, 2016, 11:20 am
Has thanked: 913 times
Been thanked: 4096 times

Re: TJH Portfolio adjustment

#383766

Postby tjh290633 » February 4th, 2021, 10:26 pm

Arborbridge wrote:As regards Aviva, what yield are you using? Are you not disqualifying due to the non-payment in June and the reduction in the interim?

I am using the 7p interim and am assuming a 14p final, as indicated in https://www.investegate.co.uk/aviva-plc ... 00055450G/

I am ignoring the changes wrought by government panic.

TJH

Arborbridge
The full Lemon
Posts: 10367
Joined: November 4th, 2016, 9:33 am
Has thanked: 3601 times
Been thanked: 5227 times

Re: TJH Portfolio adjustment

#383795

Postby Arborbridge » February 5th, 2021, 6:57 am

tjh290633 wrote:
Arborbridge wrote:As regards Aviva, what yield are you using? Are you not disqualifying due to the non-payment in June and the reduction in the interim?

I am using the 7p interim and am assuming a 14p final, as indicated in https://www.investegate.co.uk/aviva-plc ... 00055450G/

I am ignoring the changes wrought by government panic.

TJH


Thanks - I am also using 21p total.

Arb.

tjh290633
Lemon Half
Posts: 8208
Joined: November 4th, 2016, 11:20 am
Has thanked: 913 times
Been thanked: 4096 times

Re: TJH Portfolio adjustment

#391209

Postby tjh290633 » March 1st, 2021, 3:50 pm

Just recording that I bought back my Tesco shares, plus about 6% because of the fall in SP, at 224.7p this morning. They were top of my eligible shares for topping up, ranking equal with NG. That has brought Tesco back to just over median weight.

My top-up table now looks like this:

Top-up          Income                     Cost                
Rank EPIC Rank EPIC % Income Rank Epic % Cost
1 IMB* 1 RIO 6.09% 1 AV. 4.61%
2 BATS* 2 LGEN 5.68% 2 PSON 4.30%
3 VOD 3 BATS 5.34% 3 BP. 4.29%
4 BP.*+ 4 AV. 5.21% 4 RDSB 4.28%
5 GSK* 5 BP. 4.96% 5 LLOY 4.24%
6 NG. 6 GSK 4.68% 6 MARS 4.20%
7 IGG 7 IMB 4.61% 7 BT.A 4.04%
8 ULVR 8 SSE 4.35% 8 MKS 3.87%
9 SSE* 9 VOD 4.20% 9 GSK 3.70%
10 RB. 10 ADM 4.16% 10 PHP 3.67%
11 AZN 11 NG. 4.04% 11 IGG 3.60%
12 MKS# 12 BA. 3.73% 12 S32 3.58%
13 LLOY+ 13 IGG 3.67% 13 TSCO 3.55%
14 UU. 14 UU. 3.65% 14 BLND 3.50%
15 LGEN* 15 TATE 3.23% 15 BHP 3.39%
16 RDSB+ 16 PHP 3.22% 16 LGEN 3.30%
17 TSCO 17 TSCO 3.20% 17 SSE 3.16%
18 BA. 18 BHP 3.11% 18 KGF 3.03%
19 BT.A# 19 BLND 2.56% 19 BATS 2.91%
20 SGRO 20 RDSB 2.51% 20 VOD 2.88%

I exclude shares from topping-up if, by doing so by 20%, they would exceed 5% of either share of dividend income (*) or of cost (+). I also exclude any share not currently paying a dividend (#).

VOD has now crept into the eligible ranks after that addition to Tesco. These rankings are based on Friday's closing prices.

TJH

daveh
Lemon Quarter
Posts: 2191
Joined: November 4th, 2016, 11:06 am
Has thanked: 409 times
Been thanked: 807 times

Re: TJH Portfolio adjustment

#391216

Postby daveh » March 1st, 2021, 4:07 pm

That's a good price, I reinvested my Tesco dividend in Tesco shares this morning, but paid 226.1p per share and costs +stamp duty took it to just over 230p per share. Still considerably cheaper than the price I paid back in 2011 and 2012 (which after the consolidation was an average of 454p/share).

tjh290633
Lemon Half
Posts: 8208
Joined: November 4th, 2016, 11:20 am
Has thanked: 913 times
Been thanked: 4096 times

Re: TJH Portfolio adjustment

#398875

Postby tjh290633 » March 25th, 2021, 11:58 am

I added to my holding of Vodafone this morning, about 15% more, at 136.03p. I meant to do it yesterday, but gardening intervened. Unfortunately the price jumped this morning. This now makes VOD about 5% above my median holding weight.

My top-up table now looks like this:

Top-up          Income                     Cost                
Rank EPIC Rank EPIC % Income Rank Epic % Cost
1 IMB+ 1 RIO 5.68% 1 AV. 4.54%
2 BATS+ 2 LGEN 5.29% 2 VOD 4.28%
3 BP.+* 3 BATS 4.98% 3 PSON 4.24%
4 NG. 4 AV. 4.86% 4 BP. 4.23%
5 GSK+ 5 BP. 4.60% 5 RDSB 4.22%
6 IGG 6 VOD 4.49% 6 LLOY 4.18%
7 RDSB* 7 GSK 4.36% 7 MARS 4.14%
8 SSE 8 IMB 4.30% 8 BT.A 3.98%
9 RB. 9 ADM 4.11% 9 MKS 3.82%
10 RIO+ 10 SSE 4.06% 10 GSK 3.65%
11 AZN 11 NG. 3.76% 11 PHP 3.62%
12 ULVR 12 BHP 3.68% 12 IGG 3.55%
13 MKS# 13 BA. 3.48% 13 S32 3.53%
14 PHP 14 IGG 3.42% 14 TSCO 3.50%
15 TSCO 15 UU. 3.40% 15 BLND 3.45%
16 UU. 16 TW. 3.38% 16 BHP 3.34%
17 LLOY 17 TATE 3.01% 17 LGEN 3.25%
18 VOD+* 18 PHP 3.00% 18 SSE 3.11%
19 SGRO 19 TSCO 2.99% 19 KGF 2.99%
20 TW. 20 BLND 2.38% 20 BATS 2.86%

As I have said before, I disqualify shares whose share of cost (*) or dividend income (+) is over 5% and also those not curtrently paying dividends (#). VOD now joins there ranks on both counts of cost and income. LLOY is now released from disqualification.

My portfolio now looks like this, at last night's prices (except for VOD):

Value                
Rank EPIC Weight
1 AV. 3.70%
2 PSON 3.59%
3 BHP 3.36%
4 LGEN 3.29%
5 DGE 3.18%
6 ADM 3.15%
7 TATE 3.12%
8 IMI 3.12%
9 VOD 3.03%
10 RIO 3.02%
11 SMDS 2.94%
12 BA. 2.94%
13 KGF 2.93%
14 BLND 2.92%
15 S32 2.91%
16 TW. 2.91%
17 SSE 2.91%
18 UU. 2.90%
19 MARS 2.87%
20 PHP 2.83%
21 TSCO 2.83%
22 GSK 2.81%
23 BP. 2.77%
24 IGG 2.72%
25 NG. 2.65%
26 BATS 2.64%
27 ULVR 2.50%
28 SGRO 2.49%
29 RDSB 2.44%
30 AZN 2.44%
31 BT.A 2.30%
32 RB. 2.21%
33 CPG 2.06%
34 LLOY 2.03%
35 IMB 1.87%
36 MKS 1.62%

Mean 2.78%

It looks as if NG. will be the next beneficiary of a top-up, probably mid April after the RIO Tinto dividends arrive.

TJH

SuperCally
Lemon Pip
Posts: 67
Joined: August 2nd, 2017, 7:31 am
Has thanked: 1008 times
Been thanked: 70 times

Re: TJH Portfolio adjustment

#398917

Postby SuperCally » March 25th, 2021, 2:03 pm

Thanks TJH.

At the risk of testing the ‘no such thing as a stupid question’ rule, what are the criteria for inclusion in the leftmost ‘Top-up rank’ list. Thanks, Vinny.

tjh290633
Lemon Half
Posts: 8208
Joined: November 4th, 2016, 11:20 am
Has thanked: 913 times
Been thanked: 4096 times

Re: TJH Portfolio adjustment

#398939

Postby tjh290633 » March 25th, 2021, 3:43 pm

SuperCally wrote:Thanks TJH.

At the risk of testing the ‘no such thing as a stupid question’ rule, what are the criteria for inclusion in the leftmost ‘Top-up rank’ list. Thanks, Vinny.

It's the algorithm used in the HYPTUSS spreadsheet. Holdings are ranked inversely by weight (lightest = 1) and by yield (highest = 1). Rankings added together and then ranked by the combined score. If the scores are equal, they appear alphabetically which is a point to be watched. Here is my table showing the calculation:

Holding   Weight   Yld   W+Y   Rank
ADM 31 12 43 25
AV. 36 11 47 28
AZN 7 24 31 11
BA. 25 14 39 22
BATS 11 2 13 2
BLND 23 22 45 27
BHP 34 10 44 26
BP. 14 4 18 3
BT.A 6 35 41 24
CPG 4 36 40 23
DGE 32 29 61 35
GSK 15 6 21 5
IGG 13 13 26 6
IMB 2 1 3 1
IMI 29 30 59 34
KGF 24 26 50 31
LGEN 33 5 38 21
LLOY 3 32 35 17
MARS 18 34 52 32
MKS 1 33 34 13
NG. 12 8 20 4
PHP 17 17 34 14
PSON 35 27 62 36
RB. 5 25 30 9
RDSB 8 20 28 7
RIO 27 3 30 10
S32 22 31 53 33
SGRO 9 28 37 19
SMDS 26 23 49 29
SSE 20 9 29 8
TATE 30 19 49 30
TSCO 16 18 34 15
TW. 21 16 37 20
ULVR 10 21 31 12
UU. 19 15 34 16
VOD 28 7 35 18


You will see four with a combined score of 34 - MKS, PHP, TSCO and UU. which are ranked alphabetically. In such a case I would probably select the one with the highest yield.

TJH

TUK020
Lemon Quarter
Posts: 2039
Joined: November 5th, 2016, 7:41 am
Has thanked: 762 times
Been thanked: 1175 times

Re: TJH Portfolio adjustment

#398955

Postby TUK020 » March 25th, 2021, 4:12 pm

tjh290633 wrote:
SuperCally wrote:Thanks TJH.

At the risk of testing the ‘no such thing as a stupid question’ rule, what are the criteria for inclusion in the leftmost ‘Top-up rank’ list. Thanks, Vinny.

It's the algorithm used in the HYPTUSS spreadsheet. Holdings are ranked inversely by weight (lightest = 1) and by yield (highest = 1). Rankings added together and then ranked by the combined score. If the scores are equal, they appear alphabetically which is a point to be watched. Here is my table showing the calculation:
TJH


Vinny,
In case you are new to this, HYPTUSS is the "High Yield Portfolio Top Up Spread Sheet".
It is a software tool created (and supported) by some rather splendid chaps here on the TLF site.
You enter your shareholdings, and it can then download share price information, forecast yield, and perform the top up calculation for you. (It uses TJH's well tried algorithm.
You can read about it and download a copy in the "Managing your finances" section, 'Financial Software', and 'Financial Software - Discussion' threads.
Well worth downloading a copy and having a play
tuk020

SuperCally
Lemon Pip
Posts: 67
Joined: August 2nd, 2017, 7:31 am
Has thanked: 1008 times
Been thanked: 70 times

Re: TJH Portfolio adjustment

#398998

Postby SuperCally » March 25th, 2021, 6:41 pm

TJH, tuk020, thanks both. Ah yes, HYPTUSS, I should have realised. I haven’t got around to downloading it yet, but I will do. My portfolio is quite modest, and thus top-ups are few and far between, and done ‘old-school’!

tjh290633
Lemon Half
Posts: 8208
Joined: November 4th, 2016, 11:20 am
Has thanked: 913 times
Been thanked: 4096 times

Re: TJH Portfolio adjustment

#405555

Postby tjh290633 » April 20th, 2021, 10:25 am

I topped up my holding of National Grid by about 15% this morning, at 902p, it being the highest ranked eligible share for topping up. This was thanks to the RIO ordinary and special dividends received last week. I forgot to do it yesterday, as I spent most of the day in the garden, so have benefitted from a reduction in the price. NG. now rises from about 8% below median value to 5% above median and also moves just into the range of shares ineligible because of share of income. However Admiral and SSE move out of that zone and SSE is now my most eligible share for topping up.

My top-up rankings now look like this:

Top-up          Income                     Cost                
Rank EPIC Rank EPIC % Income Rank Epic % Cost
1 IMB* 1 RIO 6.11% 1 AV. 4.54%
2 BATS* 2 LGEN 5.20% 2 VOD 4.28%
3 BP.*+ 3 BATS 4.89% 3 PSON 4.24%
4 GSK* 4 AV. 4.77% 4 BP. 4.23%
5 VOD* 5 BP. 4.52% 5 RDSB 4.22%
6 RDSB+ 6 VOD 4.41% 6 LLOY 4.18%
7 SSE 7 GSK 4.29% 7 MARS 4.14%
8 RKT 8 NG. 4.23% 8 BT.A 3.98%
9 ULVR 9 IMB 4.22% 9 MKS 3.82%
10 IGG 10 ADM 4.04% 10 GSK 3.65%
11 AZN 11 SSE 3.99% 11 PHP 3.62%
12 TSCO 12 BHP 3.43% 12 IGG 3.55%
13 PHP 13 BA. 3.41% 13 S32 3.53%
14 LGEN* 14 IGG 3.36% 14 TSCO 3.50%
15 MKS# 15 RDSB 3.35% 15 BLND 3.45%
16 LLOY 16 UU. 3.34% 16 BHP 3.34%
17 NG.* 17 TW. 3.32% 17 LGEN 3.25%
18 RIO* 18 TATE 2.95% 18 SSE 3.11%
19 BA. 19 PHP 2.95% 19 KGF 2.99%
20 SGRO 20 TSCO 2.77% 20 BATS 2.86%

To be eligible for topping up, its share of income or of cost must not exceed 5% after topping up. I assume 20% top-up, which sets the limits at 4.2% for share of income (*) and for share of cost (+). I also disqualify shares not currently paying a dividend (#). Incidentally, the way that the ranking works is that the next two, RKT and ULVR, have the same ranking but are shown in alphabetical order. With ULVR having a slightly higher yield, I would probably choose that share in preference.

My portfolio now looks like this:

Value                           
Rank EPIC Weight % Median
1 AV. 3.60% 125.6%
2 PSON 3.54% 123.2%
3 BHP 3.44% 119.9%
4 DGE 3.24% 113.0%
5 RIO 3.23% 112.5%
6 IMI 3.20% 111.5%
7 ADM 3.20% 111.5%
8 LGEN 3.18% 111.0%
9 KGF 3.09% 107.7%
10 NG. 3.03% 105.5%
11 TATE 2.97% 103.4%
12 TW. 2.96% 103.2%
13 S32 2.95% 102.9%
14 UU. 2.95% 102.9%
15 BA. 2.93% 102.0%
16 SMDS 2.91% 101.5%
17 SSE 2.89% 100.7%
18 VOD 2.87% 100.0%
19 IGG 2.87% 100.0%
20 BLND 2.82% 98.3%
21 PHP 2.79% 97.2%
22 GSK 2.78% 97.0%
23 TSCO 2.75% 96.0%
24 MARS 2.69% 93.9%
25 BP. 2.63% 91.7%
26 BATS 2.57% 89.4%
27 SGRO 2.52% 87.8%
28 ULVR 2.43% 84.5%
29 AZN 2.41% 84.1%
30 RDSB 2.41% 84.0%
31 BT.A 2.32% 80.7%
32 RKT 2.19% 76.4%
33 CPG 2.10% 73.1%
34 LLOY 2.00% 69.6%
35 IMB 1.88% 65.6%
36 MKS 1.67% 58.0%

The current yield is 3.9%, based on dividends announced to date and those paid last year. The yield on the FTSE100 is 3.31% according to the FT's "World Markets at a glance". Last night my capital value was at an all-time high, but my income units are about 5% below their maximum at the end of May 2017. In the current year my income units are up 11.43%, my accumulation units up 11.45% and the FTSE100 up 8.65% as of last night.

Next top-up anticipated about mid-May.

TJH

tjh290633
Lemon Half
Posts: 8208
Joined: November 4th, 2016, 11:20 am
Has thanked: 913 times
Been thanked: 4096 times

Re: TJH Portfolio adjustment

#412809

Postby tjh290633 » May 17th, 2021, 7:14 pm

As discussed in viewtopic.php?p=412329#p412329 I decided that I would top up my holding of Imperial Brands plc today by about 20%. By adding into the calculation the expectation that BT.A would resume dividend payments, it moved IMB out of the disqualification zone for share of income, just. I did the deal late morning at 1585p, prompted by the yield available from IMB of 8.7%. They are due to report half-year results tomorrow. This has brought them up to about 80% of the median holding value, rising from 35th to 32nd ranked by weight.

My top-up table now looks like this:

Top-up          Income                     Cost                
Rank EPIC Rank EPIC % Income Rank Epic % Cost
1 IMB* 1 RIO 6.11% 1 AV. 4.52%
2 BATS* 2 LGEN 5.05% 2 VOD 4.25%
3 BT.A# 3 IMB 4.91% 3 PSON 4.22%
4 IGG 4 BATS 4.75% 4 BP. 4.20%
5 GSK 5 AV. 4.64% 5 RDSB 4.20%
6 RDSB 6 VOD 4.28% 6 LLOY 4.16%
7 RKT 7 GSK 4.16% 7 MARS 4.12%
8 BP. 8 NG. 4.11% 8 BT.A 3.96%
9 TW. 9 ADM 3.92% 9 MKS 3.80%
10 ADM 10 SSE 3.87% 10 GSK 3.63%
11 SSE 11 BP. 3.39% 11 PHP 3.60%
12 ULVR 12 RDSB 3.36% 12 IGG 3.53%
13 VOD*+ 13 BA. 3.32% 13 S32 3.51%
14 TSCO 14 IGG 3.26% 14 TSCO 3.49%
15 LGEN* 15 UU. 3.25% 15 BLND 3.43%
16 RIO* 16 TW. 3.22% 16 BHP 3.33%
17 MKS# 17 BHP 3.18% 17 LGEN 3.23%
18 PHP 18 BT.A 2.89% 18 SSE 3.09%
19 AZN 19 TATE 2.87% 19 KGF 2.97%
20 BA. 20 PHP 2.86% 20 IMB 2.92%

As always, I have rules to prevent a share providing more than 5% or either cost or income, so assuming a 20% increase in a holding, I disqualify any share with more than 4.2% of either property. Following the addition, IMB is now over the share of income limit and is now disqualified again. Those with more than 4.2% of Income (*) or with more than 4% of portfolio cost (+) are marked, their number now being much reduced, but VOD is disqualified on both counts. RIO, LGEN, IMB and BATS are now diqualified because of share on income. I also disqualify and share not currently paying a dividend (#), and although I included BT.A's expected dividends in my calculations, I disqualify it on that ground, as I do MKS. Interestingly, both BP. and RDSB become eligible again.

My portfolio now looks like this:

Value                           
Rank EPIC Weight % Median
1 IMI 3.74% 134.2%
2 PSON 3.68% 132.2%
3 AV. 3.52% 126.5%
4 BHP 3.42% 122.8%
5 DGE 3.32% 119.2%
6 RIO 3.27% 117.2%
7 LGEN 3.16% 113.5%
8 KGF 3.10% 111.3%
9 NG. 3.07% 110.1%
10 TATE 3.05% 109.6%
11 VOD 2.95% 106.0%
12 S32 2.94% 105.6%
13 UU. 2.91% 104.5%
14 ADM 2.90% 104.1%
15 SSE 2.89% 103.6%
16 BA. 2.87% 103.1%
17 SMDS 2.85% 102.4%
18 GSK 2.82% 101.1%
19 BLND 2.75% 98.9%
20 PHP 2.74% 98.4%
21 BP. 2.71% 97.3%
22 TW. 2.68% 96.3%
23 TSCO 2.68% 96.1%
24 MARS 2.62% 93.9%
25 IGG 2.56% 92.1%
26 AZN 2.52% 90.6%
27 SGRO 2.50% 89.7%
28 ULVR 2.48% 89.2%
29 BT.A 2.44% 87.7%
30 BATS 2.44% 87.4%
31 RDSB 2.42% 87.0%
32 IMB 2.22% 79.6%
33 LLOY 2.16% 77.4%
34 RKT 2.04% 73.4%
35 CPG 1.98% 71.1%
36 MKS 1.58% 56.5%

Only MARS, CPG and MKS now have to announce resumption of dividends. When that happens more shares will be released from disqualification. Meanwhile I may add to my holding of IGG when the next opportunity arises, probably late in June, but much can change before then.

TJH

csearle
Lemon Quarter
Posts: 4762
Joined: November 4th, 2016, 2:24 pm
Has thanked: 4809 times
Been thanked: 2083 times

Re: TJH Portfolio adjustment

#412944

Postby csearle » May 18th, 2021, 11:46 am

As it happens my top-up, just now, was BATS. With CNA, MARS, MKS, SMDS, and (still) BT-A on the naughty step (harsh perhaps given the situation) they were the top of my Terryish top-up list this time.

Following Foolish wisdom gleaned on these boards I have now a second broker (ii in addition to iWeb). New ISA allocations will go to the new one and top-ups will eventually happen in both. For the purposes of the top-up ranking I'm treating them as one notional place.

Chris


Return to “HYP Practical (See Group Guidelines)”

Who is online

Users browsing this forum: Smautf and 17 guests