DAYOFWEEK delayed by one hour

• 09/09/2021 at 2:18 PM #177147
  gfx

  Hi,

  I added the DAYOFWEEK function in a money management routine;

  I was very surprised that it increases by one after 01:00 am.

  Though it is already Thursday 00:30 AM on the graphique, DAYOFWEEK  returns 3 as if it was based on UTC+1 whereas chart prices displays on UTC+2.

  Any solution ?

  Thks

   

  

  gfx

  Participant

  Topics: 25

  Replies: 65

  Been thanked: 5 times
  09/09/2021 at 4:38 PM #177154
  robertogozzi

  There’s no pic attached.

  In any case, DayOfWeek is the day of the week when a candle closes, while OpenDayOfWeek is the day of the week when a candle opens.

  On DAX, 1h, Thursday is returned when the 00:00 (Utc+2) candle closes (at 01:00).

  On DAX, 4h, Thursday is returned when the 21:00 (Utc+2) of the previous day candle closes (at 01:00 of the next day).

   

   

   

  1 user thanked author for this post.

  Nicolas

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 18044

  Been thanked: 4611 times
• Author
  Posts