I want to import the live individual stock price in the Google Sheets as highlighted on the image.
Is that possible?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityI want to import the live individual stock price in the Google Sheets as highlighted on the image.
Is that possible?
=IMPORTXML("https://in.investing.com/equities/jagson-airlines-bo",
"//span[@id='last_last']")
=IMPORTXML("https://in.investing.com/equities/jagson-airlines-bo",
"//span[@class='arial_26 inlineblock pid-987852-last']")
=INDEX(IMPORTHTML("https://in.investing.com/equities/jagson-airlines-bo",
"TABLE", 12), 2, 3)