Page 1 of 1

WSJ import into Google sheets stopped working

Posted: Wed Oct 02, 2019 9:02 am
by jason
Hello,
I've been importing the US Treasury prices from the Wall Street Journal bond pricing page into my Google sheet for years. It stopped working for me recently. Have other people noticed the same thing? Is there a workaround or alternative source?
Thanks!

Re: WSJ import into Google sheets stopped working

Posted: Wed Oct 02, 2019 10:16 am
by flyingpylon
Looks like they are no longer using a simple HTML table to display the data, so the Google Sheets formula fails. That sucks.

If anyone is good with regular expressions, the data is still there and could probably be retrieved. Unfortunately I am short on both regex skills and time to figure it out, so maybe there's another source out there.

Re: WSJ import into Google sheets stopped working

Posted: Wed Oct 02, 2019 12:31 pm
by dualstow
A few weeks ago, I started just typing in the values from Vanguard occasionally. I was going to look for a real fix, but I noticed the stock prices Google Sheets was pulling weren’t that hot either. They didn’t match Yahoo & Vanguard.

Re: WSJ import into Google sheets stopped working

Posted: Wed Oct 02, 2019 3:16 pm
by jason
The pricing data does load into the source code of the URL, so if there is a possibility of somehow parsing the source code and inserting the data into a Google sheet, that would be great. This is way over my head, technically.

Re: WSJ import into Google sheets stopped working

Posted: Thu Oct 03, 2019 12:29 am
by Mark Leavy
Stopped working for me also. I couldn't figure out how to get the data out of the WSJ page, so in the meantime, I've reverted back to pulling the data from Treasury Direct.

Code: Select all

=importhtml("https://www.treasurydirect.gov/GA-FI/FedInvest/todaySecurityPriceDate.htm","table",1) 
Unfortunately, it is only closing prices and only posted for a few hours per day. Most of the time it is a bad link.

If anyone has a better fix, I'm all ears.
Mark

Re: WSJ import into Google sheets stopped working

Posted: Thu Oct 03, 2019 12:12 pm
by jason
Does anyone know if there are other Google sheets functions that can work such as these?
ImportXML
ImportFEED
ImportDATA

Re: WSJ import into Google sheets stopped working

Posted: Mon Oct 07, 2019 11:52 am
by mukramesh
Ayah, I thought it was just my Google sheet that stopped working! It was nice being able to see the entire yield curve at a glance.

Has anyone found a decent workaround yet?

Re: WSJ import into Google sheets stopped working

Posted: Mon Oct 07, 2019 10:19 pm
by Kbg
Excel has some excellent tools for data scrapping now. But yeah, you pay for it and you have to learn how to use the tools.