simple query about a for/next loop

• 12/09/2017 at 6:44 AM #55208
  IG_CFD_Trader

  Hi Nicolas, I have a simple query. for example: For i=0 to 10 do how do I write a code that adds up bars with close>open only (i.e. adds up green bars only)?    regards, Walid

  

  IG_CFD_Trader

  Participant

  Topics: 31

  Replies: 74

  Been thanked: 2 times
  12/09/2017 at 3:31 PM #55221
  robertogozzi

  If you want to use FOR…NEXT you may write:

  BullCount = 0 FOR i = 0 TO 10 DO IF close[i] > open[i] THEN BullCount = BullCount + 1 ENDIF NEXT

  1 2 3 4 5 6

  BullCount = 0 FOR i = 0 TO 10 DO    IF close[i] > open[i] THEN       BullCount = BullCount + 1    ENDIF NEXT

  but there is a more elegant, fast and efficient way:

  BullCount = summation[11](close > open)

  1	BullCount = summation[11](close > open)

  Roberto

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17150

  Been thanked: 4039 times
  12/09/2017 at 9:40 PM #55238
  IG_CFD_Trader

  Hi Roberto,

  Thank you for your reply. Perhaps I was not clear enough in my query.

  BullCount = summation [11](close > open) will return the number of bars that meet the condition close > open in the last 11 bars. Let’s say for example it returned BullCount = 5 (i.e. there were 5 bars with close > open)

  What I am after is how I would then add the closes of these 5 bars together?

  Walid

  

  IG_CFD_Trader

  Participant

  Topics: 31

  Replies: 74

  Been thanked: 2 times
  12/09/2017 at 11:39 PM #55243
  robertogozzi

  BullSum = summation[11](close (close > open)) //sum of CLOSing price of last BULLish bars BullSum = summation[11](range * (close > open)) //sum of RANGE of last BULLish bars

  1 2	BullSum = summation[11](close   (close > open)) //sum of CLOSing price of last BULLish bars BullSum = summation[11](range * (close > open)) //sum of RANGE of last BULLish bars

  This example multiplies CLOSE by the logical/boolean value 0 (when the condition is  false) or 1 (when true), so if there are 5 bullish bars their CLOSing price will be summed up.

  To adapt this to BEARish bars you just need to change the condition to “close < open”.

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17150

  Been thanked: 4039 times
• Author
  Posts