Question About My 30 Yr Treasuries
Moderator: Global Moderator
Question About My 30 Yr Treasuries
I noticed that TLT was up 2.04% today yet my own 30 yr treasuries seem to have risen about 1.3%. As an example, I have a 30 yr with a price of $100.344 that rose $1.33 today. Why the discrepancy?
Re: Question About My 30 Yr Treasuries
Sounds like your displayed bond price is delayed by a day. $1.33 was the previous day's gain (calculated price based on the yield change from 3.055% on 4/3/2013 to 2.987% on 4/4/2013). Check the price again on the next trading day and my guess is that you'll probably see today's ~2.5% gain on your 30-year bond.Reub wrote: I noticed that TLT was up 2.04% today yet my own 30 yr treasuries seem to have risen about 1.3%. As an example, I have a 30 yr with a price of $100.344 that rose $1.33 today. Why the discrepancy?
Last edited by Tortoise on Sat Apr 06, 2013 2:09 am, edited 1 time in total.
Re: Question About My 30 Yr Treasuries
Thank you, Tortoise. The bond price was delayed one day and I had a 2.45% increase. 

- dualstow
- Executive Member
- Posts: 15215
- Joined: Wed Oct 27, 2010 10:18 am
- Location: searching for the lost Xanadu
- Contact:
Re: Question About My 30 Yr Treasuries
Someone posted a helpful code -- was that melvey? fnord? -- that definitely shows updates faster than what I see in my brokerage houses, for those of us who can't wait for the monthly statements after an up day.Reub wrote: Thank you, Tortoise. The bond price was delayed one day and I had a 2.45% increase.![]()
So in google drive, you can have spreadsheet cell with the formula
=index(ImportHtml("http://fixedincome.fidelity.com/fi/FIBo ... &$A24,1,10),5,2)
while cell A24 contains the CUSIP. Very useful indeed.
I just noticed that you could also paste that same code with the cusip after the equals sign into your browser's address bar instead of a spreadsheet. e.g. https://fixedincome.fidelity.com/ftgw/f ... =912810QU5
and skip everything else to the right of the equals sign.
Last edited by dualstow on Sat Apr 06, 2013 10:07 am, edited 1 time in total.
*
Re: Question About My 30 Yr Treasuries
Yes, another similar function for gold is =Index(ImportHTML("http://apmex.com/","table",7),2,2)dualstow wrote:Someone posted a helpful code -- was that melvey? fnord? -- that definitely shows updates faster than what I see in my brokerage houses, for those of us who can't wait for the monthly statements after an up day.Reub wrote: Thank you, Tortoise. The bond price was delayed one day and I had a 2.45% increase.![]()
So in google drive, you can have spreadsheet cell with the formula
=index(ImportHtml("http://fixedincome.fidelity.com/fi/FIBo ... &$A24,1,10),5,2)
while cell A24 contains the CUSIP. Very useful indeed.
I just noticed that you could also paste that same code with the cusip after the equals sign into your browser's address bar instead of a spreadsheet. e.g. https://fixedincome.fidelity.com/ftgw/f ... =912810QU5
and skip everything else to the right of the equals sign.
With these two functions, it makes it easy to track a Kosher PP (no GLD or TLT

everything comes from somewhere and everything goes somewhere