Gamestudio Links
Zorro Links
Newest Posts
Blobsculptor tools and objects download here
by NeoDumont. 03/28/24 03:01
Issue with Multi-Core WFO Training
by aliswee. 03/24/24 20:20
Why Zorro supports up to 72 cores?
by Edgar_Herrera. 03/23/24 21:41
Zorro Trader GPT
by TipmyPip. 03/06/24 09:27
VSCode instead of SED
by 3run. 03/01/24 19:06
AUM Magazine
Latest Screens
The Bible Game
A psychological thriller game
SHADOW (2014)
DEAD TASTE
Who's Online Now
2 registered members (Quad, aliswee), 835 guests, and 5 spiders.
Key: Admin, Global Mod, Mod
Newest Members
sakolin, rajesh7827, juergen_wue, NITRO_FOREVER, jack0roses
19043 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
CSVtoHistory "master degree" #472984
06/05/18 12:15
06/05/18 12:15
Joined: Feb 2018
Posts: 68
T
tomaslolo Offline OP
Junior Member
tomaslolo  Offline OP
Junior Member
T

Joined: Feb 2018
Posts: 68
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.

Re: CSVtoHistory "master degree" [Re: tomaslolo] #472995
06/06/18 15:41
06/06/18 15:41
Joined: Apr 2008
Posts: 585
Austria
Petra Offline
Support
Petra  Offline
Support

Joined: Apr 2008
Posts: 585
Austria
Hi, the date already looks wrong, you must really reproduce the format and include all the '.' and ':' characters.

Re: CSVtoHistory "master degree" [Re: Petra] #472996
06/06/18 15:59
06/06/18 15:59
Joined: Feb 2017
Posts: 1,718
Chicago
AndrewAMD Online
Serious User
AndrewAMD  Online
Serious User

Joined: Feb 2017
Posts: 1,718
Chicago
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.

Re: CSVtoHistory "master degree" [Re: AndrewAMD] #473001
06/07/18 08:31
06/07/18 08:31
Joined: Feb 2018
Posts: 68
T
tomaslolo Offline OP
Junior Member
tomaslolo  Offline OP
Junior Member
T

Joined: Feb 2018
Posts: 68
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.


Moderated by  Petra 

Powered by UBB.threads™ PHP Forum Software 7.7.1