Create script or excel macro to autofill spreadsheet from MT5 HTML/Excel statement

Scripts Integration

Specification

I use EdgeWonk trading journal software to journal my trades. I want someone to create some sort of script or macro to autofill the Edgewonk generic spreadsheet with all my closed positions from my MT5 statements.

I have attached the Edgewonk generic statement and a screenshot of how the cells need to be formatted.

Files:

ZIP
Edgewonk.zip
66.4 Kb

Responded

1
Developer 1
Rating
4.92
(78)
Projects
130
36%
Arbitration
19
21% / 42%
Overdue
36
28%
Working
2
Developer 2
Rating
4.6
(128)
Projects
208
40%
Arbitration
86
20% / 40%
Overdue
93
45%
Busy
3
Developer 3
Rating
4.6
(5)
Projects
6
0%
Arbitration
0
Overdue
2
33%
Working
4
Developer 4
Rating
3.67
(3)
Projects
3
0%
Arbitration
1
0% / 100%
Overdue
0
Free

Project information

Budget
30+ USD
For the developer
27 USD

Customer

Placed orders6
Arbitrage count0