Price updates when owning bonds directly

Discussion of the Bond portion of the Permanent Portfolio

Moderator: Global Moderator

Post Reply
User avatar
Matthew19
Senior Member
Senior Member
Posts: 115
Joined: Fri May 29, 2015 9:50 pm

Price updates when owning bonds directly

Post by Matthew19 » Wed Aug 12, 2015 11:05 am

Silly question : I bought my bonds through the bond desk at fidelity. Am I seeing an up to date price for the bonds when I look at my portfolio through fidelity or is delayed a day?
murphy_p_t
Executive Member
Executive Member
Posts: 1675
Joined: Fri Jul 02, 2010 3:44 pm

Re: Price updates when owning bonds directly

Post by murphy_p_t » Wed Aug 12, 2015 11:29 am

pricess updated overnight...not throughout day...something like 10pm eastern time..
barrett
Executive Member
Executive Member
Posts: 1982
Joined: Sat Jan 04, 2014 2:54 pm

Re: Price updates when owning bonds directly

Post by barrett » Wed Aug 12, 2015 2:59 pm

Yeah, with Fidelity the price update is even later than that... sometime after midnight. You can really only get an accurate idea of portfolio value by checking after the bonds update. For several hours during the trading day Fidelity shows the closing values from the previous day (and the increase or decrease in price). Then, at some point before they actually update around 1:00AM EST, they show values that are unchanged.

A great source for an up-to-date look at the PP is Ryan Melvey's Stable Investing site. The Recent Performance page has an "Intraday Interplay" chart which updates every minute or so. If you know the size of your PP and can do some basic math, you'll be able to figure out how much you are up or down for the day.
User avatar
Xan
Administrator
Administrator
Posts: 4392
Joined: Tue Mar 13, 2012 1:51 pm

Re: Price updates when owning bonds directly

Post by Xan » Wed Aug 12, 2015 3:11 pm

barrett wrote:If you know the size of your PP and can do some basic math, you'll be able to figure out how much you are up or down for the day.
Yowza.
User avatar
Matthew19
Senior Member
Senior Member
Posts: 115
Joined: Fri May 29, 2015 9:50 pm

Re: Price updates when owning bonds directly

Post by Matthew19 » Wed Aug 12, 2015 3:44 pm

Thanks guys. I don't plan on checking daily or anything, but since I just made my first purchase for the PP it's cool to watch the non-correlation at play.
User avatar
dualstow
Executive Member
Executive Member
Posts: 14228
Joined: Wed Oct 27, 2010 10:18 am
Location: synagogue of Satan
Contact:

Re: Price updates when owning bonds directly

Post by dualstow » Mon Aug 24, 2015 10:39 am

Although I have google drive sheets with specific bond prices set up with the help of members like fnord, I usually just look at what TLT is doing during the day. It's not perfect, but it's as good as going to the Wall Street Journal and reading about bonds.
Sam Bankman-Fried sentenced to 25 years
User avatar
dualstow
Executive Member
Executive Member
Posts: 14228
Joined: Wed Oct 27, 2010 10:18 am
Location: synagogue of Satan
Contact:

Re: Price updates when owning bonds directly

Post by dualstow » Tue Sep 29, 2015 2:18 pm

Google Sheets seems to update later than it used to. I used to see changes shortly after 3pm EST. Not so, these days.
Sam Bankman-Fried sentenced to 25 years
User avatar
foglifter
Executive Member
Executive Member
Posts: 634
Joined: Tue Apr 27, 2010 5:37 pm
Location: The Golden State

Re: Price updates when owning bonds directly

Post by foglifter » Wed Oct 14, 2015 5:58 pm

dualstow wrote: Although I have google drive sheets with specific bond prices set up with the help of members like fnord, I usually just look at what TLT is doing during the day. It's not perfect, but it's as good as going to the Wall Street Journal and reading about bonds.

dualstow, could you share the formula you use to get the bond price? I used to use the following formula, but at some point it stopped working and I wasn't able to fix it.


=index(ImportHtml("http://fixedincome.fidelity.com/fi/FIBo ... XXXX",1,10),5,2)
"Let every man divide his money into three parts, and invest a third in land, a third in business, and a third let him keep in reserve."
- Talmud
User avatar
dualstow
Executive Member
Executive Member
Posts: 14228
Joined: Wed Oct 27, 2010 10:18 am
Location: synagogue of Satan
Contact:

Re: Price updates when owning bonds directly

Post by dualstow » Wed Oct 14, 2015 8:53 pm

Sure. By the way, it does seem to be updating in a timely manner after all. I think I got this from fnord and one other bright spark.
If it looks like I'm dumbing it down, that's just in case brand new readers come across this. I know most of this will be obvious to you.

Code: Select all

=vlookup(date(2040,11,15),wsj!A200:C380,3,FALSE)
Instead of using a cusip, you can see that I had to fill in the date of maturity.

Now I don't remember if the authors of this code accessed the Wall Street Journal directly, but I found it convenient to have a tab right in my spreadsheet that loads the data. wsj! refers to that tab.

Put this in place of that tab name, or if you do it like me, make a tab called wsj and put this in cell A1:

Code: Select all

=importhtml("http://wsj.com/mdc/public/page/2_3020-treasury.html", "table",0)
Newly bought bonds are eventually out of bounds of those cell references, so I just make the numbers bigger. A200:C380 above used to be A100:C200 or something like that.
Last edited by dualstow on Wed Oct 14, 2015 8:54 pm, edited 1 time in total.
Sam Bankman-Fried sentenced to 25 years
User avatar
foglifter
Executive Member
Executive Member
Posts: 634
Joined: Tue Apr 27, 2010 5:37 pm
Location: The Golden State

Re: Price updates when owning bonds directly

Post by foglifter » Wed Oct 14, 2015 10:31 pm

Thanks, your explanation made sense and worked like a charm!  :)
"Let every man divide his money into three parts, and invest a third in land, a third in business, and a third let him keep in reserve."
- Talmud
User avatar
sophie
Executive Member
Executive Member
Posts: 1959
Joined: Mon Apr 23, 2012 7:15 pm

Re: Price updates when owning bonds directly

Post by sophie » Thu Oct 15, 2015 10:55 am

dualstow,

I've seen you post this before and I definitely wish I could take advantage of your excellent tips! 

However I have a mac and it seems unable to do queries (mac-ism for "import html").  Something about needing to install an ODBC driver.  I'm not crazy about installing an SQL database on an old macbook just for this, not to mention pay money to do so.  Does anyone know how to work around this??
"Democracy is two wolves and a lamb voting on what to have for lunch." -- Benjamin Franklin
User avatar
foglifter
Executive Member
Executive Member
Posts: 634
Joined: Tue Apr 27, 2010 5:37 pm
Location: The Golden State

Re: Price updates when owning bonds directly

Post by foglifter » Thu Oct 15, 2015 11:08 am

sophie wrote: dualstow,

I've seen you post this before and I definitely wish I could take advantage of your excellent tips! 

However I have a mac and it seems unable to do queries (mac-ism for "import html").  Something about needing to install an ODBC driver.  I'm not crazy about installing an SQL database on an old macbook just for this, not to mention pay money to do so.  Does anyone know how to work around this??

Sophie, you must be talking about Excel. The formulas above are for Google Sheets, which is all web-based hence you don't have to worry about ODBC drivers. Just open the browser, log into your Google account, create a spreadsheet and voila!
"Let every man divide his money into three parts, and invest a third in land, a third in business, and a third let him keep in reserve."
- Talmud
User avatar
sophie
Executive Member
Executive Member
Posts: 1959
Joined: Mon Apr 23, 2012 7:15 pm

Re: Price updates when owning bonds directly

Post by sophie » Thu Oct 15, 2015 11:21 am

Thanks!

I prefer not to keep my PP spreadsheet on Google, but at least it's nice to have a "calculator" for Treasuries available.
"Democracy is two wolves and a lamb voting on what to have for lunch." -- Benjamin Franklin
User avatar
dualstow
Executive Member
Executive Member
Posts: 14228
Joined: Wed Oct 27, 2010 10:18 am
Location: synagogue of Satan
Contact:

Re: Price updates when owning bonds directly

Post by dualstow » Thu Oct 15, 2015 12:25 pm

Right, what foglifter said. I don't use excel anymore and have never tried Apple's numbers app,
but I am on a Mac using Google Drive / Docs / Sheets.
Sam Bankman-Fried sentenced to 25 years
User avatar
mercuryfish
Junior Member
Junior Member
Posts: 2
Joined: Wed Oct 14, 2015 1:51 am

Re: Price updates when owning bonds directly

Post by mercuryfish » Fri Oct 16, 2015 12:40 am

A great source for an up-to-date look at the PP is Ryan Melvey's Stable Investing site. The Recent Performance page has an "Intraday Interplay" chart which updates every minute or so. If you know the size of your PP and can do some basic math, you'll be able to figure out how much you are up or down for the day.
[/quote]???
would you like to give me the link of Ryan Melvey's Stable Investing site???I Can't find it out.thank you.
gizmo_rat
Executive Member
Executive Member
Posts: 302
Joined: Mon Jan 17, 2011 5:25 am

Re: Price updates when owning bonds directly

Post by gizmo_rat » Fri Oct 16, 2015 4:28 am

mercuryfish wrote: would you like to give me the link of Ryan Melvey's Stable Investing site???I Can't find it out.thank you.
http://www.stableinvesting.com
TrevorShrade
Junior Member
Junior Member
Posts: 5
Joined: Fri Dec 20, 2013 4:45 pm

Re: Price updates when owning bonds directly

Post by TrevorShrade » Fri Oct 16, 2015 10:59 pm

dualstow wrote: Sure. By the way, it does seem to be updating in a timely manner after all. I think I got this from fnord and one other bright spark.
If it looks like I'm dumbing it down, that's just in case brand new readers come across this. I know most of this will be obvious to you.

Code: Select all

=vlookup(date(2040,11,15),wsj!A200:C380,3,FALSE)
Instead of using a cusip, you can see that I had to fill in the date of maturity.

Now I don't remember if the authors of this code accessed the Wall Street Journal directly, but I found it convenient to have a tab right in my spreadsheet that loads the data. wsj! refers to that tab.

Put this in place of that tab name, or if you do it like me, make a tab called wsj and put this in cell A1:

Code: Select all

=importhtml("http://wsj.com/mdc/public/page/2_3020-treasury.html", "table",0)
Newly bought bonds are eventually out of bounds of those cell references, so I just make the numbers bigger. A200:C380 above used to be A100:C200 or something like that.


Another options is you could use:

Code: Select all

=ImportXml("http://wsj.com/mdc/public/page/2_3020-treasury.html","//tr[td='11/15/2040']/td[3]")
which would access the Wall Street Journal directly everytime and not need the extra tab.
Last edited by TrevorShrade on Fri Oct 16, 2015 11:07 pm, edited 1 time in total.
User avatar
Kriegsspiel
Executive Member
Executive Member
Posts: 4052
Joined: Sun Sep 16, 2012 5:28 pm

Re: Price updates when owning bonds directly

Post by Kriegsspiel » Fri Oct 16, 2015 11:20 pm

Once fnord's formulas stopped working, I just started getting the price off Vanguard. Is that the same thing?
You there, Ephialtes. May you live forever.
economicsjunkie
Full Member
Full Member
Posts: 88
Joined: Mon Jun 29, 2015 2:09 pm

Re: Price updates when owning bonds directly

Post by economicsjunkie » Mon Oct 26, 2015 12:49 pm

Matthew19 wrote: Silly question : I bought my bonds through the bond desk at fidelity. Am I seeing an up to date price for the bonds when I look at my portfolio through fidelity or is delayed a day?
In Fidelity I always look up the current price under "Positions":

- click on the bond line item
- click on "View details for UNITED STATES TREAS BDS."
- click on "Price & Performance"
- then under "Price(Bid)" you can see the price at which you can currently sell the bonds
Post Reply