XML Data Migration to Excel for Analysis

Job ID: 38689824

Budget: $30 – $250 USD

I need someone to migrate a large XML dataset (over 28.000 records) to MS Excel. The primary purpose of this migration is for data analysis.

Key Requirements:
- Experience in data migration from XML to Excel
- Proficiency in MS Excel
- Ability to handle large datasets
- Able to transform data

See attached the xml file

Data needs to be loaded and transformed towards the following columns:

(Column name - example value)
//All numbers should be numbers in Excel, Timestamp date should be a date
Index Point = 13
Timestamp date = 2023-07-03
Timestamp time = 21:05:00
BBand Top = 102,653160892396
BBand Bottom = 102,60991588983
BBand Middle = 102,631538391113
High = 102,639999389648
Low = 102,63500213623
Open = 102,63500213623
Close = 102,63500213623
PVT = -0,00136349635096802
MACD Histogram = -0,0005059045458662
MACD = 0,00122802089782681
Signal = 0,00173392544369301
Vol = 3