NexusFi: Find Your Edge


Home Menu

 





Newbie: Chart Discrepancies with Exchange


Discussion in NinjaTrader

Updated
    1. trending_up 1,544 views
    2. thumb_up 6 thanks given
    3. group 4 followers
    1. forum 5 posts
    2. attach_file 2 attachments




 
Search this Thread

Newbie: Chart Discrepancies with Exchange

  #1 (permalink)
 
jerbersoft's Avatar
 jerbersoft 
Manila, Philippines
 
Experience: Beginner
Platform: CQG,Bookmap,Sierra Chart
Broker: CQG
Trading: BUND
Posts: 59 since Apr 2014
Thanks Given: 47
Thanks Received: 26

Hi there. Hope I am in the correct thread. I am new to this forum and I'm new to using Ninja Trader as well.

I am curious as I have found out some daily chart gaps when pulling out CL 06-14 charts. See attached [NT_IQ_CL_06-14.png]. Now, I am using IQ Feed by the way and the free license of Ninja Trader.

I wanted to compare this chart to CME's so I browsed to https://www.cmegroup.com/trading/energy/crude-oil/light-sweet-crude.html and pulled up their June Crude Oil (WTI) chart. To my surprise, they are very different. See attached [CME_June_Crude_Oil_WTI.png]

I'm pretty much sure I'm missing something. Can someone please enlighten me. Thanks.

Attached Thumbnails
Click image for larger version

Name:	NT_IQ_CL_06-14.png
Views:	176
Size:	71.0 KB
ID:	145789   Click image for larger version

Name:	CME_Daily_June_Crude_Oil_WTI.png
Views:	178
Size:	127.1 KB
ID:	145790  
Follow me on Twitter Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Better Renko Gaps
The Elite Circle
Quant vue
Trading Reviews and Vendors
ZombieSqueeze
Platforms and Indicators
NexusFi Journal Challenge - May 2024
Feedback and Announcements
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
 
  #2 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader, MultiCharts
Broker: Interactive Brokers
Trading: Keyboard
Posts: 9,888 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,103

You can build daily charts from futures in different ways. It depends on the data input and the way you merge futures contracts with different expiry.


Data input

CME/NYMEX publishes full session data, which means

-> the open is taken at 6:00 PM EST
-> the high is the high over the full electronic session from 6:00 PM to 5:15 PM EST
-> the low is the low over the full electronic sesison from 6:00 PM to 5:15 PM EST
-> the close is the settlement price taken as the volume weighted average of all trades between 2:28 and 2:30 PM EST

This is what you see on the CME chart.


The NinjaTrader chart is populated with regular session data, that is

-> the open is the regular open at 9:00 AM EST
-> the high is the regular high between 9:00 AM and 2:30 PM EST
-> the low is the regular low between 9:00 AM and 2:30 PM EST
-> the close is the settlement price (see above)

Therefore the NinjaTrader chart makes appear the gaps resulting from the price action during the evening and the night session.

DTN/IQ also provides for full session data, you just need to select the correct symbol under instrument settings.


Contracts used

For the last days the charts should approximately match, but if you move back further in time it is important which method has been used to merge contracts. The current contract CL 06-14 has only been liquid for a few weeks, therefore the data shown on the chart for early April and earlier is probably taken from other contracts. If you wish that the data matches, both chart should use the exact same settings for merging contracts, that is

-> single month contract (not merged, will show holes in data when going back further)
-> merged non-adjusted contract (you need to select the rollover dates)
-> merged back-ajdusted contracts (you need to select the rollover dates and appropriate offsets)
-> perpetual continuous future contract (you need to enquire about the method used by the data provider)

I personally use mergebackadjusted contracts and roll on volume crossover. Those contracts can be built with NinjaTrader from single month contracts. The first three options above can be selected via the NinjaTrader Control Center -> Options -> Data -> Merge policy. The last option depends on the way the data provider builds continuous data. You can access that data by select CL ##-## instead of CL 06-14.

Reply With Quote
  #3 (permalink)
 
sands's Avatar
 sands 
London + UK
 
Experience: Advanced
Platform: Proprietary Analytics
Broker: Multiple broker + Multiple feed
Trading: Currently European and US equities
Posts: 443 since Dec 2013
Thanks Given: 257
Thanks Received: 234


You'll find that market providers can often massage the way prices are published on their webpages/published, due to the specific smoothing algorithms they use to combine contracts, or average out prices to cover price discontinuities to make the data presentable. You'd be surprised that at an institutional level the data I receive from Bloomberg and Reuters on a daily basis is often different than we see out of our unfiltered live feeds.

As an end of day consumer this is often why prices take some time to be published.

Note: this is a wider comment base don my experiences using market data for many asset classes and not solely futures.

Reply With Quote
  #4 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader, MultiCharts
Broker: Interactive Brokers
Trading: Keyboard
Posts: 9,888 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,103


sands View Post
You'll find that market providers can often massage the way prices are published on their webpages/published, due to the specific smoothing algorithms they use to combine contracts, or average out prices to cover price discontinuities to make the data presentable. You'd be surprised that at an institutional level the data I receive from Bloomberg and Reuters on a daily basis is often different than we see out of our unfiltered live feeds.

As an end of day consumer this is often why prices take some time to be published.

Note: this is a wider comment base don my experiences using market data for many asset classes and not solely futures.

Why don't you show us a some daily charts from Reuters and Bloomberg. I would like to know how they are different from daily data which is supplied by DTN/IQ or eSignal.

Reply With Quote
  #5 (permalink)
 
sands's Avatar
 sands 
London + UK
 
Experience: Advanced
Platform: Proprietary Analytics
Broker: Multiple broker + Multiple feed
Trading: Currently European and US equities
Posts: 443 since Dec 2013
Thanks Given: 257
Thanks Received: 234


Fat Tails View Post
Why don't you show us a some daily charts from Reuters and Bloomberg. I would like to know how they are different from daily data which is supplied by DTN/IQ or eSignal.

I'm talking from a more published end of day perspective rather than R/T, that the prices wont always reflect what you see on your charts when the market closes.

I think comparing BBG/Reuters/DTN etc, you'll tend to see very similar charts intra-day on the whole, as with any provider you'll see some differences. Apologies if that wasn't clear :-)

In an intra-day format clearly the points you mention contract merging etc, and the session specified will alter the end format of the data as illustrated.

Reply With Quote
  #6 (permalink)
 
jerbersoft's Avatar
 jerbersoft 
Manila, Philippines
 
Experience: Beginner
Platform: CQG,Bookmap,Sierra Chart
Broker: CQG
Trading: BUND
Posts: 59 since Apr 2014
Thanks Given: 47
Thanks Received: 26


Fat Tails View Post
You can build daily charts from futures in different ways. It depends on the data input and the way you merge futures contracts with different expiry.


Data input

CME/NYMEX publishes full session data, which means

-> the open is taken at 6:00 PM EST
-> the high is the high over the full electronic session from 6:00 PM to 5:15 PM EST
-> the low is the low over the full electronic sesison from 6:00 PM to 5:15 PM EST
-> the close is the settlement price taken as the volume weighted average of all trades between 2:28 and 2:30 PM EST

This is what you see on the CME chart.


The NinjaTrader chart is populated with regular session data, that is

-> the open is the regular open at 9:00 AM EST
-> the high is the regular high between 9:00 AM and 2:30 PM EST
-> the low is the regular low between 9:00 AM and 2:30 PM EST
-> the close is the settlement price (see above)

Therefore the NinjaTrader chart makes appear the gaps resulting from the price action during the evening and the night session.

DTN/IQ also provides for full session data, you just need to select the correct symbol under instrument settings.


Contracts used

For the last days the charts should approximately match, but if you move back further in time it is important which method has been used to merge contracts. The current contract CL 06-14 has only been liquid for a few weeks, therefore the data shown on the chart for early April and earlier is probably taken from other contracts. If you wish that the data matches, both chart should use the exact same settings for merging contracts, that is

-> single month contract (not merged, will show holes in data when going back further)
-> merged non-adjusted contract (you need to select the rollover dates)
-> merged back-ajdusted contracts (you need to select the rollover dates and appropriate offsets)
-> perpetual continuous future contract (you need to enquire about the method used by the data provider)

I personally use mergebackadjusted contracts and roll on volume crossover. Those contracts can be built with NinjaTrader from single month contracts. The first three options above can be selected via the NinjaTrader Control Center -> Options -> Data -> Merge policy. The last option depends on the way the data provider builds continuous data. You can access that data by select CL ##-## instead of CL 06-14.

Thanks Fat Tails. I actually emailed Ninja Trader support. What the support guy suggested was for me to Right-click on the chart and click Reload All Historical Data. Then BOOM! It was fixed. Nevertheless, what you posted has also given me new information. Thank you for that.

Follow me on Twitter Started this thread Reply With Quote




Last Updated on May 8, 2014


© 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