Google Sheets hasn't pulled PHYS price for a long time

Discussion of the Gold portion of the Permanent Portfolio

Moderator: Global Moderator

Post Reply
User avatar
dualstow
Executive Member
Executive Member
Posts: 14228
Joined: Wed Oct 27, 2010 10:18 am
Location: synagogue of Satan
Contact:

Google Sheets hasn't pulled PHYS price for a long time

Post by dualstow » Tue Feb 26, 2019 11:21 am

Well, over a week, at the least.
Yahoo finance still shows it.
I guess it's just a Google Drive problem(?)
Sam Bankman-Fried sentenced to 25 years
flyingpylon
Executive Member
Executive Member
Posts: 1102
Joined: Fri Jan 06, 2012 9:04 am

Re: Google Sheets hasn't pulled PHYS price for a long time

Post by flyingpylon » Tue Feb 26, 2019 11:32 am

Yeah, I'm not sure what's up with that. I just paste the current price into my spreadsheet temporarily so that it can update and then ctrl+z to go back to the formula hoping that the issue will eventually get resolved.

Or at least that's what I would do if I was checking, which of course I am not...

I'm not even sure if it's possible to report such things to the almighty Google.
User avatar
dualstow
Executive Member
Executive Member
Posts: 14228
Joined: Wed Oct 27, 2010 10:18 am
Location: synagogue of Satan
Contact:

Re: Google Sheets hasn't pulled PHYS price for a long time

Post by dualstow » Tue Feb 26, 2019 12:30 pm

Same here. I paste the price now and then, but of course I'm not looking. No one is! O0
Sam Bankman-Fried sentenced to 25 years
flyingpylon
Executive Member
Executive Member
Posts: 1102
Joined: Fri Jan 06, 2012 9:04 am

Re: Google Sheets hasn't pulled PHYS price for a long time

Post by flyingpylon » Tue Mar 05, 2019 9:12 am

I figured out what's going on with this. Google Finance now uses PHYS.U for Sprott Physical Gold Trust. PHYSX is PIA High Yield Fund Institutional Class.

So just enter PHYS.U and your spreadsheet should update again.

But quickly close it before you see your new total portfolio value. :)
User avatar
dualstow
Executive Member
Executive Member
Posts: 14228
Joined: Wed Oct 27, 2010 10:18 am
Location: synagogue of Satan
Contact:

Re: Google Sheets hasn't pulled PHYS price for a long time

Post by dualstow » Tue Mar 05, 2019 9:21 am

Wow, it works! Thank you!
Sam Bankman-Fried sentenced to 25 years
User avatar
jason
Executive Member
Executive Member
Posts: 248
Joined: Mon Jun 10, 2013 4:10 pm

Re: Google Sheets hasn't pulled PHYS price for a long time

Post by jason » Tue Apr 28, 2020 10:32 am

PHYS stopped working for me in google sheets. I tried both PHYS and PHYS.U and neither are working for me. Are other people seeing the same problem? Any solution?
User avatar
jason
Executive Member
Executive Member
Posts: 248
Joined: Mon Jun 10, 2013 4:10 pm

Re: Google Sheets hasn't pulled PHYS price for a long time

Post by jason » Tue Apr 28, 2020 10:48 am

Actually, I just figured it out. To get PHYS to work in google sheets you now have to use this symbol: NYSEARCA:PHYS
User avatar
dualstow
Executive Member
Executive Member
Posts: 14228
Joined: Wed Oct 27, 2010 10:18 am
Location: synagogue of Satan
Contact:

Re: Google Sheets hasn't pulled PHYS price for a long time

Post by dualstow » Tue Apr 28, 2020 10:52 am

jason wrote:
Tue Apr 28, 2020 10:48 am
Actually, I just figured it out. To get PHYS to work in google sheets you now have to use this symbol: NYSEARCA:PHYS
Brilliant, thank you!
Sam Bankman-Fried sentenced to 25 years
User avatar
jason
Executive Member
Executive Member
Posts: 248
Joined: Mon Jun 10, 2013 4:10 pm

Re: Google Sheets hasn't pulled PHYS price for a long time

Post by jason » Tue Apr 28, 2020 12:05 pm

For whatever reason, NYSEARCA:PHYS just stopped working so I changed it back to PHYS and now it's working. So google must have changed it yet again.
User avatar
dualstow
Executive Member
Executive Member
Posts: 14228
Joined: Wed Oct 27, 2010 10:18 am
Location: synagogue of Satan
Contact:

Re: Google Sheets hasn't pulled PHYS price for a long time

Post by dualstow » Tue Apr 28, 2020 12:15 pm

I've been just hard coding it for a while now. I'll stick with that.
Sam Bankman-Fried sentenced to 25 years
User avatar
vnatale
Executive Member
Executive Member
Posts: 9423
Joined: Fri Apr 12, 2019 8:56 pm
Location: Massachusetts
Contact:

Re: Google Sheets hasn't pulled PHYS price for a long time

Post by vnatale » Tue Apr 28, 2020 7:53 pm

MangoMan wrote:
Tue Apr 28, 2020 7:39 pm
dualstow wrote:
Tue Apr 28, 2020 12:15 pm
I've been just hard coding it for a while now. I'll stick with that.
What does that mean?
I wondered also. But I think he means, from other times he has written about this, that it means inputting the amounts by hand.

Vinny
Above provided by: Vinny, who always says: "I only regret that I have but one lap to give to my cats." AND "I'm a more-is-more person."
User avatar
dualstow
Executive Member
Executive Member
Posts: 14228
Joined: Wed Oct 27, 2010 10:18 am
Location: synagogue of Satan
Contact:

Re: Google Sheets hasn't pulled PHYS price for a long time

Post by dualstow » Tue Apr 28, 2020 8:02 pm

Yeah, I just type it in based on a price from Yahoo or Vanguard every 24 hrs instead of pulling it dynamically.
Sam Bankman-Fried sentenced to 25 years
Post Reply