Question about Microsoft Excel

Aseel 0 Reputation points
2023-07-04T16:31:23.2433333+00:00

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

1

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,145 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,756 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Olaf Helper 45,881 Reputation points
    2023-07-05T06:10:46.4933333+00:00

    Try it with "Power Query" for Excel => Web Connector

    https://learn.microsoft.com/en-us/power-query/connectors/web/web

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.