Sum open to close of candles in a defined time range?

• 07/14/2019 at 8:15 AM #102542
  robdav

  I’m writing a validation indicator because the system I’m working on works off the open of the current candle, not the evaluation of it on the next candle open.

  I’m using a trading session of TIME > 080000 AND < TIME 100000 and would like to total the SUM of Close-Open for long trades and Open-Close for short i.e. how many points could be made trading the open to close in the trading session for the candles that meet the criteria. Easy to do for a single candle but I’m not sure how to total them for the trading session.

  So if I was trading a 2 hour session on a 30 min timeframe and only two candles meet the criteria then I only want to sum those two. The timeframe might be an odd one like 36 mins.

  Some candles might be long or short in the trading session but that’s worked out on the criteria, it’s the totalling I need help with.

  Is this possible please?

  Thanks, Rob

  

  robdav

  Participant

  Topics: 65

  Replies: 116

  Been thanked: 7 times
  07/14/2019 at 9:24 AM #102543
  robertogozzi

  There you go:

  ONCE StartTime = 080000 ONCE EndTime = 100000 ONCE BullCount = 0 ONCE BearCount = 0 Bullish = close > open Bearish = close < open IF Time = StartTime THEN BullCount = 0 BearCount = 0 ENDIF IF time >= StartTime AND time <= EndTime THEN IF Bullish THEN BullCount = BullCount + (close - open) ENDIF IF Bearish THEN BearCount = BearCount + (open - close) ENDIF ENDIF

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

  ONCE StartTime = 080000 ONCE EndTime   = 100000 ONCE BullCount = 0 ONCE BearCount = 0 Bullish = close > open Bearish = close < open IF Time = StartTime THEN    BullCount = 0    BearCount = 0 ENDIF IF time >= StartTime AND time <= EndTime THEN    IF Bullish THEN       BullCount = BullCount + (close - open)    ENDIF    IF Bearish THEN       BearCount = BearCount + (open - close)    ENDIF ENDIF

  after EndTime both bullish and bearish candlesticks will have been tallied.

  Next day the counting will be restarded at StartTime.

   

  1 user thanked author for this post.

  robdav

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17188

  Been thanked: 4064 times
  07/14/2019 at 9:34 AM #102544
  GraHal

  Link to above code added to here

  Snippet Link Library

   

  1 user thanked author for this post.

  robertogozzi

  

  GraHal

  Participant

  Topics: 214

  Replies: 8830

  Been thanked: 2201 times
  07/14/2019 at 10:54 AM #102545
  robdav

  robertogozzi wrote:

  There you go:

  ONCE StartTime = 080000<br /> ONCE EndTime = 100000<br /> ONCE BullCount = 0<br /> ONCE BearCount = 0<br /> Bullish = close > open<br /> Bearish = close < open<br /> IF Time = StartTime THEN<br /> BullCount = 0<br /> BearCount = 0<br /> ENDIF<br /> IF time >= StartTime AND time <= EndTime THEN<br /> IF Bullish THEN<br /> BullCount = BullCount + (close – open)<br /> ENDIF<br /> IF Bearish THEN<br /> BearCount = BearCount + (open – close)<br /> ENDIF<br /> ENDIF

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

  ONCE StartTime = 080000 ONCE EndTime = 100000 ONCE BullCount = 0 ONCE BearCount = 0 Bullish = close > open Bearish = close < open IF Time = StartTime THEN BullCount= 0 BearCount= 0 ENDIF IF time >= StartTime AND time <= EndTime THEN IF Bullish THEN BullCount= BullCount + (close – open) ENDIF IF Bearish THEN BearCount= BearCount + (open – close) ENDIF ENDIF

  after EndTime both bullish and bearish candlesticks will have been tallied.

  Next day the counting will be restarded at StartTime.

  Hi Roberto

  This is close to what I need but it adds the cumulative bullish/bearish points to the previous session. I was hoping just to capture the number of bullish/bearish points for each individual session.

  Does that make sense? I’ve tried to show this in the attached image.

  Thanks again

  Rob

  

  robdav

  Participant

  Topics: 65

  Replies: 116

  Been thanked: 7 times
  07/14/2019 at 11:51 AM #102547
  robertogozzi

  Please do not quote posts unless necessary.

  Everyday, at StartTime, it restarts.

  The candle must CLOSE at StartTime, if you want to use a custom TF,  say 7 or 36 minute TF you must either:

  1 – change the StartTime and EndTime

  2 – replace = with < at line 7.

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17188

  Been thanked: 4064 times
  07/14/2019 at 12:15 PM #102548
  robertogozzi

  You also need to remove = from line 11 if you want the time interval to be only > than StartTime and < EndTime.

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17188

  Been thanked: 4064 times
  07/14/2019 at 12:23 PM #102549
  robdav

  Thanks Roberto but it’s still the total for the period rather than each candle that I’m after.

  Thanks though.

  Rob

  

  robdav

  Participant

  Topics: 65

  Replies: 116

  Been thanked: 7 times
  07/14/2019 at 12:59 PM #102550
  robertogozzi

  I read you could do that individually but wanted their sum,

  A single candle count is easy;

  IF time >= 080000 AND time <= 100000 THEN Count = abs(close - open) ENDIF RETURN

  1 2 3 4

  IF time >= 080000 AND time <= 100000 THEN    Count = abs(close - open) ENDIF RETURN

  Of course you’ll have to add your conditions, other than bullish or bearish, if any, at lines 12 and 15.

  My code is generic and counts all of them.

  2 users thanked author for this post.

  Kovit, robdav

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17188

  Been thanked: 4064 times
  10/23/2020 at 12:22 PM #148219
  Kovit

  Hi Roberto thanks for the code listed above would it be possible to adapt it so it does a rolling count of bear and bullish candles that updates every hour ?  I’ve been looking for something to help remove some losses with a long position on a 1 minute time frame and wondered if this could be adapted ?  Happy to open a new thread if needed ?

  Thanks in advance.

  

  Kovit

  Participant

  Topics: 33

  Replies: 93

  Been thanked: 14 times
  10/23/2020 at 2:01 PM #148241
  robertogozzi

  There you go:

  ONCE BullCount = 0 ONCE BearCount = 0 Bullish = close > open Bearish = close < open IF OpenHour <> OpenHour[1] THEN    BullCount = 0    BearCount = 0 ENDIF IF Bullish THEN    BullCount = BullCount + (close - open) ENDIF IF Bearish THEN    BearCount = BearCount + (open - close) ENDIF Return BullCount as “Bullish”, BearCount as “Bearish”

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

  ONCE BullCount = 0 ONCE BearCount = 0 Bullish = close > open Bearish = close < open IF OpenHour <> OpenHour[1] THEN    BullCount = 0    BearCount = 0 ENDIF IF Bullish THEN    BullCount = BullCount + (close - open) ENDIF IF Bearish THEN    BearCount = BearCount + (open - close) ENDIF Return BullCount as “Bullish”, BearCount as “Bearish”

   

  1 user thanked author for this post.

  Kovit

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17188

  Been thanked: 4064 times
  10/23/2020 at 3:17 PM #148251
  Kovit

  Perfect thanks Roberto.:)

  

  Kovit

  Participant

  Topics: 33

  Replies: 93

  Been thanked: 14 times
• Author
  Posts