Daily Market Data PowerQuery in Excel - 18/04/2024 18:11 EDT
Budget: £20 – £250 GBP
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes.
Google Shhets example =INDEX(IMPORTXML("https://markets.ft.com/data/funds/tearsheet/summary?s=" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1).
<Where C31 = Cell containing the Stock
eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163
I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable)
Ideal skills:
- Proficiency in Excel 365 and PowerQuery and VBA
- Experience in web scraping and handling dynamic data sources.
I am after a fixed quote for this project.
Google Shhets example =INDEX(IMPORTXML("https://markets.ft.com/data/funds/tearsheet/summary?s=" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1).
<Where C31 = Cell containing the Stock
eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163
I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable)
Ideal skills:
- Proficiency in Excel 365 and PowerQuery and VBA
- Experience in web scraping and handling dynamic data sources.
I am after a fixed quote for this project.