NexusFi: Find Your Edge


Home Menu

 





Converting tick data between time zones


Discussion in NinjaTrader

Updated
    1. trending_up 2,620 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?
CFTC Approves First US Bitcoin Perpetual Futures -- Kals …
Traders Hideout
Khamenei Vetoes Uranium Transfer as Peace Odds Surge to …
Prediction Markets & Event Contracts
Would a node-based workflow for automated trading be useful?
Traders Hideout
Memorandum Watch: How the 60-Day MOU Framework Makes May …
Prediction Markets & Event Contracts
Penalties in Budapest, Peace Deadline in Tehran: Arsenal …
Prediction Markets & Event Contracts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
NexusFi site changelog and issues/problem reporting
10 thanks
Darmok and Jalad at Tanagra
3 thanks
Big Mike in Ecuador
1 thanks
30 Sessions
1 thanks
  #2 (permalink)
 
Fat Tails's Avatar
 Fat Tails 
Berlin, Europe
Legendary 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,117

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
Legendary 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,117


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