Monday = INTRADAYBARINDEX : 11 ?
- This topic has 21 replies, 5 voices, and was last updated 1 year ago by
.
-
I don’t know the answer hence how to deal with it, but this may be related to when the Fx pair resets. For example, for EUR/USD this is 02:00 our time (Brussel) for IB.
I said “for IB” because I recall that for IG this is not the same. This is how the daily gain in % is not equal for both.Then I said in the first sentence “may be”, because it also looks like your issue being that the week starts at 23:00 (our time) while it is still Sunday. Now compare with e.g. the UK where it will be 22:00.
I hope that someone else has a good answer to this. If not, best is to work around it. Offset it yourself (somehow). Don’t forget daylight savings !
1 user thanked author for this post.
Hi @Zerocafeine, although it hasn’t been discussed for a while, this question used to be raised in the early days of the site with topics of users trying to calculate pivot points on IG ruling out Sundays and/or a few night hours in the week. The key points are :
- times and intradaybarindex keywords are in your timezone, related to « your » midnight,
- but dates keywords and therefore date changes are not in your timezone, they are common to everyone in the market’s timezone, the market date changes at the same instant wherever you are on the globe (I like to call it the « market’s midnight », but you don’t have to, it’s not an official term), so this date change frontier is not at the same hour for different people in different timezones.
dayofweek=1 is a market date keyword, it is not in your timezone, so in this case it is true from midnight UK time market date change (however, note : not all cfd’s from IG necessarily have a UK midnight date change), which happens to be 1:00am your time, and another time for someone in another timezone.
You are in 5mn timeframe, so at « your » midnight you first have intradaybarindex=0 and 12 times 5mn candles in total (0,1,2,…,11 if no empty ones) make up one hour until market ‘s midnight, that’s your intradaybarindex=11 candle count since midnight, starting at 0 :55 and closing at 1 :00am your time.
As a sidenote, your code says it’s Monday only because you picked candle close, you could just as well have picked date at candle open with opendayofweek=1 and it would have been the =12 candle starting at 1am.
1 user thanked author for this post.
@JC_Bywan
First of all, thank you very much for all your answers 😊, and I wish you a good recovery 😊It’s me I messed up and instead of using the times of day I thought using the INTRADAYBARINDEX function would be nicer for various reasons, but since it can have missing candles and therefore skew all the calculations then I’ll go for conditions with the Time function instead
1 user thanked author for this post.
The issue is due to DayOfWeek which is NOT updated whan a new day start, but when the DAILY candle opens. So, when the daily candle is set to open by IG at 010000, your date will show the new day (in this case Tuesday), but DayOfWeek will retain 1 (it’s still the Monday’s candle) from 000000 to 005959.
Use this code:
123456789IF (DayOfWeek = 1 AND Time > 080500) THENMyCondition = 1ENDIFIF (DayOfWeek >= 2 AND Time >= 080500) THENMyCondition = 0ENDIF//Graph Monday AS "Monday"Graph MyCondition AS "MyCondition"1 user thanked author for this post.
You probably did not understand my explanation fully.
Use my code, replacing MyCondition with X, then add
X = X + 1
just before GRAPH.
1 user thanked author for this post.
Find exclusive trading pro-tools on 
