google sheet not working for HK ETFs

For investors outside the US. Personal investments, personal finance, investing news and theory.
Sister forums: Canada, Spain (en español)
---------------
Post Reply
Topic Author
HKRiver
Posts: 12
Joined: Thu Jan 28, 2021 7:18 am

google sheet not working for HK ETFs

Post by HKRiver »

Hi

My google sheets is not able to pull prices for HK listed ETFs. This issue has lasted two weeks. Just wonder if anyone has the same issue? thanks!
Topic Author
HKRiver
Posts: 12
Joined: Thu Jan 28, 2021 7:18 am

Re: google sheet not working for HK ETFs

Post by HKRiver »

just wonder if any folks seeing this post can help try if your google sheets can pull prices for any HK listed ETFs and let me know? some HK listed ETFs like 3067 HK. The google sheets formula GoogleFinance(B12,"PRICE") B12=HKG:3067 used to work well to import prices into the google sheet. tsk
TedSwippet
Posts: 5181
Joined: Mon Jun 04, 2007 4:19 pm
Location: UK

Re: google sheet not working for HK ETFs

Post by TedSwippet »

GoogleFinance is sometimes flaky, but also seems occasionally prone to ... rationalisation? For example, at one time it used to reliably offer prices for most UK based mutual funds. Then it stopped, restarted, stopped, started again, and finally stopped and never restarted. For whatever reason it seems that Google simply decided to no longer offer information on these mutual funds. Perhaps it has now decided the same for HK based ETFs?

If you have some familiarity with other Sheets functions, you can probably put together a combination of ImportXml and other functions that will 'scrape' an alternative site to get the value you want. Perhaps something based on the following ideas?

xpath - Google Sheet: IMPORTXML from Yahoo Finance - Stack Overflow

It's a bit fiddly to do, though. Also, it tends to be brittle, since it relies on the layout/structure of the imported page not changing much, and they will. And there is always the possibility of the site you're importing from deliberately changing things to frustrate or even entirely stop this type of activity.
Post Reply