Reply

How can I load in QA the MT4 report recognized by comment?

4 replies

Christian Schranz

Subscriber, bbp_participant, community, 30 replies.

Visit profile

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

Attachments:
You must be logged in to view attached files.

0

Christian Schranz

Subscriber, bbp_participant, community, 30 replies.

Visit profile

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

 

 

Attachments:
You must be logged in to view attached files.

0

tomas262

Administrator, sq-ultimate, 2 replies.

Visit profile

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

0

clonex / Ivan Hudec

Customer, bbp_participant, community, sq-ultimate, contributor, author, editor, 271 replies.

Visit profile

6 years ago #203232

Hi Chris. Good Job. Thanks

0

Sergei Lebedev

Subscriber, bbp_participant, community, 0 replies.

Visit profile

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.

0

Viewing 4 replies - 1 through 4 (of 4 total)