Hi, I'm trying to use the IMPORTXML function in google sheets since the RC stock is now missing from GOOGLEFINANCE. I tried data scraping off of yahoo finance, motley fool, etc. but I always get “N/A resource at url not found.”
E.g. =IMPORTXML(“https://finance.yahoo.com/quote/RC/”,”/html/body/div[1]/div/div/div[1]/div/div[2]/div/div/div[6]/div/div/div/div[3]/div[1]/div/fin-streamer[1]“)
Any suggestions?
Leave a Reply