Google Sheets hasn't pulled PHYS price for a long time
Moderator: Global Moderator
- dualstow
- Executive Member
- Posts: 14226
- Joined: Wed Oct 27, 2010 10:18 am
- Location: synagogue of Satan
- Contact:
Google Sheets hasn't pulled PHYS price for a long time
Well, over a week, at the least.
Yahoo finance still shows it.
I guess it's just a Google Drive problem(?)
Yahoo finance still shows it.
I guess it's just a Google Drive problem(?)
RIP Marcello Gandini
-
- Executive Member
- Posts: 1102
- Joined: Fri Jan 06, 2012 9:04 am
Re: Google Sheets hasn't pulled PHYS price for a long time
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.
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.
- dualstow
- Executive Member
- Posts: 14226
- 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
Same here. I paste the price now and then, but of course I'm not looking. No one is!
RIP Marcello Gandini
-
- Executive Member
- Posts: 1102
- Joined: Fri Jan 06, 2012 9:04 am
Re: Google Sheets hasn't pulled PHYS price for a long time
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.
So just enter PHYS.U and your spreadsheet should update again.
But quickly close it before you see your new total portfolio value.
- dualstow
- Executive Member
- Posts: 14226
- 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
Wow, it works! Thank you!
RIP Marcello Gandini
Re: Google Sheets hasn't pulled PHYS price for a long time
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?
Re: Google Sheets hasn't pulled PHYS price for a long time
Actually, I just figured it out. To get PHYS to work in google sheets you now have to use this symbol: NYSEARCA:PHYS
- dualstow
- Executive Member
- Posts: 14226
- 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
Brilliant, thank you!
RIP Marcello Gandini
Re: Google Sheets hasn't pulled PHYS price for a long time
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.
- dualstow
- Executive Member
- Posts: 14226
- 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
I've been just hard coding it for a while now. I'll stick with that.
RIP Marcello Gandini
- vnatale
- Executive Member
- Posts: 9422
- Joined: Fri Apr 12, 2019 8:56 pm
- Location: Massachusetts
- Contact:
Re: Google Sheets hasn't pulled PHYS price for a long time
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."
- dualstow
- Executive Member
- Posts: 14226
- 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
Yeah, I just type it in based on a price from Yahoo or Vanguard every 24 hrs instead of pulling it dynamically.
RIP Marcello Gandini