Login Page - Create Account

Support Board


Date/Time: Sun, 19 May 2024 09:23:12 +0000



Post From: Technical Discussion: EUREX Bid Volume and Ask Volume

[2014-01-28 01:11:22]
Sierra Chart Engineering - Posts: 104368
This is a discussion about the determination of volume at trades that occur at the bid price and determination of volume of trades that occur at the ask price on the EUREX.

This is known as Bid (Trade) Volume and Ask (Trade) Volume.

It does not come to any definite conclusions.

We will try to make this as brief as possible.

The new Sierra Chart EUREX futures data feed, is identifying trades at the bid and the ask sometimes differently compared to IQ Feed and CTS T4. Both of which would be considered good references. This identification affects Bid Volume and Ask Volume which is used by various studies including Numbers Bars and Cumulative Delta Bars.

The general reason has to do with the completeness of best bid/ask price data and/or the timing of this data in relation to the trades. The data feed we use originates from CQG. This does not mean there is any problem with the source data feed. Based upon the behavior of the EUREX data feed, as will be explained, small timing differences can have a significant effect.

Update: We have determined that the Sierra Chart EUREX data feed provides more bid/ask updates than IQ Feed. We can provide some screenshots to prove this.

Look at the attached image. You will notice a chart on the left which is from IQ Feed and on the right which is from the Sierra Chart EUREX data feed.

For our analysis, we are using the Cumulative Delta Bars study. The reason for this study is that it uses bid volume and ask volume and this is where the problem is. It also performs a cumulative calculation throughout the entire trading day which means that small discrepancies with individual trades become much more apparent. So it is very ideal to validate Bid Volume and Ask Volume.

What you will find in these images is that Cumulative Delta Bars based on ask/bid volume, compared to up/down tick volume, have a very similar appearance in the IQ Feed chart.

The Cumulative Delta Bars using up/down tick volume from the Sierra Chart data feed, also looks like the IQ Feed CDB (cumulative Delta bars) based on ask/bid volume.

One thing that you will notice is that even though the DAX has traded slightly up on the day, the IQ Feed CDB based on ask/bid volume is significantly negative. This does not seem to be valid. The CDB based upon up/down tick volume appears to be more accurate and reasonable.

The main problem is that with the EUREX, trades often occur between the quoted bid and ask prices. This is not common from our observations on the CME. What Sierra Chart does in this case, is that it will see whether the trade price is closest to the bid or closest to be ask to determine whether it is considered at the bid or at the ask. If it is exactly in the middle, then it uses up/down tick logic to make the determination.

When there is a significant amount of trading going on between the bid and the ask, there is a significant amount of variability to identify whether the trade is at the bid or the ask. This is not a stable algorithm.

After considering all of this, it only seems to make sense in the case of the EUREX, that up/down ticks are used in the determination of bid volume and ask volume.

The Sierra Chart EUREX data feed uses this method now and produces a more reasonable result for bid volume and ask volume. This went into effect 2014-1-28.

Therefore, you should look at IQ Feed and look at the results you get with the Sierra Chart EUREX data feed and determine which one is going to be better for you. This is up for you to decide.

However, at this point in time, with what we know, there is definitely not an accuracy problem with the Sierra Chart EUREX data feed because with what we are seeing now with IQ Feed and how Sierra Chart is processing the data, the bid/ask volume result you get with IQ Feed is definitely not 100% accurate. Since it is not possible for it to be accurate to begin with based on how the exchange provides data.

And with the changes we made, we have produced a good result with bid volume and ask volume with the Sierra Chart EUREX data feed, which appears to be more accurate than IQ Feed.

In this exhibit below, is a sample of the raw IQ Feed data for the DAX showing trades between the quoted bid and ask. In the next exhibit after this, you can see the field descriptions for the lines below.

IQ Feed data:

1,2014-01-27 15:58:19,9342.50,1,160356,9341.50,9343.00,837730,0,0,C, | 2014-01-28 06:36:12
1,2014-01-27 15:58:20,9342.50,1,160357,9341.50,9342.50,837740,0,0,C, | 2014-01-28 06:36:12
1,2014-01-27 15:58:21,9343.00,1,160358,9341.50,9343.00,837750,0,0,C, | 2014-01-28 06:36:12
1,2014-01-27 15:58:27,9343.00,3,160361,9341.50,9343.50,837760,0,0,C, | 2014-01-28 06:36:12

Field descriptions lines of data above.
Request ID   Text   This field will only exist if the request specified a RequestID. If not specified in the request, the first field in each message will be the Timestamp.
Time Stamp   CCYY-MM-DD HH:MM:SS   Example: 2008-09-01 16:00:01
Last   Decimal   Example: 146.2587
Last Size   Integer   Example: 100
Total Volume   Integer   Example: 1285001
Bid   Decimal   Example: 146.2400
Ask   Decimal   Example: 146.2600
TickID   Integer   Example: 6813524
Reserved      Example: 0
Reserved      Example: 0
Basis For Last   Character   Possible single character values include:

C - Last Qualified Trade.
E - Extended Trade = Form T trade.

Finally, this thread is locked and cannot be posted into. If you would like to comment on this, start a new Support Request on this Support Board.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2014-03-14 00:46:54
image2014-01-28_101734.png / V - Attached On 2014-01-28 01:11:13 UTC - Size: 43.37 KB - 775 views