Trying to code for a missing stock in Google Sheets Portfolio (NYSE:RC), please help


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?


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *