Still not working... time to figure out alternatives
Still not working... time to figure out alternatives
Looks like they have not fixed the problem on both their search engine and on google sheets. Am I right?
This is the formula I've started using for Google Sheets (I have 2800 in D4):
=IMPORTXML("https://www.marketwatch.com/investing/fund/"&D4&"?countrycode=hk","//*[@id='maincontent']/div[2]/div[3]/div/div[2]/h2/span")
Wow, thanks for the formula. It works! I only have one HK stock in my portfolio so not gonna pay for those add-on.
... and one more alternative
=IMPORTXML("https://finance.yahoo.com/quote/"&D4&".HK","//*[@id='quote-header-info']/div[3]/div[1]/div/fin-streamer[1]")
any alternative to the above two formulas, none of them work now it seems.
seems only work for 2800