1

I want to import the live individual stock price in the Google Sheets as highlighted on the image.

Is that possible?

https://in.investing.com/equities/jagson-airlines-bo

enter image description here

1 Answer 1

1

=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)

3

Not the answer you're looking for? Browse other questions tagged or ask your own question.