How can I load in QA the MT4 report recognized by comment?
4 replies
Christian Schranz
6 years ago #203129
Hi , I know that there is a possibility to load live report from MT4 into the QA as Portfolio and recognized by comment (see pciture attachment below). But why is the field not active in QA when I use load report?
In the comment are the magic numbers in the live report and I will select and sort in the QA portfolio by magic number.
Chris
Christian Schranz
6 years ago #203143
OK I found an easy solution, but I don’t know, why it is not implemented in QA4:
1. Convert and save the MT4 html report file in an csv file.
2. Change the file GeneralCSVImport in the folder C:\QuantAnalyzer4\settings\plugins\LoaderGeneralCsv
Format.3.SkipRow=1
Format.3.Separator=,
Format.3.DateFormat=yyyy.MM.dd HH:mm:ss
Format.3.LineFormat=Ticket,OpenTime,Action,Size,Symbol,OpenPrice,Unused,Unused,CloseTime,ClosePrice,Unused,Unused,CommSwap,PL,Comment
3. Now the QA4 can read your csv file including your comment and if you want additonal colums….
Also the comment field in loading process portfolio is now open (see the attachments).
Hope this will help also other trader …
Regards Chris
tomas262
6 years ago #203218
Hello,
yes, and by additional modifying the CSV config file you also import reports having different data formats. Let me know if any issues
clonex / Ivan Hudec
6 years ago #203232
Hi Chris. Good Job. Thanks
Sergei Lebedev
6 years ago #233040
Try to parse file with date&time in column “DATETIME” with plain format “Format.3.DateFormat=yyyy.MM.dd HH:mm:ss” (example: “2017.08.22 09:36:55”) , however i catch the error:
– error loading using GeneralCsv loader – Incorrect csv file or format unrecognized. Failed to parse order. Reason: Unknown column type! Type: DATETIME
Line: 2017.08.14 13:48:54,XAUUSD.m,2,buy,In,…
So it seems that some date&time formats couldn’t be recognized even in case of correct specification of new format in GeneralCSVImport.ini.
Viewing 4 replies - 1 through 4 (of 4 total)