0

I am using google sheet function to extract a table from investing.com, the data I need is on daily basis, where there is a button in the page named "daily". However since the default setting of the page is "hourly", when I use "importhtml" in google sheet the data given is on an hourly basis. The url for both "daily" and "hourly" is exactly the same. How can I extract the "daily" data?

enter image description here

https://www.investing.com/equities/apple-computer-inc-technical

Improve this question
1
  • Can you show your mporthtml function that your pulling in? e.g. which index your choosing for "table" - I think I have an answer for you , but I cant compare results without knowing
    – Aurielle Perlmann
    Mar 24, 2017 at 5:27

1 Answer 1

Reset to default
0

Actually this is an interesting workaround that works - for whatever reason - the mobile version of their site defaults to daily instead of hourly - the table indices are slightly differently ordered.

Original Function

But for example for this table, which on the regular page (the one you listed) would be :

=IMPORTHTML("https://www.investing.com/equities/apple-computer-inc-technical","table",5)

enter image description here

New Function

And for the same table with the mobile site you get daily:

=IMPORTHTML("https://m.investing.com/equities/apple-computer-inc-technical","table",0)

enter image description here

Improve this answer

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.