Gyroscopic Investing

Well, over a week, at the least.
Yahoo finance still shows it.
I guess it's just a Google Drive problem(?)

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.

Same here. I paste the price now and then, but of course I'm not looking. No one is!

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.

Wow, it works! Thank you!

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?

Actually, I just figured it out. To get PHYS to work in google sheets you now have to use this symbol: NYSEARCA:PHYS

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!

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.

I've been just hard coding it for a while now. I'll stick with that.

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

Yeah, I just type it in based on a price from Yahoo or Vanguard every 24 hrs instead of pulling it dynamically.