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(?)

flyingpylon · 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.

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!

flyingpylon · 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.

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

Wow, it works! Thank you!

jason · 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?

jason · 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

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!

jason · 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.

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.

vnatale · 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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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