'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