Stock Quote issues - Google Product Forums: Shasha - Community Specialist said:
Hi Philip,
Welcome to the Google Docs Help Forum.
As you mentioned, you're facing issues with some Canadian stocks. I'd recommend following the below steps to see if it helps:
Close the tab and reopen (Ctrl-Shift-T).
Select the cells with formulas, copy and paste back as "values only".
In addition to this, you can try using the IMPORTXML function that can pull the price off the google finance webpage. To learn more, please refer to our useful Help Center Article on�GOOGLEFINANCE.
If the issue still persists, please consider sharing a sample sheet with us using the shareable link.
Hope this helps.
Best,
Shasha
Wednesday, January 11, 2017
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment