Data export Problem NT7

[mcr-ksh]

Hi,

i've been exporting Minute data ('Last') and somehow can't reconstruct the way the candels are build from that data.

This is the chart and the candle for test:


The Data Box:


This is the Data from the NT7 DB export:

    %        date   time ; open  ; high  ; low ;  close  ; volume
    %-    20160314 145500;2007.75;2008   ;2006.75;2007   ;3925 
    %     20160314 145600;2007   ;2007.25;2006.5 ;2007   ;2706 
    %     20160314 145700;2007   ;2007.5 ;2006.75;2007.25;2466 
    %     20160314 145800;2007.25;2007.25;2006   ;2006.25;3140 
    %     20160314 145900;2006.25;2006.5 ;2005.75;2006.25;4674
    %-    20160314 150000;2006.5 ;2006.5 ;2005.75;2006.5 ;6974

If I reconstruct the 5M candle from the 1M data I should get this, right?

                      1455            2007.75;2008   ;2005.75;2006.25;16911

But even in the raw data export there is NO value that even reaches the high of 2009
to compare the Data box:

                      1455            2007.75;2008   ;2005.75;2006.25;16911
                      1455            2008.75;2009   ;2006.75;2007.00;16755

What am I doing wrong here?

PS: must be the same data as on the chart, right?

ksh

[NinjaTrader_Brandon]

Hello mcr-ksh,
Thanks for your post.
When you export data it will be in UTC time. If you adjust what data you are looking at based on it being UTC time does it match what you expect?

[mcr-ksh]

NO. This is why I posted the times. the Databox is at UTC 1455 while the chart is at 1555. The conversion is already done.

ksh

[NinjaTrader_Brandon]

Hello mcr-ksh,
Thanks for your reply.
NinjaTrader time stamps on bar close.
So for the 5 minute bar you would check data from 14:51-14:55 UTC

[mcr-ksh]

% 20160314 145100;2008.75;2009 ;2008 ;2008 ;2841
% 20160314 145200;2008.25;2008.5 ;2007.5 ;2008 ;2461
% 20160314 145300;2007.75;2008 ;2007.5 ;2007.75;2639
% 20160314 145400;2007.75;2008.25;2007.5 ;2008 ;4889
%- 20160314 145500;2007.75;2008 ;2006.75;2007 ;3925

this is it!

thanks.
ksh