Gamestudio Links
Zorro Links
Newest Posts
Alternative to Stooq for Zorro S
by jcl. 10/09/26 16:00
Stooq now requires an API key
by cwford. 10/08/26 23:27
ZorroGPT
by TipmyPip. 10/06/26 05:32
Purchase A8 full licence version
by jcl. 10/05/26 12:12
AUM Magazine
Latest Screens
Dorifto samurai
Shadow 2
Rocker`s Revenge
Stug 3 Stormartillery
Who's Online Now
4 registered members (AndrewAMD, cwford, JeyKey II, 1 invisible), 17,133 guests, and 1 spider.
Key: Admin, Global Mod, Mod
Newest Members
JimSimons, julienp, julienper, KelleyAbbey, Yopachi
19246 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
Lagged data when history file contains repeated time stamps #479704
04/19/20 05:11
04/19/20 05:11
Joined: Oct 2018
Posts: 72
J
JamesHH Offline OP
Junior Member
JamesHH  Offline OP
Junior Member
J

Joined: Oct 2018
Posts: 72
I am posting here because this looks like a potentially serious bug to me.

I was working with the timeseries for EURUSD_2015 in CSV format, which I obtained from ZHistoryEditor. These prices, especially the High and Low prices, do not always match what Zorro sees from the original EURUSD_2015.t6 file. In some cases Zorro is getting lagged values, and this only happens when a timestamp is repeated. For example:

In EURUSD_2015.csv, after reversing the order, we have

1 2015-01-02 03:45:00 1.21002 1.21002 1.20584 1.20593 30
2 2015-01-02 03:45:00 1.21002 1.21002 1.20584 1.20593 30
3 2015-01-02 03:46:00 1.20593 1.20625 1.20590 1.20625 131

But in EURUSD_2015.t6 when read from Zorro (I don't know how to read volume with free Zorro), we have lagged High and Low prices:

1 2015-01-02 03:46:00 1.20593 1.21002 1.20584 1.20625

Another example: From EURUSD_2015.csv we have

11 2015-01-02 03:52:00 1.20604 1.20610 1.20592 1.20593 60
12 2015-01-02 03:53:00 1.20593 1.20600 1.20585 1.20594 90
13 2015-01-02 03:53:00 1.20593 1.20600 1.20585 1.20594 90

while Zorro read the following from EURUSD_2015.t6 with a lagged High value:

7 2015-01-02 03:52:00 1.20604 1.20610 1.20592 1.20593
8 2015-01-02 03:53:00 1.20593 1.20610 1.20585 1.20594

There are several hundred such examples in EURUSD_2015.

I suppose it is conceivable that the error is in ZHistoryEditor. The correct timeseries depends on which one is to be trusted (between Zorro and ZHistoryEditor).

When I removed the duplicates from the CSV, and then recreated the history file (using a Zorro script) everything agrees.

Re: Lagged data when history file contains repeated time stamps [Re: JamesHH] #479744
04/22/20 05:53
04/22/20 05:53
Joined: Oct 2018
Posts: 72
J
JamesHH Offline OP
Junior Member
JamesHH  Offline OP
Junior Member
J

Joined: Oct 2018
Posts: 72
PS. Just reread my post and realized that this can easily be verified by starting from a CVS file with duplicate timestamps and then generating the t6.

Re: Lagged data when history file contains repeated time stamps [Re: JamesHH] #479802
04/27/20 10:36
04/27/20 10:36
Joined: Jul 2000
Posts: 28,140
Frankfurt
jcl Offline

Chief Engineer
jcl  Offline

Chief Engineer

Joined: Jul 2000
Posts: 28,140
Frankfurt
Is this a bug report for Zorro or for the ZHistory editor? If for Zorro, with which script you got wrong converted duplicates?


Moderated by  jcl, Nems, Spirit, Tobias 

Gamestudio download | Zorro platform | shop | Data Protection Policy

oP group Germany GmbH | Birkenstr. 25-27 | 63549 Ronneburg / Germany | info (at) opgroup.de

Powered by UBB.threads™ PHP Forum Software 7.7.1