I’m trying to extract RSI(14) value from investing.com into Google Sheets. I tried both =importxml and =importhtml but I’m getting error ‘Couldn’t fetch URL’. Importhtml used to work in past but not working anymore.
=importxml("https://www.investing.com/equities/apple-computer-inc-technical","/html/body/div[2]/div[2]/div[2]/div[2]/div[1]/div[3]/div/div[2]/div[2]/div[2]/div/table/tbody/tr[1]/td[2]")
=importhtml("https://www.investing.com/equities/apple-computer-inc-technical","table",4)
0
Google Sheets functions importhtml(), importxml(), importdata() and importfeed() only work with static pages. The link you’ve provided (investing.com) uses scripts to load the data, so you cannot use these mentioned functions.