READ-ONLY

The forum is now a read-only archive.

For bug reports & platform questions → [email protected]

Our community lives on Discord and YouTube — come join us!

Loading custom csv files

2 replies

rafaeldelrey

Customer, bbp_participant, community, 18 replies.

Visit profile

10 years ago #115268

Hi,

 

I am trying to import an excel sheet into SQA.  Which columns/fields are mandatory?  Do they need to be in an specific order?  Do they need specific column header names?

 

Thank you,

Rafael

0

Tamas

Customer, bbp_participant, community, sq-ultimate, administrator, 71 replies.

Visit profile

10 years ago #137988

Hello, 

 

you can use one of the existing format or define your own in file

\QuantAnalyzer4\settings\plugins\LoaderGeneralCsv\GeneralCSVImport.ini

 

The format of the setting file is simple

Format.2.SkipRow=0 – skip first N rows
Format.2.Separator=; – column separator
Format.2.DateFormat=dd.MM.yyyy HH:mm:ss – date format used for Open/Close time
Format.2.LineFormat=Ticket,OpenTime,Action,Size,Symbol,OpenPrice,ClosePrice,Unused,CloseTime,Unused,Unused,Unused,Unused,PL – list of colum types.
 
If you need a help just copy here some few rows from your report and I will create a format for it.
 
Sincerely,
Tomas

0

gianlucat

Subscriber, bbp_participant, community, 1 replies.

Visit profile

10 years ago #138291

 

Hello, 

 

you can use one of the existing format or define your own in file

\QuantAnalyzer4\settings\plugins\LoaderGeneralCsv\GeneralCSVImport.ini

 

The format of the setting file is simple

Format.2.SkipRow=0 – skip first N rows
Format.2.Separator=; – column separator
Format.2.DateFormat=dd.MM.yyyy HH:mm:ss – date format used for Open/Close time
Format.2.LineFormat=Ticket,OpenTime,Action,Size,Symbol,OpenPrice,ClosePrice,Unused,CloseTime,Unused,Unused,Unused,Unused,PL – list of colum types.
 
If you need a help just copy here some few rows from your report and I will create a format for it.
 
Sincerely,
Tomas

 

Hello,

i have quant analyzer version 4.0.2

please can you help me in creating a format for this file (it is from signals in mql5.com) :

Time;Type;Volume;Symbol;Price;S/L;T/P;Time;Price;Commission;Swap;Profit;Comment
2016.07.11;Balance;;;;;;;;;;-2.59;
2016.07.08;Sell;0.03;EURUSD;;;;2016.07.11;;;0.04;9.91;
2016.07.11 02:55:04;Balance;;;;;;;;;;-1.71;
2016.07.08 19:04:56;Sell;0.03;EURUSD;1.10590;;;2016.07.11 02:54:38;1.10349;;0.04;6.55;
2016.07.11 02:50:00;Balance;;;;;;;;;;-0.96;
2016.07.08 15:03:14;Sell;0.03;EURUSD;1.10547;;;2016.07.11 02:49:34;1.10367;;0.04;4.89;
2016.07.08 15:29:13;Buy;0.03;EURUSD;1.10623;;;2016.07.08 19:04:25;1.10578;;;-1.22;
2016.07.08 14:33:08;Balance;;;;;;;;;;-10.30;
2016.07.08 14:33:08;Balance;;;;;;;;;;-4.10;
2016.07.08 14:28:36;Sell;0.06;EURUSD;1.10810;;;2016.07.08 14:30:46;1.10083;;;39.62;
2016.07.08 02:39:47;Sell;0.03;EURUSD;1.10716;;;2016.07.08 14:30:46;1.10137;;;15.77;from #417442007
2016.07.08 12:55:34;Balance;;;;;;;;;;-1.26;
2016.07.08 12:14:39;Buy;0.06;EURUSD;1.10600;;;2016.07.08 12:55:12;1.10691;;;4.93;
2016.07.08 02:39:47;Sell;0.03;EURUSD;1.10716;;;2016.07.08 10:25:54;1.10719;;;-0.08;to #417446071
2016.07.07 19:12:19;Balance;;;;;;;;;;-1.20;
2016.07.06 12:40:16;Sell;0.03;EURUSD;1.10719;;;2016.07.07 19:11:42;1.10553;;0.12;4.50;
2016.07.06 15:20:13;Balance;;;;;;;;;;-0.98;
2016.07.06 15:20:13;Balance;;;;;;;;;;-0.86;
2016.07.06 15:20:12;Balance;;;;;;;;;;-0.24;
2016.07.06 15:20:11;Balance;;;;;;;;;;-0.09;
2016.07.06 10:33:42;Buy;0.03;EURUSD;1.10584;;;2016.07.06 12:41:06;1.10723;;;3.77;from #417410026
2016.07.06 10:34:33;Buy;0.03;EURUSD;1.10560;;;2016.07.06 12:39:35;1.10682;;;3.31;from #417410053
2016.07.06 10:34:33;Buy;0.03;EURUSD;1.10560;;;2016.07.06 11:56:36;1.10594;;;0.92;to #417411512
2016.07.06 10:33:42;Buy;0.03;EURUSD;1.10584;;;2016.07.06 11:56:36;1.10596;;;0.33;to #417411513

 

thanks

gianluca
 

0

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