Google-sheets – How to import data from Investing.com into spreadsheet

formulasgoogle sheetsimporthtmlimportxmlworksheet-function

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

The error in your importxml was in the xpath syntax. here is the correct one:

=CONCATENATE(IMPORTXML("http://www.walmart.com/ip/Morton-Sea-Salt-Fine-Salt-17.6-oz/10849552","//*[@itemprop='price'][1]"))

edited: added the [1] at the end of the xpath to prevent the duplicate price.

This formula worked perfectly for me:

=IMPORTXML("http://www.toysrus.com/product/index.jsp?productId=22360626","//*[@id='price']/ul/li[2]/span")