Using IMPORTHTML, how would I take the table for the 2 or 3 tabs within investing.com's Real Time Commodity Futures Prices

user_18602230 0
Viewed 43

Trying to acquire the "Performance" table in Google Sheets using this link: https://www.investing.com/commodities/real-time-futures

I have tried: =IMPORTHTML("https://www.investing.com/commodities/real-time-futures","table",1)

But it only comes back with the first tab "Price" table. Any suggestions would be helpful.

google-sheets-formula web-scraping google-sheets import xpath
1 Answers

not possible. "Performance" table is controlled by JavaScript and google sheets IMPORT functions are not able to work with / scrape JS content

user_56326290
Related