I went through the API documentation and I understand that the trade conditions get mapped to the 'C','E','O' qualifiers in the Message Contents field. I can dynamically get a list of trade conditions using the SystemInfoSocket tool that you have provided (screenshot below). But this just provides the list and does not provide which trade condition maps to C and which maps to O. Is there a way to query that information or do I have to triangulate the CTS and UTP specs (screenshot of one the pages below) with the potential for making erroneous assumptions on how you may have actually mapped the trade conditions?

Our data follows the exchange formatting specs,like what you show in your screen shot, for the first trade condition given to us. Subsequent trade conditions in the same message are not considered in assigning the trades to the C,E, or O message type. The E is a DTN creation though that you will not see in the specs, E trades are generally the FormT trades that occur before, during, and after the market's open and close.

But, no lookup exists for those specifications to come through our feed at this time.

Tim

Thanks Tim. Yes, I understand the E in CEO. Your documentation explained it. I wasn't looking for you to provide the exchange specifications but rather an indication of which trade conditions are mapped to C and which to O. If you see the screenshot below of the SystemInfoSocket tool that you have provided, the trade conditions are dynamically retrieved and displayed in 3 column format with first being the number, the next two columns being a short name and a long name for the condition. A fourth column indicating whether it is treated as a C or O would have been very helpful. Is such information available? Thanks again.

There is not and each exchange can be different.

Here are a couple of the links that our market data team makes use of to configure our feed. We make use of the consolidated processing guidelines when making determinations. Which means, if a trade comes in of any type we check to see if it sets a Last, if it does, it is a C. If it does not, it is an O, except for Extended trades.

http://nasdaqtrader.com/content/technicalsupport/specifications/utp/utdfspecification.pdf
7.5.1.1. UTP Trade Condition Matrix

https://cta.nyxdata.com/cta/document/5944/2f76d73065c5d0f9629eb576302adc1da66d1f9f
Page 113

Thanks Tim. Yes, I have those exchange specifications. A couple more questions to get completely clear and we can close this topic. In the documentation for historical lookup via TCP it says that the trade conditions field will be "one to four 2digit hex numbers".

1. I assume the hex numbers are not comma delimited. So, as example, trade conditions 61 (decimal for Intermarket sweep) (0x3D) and 135 (decimal for Odd lot) (0x77) would appear as one string "3D77"?

2. It says "one to four". I presume there is no guarantee that it is restricted to four? Could be six conditions though that would be very rare? For realtime, the Update/Summary message documentation for Most Recent Trade Conditions simply says "non delimited 2digit hex numbers" and leaves out the "one to four".

Thanks.

It is not delimited as you assumed and it is in fact limited to a max of 4. I will inquire about if there are times we could get more conditions than that or if it is a max set by the exchange and let you know.

Tim

Thanks Tim. These are indeed limited to 4 fields by the equities exchanges (p111 of CTS specification and p6-17 of UTP specification). Do you have pointers to the corresponding specifications for last-qualifying trades for CME and ICE?

I will look around tomorrow morning and see what I can find for you, but not off the top of my head. If nothing else, I know the people that will know and I will ask them.

Tim

With futures markets there are only two items, regular trades and implied trades, this is consistent across both of the listed exchanges. Indexes on these exchanges will just have regular trades.

Tim

Thank you Tim.