Script in mql5 to translate yahoo finance stock data into compatible data for mt5

MQL5 Scripts

Job finished

Execution time 1 hour
Feedback from customer
Very good work! As requested, thanks!
Feedback from employee
Thank you, Marco! Glad to work with you again!

Specification

I need a simple script in mql5, which must take data from an CSV file in -> MetaTrader 5\HISTORY -> downloaded by me from yahoo finance website, so must edit the data and print another CSV file, with compatible data for the MT5 platform.

More precisely the necessary changes are:

- Removing the first row

- Remove Adj Close column

- replace the "-" (hyphen) of the date with a "." (point)

- Add the time culumn with 00:00 as default value, after the date

- Replace the separator from "," (comma) to Tab

- then print a csv with the -> original name + "correct"

Additional features

- I need to be able to select the print date format ( dd.mm.yyyy or yyyy.mm.dd or mm.dd.yyyy )  in external settings

- i need to be able to select the print culumn time  in external settings

- i need to be able to write the name of the file to be changed in external settings


the source code mq5 must be included in the work

The work must be done in a single mq5 file without dll


I am attaching the example of an original yahoo file, "AAPL eng Yahoo format" and the fixed file "APPL" correct as the script should do

Files:

CSV
AAPL.csv
644.1 Kb

Responded

1
Developer 1
Rating
(192)
Projects
232
30%
Arbitration
1
100% / 0%
Overdue
9
4%
Free
Published: 2 codes
2
Developer 2
Rating
(12)
Projects
12
25%
Arbitration
1
0% / 100%
Overdue
0
Free
3
Developer 3
Rating
(14)
Projects
19
11%
Arbitration
1
0% / 100%
Overdue
5
26%
Free

Project information

Budget
30+ USD