Like Tree12Likes

2800 Tracker/Google Finance

Closed Thread
Page 2 of 3 FirstFirst 1 2 3 LastLast
  1. #11

    Join Date
    Oct 2011
    Posts
    871


    Still not working... time to figure out alternatives

  2. #12

    Join Date
    Dec 2002
    Location
    薄扶林
    Posts
    47,971

    Yahoo Finance with Sheets scripts...


  3. #13

    Join Date
    Dec 2002
    Location
    薄扶林
    Posts
    47,971

    Looks like they have not fixed the problem on both their search engine and on google sheets. Am I right?


  4. #14

    Join Date
    Oct 2011
    Posts
    871
    Quote Originally Posted by shri:
    Looks like they have not fixed the problem on both their search engine and on google sheets. Am I right?
    yup, seems like they don't even bother anymore They rather encourage people to use adds-on with some fee

  5. #15

    Join Date
    Jul 2016
    Posts
    182
    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")
    shri, Andy SNK and Damelin like this.

  6. #16

    Join Date
    Jan 2022
    Posts
    1

    Wow, thanks for the formula. It works! I only have one HK stock in my portfolio so not gonna pay for those add-on.


  7. #17

    Join Date
    Jul 2016
    Posts
    182

    ... and one more alternative

    =IMPORTXML("https://finance.yahoo.com/quote/"&D4&".HK","//*[@id='quote-header-info']/div[3]/div[1]/div/fin-streamer[1]")

    shri likes this.

  8. #18

    any alternative to the above two formulas, none of them work now it seems.


  9. #19

    Join Date
    Dec 2002
    Location
    薄扶林
    Posts
    47,971
    Quote Originally Posted by austinmtrhk:
    any alternative to the above two formulas, none of them work now it seems.
    This works. Tried it a minute ago.


    Code:
    =IMPORTXML("https://finance.yahoo.com/quote/2800.HK","//*[@id='quote-header-info']/div[3]/div[1]/div/fin-streamer[1]")

  10. #20

    Join Date
    Oct 2011
    Posts
    871

    seems only work for 2800

    austinmtrhk likes this.