Gamestudio Links
Zorro Links
Newest Posts
zorro 64bit command line support
by 7th_zorro. 04/20/24 10:06
StartWeek not working as it should
by jcl. 04/20/24 08:38
Data from CSV not parsed correctly
by jcl. 04/20/24 08:32
Zorro FIX plugin - Experimental
by jcl. 04/20/24 08:30
folder management functions
by VoroneTZ. 04/17/24 06:52
lookback setting performance issue
by 7th_zorro. 04/16/24 03:08
Zorro FIX plugin - Experimental
by flink. 04/14/24 07:46
AUM Magazine
Latest Screens
The Bible Game
A psychological thriller game
SHADOW (2014)
DEAD TASTE
Who's Online Now
3 registered members (7th_zorro, Aku_Aku, 1 invisible), 579 guests, and 1 spider.
Key: Admin, Global Mod, Mod
Newest Members
EternallyCurious, howardR, 11honza11, ccorrea, sakolin
19047 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
CSVtoHistory Sunday data #486009
05/27/22 13:07
05/27/22 13:07
Joined: May 2022
Posts: 3
USA
Q
quandr Offline OP
Guest
quandr  Offline OP
Guest
Q

Joined: May 2022
Posts: 3
USA
I used CSVtoHistory script to ingest ES m1 data from tradestation, all seems well, except the Sundays. The time stamps are in EST timezone,
Globex opens at 18:00 EST, in the CSV file ... (O,H,L,C)

1200105.00,2020-01-05 18:01:00,3136.25,3138.50,3134.50,3135.50,2660,3162
1200105.00,2020-01-05 18:02:00,3135.75,3137.00,3134.75,3135.25,756,786
1200105.00,2020-01-05 18:03:00,3135.25,3136.00,3133.50,3134.25,867,948
1200105.00,2020-01-05 18:04:00,3134.25,3135.00,3133.25,3133.25,744,892
1200105.00,2020-01-05 18:05:00,3133.25,3134.25,3132.50,3133.50,794,1009

On Zorro chart with BarPeriod = 30
2020-01-03 17:00:00 3151.00000 3151.75000 3150.25000 3151.50000 30.00000
2020-01-05 23:00:00 3136.25000 3141.75000 3132.25000 3141.00000 3240.00000
2020-01-05 23:30:00 3141.25000 3146.00000 3140.25000 3145.00000 30.00000
2020-01-06 00:00:00 3145.00000 3145.00000 3142.75000 3144.50000 30.00000
2020-01-06 00:30:00 3144.25000 3145.00000 3142.50000 3143.25000 30.00000

11pm bar is in fact a 5hr bar, the low of 3132.25 comes from 18:18 minute bar.

If BarPeriod =1

2020-01-03 17:00:00 3151.25000 3151.75000 3151.25000 3151.50000 1.00000
2020-01-05 23:00:00 3136.25000 3141.75000 3132.25000 3141.00000 3240.00000
2020-01-05 23:01:00 3141.25000 3141.25000 3141.00000 3141.25000 1.00000
2020-01-05 23:02:00 3141.00000 3141.25000 3141.00000 3141.25000 1.00000
2020-01-05 23:03:00 3141.25000 3141.25000 3140.75000 3140.75000 1.00000

11pm bar on Sundays still represents 5hr of data between 6pm and 11pm.


What is causing this behavior, and how can I fix it?

Thanks!

Re: CSVtoHistory Sunday data [Re: quandr] #486011
05/27/22 15:15
05/27/22 15:15
Joined: May 2022
Posts: 3
USA
Q
quandr Offline OP
Guest
quandr  Offline OP
Guest
Q

Joined: May 2022
Posts: 3
USA
Here's the content of run() function

set(LOGFILE);
Verbose = 2;
StartDate = 20200103;
EndDate = 20200130;
BarPeriod = 1.;
set(PLOTNOW);
plot("Open", priceOpen(), NEW, BLUE);
plot("High", priceHigh(), NEW, BLUE);
plot("Low", priceLow(), NEW, BLUE);
plot("Close", priceClose(), NEW, BLUE);
plot("minutesAgo(1)", minutesAgo(1), NEW, BLUE);

Re: CSVtoHistory Sunday data [Re: quandr] #486012
05/28/22 07:00
05/28/22 07:00
Joined: Apr 2008
Posts: 585
Austria
Petra Offline
Support
Petra  Offline
Support

Joined: Apr 2008
Posts: 585
Austria
Its no 5 hr gap. Its a 2.5 days gap and is called "weekend".

You can set up the weekend time, or if you want a weekend at all with BarMode.

https://zorro-project.com/manual/en/barmode.htm

Re: CSVtoHistory Sunday data [Re: Petra] #486017
05/28/22 20:47
05/28/22 20:47
Joined: May 2022
Posts: 3
USA
Q
quandr Offline OP
Guest
quandr  Offline OP
Guest
Q

Joined: May 2022
Posts: 3
USA
Thanks, Petra.

The settings below produced the expected result.
StartWeek = 71801;
EndWeek = 51701;
BarMode = BR_WEEKEND; //+BR_SLEEP;


I was wondering if Zorro maintains holiday lists for major markets in yyyymmdd format going back 10-20 years?


Moderated by  Petra 

Powered by UBB.threads™ PHP Forum Software 7.7.1