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!
google sheet not working for HK ETFs
Re: google sheet not working for HK ETFs
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
-
- Posts: 5181
- Joined: Mon Jun 04, 2007 4:19 pm
- Location: UK
Re: google sheet not working for HK ETFs
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.
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.