Gamestudio Links
Zorro Links
Newest Posts
Data from CSV not parsed correctly
by EternallyCurious. 04/18/24 10:45
StartWeek not working as it should
by Zheka. 04/18/24 10:11
folder management functions
by VoroneTZ. 04/17/24 06:52
lookback setting performance issue
by 7th_zorro. 04/16/24 03:08
zorro 64bit command line support
by 7th_zorro. 04/15/24 09:36
Zorro FIX plugin - Experimental
by flink. 04/14/24 07:48
Zorro FIX plugin - Experimental
by flink. 04/14/24 07:46
AUM Magazine
Latest Screens
The Bible Game
A psychological thriller game
SHADOW (2014)
DEAD TASTE
Who's Online Now
4 registered members (7th_zorro, Quad, VoroneTZ, 1 invisible), 623 guests, and 2 spiders.
Key: Admin, Global Mod, Mod
Newest Members
EternallyCurious, 11honza11, ccorrea, sakolin, rajesh7827
19046 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
Import historical data from MT5 #483724
07/17/21 14:17
07/17/21 14:17
Joined: Jul 2021
Posts: 3
Vitoria
F
fredperim Offline OP
Guest
fredperim  Offline OP
Guest
F

Joined: Jul 2021
Posts: 3
Vitoria
Hello,
I was wondering which is the best way to import historical data from MT5 platform. I exported a csv file but when I try to
import into Zorro it gives an error about date format.
Fred

Re: Import historical data from MT5 [Re: fredperim] #483726
07/17/21 15:53
07/17/21 15:53
Joined: Mar 2021
Posts: 42
Casablanca, Morocco
anissyo Offline
Newbie
anissyo  Offline
Newbie

Joined: Mar 2021
Posts: 42
Casablanca, Morocco
Have you converted the data to t6 format or another compatible format ?


if you did and you did it trough the CSVtohistory script, you just need to put in the right format by making changes to the string format line, if not clear show me an example of the csv file you are trying to convert and i will help you

Re: Import historical data from MT5 [Re: anissyo] #483728
07/17/21 19:50
07/17/21 19:50
Joined: Jul 2021
Posts: 3
Vitoria
F
fredperim Offline OP
Guest
fredperim  Offline OP
Guest
F

Joined: Jul 2021
Posts: 3
Vitoria
Hi Anissyo,
I've exported the csv from MT5 terminal as a csv file. It has a format like the following:

2020.10.16 11:24,100961.00000,100966.00000,100884.00000,100905.00000,4576,19635
2020.10.16 11:25,100910.00000,100956.00000,100874.00000,100920.00000,6292,24653
2020.10.16 11:26,100920.00000,100956.00000,100879.00000,100894.00000,4601,20388

Thank you for your support

Re: Import historical data from MT5 [Re: fredperim] #483729
07/17/21 22:01
07/17/21 22:01
Joined: Mar 2021
Posts: 42
Casablanca, Morocco
anissyo Offline
Newbie
anissyo  Offline
Newbie

Joined: Mar 2021
Posts: 42
Casablanca, Morocco
so you need to convert it to a t6 format, follow the steps:

1) Edit the script CSVtoHistory by giving to the String format the following value:

string Format = "+%Y.%m.%d %H:%M,f3,f1,f2,f4,f6";

2) save and run the script by clicking test

3) select the csv file

and then you are good to go, you will have an output of the same csv as a T6 file


Moderated by  Petra 

Powered by UBB.threads™ PHP Forum Software 7.7.1