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.