Hey eveyone!
I wanted to sort out something for myself and was curious if my thinking is right.
So let's say I download the daily data from dukascopy into a csv file:
EURAUD_Candlestick_1D_BID_09.10.1991-02.04.2016.csv.
Now, the first row has a column GMT.Time and it reads 08.10.1991 02:00. Now, does that timestamp refer to the beginning of the day or the close?
My thinking is - when a day opens, there is no data for that day, so if we want to know the day's data for 08.10.1991, at 00:00 there will be no data, at 23:59:59 we will have almost the full day. We can close 08.09.1991, when the next day begins - 09.10.1991 00:00. So the timestamp 09.10.1991 00:00 will give us the data since 08.10.1991 00:00. This is one way of reading the data.
The other way is the "day beginning" way. So with a GMT.time 08.10.1991 02:00, dukascopy is saying that the OHLC data that follows is a summary of what happened on the day that started on 08.10.1991 02:00 GMT+2?
Do you guys know which way Dukascopy is formatting the data?
Cheerios!
D
EDIT: Just simply compared the data from another platform, Dukascopy's GMT time field corresponds to the "day starting" way of organising days.
I wanted to sort out something for myself and was curious if my thinking is right.
So let's say I download the daily data from dukascopy into a csv file:
EURAUD_Candlestick_1D_BID_09.10.1991-02.04.2016.csv.
Now, the first row has a column GMT.Time and it reads 08.10.1991 02:00. Now, does that timestamp refer to the beginning of the day or the close?
My thinking is - when a day opens, there is no data for that day, so if we want to know the day's data for 08.10.1991, at 00:00 there will be no data, at 23:59:59 we will have almost the full day. We can close 08.09.1991, when the next day begins - 09.10.1991 00:00. So the timestamp 09.10.1991 00:00 will give us the data since 08.10.1991 00:00. This is one way of reading the data.
The other way is the "day beginning" way. So with a GMT.time 08.10.1991 02:00, dukascopy is saying that the OHLC data that follows is a summary of what happened on the day that started on 08.10.1991 02:00 GMT+2?
Do you guys know which way Dukascopy is formatting the data?
Cheerios!
D
EDIT: Just simply compared the data from another platform, Dukascopy's GMT time field corresponds to the "day starting" way of organising days.