1

My goal is to retrieve the "Clôture de la veille" number (90,050 €) from this webpage : https://www.easybourse.com/action-cours/renault/intraday/FR0000131906-25

In Google Sheets, when using the IMPORTXML formula, it returns 0€ instead of 90,050€. Here is my formula: =value(IMPORTXML("https://www.easybourse.com/action-cours/renault/intraday/FR0000131906-25","//span[@id='cours_dernier_veille']"))

Can you please explain to me why Google Sheets is returning a wrong value?

1
  • Sure but do you have any idea why the IMPORTXML is blank? Nov 8, 2017 at 10:57

1 Answer 1

1

IMPORTXML is only able to read values on the source code of the page but the value you are looking for isn't there, it's added by something that modify the DOM (document object model).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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