NexusFi: Find Your Edge


Home Menu

 





inconsistent results from different data sources


Discussion in Emini and Emicro Index

Updated
      Top Posters
    1. looks_one hughesfleming with 4 posts (0 thanks)
    2. looks_two ABCTG with 2 posts (0 thanks)
    3. looks_3 mitty with 2 posts (0 thanks)
    4. looks_4 turbolover with 1 posts (0 thanks)
    1. trending_up 4,394 views
    2. thumb_up 5 thanks given
    3. group 9 followers
    1. forum 13 posts
    2. attach_file 2 attachments




 
Search this Thread

inconsistent results from different data sources

  #1 (permalink)
mitty
Christchurch, New Zealand
 
Posts: 10 since Mar 2018
Thanks Given: 2
Thanks Received: 0

Hi - I am having trouble getting consistent results from different data sources (IQ feed CME/Globex and IB Globex).

I am currently using IQ feed to backtest some ES futures strategies in Multicharts. When I test the Globex data from IQ feed vs data from Interactive Brokers over the same period the results differ significantly. Various metrics can be out by as much as 2-3x. Anyone have any idea what might be causing this?

Also, what is the difference between the straight CME data vs the Globex data from IQ Feed? the two also give significantly different results when tested under the same strategies.

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
How to apply profiles
Traders Hideout
NexusFi Journal Challenge - May 2024
Feedback and Announcements
Trade idea based off three indicators.
Traders Hideout
ZombieSqueeze
Platforms and Indicators
REcommedations for programming help
Sierra Chart
 
  #3 (permalink)
 artemiso 
New York, NY
 
Experience: Beginner
Platform: Vanguard 401k
Broker: Yahoo Finance
Trading: Mutual funds
Posts: 1,152 since Jul 2012
Thanks Given: 784
Thanks Received: 2,685


IB data has a known issue. It aggregates the data in windowed snapshots, so you don't see everything that happened inbetween snapshots..

IQF data is lossless from what I understand.

CME's (DataMine's) data preserves the original message trees, which allows you to construct a more accurate simulation than IQF's data, which undergoes some modifications before it reaches you.

Reply With Quote
  #4 (permalink)
 hughesfleming 
Sliema+Sliema/Malta
 
Experience: None
Platform: Multicharts, Proprietary
Broker: IB,IQFeed,Barcharts.com
Trading: Stocks,Futures
Posts: 40 since Mar 2014
Thanks Given: 87
Thanks Received: 20

This is a common problem. It also depends on how well your data source filters bad ticks. Multicharts does not deal with this on its own. IQFeed is unfiltered but it also does not do a great job of correcting bad data. I also have a second feed that is much better at cleaning historical data but is problematic in other areas.

Keep in mind that your real time data might not match your historical data either regardless of who the provider is. Honestly, I don't think there is much you can do about it. Don't put too much faith in your back tests unless they correlate well with your forward tests.

Reply With Quote
  #5 (permalink)
mitty
Christchurch, New Zealand
 
Posts: 10 since Mar 2018
Thanks Given: 2
Thanks Received: 0

I maybe should have been more specific, I am using the continuous backadjusted futures contract from IQ Feed and a custom futures contract for data from IB as they do not allow the continuous contracts to be queried through IB gateway yet or something.

I am aware of IBs snapshot but thought this only applies to really small timeframes (eg 1 second) and would have a minimal effect on the hour bars my system is built to trade on.

also, as far as the CME Vs globex data issue, IQ Feed appears to offer both CME data and CME_GLOBEX and was wondering if anyone could explain what the difference was? I presume regular CME data includes open out cry but the globex data is electronic only?

Reply With Quote
  #6 (permalink)
 ABCTG   is a Vendor
 
Posts: 2,436 since Apr 2013
Thanks Given: 482
Thanks Received: 1,628

mitty,

I'd start with comparing the actual number of bars you get for the two instruments to make sure they are same.

You could also switch to the continuous contract for IQFeed to rule out any differences caused by the backadjustment or compare your system's results on the backadjusted contract versus the continuous contract both using IQFeed data.

Regards,

ABCTG

Follow me on Twitter Reply With Quote
  #7 (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

The data from Interactive Brokers is not suited for backtesting. There is a number of differences, notably


1. Daily data

DTN/IQ supplies to the official data published by CME. The bar close represents the daily settlement price calculated as an average from all transactions between 3:14:30 and 3:15:00 PM CT (different method used for the last business day of the month). Interactive Brokers aggregates intraday data to build daily bars. The bar close represents the last traded price prior to 4:00 PM CT.

2. Minute data

HIstorical minute data should be identical. However, Interactive Brokers does not supply genuine real-time volume. This means that with data supplied from Interactive Brokers volume indicators will not work correctly on your minute charts. Historical backfill supplied by IB shows correct volume. Volume figures will change when you replace real-time data with historical backfill.

3. Tick data

Interactive Brokers does not supply historical tick data. Real-time tick data is snapshot data, not showing all transactions and not showing correct volume.


Comparing backtests

When you use daily data or tick data, back tests will not match. When you use volume for your backtest, there will be minor discrepancies resulting from slightly different data for historical back fill.

In case that you find major differences when backtesting strategies on minute data, please look at the following issues

- are there any holes in your data?
- how are contract merged, what rollover offsets are used?

You should be able to match backtests on minute data taken from DTN/IQ and IB. Please pay attention to all minor details.

Reply With Quote
  #8 (permalink)
LaissezFaire
Oslo + Norway
 
Posts: 224 since May 2016
Thanks Given: 224
Thanks Received: 104

Is IQFeed still considered a reliable and good datafeed...?

It's what I've been and am using, but I'm not quite up to date about what else there is.

Reply With Quote
  #9 (permalink)
 hughesfleming 
Sliema+Sliema/Malta
 
Experience: None
Platform: Multicharts, Proprietary
Broker: IB,IQFeed,Barcharts.com
Trading: Stocks,Futures
Posts: 40 since Mar 2014
Thanks Given: 87
Thanks Received: 20

IQFeed has been working well and they have an excellent set of indexes that work in real time. It is however not without problems. I think it depends a lot on which platform you use so you can't just look at the feed alone.

I use Multicharts which has no way to deal with bad ticks except by manually correcting them. This is very frustrating. It also leads to incorrect back tests on intraday data. I have attached a snapshot of SPY and an indicator that tracks volatility. It gets completely distorted by these bad ticks which don't get corrected. You will have to decide if this is important to you.

regards,

Alex


Reply With Quote
  #10 (permalink)
 ABCTG   is a Vendor
 
Posts: 2,436 since Apr 2013
Thanks Given: 482
Thanks Received: 1,628


Alex,

depending on what causes these "bad" ticks, you might have a chance to filter them by enabling the "Filter extended trades supplied by the exchange" option in the data feed settings for IQ (open the MC Quotemanager and
go to -> Tools -> Data Sources, select IQFeed and click on "Settings" to get to the window, where you can enable this option).

Regards,

ABCTG

Follow me on Twitter Reply With Quote




Last Updated on July 19, 2018


© 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