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?
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.
But for example for this table, which on the regular page (the one you listed) would be :
And for the same table with the mobile site you get daily:
I am also having similar issue with historical values of Oil. The link for the same is https://www.investing.com/commodities/crude-oil-historical-data.
When I use the below function, it is populating last one month data. How can I make the function to download past 10 years data or so?
Is it possible to tweak the below?