Daily Market Data PowerQuery in Excel
Budget: £20 – £250 GBP
I need an Excel 365 PowerQuery script that can fetch daily market data and handle potential data source interruptions or changes.
I will be providing a URL that contains the market data, and you'll need to replicate the Google Sheets function =INDEX(IMPORTXML("https://markets.ft.com/data/funds/tearsheet/summary?s=" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). This function provides real-time data from the specified URL. Please note that the data is structured using HTML tags.
Key requirements:
- The PowerQuery should be able to be refreshed with the google sheet.
- It needs to include robust error handling. If the data source is unavailable or the structure changes, the PowerQuery should not break but continue to function, ideally providing a notification that an error occurred.
Ideal skills:
- Proficiency in Excel 365 and PowerQuery.
- Experience in web scraping and handling dynamic data sources.
- Strong understanding of error handling techniques in PowerQuery.
I will be providing a URL that contains the market data, and you'll need to replicate the Google Sheets function =INDEX(IMPORTXML("https://markets.ft.com/data/funds/tearsheet/summary?s=" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). This function provides real-time data from the specified URL. Please note that the data is structured using HTML tags.
Key requirements:
- The PowerQuery should be able to be refreshed with the google sheet.
- It needs to include robust error handling. If the data source is unavailable or the structure changes, the PowerQuery should not break but continue to function, ideally providing a notification that an error occurred.
Ideal skills:
- Proficiency in Excel 365 and PowerQuery.
- Experience in web scraping and handling dynamic data sources.
- Strong understanding of error handling techniques in PowerQuery.