NexusFi: Find Your Edge

Home Menu


CQG historical tick data missing trade direction (buy/sell)? Need other sources of ti

Discussion in Traders Hideout

      Top Posters
    1. looks_one matthew28 with 1 posts (0 thanks)
    2. looks_two fede72bari with 1 posts (0 thanks)
    3. looks_3 Trembling Hand with 1 posts (0 thanks)
    4. looks_4 EgoRisk with 1 posts (1 thanks)
    1. trending_up 1,473 views
    2. thumb_up 1 thanks given
    3. group 4 followers
    1. forum 3 posts
    2. attach_file 0 attachments

Search this Thread

CQG historical tick data missing trade direction (buy/sell)? Need other sources of ti

(login for full post details)
  #1 (permalink)
Turin Italy
Posts: 10 since Mar 2021
Thanks Given: 3
Thanks Received: 0

I need ticks rough data of futures for playing with Machine Learning algorithms. Obviously, for each trade I need the timestamp possibly down to milliseconds, the price, the direction (buy or sell) and the volume exchanged. Since I am in trouble finding around, I tried to buy one month of ES from CQG. I spent 27$ (!!!) and they delivered the zip folder after 2 days (!!!!!!). When I gave a glance inside I couldn't find the direction of the trade. Is it possible? How could I calculate the CVD, VWAP and Delta Volume Profile without that simple 1 bit long information? Has somebody already worked with historical CQG data? Am I missing something?

Here is an extract of a data sample


and here is the explanation of the data model from CQG documentation

Each record contains eight data fields (nine data fields if you select trade volume). The fields are:
1. CQG Contract Name (6-14 characters)
2. Trade Date YYYYMMDD
3. Session Indicator 1 character – 0=First Session, 1= Second Session, 2=Third Session
4. Transaction Time (U.S. Central Time). For details please see section "Time resolution" below:
HHMM: HH - hour, MM - minute
or HHMMSSMMM: HH - hour, MM - minute, SS - second, MMM - millisecond
5. Transaction Price
6. Transaction Type 1 character – B=Bid, A=Ask, T= Trade, S=Settlement
7. Market Indicator 1 character – F=Fast Market, N=Normal Market
8. Transaction Correction Indicator 1 character – E=Exchange delete I=Insert F= CQG Filter delete N=Normal
9. Trade volume
1 2 3 4 5 6 7 8 9

Could anyone give any suggestions?

- Am I missing something that could allow at identifying the direction of trading (buy/sell) for "T" exchanges?
- Is there a way to have a subscription to CQG as data feeder through a broker to store and export the real time data and the 1 month historical data available with CQG including the trades directions?
- has anybody some months of ES and Natural Gas futures tick data with volumes and directions to share?

Thank you.

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Do 5-days or 7-days constitute a Multiweek Channel?
Optimal Futures Trading Workflow
Platforms and Indicators
Price Action Swing Pro
Traders Hideout
convert tradingview pinescript to ninjascript indicator …
The Elite Circle
Tradestation historical data to be used in NinjaTrader 8
Platforms and Indicators

(login for full post details)
  #2 (permalink)
Fort Lauderdale, Florida, USA
Experience: Beginner
Platform: NT8, Bookmap
Trading: ES, MES
Posts: 188 since Feb 2017
Thanks Given: 78
Thanks Received: 197

I think the T trades are the label given when the transaction occurs at some price other than the Ask or Bid. When this happens, there's no way to tell whether it's an aggressive buy or sell. Some platforms, in the time n sales, color such transactions a different third color because the direction of the trade is not discernable or is undefined.

Remember, the definition of an aggressive buy is when the transaction occurs at the Ask. And an aggressive sell is when the transaction occurs at the Bid. That's it.

Thus, if the transaction occurs at some price other than the Ask or Bid, how would you even go about defining it as a buy or sell? I think your model just has to account for this in the data.

Unless I am just stupid and missing something....anyone?

Reply With Quote
The following user says Thank You to EgoRisk for this post:
(login for full post details)
  #3 (permalink)
 Trembling Hand 
Melbourne, Land of Oz
Experience: Advanced
Platform: Sierra Chart, CQG
Broker: CQG
Trading: HSI
Posts: 242 since Jun 2011
Thanks Given: 28
Thanks Received: 351

6. Transaction Type 1 character – B=Bid, A=Ask, T= Trade, S=Settlement

fivewhy is right. This is the field that indicates if the trade was on the best bid or best ask and therefore the buyer or seller was the aggressor in the transaction.

T= Trade - is I'm guessing the first trade of the day and therefore indicates the opening auction and cannot be labelled on bid or ask.

I wouldn't get my tick data directly from CGQ. Way too costly. Get a Sierra chart subscription for 1 month and get access to approx 10 years of tick data for all futures for $30!

Follow me on Twitter Reply With Quote
(login for full post details)
  #4 (permalink)
matthew28's Avatar
United Kingdom
Experience: Beginner
Platform: Bookmap
Broker: Stage 5, Rithmic
Trading: US Equity Index Futures
Posts: 1,250 since Sep 2013
Thanks Given: 3,500
Thanks Received: 2,530

As fivewhy said. I remember a Jigsaw tools presentation with Peter Davies talking about the time and sales, or consolidated tape as they call it, saying the data from the exchange doesn't have buy and sell details, just whether it traded at the bid, offer or another price (eg, in between the spread). For the latter it could be buying or selling so it is most accurate to make it a different colour to mark that it is unknown as to whether it was buying or selling.

Time and sales or footprint charts and such like only showing buy or sell presumably use some sort of logic that an order after an aggressive order at the bid will also be at the bid unless it is at the offer, that way unclear trades can be allocated to one side or the other and there are just two options.

You do not win as a trader, you just get to play again the next day. If that game doesn’t appeal to you then you should not trade. Gary Norden
Reply With Quote

Last Updated on October 10, 2022

© 2023 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts