I've trying this for several days and I'm not able to load the data displayed below the graph in https://es.investing.com/equities/facebook-inc

IMPORTHTML does not work because these fields are the response from a JSON query. I've used Chrome Dev Tools to save the result in a HAR file and found one of the fields "Retorno un año", but I am not able to automatize the query (curl cmd only returns the .js source code, not the response, it was the first time that I used it...):

Any ideas about how to import these fields into a Google Docs Spreadsheet?

P.S.: I can't paste the commands due to my low reputation (no more than 1 URL allowed), sorry :(

1 Answer 1


You can pull in all those fields using importxml instead of importhtml:

=IMPORTXML("https://es.investing.com/equities/facebook-inc","//*[@class='clear overviewDataTable']/*")

enter image description here

  • Nice! it works, it will be really helpful, thank you so much :). Best Regards.
    – Adrián
    Apr 3, 2017 at 11:02

Your Answer

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

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