Timezone adjustment and bar construction

[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

[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]

Thank you !