Unitising my portfolio shows I sucked last year

The trouble with unitising one’s portfolio is there’s nowhere to hide. Unitising lets you track the effects of adding money, which helps avoid the easiest gotcha in fooling yourself on returns. The Beardstown Ladies Investment Club effect. The hard earned cash you lob into the pot makes your portfolio go up, but it’s not profit, or ROI, or anything like that.

Unlike starting with a one off lump sum from which you draw nothing, evaluating performance gets a lot more complicated if you draw a yearly stipend from your stash. It gets a lot more complicated if you’re one of the ordinary mugs who has to actually, y’know, earn the money they are putting into their future freedom fund, paying it in year by year as they go.

The UK version of the Motley Fool used to have the greatest description of how to unitise and worked example called Stockpicking – Are You As Good As You Think? by G.A.Chester which was still visible to freebie members, but all that was lost when they reorganised the website(19 January update – see Neil’s comment for the original text – he had saved this). Sadly G.A. Chester seems to serve up endless spammy clickbait articles these days, what the hell happened to you, man? Stockpicking was an article pure genius, putting across a tough concept in actionable bitesize steps.

Monevator has a description here but for some reason I really struggle to follow that, although I recognise the moving parts when I analyse my spreadsheet written to implement GA Chester’s more ermine-friendly narrative. I tested the spreadsheet against Chester’s example. Pity that gem of wisdom is lost to linkrot.

Unitising is quite a grief-stricken and error-prone process because it involves going through the spreadsheet and entering the current price of holdings I own at the January sampling datum point. After 10 years, particularly with some occasional muppetry I have a few dead lines of stocks I have no holdings in, but it’s easy to miss the odd line where I do have holdings. It fails safe in that if I don’t enter the price of a holding I own, it says the value of that line is 0 which makes the unit price lower, which is an incentive to go back and catch all of ’em on the grounds I can’t be that crap, surely? There’s also a error-checking catch line that tots all the holdings up, it’s kinda nice if it matches Iweb’s view of my world. Obviously fans of Cloud Services like Money Dashboard will have this easier, though you still need to do the annual spreadsheetery to unitise. Money Dashboard claims to be

a secure cloud-based open banking website that enables you to replicate and then track all the spending categories you set up in MSE’s Budget Planner

Colour me a cynical sonofagun but I am of the firm opinion that secure and cloud-based do not belong in the same sentence. See Equifax for a worked example.

The Ermine portfolio unit value is down 5% this January to last January. It’s also changed nature, more gold and I have taken 20k out as cash, though I may stick that back in to Charles Stanley, which is a Flexible ISA, and pull it out again halfway through April. And I may contribute something to Iweb this year, though I can’t make the full 20k.

Now that’s not dreadful. What would I have been doing otherwise – I’d be in VWRL a la Lars Kroijer.

Hargreaves Lansdown tells me VWRL is down 6.87% Jan 18 to Jan 19

I get divi from VWRL, which is about 2%, I guess there’s a .25% platform fee too. So instead of all that tracking, I could have had one lot of VWRL and been about the same.

What about VGLS100? That was about -5.36% in acc units. Much of a muchness and not worth the Sturm und Drang. In general, a little bit shit. Where Eagles Fear to Perch did better than me last year for instance, congratulations that man!

Defence, not offence is the word at the moment

Now I did shift much more defensively, there’s a lot of gold, there are some government bonds in there. I am probably suffering the deadweight drag of the gold not earning an income. Well, that’s my excuse. I shifted more defensively for several reasons. It is not quite determinate when the best time to take my main pension is, there is a balance between the actuarial reduction because I am not 60 and what appears to be high CETVs which incidentally seem to reduce the actuarial reduction, for reasons I don’t understand.

So I have to keep on pinging the pension modeller. I might need some of that cash if the modeller says delay a bit, and money you might need in the next five years has no business being in the stock market. Particularly when said stock markets are at high valuations. I did much of the switching mid last year, but all that gold and the cash is pretty much a passenger now. I am not one of you young finance workers getting a savings rate of 50% into your SIPPs, I might have a negative savings rate this year.

I’m also trying to keep some of this year and last year’s ISA allowance, because I will draw a pension commencement lump sum from my main pension. And there is some hazard of a Corbyn led government in the future. As a retiree I won’t have a particularly spectacular income1 so I will probably be safe from his ministrations, but an ISA allowance of £20000 is way above what the vast majority of the population could even dream of saving. The argument that letting the rich shelter such a large yearly amount from tax does have some cogency, so I want the possibility of getting that PCLS into the ISA within the next year or two. Whether £20,000 will have any useful value in the Brexit Brave New World of buccaneering brio will remain to be seen.


  1. by the standards of my professional self or indeed the general UK PF scene – even the employed Ermine was way down in the ranks of finance whizz-kids well represented on the UK PF scene now. It wil be fine and more than my early retired self, but I don’t expect to be a tall poppy in Corbyn’s sights. Hopefully Corbyn won’t have the Blairite ambitions of siring a baby-boom through pronatal giveaways as we had in a tough period midway through my career, where every other bugger seemed to be getting the breaks. 
Advertisements