NexusFi: Find Your Edge


Home Menu

 





Converting tick data between time zones


Discussion in NinjaTrader

Updated
    1. trending_up 2,524 views
    2. thumb_up 1 thanks given
    3. group 2 followers
    1. forum 4 posts
    2. attach_file 0 attachments




 
Search this Thread
  #1 (permalink)
 daydaxer 
Madrid/Spain
 
Experience: Beginner
Platform: NinjaTrader
Broker: Interactive Brokers/Kinetick
Trading: FDAX
Posts: 16 since Mar 2012
Thanks Given: 3
Thanks Received: 6

Hi,

Recently I downloaded FDAX tick data from patbateman, which is in NT db format (*.ntd). The problem I have is that the tick data seems to be EST (It displayed ticks from 2:00 to 16:00 in my PC, were it should have been 8:00 to 22:00).

I have now converted the data by following these steps:

1) Delete all FDAX data
2) Copy all tick data files to \NinjaTrader 7\db\tick\....
3) Change my PC timezone to EST
4) Start NT
5) Export all tick data to text files
6) Quit NT
7) Change time zone back to my time zone (Madrid UTC+1 with daylight savings)
8) Start NT
9) Import the text files I exported in 5

It seems data timestamps are ok and properly converted, but I'm not sure if I have errors in it, specially with daylight savings.

Is there a better way to do this? and more important is this the correct way of converting tick timestamps?

Cheers!


Follow me on X Started this thread Reply With Quote
Thanked by:

Can you help answer these questions
from other members on NexusFi?
Hungary Called for Magyar at 97pct, Ending 16-Year Orban …
Prediction Markets & Event Contracts
Powell in 48 Hours: Word Markets Give 78% on Inflation, …
Prediction Markets & Event Contracts
Prediction Markets Expiry Day: Trump Eyes War Exit, $230 …
Prediction Markets & Event Contracts
Weekend Update: First Qatari LNG Transit Attempted -- IR …
Traders Hideout
Bookmap Global Plus Lifetime + Lifetime Addons For Sale
Platforms and Indicators
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Sober Journey With S&P
24 thanks
2026 Jlab journal
10 thanks
Lady Vols Primer: Trading Volatility Journal
7 thanks
Algo automated / semi-automated trading anyone?
6 thanks
Trying to learn Volume and price action correlation
5 thanks
  #2 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader
Broker: Interactive Brokers
Trading: Futures & Stocks
Posts: 9,887 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,114

It is a pain to convert that data between different time zones. I do not know a better solution. But I will test it.


Reply With Quote
  #3 (permalink)
 daydaxer 
Madrid/Spain
 
Experience: Beginner
Platform: NinjaTrader
Broker: Interactive Brokers/Kinetick
Trading: FDAX
Posts: 16 since Mar 2012
Thanks Given: 3
Thanks Received: 6


Actually the method I just posted seems to have worked fine. And was not that hard.

I've just coded a strategy to check the tick data against my 1 min bars..... I'll do some tests and post them.


Follow me on X Started this thread Reply With Quote
  #4 (permalink)
 daydaxer 
Madrid/Spain
 
Experience: Beginner
Platform: NinjaTrader
Broker: Interactive Brokers/Kinetick
Trading: FDAX
Posts: 16 since Mar 2012
Thanks Given: 3
Thanks Received: 6


Fat Tails View Post
It is a pain to convert that data between different time zones. I do not know a better solution. But I will test it.

According to NT support the recommended way of doing it is using the export / import process instead of copying in pure ntd files for exactly for this reason. The exported files from NT would be UTC and if imported again would be put into the correct target timezone on the local PC.


Follow me on X Started this thread Reply With Quote
  #5 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Market Wizard
 
Experience: Advanced
Platform: NinjaTrader
Broker: Interactive Brokers
Trading: Futures & Stocks
Posts: 9,887 since Mar 2010
Thanks Given: 4,242
Thanks Received: 27,114


daydaxer View Post
According to NT support the recommended way of doing it is using the export / import process instead of copying in pure ntd files for exactly for this reason. The exported files from NT would be UTC and if imported again would be put into the correct target timezone on the local PC.

Last time I tried, I was not successful, but this was a long time ago.


Reply With Quote




Last Updated on June 8, 2012


© 2026 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 - Downloads - Top
no new posts