Timezone adjustment and bar construction

Report any bugs with the Tickstory Lite software here. Please give as much detail as possible so the issue can be identified and resolved as soon as possible.
Post Reply
7Bridges
Posts: 7
Joined: Wed Apr 26, 2023 7:19 am

Timezone adjustment and bar construction

Post by 7Bridges »

Good day,

I discovered your tool that.seems amazone because I struggle a lot with the timezone on my backtesting.
So I tried to export the data with your "Adjust Timezone" functionality for :
- UTC + 2 with European/London DST
- EST + 7 NY trading Hours

I did the test for EURUSD. When I open the exported files, I have the exact same data (with the same opening time for each Hourly candle)

I look for some details about the fictionality of timeshiftimg but I didn't find so much on the forum. I am not sure to understand the way it works, could you help?

Thank you
Attachments
EURUSD-NY-H1.csv
(3.21 KiB) Downloaded 71 times
EURUSD-LND-H1.csv
(3.21 KiB) Downloaded 74 times

tickstory
Posts: 4883
Joined: Sun Jan 06, 2013 12:27 am

Re: Timezone adjustment and bar construction

Post by tickstory »

Hi 7Bridges,

The process of shifting time-zones and creating hourly bars occurs as follows:

1) Take the input date/time stamp of the tick (which is usually in UTC for FX symbols).
2) Convert the timestamp into the target time-zone (eg. EST + 7).
3) Create an hourly bar that will hold all the data for the current hour.
4) Process all the incoming ticks (with their adjusted time-stamps) and record the open, high, low and close for the hour.
5) Repeat for every subsequent hourly bar.

Therefore, you will always have timestamps that look similar but the content of the OHLC of the bar will be different.
Hope this helps.

7Bridges
Posts: 7
Joined: Wed Apr 26, 2023 7:19 am

Re: Timezone adjustment and bar construction

Post by 7Bridges »

Thank you !

Post Reply