CSVtoHistory "master degree"

Posted By: tomaslolo

CSVtoHistory "master degree" - 06/05/18 12:15

Hello all, I�m trying to convert csv daily data to Zooro t6 file. I�m stuck, red the manual, couple post about it but can�t find what am I doing rong.

This is original data, EOD data in the CSV (Date ; Time ; Open ; High; Low ; Close ; Spread ; Volume).

Quote:

2000.12.18 00:00;52705,00;54075,00;52705,00;54000,00;0,10;12247
2000.12.19 00:00;53950,00;54600,00;53440,00;53505,00;0,10;14829
2000.12.20 00:00;53450,00;53545,00;52085,00;52190,00;0,10;15189
2000.12.21 00:00;52275,00;53240,00;51600,00;53075,00;0,10;12677
2000.12.22 00:00;53075,00;54125,00;53000,00;54050,00;0,10;7596
2000.12.26 00:00;54000,00;54325,00;53625,00;54265,00;0,10;3929
2000.12.27 00:00;54150,00;54900,00;53825,00;54850,00;0,10;7433
2000.12.28 00:00;54760,00;55275,00;54400,00;54925,00;0,10;5716
2000.12.29 00:00;54925,00;55320,00;54200,00;54365,00;0,10;5342

This is my string format in script:

Code:

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

This is wat Zorro does:

Quote:

Zorro S 1.83.2
(c) oP group Germany 2018
Zorro S Subscription

test_2006.t6
test_2005.t6
test_2004.t6
test_2003.t6
test_2002.t6
test_2001.t6
test_2000.t6
test_1999.t6
test_1998.t6
test_1997.t6
test_1996.t6
Copied to Clipboard!

This is what you can see with ZHistoryEditor:

Quote:

2000.12.31 00:12 50540 50675 49775 49840 0 0
2000.12.31 00:12 50725 50925 50505 50550 0 0
2000.12.31 00:12 50510 50720 50400 50665 0 0
2000.12.31 00:12 50070 50850 50000 50585 0 0
2000.12.31 00:12 50180 50350 50150 50200 0 0
2000.12.31 00:12 49900 50375 49625 50225 0 0

I�ve tried different configurations but I don�t find the way. I�m triyng to undertand the meaning of f3;f1;f2;f4;f6;f (I supposed it�s O;H;L;C;spread;Vol but I can�t find where to check it).

In Zorro manual ( http://www.zorro-trader.com/manual/en/data.htm ), you can see that "f" stands for a "a floating point field", but not sure what the numbers 3, 1, 2, 4, 6 means.

Any clues?

Thank you.

Posted By: Petra

Re: CSVtoHistory "master degree" - 06/06/18 15:41

Hi, the date already looks wrong, you must really reproduce the format and include all the '.' and ':' characters.

Posted By: AndrewAMD

Re: CSVtoHistory "master degree" - 06/06/18 15:59

Side note: I will venture a guess that Zorro cannot parse "52705,00" as a floating point, and it will need to be converted to "52705.00" prior to parsing. In your example, all of the float numbers end in ",00", so it is not clear whether or not the last bit is being ignored.

Posted By: tomaslolo

Re: CSVtoHistory "master degree" - 06/07/18 08:31

Thank you both, I�ve tried different combinations but don�t get it. I�ll give it a try a couple days later. I�m stuck.