This article can be read by selected Monevator members. Please see our membership plans and consider joining! Already a member? Sign in here.
Index-linked gilts: how to price, value, and track them in your portfolio with our spreadsheet [Members]
Next post: FIRE-side chat: secret squirrel
Previous post: Weekend reading: Trading places
Comments on this entry are closed.
Wonderful. Personally, I like spreadsheets, and I like reading; reading about spreadsheets is a whole new level 🙂
I downloaded v1 for future use. Could you post a note in the comments in case of any updates or corrections?
Many thanks!
Heh heh. Yes, sure will.
When I click the spreadsheet link it just opens up as a new tab on Firefox. I have goggle docs on my tablet. I know how to make and edit the spreadsheet but how do I get it from the link to goggle docs.
I’m shocked that this hasn’t got hundreds of comments…
Many thanks – I got interested in I-L bonds through youthful reading of Troy, Ruffer and CGT, but has it worked for them (Arrested Development gif)? Maybe it has – it certainly should have, given how smart they all are.
But I think ultimately they are still in my ‘too hard’ pile (which sounds better than my ‘I’m not smart enough’ pile…).
It’s probably a cop-out – I’m not a gold bug, but it has seemed to work better for me as an inflation hedge.
Anyway, often things change, and I come back to look at stuff, so I’m very grateful for this and the other article, and will no doubt be reading it carefully in the future.
@Tom — Cheers, and I know. Strangely silent after the huge debate on Linkers last week, and it’s not for lack of Mavens opening and reading the page.
Maybe everyone is just linkered out 😉
Re: Gold, grateful to have some, wish I hadn’t top-sliced it a few months ago… 😉
@Garry — Sorry to hear of your troubles.
I’m not sure exactly what your asking? Are you saying the new tab doesn’t show the spreadsheet? I’ve tested I can’t recreate that here. If this is so then perhaps you have some kind of security feature blocking it?
If you can open it on any device (e.g. desktop) where you’re logged into your Google accounts (e.g. gmail or Google drive) then you should be able to save the document there and re-open it on the tablet.
With that said I wouldn’t want to edit this kind of spreadsheet on a tablet, personally. It’s quite fiddly!
Hope this helps.
This series on linkers has been so valuable as a resource. As I move into deaccumulation I’m trying to simplify matters, thinking of what happens if I get hit by the proverbial bus and leaving my spouse to deal with this stuff, would a linker component to the portfolio be a step too far? Perhaps the complexity is just in the buying…
Anyway it’s definitely food for thought and thanks for all your efforts.
@ Tom and Larsen – Thank you! I know where you’re coming from. They’ve been in my too hard pile for years as well. It’s definitely a learning curve. Not because the material is inherently hard but because it’s scattered about like the fragments of some universe-vaporising super-weapon. And there isn’t a handy manual.
Once you get past all that, linkers are pretty much just a tradable index-linked saving certificate – with a better yield these days.
Hold ’em to maturity and you can’t make a loss if you buy in at a positive yield. One thing I probably haven’t mentioned enough is that Tradeweb publish the real yields on a daily basis.
I’m really keen to set up some linkers but don’t know what I’m doing. I want to make sure I understand the principles. So please forgive what will probably be the first of several silly questions about your spreadsheet.
In the first block, the dirty price (J) for TR26,T27 and T28 is calculated differently from that of T301. It seems to be because you have n/a as the index value for T301 (column U) But today (20th November 2024), looking at https://www.dmo.gov.uk/data/pdfdatareport?reportCode=D1D, I think I can see an index value for T301 of 2.83494.
My main question is why/when is a different formula used for the dirty price for some gilts? Secondly, am I right to now use the same formula for all 4 gilts?
Thank you
Hi David,
These are excellent questions and I can see I neglected to explain the difference. My apologies!
T30I is an 8-month indexation lag linker i.e. it indexes to the inflation rate 8-months ago (as opposed to 3-months ago, which is the standard used by most index-linked gilts today).
T30I is an example of an older type of index-linked gilt. This type uses a different formula (from the 3-monthers) and its index ratio should not be used.
TR26, T27 and T28 are examples of 3-month indexation linkers. This type have effectively succeeded the 8-monthers and their formula does require the index ratio.
There are only two 8-monthers left in circulation: T30I and T2IL.
Thank you.
I think this spreadsheet is a masterpiece!
I bought a very small amount of TR26 – UK Index Linked Gilt 2026 on 22/11 – Friday. I can leave a comment on that over in the ‘How to buy index linked-gilts’ post.
Anyway, the purchase was done on Friday, with Settlement on Tuesday 26/11. I plugged the values from my broker’s contract note in here and it all worked perfectly.
Even better than that, although I had to wait until the 26/11 the indexation ratio was published by the DMO, I found that plugging in all the data, including the settlement date and the ‘units double check’, I could use the goal seek function to tell me what the indexation value should be when it was published, to make the other figures make sense.
When it was published, it was correct, to 5 decinal places that the DMO use, so super impressive.
Thanks, Jam. It’s great to hear the spreadsheet helped. I was hoping it’d encourage more people to dip their toe into linkers but the muted response to this post makes me think it’s still too beardy an area for most.
Appreciate hearing about your experience on the other thread, too.
I’m retired and am happy with the current value of my share portfolio.
I’m not looking for further capital growth but do want to be protected from inflation.
While I procrastinate the value of my portfolio increases but Monevator has educated me in the dangers of that!
I’m very keen to dip my toe into linkers and then hopefully go in up to my waist.
Thank you for what you’ve written on this topic.
I tried to buy some gilts (T27) through IWeb and it gave me a clean price in line with expectation.
When I tried to make a trade it said it could not be completed automatically but had to be submitted as a negotiated order.
Is this normal? I don’t like buying something when I don’t know the price.
Hi David – I’m guessing that you have to place a telephone order? Is that what they mean by a negotiated order?
Snowman reported his experience with Halifax Share Dealing which is essentially iWeb under a different brand name:
https://monevator.com/how-to-buy-index-linked-gilts/#comment-1844172
He was able to buy his linkers online but neither were T27. It seems some brokers are running a hybrid system of online and telephone orders depending on the bond.
The article linked to above summarises the experience of a number of Monevator readers who’ve bought linkers via telephone trades – which is standard at a number of brokers.
The broker will give you an indicative price (which to be fair, is what I get when I place an online order).
That indicative price – whether clean or dirty should be close to the price you can see on Yieldgimp or using the spreadsheet attached to this article.
So far, nobody’s reported anything amiss. The system does seem to work, it’s just arcane like a wizard’s beard.
Thank you for your further comment and apologies for not responding more quickly.
I’m not asking for a response to this post. Just letting you know what happened in case that’s useful.
I didn’t raise a telephone order.
I simply allowed iWeb to submit a ‘negotiated order’ and then got notification of a trade about 30 minutes later. The price was very close to the clean price when I first attempted to make a trade.
This trade was for a trivial amount so I wasn’t concerned about the price. But I’m temperamentally uncomfortable about committing to spend a lot of money on something when I don’t know the price.
I remain very keen on linkers and will be reading through your posts and looking to other sources so that I can use them.
Thank you again for your posts on this topic.
To add to comments by others the articles on linked gilts have been very useful. Another option on the defensive side of the portfolio. Maybe held outside of an ISA as I understand you don’t pay CGT although you may pay tax on interest. I have purchased a few to test how it works. The way platforms display the clean price like you have made an immediate loss is off putting. Ill give it a little more consideration before purchasing more but definitely an option worth considering.
Good morning. I am a brand new member and struggling to understand index linked gilts. I have taken a look at the spreadsheet and will need to take quite a few more looks to understand it properly !! I wondered if fellow readers could ‘pull apart’ this simple scenario.
Say an individual has just retired and only (luckily) needs their portfolio to match inflation to provide the lifestyle required.
They have a portfolio worth 300,000 and need 10,000 a year for their desired lifestyle. They guess they will live for another 30 years.
Could they ‘simply’ on day 1 of retirement buy 10,000 GBP of index linked gilts each maturing one year after the next between year 1 and year 30. When an individual initial 10,000 GBP gilt matures it will ‘pay’ enough back to ‘live their life’ until the next gilt matures the following year and so on and so on ? Does the scenario fall down because there is an implied inflation in todays gilt price so this only protects if inflation turns out to be higher than that implied in todays pricing ? … if so then how can this implied inflation be protected against ? I know I am missing something …. perhaps a lot … all comments welcome
thanks
Miles
@Miles – this article and accompanying spreadsheet deals with the scenario you’re describing: https://monevator.com/index-linked-gilt-ladder/
That said, when you buy linkers today, the price includes inflation as measured by the RPI index – with a lag of three months. In other words, the price in Feb includes all changes in RPI up to November. Not implied inflation but actual inflation.
So £10,000 spent today on linkers buys £10,000 worth of linkers in today’s money – providing we’re not overly concerned with the index-lag, which we shouldn’t be.
So let’s say you want to live on £10,000 at the end of year 1 (adjusted for any inflation accrued in the mean-time).
You buy enough linkers so that their maturity value in one year plus any interest earned in the meantime = £10,000.
All of the linker’s cashflows will automatically adjust in line with inflation during that year because that is how the security is structured. If inflation goes up then that increase will be included in the interest and maturity value you receive as and when the linker pays out.
The same goes for the linkers bought to cover years 2 – 30. You buy enough in today’s money to cover your £10,000 income needs per year. The inflation-adjustment mechanism of each linker covers you for inflation going forward.
So, essentially I’m saying that you’re accurately describing how an index-linked gilt portfolio works when structured to deliver inflation-protected income.
But the price doesn’t include implied inflation it includes actual inflation.
Implied inflation is contained within the yield of nominal gilts. Nominal gilts provide insufficient protection against inflation if it proves higher than expected. But nominal bonds outperform linkers if inflation proves to be lower than expected. You may have read descriptions of the “breakeven rate” which could be where this idea of implied inflation has arisen?
Anyway, I hear you when you say it’s a struggle to get to grips with bonds. It really is!
You should be able to find most of our coverage here:
https://monevator.com/tag/index-linked-gilts/
I hope this helps!
@Miles #18
What you have described will work, it is a an Index Linked Gilt Ladder, as @The Accumulator has said. You will get you investment back, increased in line with actual inflation, plus a small amount extra (the real yield) over the the 30 year period.
Here is a link to a useful site: https://www.yieldgimp.com/index-linked-gilt-yields
See the column ‘Yield’ / ‘(Real)’, for the real return you will get.
So you plan is sound, unless of course you live longer than 30 years!
Taking a step back, what you are trying to do it seems is to come up with a plan to live of a pot of money, for the rest of you life and not lose spending power in real terms, not knowing how long you will live. This is an old investment problem and it is not the first time it has been considered.
Can I suggest reading the book ‘Living Off Your Money’, by Michael McClung. It is a bit of a favourite in these parts. Expensive, but it will replay the cost many times over. It goes through the problem and comes up with what I think are better solutions than the index linked gilt ladder and has heavily influenced my own approach to the problem you describe.