Try it with "Power Query" for Excel => Web Connector
https://learn.microsoft.com/en-us/power-query/connectors/web/web
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I want to extract certain live data from this page " https://www.investing.com/currencies/eur-usd-technical " to excel (not google sheet). And I'm able to do so up to an extent only. What's giving me a hard time here on this page is that it has 9 tabbed content such as 1 Min, 5 Min, 15 Min and so on. Datas under each of this tabbed content is different and it doesn't have any sub links/url when I click the tabbed content. So how do I extract information from this page under each tabbed content? Below I have uploaded a screenshot to better understand them.
Thanks
Try it with "Power Query" for Excel => Web Connector
https://learn.microsoft.com/en-us/power-query/connectors/web/web