Convert Timestamp for historical Min Data

[Laserdan]

I have min data in the NT format. The timestamps on it are 3 hours less than my local time.

Has anyone written a script that will convert this file to the time i need?

If so, please share. I can write it myself, but why reinvent the wheel?

Thanks in advance

[Laserdan]

Well I created it myself, so i thought i would share it.

Useful if you have a friend that has tick data or min data that you do not have. Have your friend export the data and send to you.

Before you import you will need to change the timestamps on the tick or min txt files to your timeZone (so add or subtract x hours)

That where this tool comes in handy...simply tell it how many hours you want to adjust the file by and where the file is.

it will create a new file in the same directory as the original with the needed time adjustments.

I tried to make this run on a background process,but i dont think it is working properly. However the files are converted properly even if your form hangs or become non responsive. It will clear up when process completes.

written in VB.net with visual studio 2008
all source files included
exe is in the bin/release folder



it takes about 5-10 min to process 2.5 million records

[NinjaTrader_Ray]

Thanks for this contribution, would you mind posting it to the NinjaScript File Sharing area under the Miscellaneous sub section?

[Laserdan]

no problem