Seems today has been busier than I expected!
I cleaned up my current holdings sheet a little. Figured this was a good excuse to give it some TLC.
Accenture
Highly profitable, stable business, currently experiencing high growth. Jumped on this with the recent rally.
Activision Blizzard
Still holding it, had it a while. Likely will sell this once it’s back in profit and consolidate the holding with EA.
Smith & Wesson
From the days where the US was always facing calls to ban guns, this would cause a surge in pricing. Old legacy holding I need to cleanup. I think I’ll see at a lose and just move on.
Altassian
Very strong fundamentals (weak value) and a recent rally. Jumped onto the hype train. Also they have just brought another company as well to expand their service desk offering.
Beyond Meat
Waste of my time. Brought into the hype. Just need to pull the plaster off and sell this. Not worth waiting on any longer in my mind.
Domino’s Pizza
Brought off the back of my analysis. Brought into my own hype!
Electronic Arts
Held for a long time, another high quality and momentum investment. Solid historic and future growth.
Cloud Computing ETF
Invests in a range of companies based on how “cloud” they are. Very sensitive but covers a lot of securities I wouldn’t normally directly invest in. I see this as a growth industry.
Frontier
Really like their games. I brought these guys for the new IPs they were developing and working on. Decent quality and momentum. Just won the rights to a new game with my next holding.
Games Workshop
Brought too late but I still like this holding. Reliable growth, good management, lots of innovation and they historically perform very well. Still recovering from COVID-19.
Greencoat UK Wind
Investment trust that focuses on wind farms in the UK. This is both my eco play and my dividend play. A strong performer historically and pays a reliable dividend as well. The dividend keeps me happy enough that I don’t worry about the value.
20+ Year Treasury Bond
Given the low rates of inflation, and also adding some protection, this felt like a smart move. Stable but in recent months has given me some excitement.
UK Gilts
My other bond fund. This one focusing on the UK rather than US. Really these are just to anchor my ISA. Try and do a little derisking.
Legal & General
Had for a while and it’s still recovering from when I brought at a high. Poor timing of the buy but happy to keep it as is.
Lyft
Brought into my own hype.
Mastercard
A very stable and reliable company. A long term position in my ISA where it happily ticks over. Solid high quality company.
Microsoft
Same as Mastercard. A solid long term slow moving quality company. Big enough I am not worried they are going to vanish, but agile enough to keep themselves innovating.
NVIDIA
High momentum, excitement driven buy. I think there are better plays out there in the world when it comes to chip manufacturers, but Nvidia is just one of those holdings you always see. Picked up a few shares with dividend build up from other stocks to lock in some short term gains.
Sainsbury’s
Brought in on my own hype. Earnings didn’t look good. Going to hold for now but a disappointing outcome so far.
Scottish Mortgage
Always been a fan. High growth, high momentum investment trust. Right now is doing extremely well. I am not looking forward to them really looking under the hood at the private investments (which they have voted to increase the overall holdings which are private.) This could be another Woodford if we aren’t careful.
Take-Two Interactive
Another gaming company. Really need to wrap all of these up. I’ll likely put it all into EA.
Taylor Wimpey
I was looking for another investment and as we start to ease out of lockdown this looked an interesting investment. Brought into my own hype again.
I recently took my ISA back into my full control, after looking after it, then moving most of the ISA to a managed solution and then back out.
The formulas I use in Google Sheets if anyone wants them.
Current value is =GOOGLEFINANCE($C3,"price"), $C3 being the symbol (make sure you add the exchange if you see strange results.)
Today change is =GOOGLEFINANCE($C3,"changepct")/100 I had to add the divide (it is a percentage already) as the percentage format kept messing with it.
All time change is the current value minus the average book cost then divided against the average book cost. =(G6-F6)/F6 it’s new number minus old new number divided by new number.
Holding percentage is the sum of all the pound values which has been divided using the pound value of this holding. =M7/sum($M$3:$M$24)
Both the pound average book cost and pound value use this formula (adjusted to look at the book or value respectively.) =($D6*F6)*IF($E6="USD",$C$29, IF($E6="GBX", 0.01,1))
It’s the number of shares multiplied by either the book or the value number. Then we multiple this by the FX. If it’s USD in the FX field then I have the latest FX rate used (0.83) in this sheet. If you find GBX in the FX rate then multiple by 0.01 to shift the numbers by two decimal places. Otherwise just multiply by 1 so there is no change (assume the FX is GBP.)
Link to sheet
I got a few requests to copy the sheet so here is a version for duplicating if you want. I’ve split it out from my normal sheet so I don’t break anything. It’s extremely basic at just tracking open positions but hopefully it helps some of you!
Not a super in depth analysis of my holding but hopefully it shines some light on what type of investments I like to make!