Gamestudio Links
Zorro Links
Newest Posts
Data from CSV not parsed correctly
by jcl. 04/26/24 11:18
M1 Oversampling
by jcl. 04/26/24 11:12
Why Zorro supports up to 72 cores?
by jcl. 04/26/24 11:09
Eigenwerbung
by jcl. 04/26/24 11:08
MT5 bridge not working on MT5 v. 5 build 4160
by EternallyCurious. 04/25/24 20:49
Trading Journey
by howardR. 04/24/24 20:04
Zorro FIX plugin - Experimental
by flink. 04/21/24 07:12
Scripts not found
by juergen_wue. 04/20/24 18:51
AUM Magazine
Latest Screens
The Bible Game
A psychological thriller game
SHADOW (2014)
DEAD TASTE
Who's Online Now
3 registered members (AndrewAMD, wandaluciaia, 1 invisible), 798 guests, and 6 spiders.
Key: Admin, Global Mod, Mod
Newest Members
wandaluciaia, Mega_Rod, EternallyCurious, howardR, 11honza11
19049 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
Time Zone of Zorro Historical Data #456715
12/06/15 10:39
12/06/15 10:39
Joined: Apr 2014
Posts: 482
Sydney, Australia
B
boatman Offline OP
Senior Member
boatman  Offline OP
Senior Member
B

Joined: Apr 2014
Posts: 482
Sydney, Australia
What is the time zone of the historical data available on the Zorro website? I had assumed that it is UCT, however it appears to be aligned to data that I use from another source (histdata.com) which is time stamped with EST times. Or does Zorro align all data to UCT, regardless of source? If so, how does it accomplish this?

Re: Time Zone of Zorro Historical Data [Re: boatman] #456729
12/07/15 09:49
12/07/15 09:49
Joined: Jul 2000
Posts: 27,986
Frankfurt
jcl Offline

Chief Engineer
jcl  Offline

Chief Engineer

Joined: Jul 2000
Posts: 27,986
Frankfurt
The time zone is UTC. All data was downloaded from FXCM, and they send it with UTC time by default, so there was no alignment necessary. Are you sure with the EST from Histdata? For most assets you can find out the time zone with a volatility check, using the plotDay or plotWeek functions.

Re: Time Zone of Zorro Historical Data [Re: jcl] #456743
12/07/15 20:29
12/07/15 20:29
Joined: Apr 2014
Posts: 482
Sydney, Australia
B
boatman Offline OP
Senior Member
boatman  Offline OP
Senior Member
B

Joined: Apr 2014
Posts: 482
Sydney, Australia
Thanks for the tip, I'll investigate further.

Re: Time Zone of Zorro Historical Data [Re: boatman] #457398
01/16/16 19:53
01/16/16 19:53
Joined: Dec 2013
Posts: 568
Fuerth, DE
Sphin Offline
User
Sphin  Offline
User

Joined: Dec 2013
Posts: 568
Fuerth, DE
From the FAQ of Histdata they describe their M1 bars time stamped EST without Day Light Savings adjustments and as bid prices.

1. Does convert.c convert the time (with DATE ConvertTime(...)) to UTC or do I have to change the code to do it?

2. According to the manual bid prices have to be converted to ask prices by adding the broker's spread. Is this already considered in convert.c (I can't find it in the #ifdef HISTDATA, but maybe this is only my problem) or do I have to add the spread from AssetFix.csv by code, or is this covered by "Using ask or bid price history has however normally no effect on backtest results"?

Thanks, Sphin

Re: Time Zone of Zorro Historical Data [Re: Sphin] #457426
01/18/16 10:29
01/18/16 10:29
Joined: Jul 2000
Posts: 27,986
Frankfurt
jcl Offline

Chief Engineer
jcl  Offline

Chief Engineer

Joined: Jul 2000
Posts: 27,986
Frankfurt
You have to change that. If the price history is EST, then you need to add 5 hours, i.e. 5./24., to the time value returned by ConvertTime. Converting bid to ask prices however is normally not necessary, since it should make no noticeable difference in the backtest.

Re: Time Zone of Zorro Historical Data [Re: jcl] #457467
01/18/16 22:03
01/18/16 22:03
Joined: Mar 2015
Posts: 336
Rogaland
N
nanotir Offline
Senior Member
nanotir  Offline
Senior Member
N

Joined: Mar 2015
Posts: 336
Rogaland
Where should it be changed? In the convert script or in the cvs files?

Re: Time Zone of Zorro Historical Data [Re: nanotir] #457471
01/18/16 22:44
01/18/16 22:44
Joined: Dec 2013
Posts: 568
Fuerth, DE
Sphin Offline
User
Sphin  Offline
User

Joined: Dec 2013
Posts: 568
Fuerth, DE
I'm not sure but isn't it more effort? Adding 5 hours results in times from 24:00 to 28:00 so I think these hours must be merged anyway into next day and then into next month and at the end of a year you have 5 hours left for the next YYYY.bar. Therefore at the beginning of a year you must borrow 5 hours from the year before. Maybe there is a library for adding hours to a datetime, this would make it surely a bit easier.

Re: Time Zone of Zorro Historical Data [Re: Sphin] #457483
01/19/16 12:34
01/19/16 12:34
Joined: Jul 2000
Posts: 27,986
Frankfurt
jcl Offline

Chief Engineer
jcl  Offline

Chief Engineer

Joined: Jul 2000
Posts: 27,986
Frankfurt
You're thinking too complicated. The time is just a straight var on which you can add hours or minutes without borrowing from the next day or year.

DATE ConvertTime(...)
{
...
SystemTimeToVariantTime(&Time,&vTime);
#ifdef HISTDATA
vTime += 5./24.; // add 5 hours for converting EST to UTC
#endif
return vTime;
}

I have not tried it, but it should work.

Re: Time Zone of Zorro Historical Data [Re: jcl] #457495
01/19/16 21:11
01/19/16 21:11
Joined: Dec 2013
Posts: 568
Fuerth, DE
Sphin Offline
User
Sphin  Offline
User

Joined: Dec 2013
Posts: 568
Fuerth, DE
Thanks, this works - at least there are no errors.


Moderated by  Petra 

Powered by UBB.threads™ PHP Forum Software 7.7.1