Announcement

Collapse
No announcement yet.

Partner 728x90

Collapse

Consistency between tick data and backtesing execution prices

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Consistency between tick data and backtesing execution prices

    Hi
    I have a free access to FXCM and used the data they provide to backtest a strategy.

    NT gives me access to the list of trades when I do the backtest. At the same time using the data manageer I have extracted the tick data of the corresponding asset. I need to do some statistical analysis but I observe an issue:

    The backtested trade execution times and price are not consistent at all with the tick data (difference above the bid-ask spread).

    For example

    I have a trade executed (given by the backtesting tool) Long at 1.61556 on 2016/01/04 10:14:32

    And below is my tick data extracted from the data manager

    2016/01/04 10:14:30; 1.61329;1
    2016/01/04 10:14:32; 1.61335;6
    2016/01/04 10:14:32; 1.61333;3
    2016/01/04 10:14:33; 1.61334;2
    2016/01/04 10:14:38; 1.61332;3
    2016/01/04 10:14:39; 1.6133;1

    This is not matching and is above the bid-ask spread.

    I attached a graphic showing this discrepancies. It seems actually the backtesting trade execution times have a small time delay compared to the tick data. The delay by the way seems to be 1 hour.

    So several question:

    Is this a known problem to which I am not familiar?
    Is the market data used by NT for backtesting consistent with the tick data we can export from data manager?
    If yes, does the backtest execution trade time is the local time of my machine and the tick data use GMT time?
    Do you recommend buying tick market data, and if yes how can we make backtesing data are consistent with the tick data?

    Thanks for the help
    Attached Files
    Last edited by jakjak74; 12-06-2016, 03:32 AM.

    #2
    Hello,

    Thank you for the post.

    It is expected there are differences between Live trading and Backtesting in Historical data specifically. As historical data is being used in the backtest, no Intrabar granularity is available unless you are specifically adding a 1 tick series and utilizing that for logic. Additionally for Forex instruments specifically the platform will utilize the Bid prices unless the ask is otherwise specified and that would be used instead. There can also be differences in volume seen based on who the data provider is which could also lead to differences seen.

    You can locate further descriptions on this topic here: http://ninjatrader.com/support/helpG...htsub=backtest

    I look forward to being of further assistance.

    Comment

    Latest Posts

    Collapse

    Topics Statistics Last Post
    Started by Geovanny Suaza, 02-11-2026, 06:32 PM
    0 responses
    589 views
    0 likes
    Last Post Geovanny Suaza  
    Started by Geovanny Suaza, 02-11-2026, 05:51 PM
    0 responses
    342 views
    1 like
    Last Post Geovanny Suaza  
    Started by Mindset, 02-09-2026, 11:44 AM
    0 responses
    103 views
    0 likes
    Last Post Mindset
    by Mindset
     
    Started by Geovanny Suaza, 02-02-2026, 12:30 PM
    0 responses
    555 views
    1 like
    Last Post Geovanny Suaza  
    Started by RFrosty, 01-28-2026, 06:49 PM
    0 responses
    552 views
    1 like
    Last Post RFrosty
    by RFrosty
     
    Working...
    X