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.