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

MQL5 Skripte

Auftrag beendet

Ausführungszeit 1 Stunde
Bewertung des Kunden
Very good work! As requested, thanks!
Bewertung des Entwicklers
Thank you, Marco! Glad to work with you again!

Spezifikation

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

Dateien:

CSV
AAPL.csv
644.1 Kb

Bewerbungen

1
Entwickler 1
Bewertung
(192)
Projekte
232
30%
Schlichtung
1
100% / 0%
Frist nicht eingehalten
9
4%
Frei
Veröffentlicht: 2 Beispiele
2
Entwickler 2
Bewertung
(12)
Projekte
12
25%
Schlichtung
1
0% / 100%
Frist nicht eingehalten
0
Frei
3
Entwickler 3
Bewertung
(14)
Projekte
19
11%
Schlichtung
1
0% / 100%
Frist nicht eingehalten
5
26%
Frei

Projektdetails

Budget
30+ USD