WSJ import into Google sheets stopped working

Discussion of the Bond portion of the Permanent Portfolio

Moderator: Global Moderator

Post Reply
User avatar
jason
Executive Member
Executive Member
Posts: 175
Joined: Mon Jun 10, 2013 4:10 pm

WSJ import into Google sheets stopped working

Post by jason » Wed Oct 02, 2019 9:02 am

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!
flyingpylon
Executive Member
Executive Member
Posts: 445
Joined: Fri Jan 06, 2012 9:04 am

Re: WSJ import into Google sheets stopped working

Post by flyingpylon » Wed Oct 02, 2019 10:16 am

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.
User avatar
dualstow
Executive Member
Executive Member
Posts: 8785
Joined: Wed Oct 27, 2010 10:18 am
Location: next to emotional support peacock
Contact:

Re: WSJ import into Google sheets stopped working

Post by dualstow » Wed Oct 02, 2019 12:31 pm

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.
RIP Paul Volcker
User avatar
jason
Executive Member
Executive Member
Posts: 175
Joined: Mon Jun 10, 2013 4:10 pm

Re: WSJ import into Google sheets stopped working

Post by jason » Wed Oct 02, 2019 3:16 pm

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.
User avatar
Mark Leavy
Executive Member
Executive Member
Posts: 513
Joined: Thu Mar 01, 2012 10:20 pm
Location: US Citizen, Permanent Traveler

Re: WSJ import into Google sheets stopped working

Post by Mark Leavy » Thu Oct 03, 2019 12:29 am

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
User avatar
jason
Executive Member
Executive Member
Posts: 175
Joined: Mon Jun 10, 2013 4:10 pm

Re: WSJ import into Google sheets stopped working

Post by jason » Thu Oct 03, 2019 12:12 pm

Does anyone know if there are other Google sheets functions that can work such as these?
ImportXML
ImportFEED
ImportDATA
mukramesh
Senior Member
Senior Member
Posts: 129
Joined: Fri Sep 12, 2014 3:27 pm

Re: WSJ import into Google sheets stopped working

Post by mukramesh » Mon Oct 07, 2019 11:52 am

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?
User avatar
Kbg
Executive Member
Executive Member
Posts: 1399
Joined: Fri May 23, 2014 4:18 pm

Re: WSJ import into Google sheets stopped working

Post by Kbg » Mon Oct 07, 2019 10:19 pm

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.
escafandro
Executive Member
Executive Member
Posts: 156
Joined: Tue Apr 26, 2011 7:15 pm

Re: WSJ import into Google sheets stopped working

Post by escafandro » Thu Oct 31, 2019 7:41 pm

Hi, any news with this issue?
User avatar
jason
Executive Member
Executive Member
Posts: 175
Joined: Mon Jun 10, 2013 4:10 pm

Re: WSJ import into Google sheets stopped working

Post by jason » Thu Nov 21, 2019 10:48 am

I've been reading online how you can extract/scrape data from websites using a Google Apps Script, but I can't figure it out. Does anyone know how to write a script and run it in google sheets? There has got to be a way to get the WSJ data imported into a Google spread sheet. Please help!!
User avatar
jason
Executive Member
Executive Member
Posts: 175
Joined: Mon Jun 10, 2013 4:10 pm

Re: WSJ import into Google sheets stopped working

Post by jason » Mon Dec 09, 2019 5:07 pm

Hello,
Now the bond prices at treasurydirect.gov are not importing into my google sheet. Is anyone having success with importing Treasury prices into a google sheet? If so, how? Please help!
Post Reply