Issue weekly data start on Tuesday
Posted: Wed May 03, 2023 8:02 pm
Good evening,
I tried to extract files for EURUSD and GBPUSD on a weekly basis with the adjust timezone of NY Trading hours.
Everything is OK until 2018. From the beginning of January 2018, all the weekly dates start on Tuesday and not Monday(I attached two export for EU and GU).
An extract for the weekly on EU
20171218,00:00:00,1.17441,1.19017,1.17377,1.18607,981440.661020398
20171225,00:00:00,1.1844,1.20254,1.18429,1.19985,642020.22086139
20180102,00:00:00,1.20102,1.20889,1.1956,1.19666,984393.291329607
20180109,00:00:00,1.19666,1.22964,1.19156,1.22634,1218168.72065184
20180116,00:00:00,1.22634,1.23231,1.2165,1.22614,1300954.38167687
And for the weekly on GU :
20171218,00:00:00,1.33095,1.34199,1.33095,1.33541,833437.472033307
20171225,00:00:00,1.33449,1.3544,1.33449,1.34944,585059.001369946
20180102,00:00:00,1.35065,1.36124,1.34945,1.35662,776777.091985054
20180109,00:00:00,1.35657,1.38193,1.34579,1.37935,867593.500804886
20180116,00:00:00,1.37935,1.39905,1.37417,1.39837,1015826.89094575
Thank you
I tried to extract files for EURUSD and GBPUSD on a weekly basis with the adjust timezone of NY Trading hours.
Everything is OK until 2018. From the beginning of January 2018, all the weekly dates start on Tuesday and not Monday(I attached two export for EU and GU).
An extract for the weekly on EU
20171218,00:00:00,1.17441,1.19017,1.17377,1.18607,981440.661020398
20171225,00:00:00,1.1844,1.20254,1.18429,1.19985,642020.22086139
20180102,00:00:00,1.20102,1.20889,1.1956,1.19666,984393.291329607
20180109,00:00:00,1.19666,1.22964,1.19156,1.22634,1218168.72065184
20180116,00:00:00,1.22634,1.23231,1.2165,1.22614,1300954.38167687
And for the weekly on GU :
20171218,00:00:00,1.33095,1.34199,1.33095,1.33541,833437.472033307
20171225,00:00:00,1.33449,1.3544,1.33449,1.34944,585059.001369946
20180102,00:00:00,1.35065,1.36124,1.34945,1.35662,776777.091985054
20180109,00:00:00,1.35657,1.38193,1.34579,1.37935,867593.500804886
20180116,00:00:00,1.37935,1.39905,1.37417,1.39837,1015826.89094575
Thank you