Gamestudio Links
Zorro Links
Newest Posts
Data from CSV not parsed correctly
by EternallyCurious. 04/18/24 10:45
StartWeek not working as it should
by Zheka. 04/18/24 10:11
folder management functions
by VoroneTZ. 04/17/24 06:52
lookback setting performance issue
by 7th_zorro. 04/16/24 03:08
zorro 64bit command line support
by 7th_zorro. 04/15/24 09:36
Zorro FIX plugin - Experimental
by flink. 04/14/24 07:48
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
1 registered members (AndrewAMD), 559 guests, and 2 spiders.
Key: Admin, Global Mod, Mod
Newest Members
EternallyCurious, 11honza11, ccorrea, sakolin, rajesh7827
19046 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
IB+Zorro data quality: Eurex futures around the closing auction #469909
12/13/17 10:52
12/13/17 10:52
Joined: Feb 2017
Posts: 20
G
Gloria Offline OP
Newbie
Gloria  Offline OP
Newbie
G

Joined: Feb 2017
Posts: 20
Hi,

I'd be most grateful if you could help me with the following issue about the quality of IB minute data in Zorro.

I have a strategy based on minute data for the Eurex Dax future, say, DAX-FUT-20171215-FDAX-DTB-EUR, for the contract that expires this Friday. When I start the strategy in the morning, I need to load one day worth of minute bars from the previous day (LookBack = 60*24) in order to calculate the signals. My strategy also uses the USDJPY, and so I get minute bars 24/7, and I don't mind if out of trading hours, the most recent dax minute bar gets repeated again and again (don't know whether this is the documented behaviour).

Zorro calls my run() function, and I log open/high/low/close of every minute bar. For the Dec 2017 contract, yesterday evening (Dec 12th) this looks as follows (times are in UTC, i.e. Eurex closes at 21:00, and the closing auction follows a few minutes later).

Quote:

2017-12-12 20:58:00 FDAX O=13173.00, H=13173.50, L=13168.00, C=13170.00
2017-12-12 20:59:00 FDAX O=13173.00, H=13173.50, L=13168.00, C=13170.50
2017-12-12 21:00:00 FDAX O=13173.00, H=13195.00, L=13168.00, C=13180.00
2017-12-12 21:01:00 FDAX O=13173.00, H=13195.00, L=13168.00, C=13179.00
2017-12-12 21:02:00 FDAX O=13179.00, H=13189.00, L=13176.00, C=13189.00
2017-12-12 21:03:00 FDAX O=13179.00, H=13189.00, L=13176.00, C=13186.00
2017-12-12 21:04:00 FDAX O=13179.00, H=13189.00, L=13176.00, C=13186.00


This series of minute bars has the following problem: The high of 13195.00 for the bar that closes at 21:00:00 is fake. It wasn't there and neither Bloomberg nor the IB Trader Workstation show it. The correct high during that minute was 13172.00, and when I display yesterday's chart in the IB TWS, the chart agrees with Bloomberg (although IB does not guarantee that they forward you all ticks - in any case, not even IB show the fake 13195.00 in their chart).

Correct would have been this:
Quote:

20:58:00 ....
20:59:00 O=13171.00 H=13171.50 L=13168.50 C=13169.00
21:00:00 O=13169.00 H=13172.00 L=13168.00 C=13170.00
21:04:00 O=13186.00 H=13186.00 L=13186.00 C=13186.00


There ought to be no volume after 21:00:00 except for a single tick around 21:04:00 which is the price of the closing auction.

What do I need to do in order to get the correct minute bars? I am running Zorro-S 1.66.5. Any help will be much appreciated.

Kind regards,

gloria

PS1: I know that the Eurex itself sends a number of volumeless ticks between 21:00 UTC and the closing auction in order to report an "indicative auction price", i.e. something like their estimate of the closing price given the orders submitted so far. Was the 13195.00 such an "indicative price" and just counted towards that minute bar by mistake? I don't know. How can I tell? Somehow IB's own TWS gets it right.

PS2: I ran the strategy this morning around 06:00 UTC, way too early to have any connection to the Eurex technical glitch between 08:00 and 08:45 local time today.

Last edited by Gloria; 12/13/17 11:07.
Re: IB+Zorro data quality: Eurex futures around the closing auction [Re: Gloria] #469914
12/13/17 12:52
12/13/17 12:52
Joined: Jul 2017
Posts: 784
Z
Zheka Offline
User
Zheka  Offline
User
Z

Joined: Jul 2017
Posts: 784
Hi,

Zorro by default requests Ask prices unless you use BrokerCommand(SET_PRICETYPE=2) - which has been introduced in v1.72+.
Quote:
The IB Bridge now downloads prices in 1500-tick packets, which increased the download speed by up to 30%.
The IB Bridge now supports the SET_PRICETYPE command with parameters 1 (quotes) and 2 (trades).


Except the Low at 20:59, your prices (from IB TWS?) are lower then Zorro's - possibly reflective of the Ask-Trade difference.

Re: IB+Zorro data quality: Eurex futures around the closing auction [Re: Zheka] #470069
12/21/17 09:24
12/21/17 09:24
Joined: Feb 2017
Posts: 20
G
Gloria Offline OP
Newbie
Gloria  Offline OP
Newbie
G

Joined: Feb 2017
Posts: 20
Thank you, looks good. Just want to mention that for currencies, I need to switch back to
Quote:
brokerCommand (SET_PRICETYPE,1)
each time I use such an asset.

Regards,

gloria

Last edited by Gloria; 12/21/17 09:25.
Re: IB+Zorro data quality: Eurex futures around the closing auction [Re: Gloria] #470604
01/24/18 10:29
01/24/18 10:29
Joined: Feb 2017
Posts: 20
G
Gloria Offline OP
Newbie
Gloria  Offline OP
Newbie
G

Joined: Feb 2017
Posts: 20

One more question. When I use an exchange traded instrument with IB, and I use BrokerCommand(SET_PRICETYPE,2) in order to receive traded prices, then what is Zorro's policy when the market is open and there has been no tick for a full minute.

What open,high,low,close prices is Zorro going to send me in this case?

Do I need to check the volume in this case? Is this reliable?

Thank you,

gloria

Re: IB+Zorro data quality: Eurex futures around the closing auction [Re: Gloria] #470609
01/24/18 15:21
01/24/18 15:21
Joined: Feb 2017
Posts: 20
G
Gloria Offline OP
Newbie
Gloria  Offline OP
Newbie
G

Joined: Feb 2017
Posts: 20

Even more questions. When I run Zorro & IB with two assets: USD/JPY (the exchange rate) and JPY-FUT-20180319-6J-GLOBEX-USD (the big Japanese Yen Future at the Globex), and Zorro calls my tick() function, I would like Ask prices for the USD/JPY, but traded prices for the JPY-FUT-.

At what point do I need to call BrokerCommand (SET_PRICETYPE,...) ?

Kind regards,

gloria


Moderated by  Petra 

Gamestudio download | chip programmers | 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