Gyroscopic Investing

I'm using a google docs spreadsheet to track my portfolio and the recommended method for getting the current prices for treasuries seems to be broken.  Anyone else having the same issue?

Here's the cell contents for fetching the current price:
All I'm getting back is 'N/A'.  If I bring up the same URL in a browser, I see what looks like current information.  Did Fidelity move things around?

mike

MikeK wrote: I'm using a google docs spreadsheet to track my portfolio and the recommended method for getting the current prices for treasuries seems to be broken.  Anyone else having the same issue?

Here's the cell contents for fetching the current price:

Code: Select all

=index(ImportHtml("http://fixedincome.fidelity.com/fi/FIBondDetails?ordersystem=AORD&cusip=CUSIP",1,10),5,2)

All I'm getting back is 'N/A'.  If I bring up the same URL in a browser, I see what looks like current information.  Did Fidelity move things around?

mike

I am having the exact same problem.  Hopefully, someone will post a fix.

I use a Python program to extract the price information with that URL, and it still works for me.

I took a quick look at the html source of the page at Fidelity and it doesn't seem to have changed.  From what I can tell the formula "should" still work.  But unfortunately, I'm not able to spend any more time on it right now.  Perhaps it will magically start working again given some time.

I'm wondering if Fidelity got tired of the extra hits to their servers and began blocking traffic coming from google apps.

MikeK wrote: I'm using a google docs spreadsheet to track my portfolio and the recommended method for getting the current prices for treasuries seems to be broken.  Anyone else having the same issue?

Here's the cell contents for fetching the current price:

Code: Select all

=index(ImportHtml("http://fixedincome.fidelity.com/fi/FIBondDetails?ordersystem=AORD&cusip=CUSIP",1,10),5,2)

All I'm getting back is 'N/A'.  If I bring up the same URL in a browser, I see what looks like current information.  Did Fidelity move things around?

mike

My google apps spreadsheet is still showing N/A for the Fidelity link.  Does anyone have a fix or know of another link I can use to put in my google spreadsheet to get bond prices?  Having to enter it manually is a real pain.

It looks to me that fidelity blocked access from google's servers.

I don't use this myself so I don't know much about it but it seems I was able to get this to work:

First, input your CUSIP on this page and it appears to give you an encrypted ID:
Then supply the new ID into the formula.
I am not sure if the ID will continue to work.

See the thread in the bonds § by MikeK akratik, specifically posts by Khisanth and Flying Pylon.

You can draw data from cnn and plug that into the price function, although FP noticed that the result may be undervalued compared to Fidelity's.
I have noticed the same thing when I sign into Vanguard and Fidelity, although it depends upon the time of day.
I also look at data from the Wall St Journal -- I don't know how to draw it via code -- which is also different, because it's from 3:00PM Eastern on a trading day, but at least it gives me something to compare the code results to.

Anyway, cnn.

Edited thread OP author only.

Did marketwatch tracking die for others too? Doesn't work anymore for me

Rezo wrote: Did marketwatch tracking die for others too? Doesn't work anymore for me

Yes, the site seems to have gone off-line a couple of days ago.  I haven't yet found a work around for automatically pulling the prices.

Update:  FNORD123's method works well:
http://gyroscopicinvesting.com/forum/bo ... /#msg77539