Loading custom csv files
2 replies
rafaeldelrey
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
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
0
gianlucat
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 rowsFormat.2.Separator=; – column separatorFormat.2.DateFormat=dd.MM.yyyy HH:mm:ss – date format used for Open/Close timeFormat.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)