Like Tree12Likes

2800 Tracker/Google Finance

Reply
Page 3 of 3 FirstFirst 1 2 3
  1. #21

    Join Date
    Dec 2002
    Location
    薄扶林
    Posts
    42,355
    Quote Originally Posted by Andy SNK:
    seems only work for 2800
    Try this then?

    Code:
    =IMPORTXML("https://www.cnbc.com/quotes/3110-HK","//*[@id='MainContentContainer']/div/div[2]/div[1]/div[2]/div[3]/div[1]/div[2]/span[1]")
    austinmtrhk and Andy SNK like this.

  2. #22

    Join Date
    Oct 2011
    Posts
    715
    Quote Originally Posted by shri:
    Try this then?

    Code:
    =IMPORTXML("https://www.cnbc.com/quotes/3110-HK","//*[@id='MainContentContainer']/div/div[2]/div[1]/div[2]/div[3]/div[1]/div[2]/span[1]")
    this one works better. thanks @shri

  3. #23

    Join Date
    Dec 2002
    Location
    薄扶林
    Posts
    42,355
    Quote Originally Posted by Andy SNK:
    this one works better. thanks @shri
    If you're familiar enough with html and browsers, inspect the price in chrome and copy the 'xpath' into the second part of the formula with the first bit being the URL ... can be made to work with pretty much any data on a publically available site, as long as they don't block the google docs/sheets crawler.
    Andy SNK likes this.

  4. #24

    Join Date
    Aug 2019
    Posts
    13

    I noticed these tickers seem to be working again on google as of yesterday. No workaround required.

    I'm curious what happened that meant just ETFs disappeared, but we'll probably never know.

    Andy SNK likes this.

  5. #25

    Join Date
    May 2021
    Posts
    561

    Just a bug, don't overthink it, its a half-baked product..


Reply
Page 3 of 3 FirstFirst 1 2 3