'googlesheet IMPORTHTML for multiple tab
I am using the IMPORTHTML
function in a Google Sheet cell to import commodities performance table from website : https://www.investing.com/commodities/real-time-futures.
=IMPORTHTML("https://www.investing.com/commodities/real-time-futures","table",1)
The website display PRICE
tab by default, the PERFORMANCE
tab must be clicked.
This formula only displays the PRICE
tab. How can I display the PERFORMANCE
table?
Solution 1:[1]
if you click on PERFORMANCE the URL does not change - this means import formula of gs will never get to it so you can't scrape it.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|---|
Solution 1 | player0 |