NexusFi: Find Your Edge


Home Menu

 





What's wrong with CQG?!


Discussion in NinjaTrader

Updated
    1. trending_up 3,533 views
    2. thumb_up 9 thanks given
    3. group 2 followers
    1. forum 18 posts
    2. attach_file 9 attachments




 
Search this Thread

What's wrong with CQG?!

  #11 (permalink)
 OpiumFP 
Moscow
 
Experience: Intermediate
Platform: NinjaTrader
Trading: commodities
Posts: 13 since Aug 2010
Thanks Given: 0
Thanks Received: 7


xplorer View Post
@OpiumFP

Another question: there's a "5" or a "6" attached at the end of each timestamp (in the Date field).

What is that?

This is Chicago summer and winter time

Started this thread Reply With Quote
Thanked by:

Can you help answer these questions
from other members on NexusFi?
Cheap historycal L1 data for stocks
Stocks and ETFs
How to apply profiles
Traders Hideout
MC PL editor upgrade
MultiCharts
ZombieSqueeze
Platforms and Indicators
REcommedations for programming help
Sierra Chart
 
  #12 (permalink)
 OpiumFP 
Moscow
 
Experience: Intermediate
Platform: NinjaTrader
Trading: commodities
Posts: 13 since Aug 2010
Thanks Given: 0
Thanks Received: 7


xplorer View Post
Thanks.

What I meant by 'daily data' was this:

would you be able to combine all of this data so that the format looks like:

CL0121 2020-07-10 (O,H,L,C)
CL0121 2020-07-11 (O,H,L,C)
CL0121 2020-07-12 (O,H,L,C)

and so on

Basically one line per day.


I'm looking for that because I could not reconcile your minute data with the data I have. I too use NT8 and Continuum CQG.

It's much easier for me to compare daily OHLC values and spot discrepancies.

By the way, just convert minute data to csv and send it to me. I will compare. I have a special code.
It's another matter if you did 'Reload All Historical Data'. Then it is already pointless, our data will match.

Started this thread Reply With Quote
  #13 (permalink)
 
xplorer's Avatar
 xplorer 
London UK
Site Moderator
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
Posts: 5,978 since Sep 2015
Thanks Given: 15,502
Thanks Received: 15,408



OpiumFP View Post
By the way, just convert minute data to csv and send it to me. I will compare. I have a special code.
It's another matter if you did 'Reload All Historical Data'. Then it is already pointless, our data will match.

How do I convert it into CSV?

Reply With Quote
  #14 (permalink)
 OpiumFP 
Moscow
 
Experience: Intermediate
Platform: NinjaTrader
Trading: commodities
Posts: 13 since Aug 2010
Thanks Given: 0
Thanks Received: 7


xplorer View Post
How do I convert it into CSV?

Tools/Export/Historical Data...


Started this thread Reply With Quote
Thanked by:
  #15 (permalink)
 
xplorer's Avatar
 xplorer 
London UK
Site Moderator
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
Posts: 5,978 since Sep 2015
Thanks Given: 15,502
Thanks Received: 15,408


OpiumFP View Post
Tools/Export/Historical Data...

Ok, first I don't have a CSV option, only TXT. Second, I realized I don't have much historical data for CL 01-21 as I had to reset all cached folders a few weeks ago. Third, bear in mind the timezone I use is UTC+00:00 Dublin, Edinburgh, Lisbon, London so you will need to adjust for that.

I zipped both files anyway.



Let me know if there's a way to enable the CSV export, or if TXT format is good enough.

Attached Files
Elite Membership required to download: cqg.zip
Reply With Quote
  #16 (permalink)
 OpiumFP 
Moscow
 
Experience: Intermediate
Platform: NinjaTrader
Trading: commodities
Posts: 13 since Aug 2010
Thanks Given: 0
Thanks Received: 7


xplorer View Post
Ok, first I don't have a CSV option, only TXT. Second, I realized I don't have much historical data for CL 01-21 as I had to reset all cached folders a few weeks ago. Third, bear in mind the timezone I use is UTC+00:00 Dublin, Edinburgh, Lisbon, London so you will need to adjust for that.

I zipped both files anyway.



Let me know if there's a way to enable the CSV export, or if TXT format is good enough.

Thank you!
I'll take a look and then write.

Started this thread Reply With Quote
  #17 (permalink)
thoughtful
Klamath Falls OR
 
Posts: 60 since Apr 2020
Thanks Given: 21
Thanks Received: 80

Just some thoughts... but I'm not sure my thoughts are helpful because I didn't look at your data nor do I use NT8. The sample data you posted looks like the differences are very minor so that makes me wonder the following:


When you exported/built the files, did you specify both of them to start on the same exact date & time? If you didn't, then the minute bars would be different 'phases' which would explain the differences.

Also, did you specify whether NT8 would start a new bar at every session change? If both files have a different setting for this, that would explain the differences.

IDK if the files were built from minute data, or tick data. They must both be built from the same source data or else they'd be different.

If the source data is minute data, maybe CQG sometimes changes the phase of the minute data you download, although I would assume they wouldn't do that.

Maybe try and see if other symbols have the same issue.

Reply With Quote
  #18 (permalink)
 OpiumFP 
Moscow
 
Experience: Intermediate
Platform: NinjaTrader
Trading: commodities
Posts: 13 since Aug 2010
Thanks Given: 0
Thanks Received: 7


OpiumFP View Post
Thank you!
I'll take a look and then write.

Dear xplorer!
Thanks again for the data. Unfortunately for me, your data matches mine after the update.

Started this thread Reply With Quote
Thanked by:
  #19 (permalink)
 OpiumFP 
Moscow
 
Experience: Intermediate
Platform: NinjaTrader
Trading: commodities
Posts: 13 since Aug 2010
Thanks Given: 0
Thanks Received: 7


thoughtful View Post
Just some thoughts... but I'm not sure my thoughts are helpful because I didn't look at your data nor do I use NT8. The sample data you posted looks like the differences are very minor so that makes me wonder the following:


When you exported/built the files, did you specify both of them to start on the same exact date & time? If you didn't, then the minute bars would be different 'phases' which would explain the differences.

Also, did you specify whether NT8 would start a new bar at every session change? If both files have a different setting for this, that would explain the differences.

IDK if the files were built from minute data, or tick data. They must both be built from the same source data or else they'd be different.

If the source data is minute data, maybe CQG sometimes changes the phase of the minute data you download, although I would assume they wouldn't do that.

Maybe try and see if other symbols have the same issue.

Thanks for your thoughts.
The data settings were the same. Data source too. I did not use tick data. But I doubt that tick data should have had any effect.

As for the little difference. The difference is really huge. If in a minute candle the difference between high and low becomes 10 ticks instead of 2 ticks, this is a big difference. Instead of a volume of 300 contracts, the volume of 40 contracts becomes - this is a huge difference.
And if we see that the differences affect 15 thousand candles - then this is a huge difference!

Of course, such differences must have their own explanation. It is usually considered that the client is to blame, because he is not competent enough, has configured something wrong on his computer, and so on, but, for example, a company (data provider, broker, etc.) is large and everything works like clockwork for them. But this is a delusion.

I cannot argue that the data provider is at fault. But what could I be wrong - I don't find it either - I am a very experienced user. So I'll keep following and figure out how to catch this error by simulating the conditions.

Started this thread Reply With Quote




Last Updated on December 30, 2020


© 2024 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