Summation with for to next loop

• 08/13/2018 at 6:53 PM #78095
  Vagus_Lux

  DEFPARAM DRAWONLASTBARONLY=TRUE LFC=summation[5](close)

  1 2 3

  DEFPARAM DRAWONLASTBARONLY=TRUE   LFC=summation[5](close)

   

  I’d like to achieve the same result with the following simple ‘for next loop’instead using ‘summation’ but there is no output using the ‘for next loop’

  for i=1 to 5 do LFC=close[i]+LFC next return LFC

  1 2 3 4 5

  for i=1 to 5 do LFC=close[i]+LFC next   return LFC

   

  

  Vagus_Lux

  Participant

  Topics: 7

  Replies: 14

  Been thanked: 3 times
  08/13/2018 at 7:05 PM #78097
  robertogozzi

  The last 5 bars are 0-4, not 1-5 (these are the previous 5 bars).

  The problem could be the value returned by LFC, too big to be displayed.

  On DAX that would be about 62000 (5 * 12400), but your are not resetting it to 0 at the beginning, so within a few bars that could become a huge number!

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17277

  Been thanked: 4126 times
  08/13/2018 at 7:18 PM #78098
  Vagus_Lux

  Thank you so much for your super fast response!
  You are right! I added one reset ahead of the for next loop and it worked.

  LFC = 0 //Reset LFC for i=1 to 5 do LFC=close[i]+LFC next

  1 2 3 4 5

  LFC = 0 //Reset LFC   for i=1 to 5 do LFC=close[i]+LFC next

   

  

  Vagus_Lux

  Participant

  Topics: 7

  Replies: 14

  Been thanked: 3 times
  08/13/2018 at 8:11 PM #78101
  Vonasi

  Vagus_Lux – please use the ‘Insert PRT Code’ button when putting code in your posts to make it more readable for others. I have tidied up your posts for you. 🙂

  I am guessing that Robert is posting from his phone otherwise he would have done the same!

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  08/13/2018 at 8:22 PM #78103
  robertogozzi

  AhAhAh…. I am indeed posting from my phone!

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17277

  Been thanked: 4126 times
  11/09/2018 at 7:22 PM #84509
  simeong

  I have a quick question there.

  In the example code below, I do have the following query

  for i=8 to 20 do LFC=close[i]+close[28] next return LFC

  1 2 3 4 5

  for i=8 to 20 do LFC=close[i]+close[28] next return LFC

  is close[28] inside the for statement 28 candles from close[0] or 28 candles from “i” or “close[i]” ?

  Kind Regards,

   

  

  simeong

  Participant

  Topics: 10

  Replies: 32

  Been thanked: 1 time
  11/09/2018 at 7:30 PM #84510
  robertogozzi

  From CLOSE[0], it is constant through the loop.

  To be from i you’ll have to write 28+i within brackets.

  1 user thanked author for this post.

  simeong

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17277

  Been thanked: 4126 times
  03/11/2020 at 5:13 PM #121845
  VN

  Hi Roberto, I am trying to count the total number of times an event took place in a given timeframe of my chart.

  For example I am counting the number of times RSI crossed above 70 and I want that calculation to be applied to any timeframe so from the beginning of time to end of time loaded.

  I don’t know how to set the beginning and end of time in a FOR NEXT loop.

  Any eloquent way that this can be achieved?

   

  

  VN

  Participant

  Topics: 5

  Replies: 51

  Been thanked: 0 times
  03/11/2020 at 6:33 PM #121864
  robertogozzi

  The beginning is always BARINDEX=0.

  BARINDEX is the progressive numeber of bars, so you need to do is, from current bar to zero:

  Count = 0 FOR i = BarIndex DOWNTO 0 IF Rsi[14](close)[i] CROSSES OVER 70 THEN Count = Count + 1 ENDIF NEXT RETURN Count AS "Count"

  1 2 3 4 5 6 7

  Count = 0 FOR i = BarIndex DOWNTO 0    IF Rsi[14](close)[i] CROSSES OVER 70 THEN       Count = Count + 1    ENDIF NEXT RETURN Count AS "Count"

  But… all the above is not necessary, since any indicator ALWAYS starts from the beginning, so all you want to do is to sum any occurrence of the event:

  ONCE Count = 0 IF Rsi[14](close) CROSSES OVER 70 THEN Count = Count + 1 ENDIF RETURN Count AS "Count"

  1 2 3 4 5

  ONCE Count = 0 IF Rsi[14](close) CROSSES OVER 70 THEN    Count = Count + 1 ENDIF RETURN Count AS "Count"

   

   

  1 user thanked author for this post.

  VN

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17277

  Been thanked: 4126 times
  05/18/2020 at 3:59 PM #132165
  VN

  hi @ robertogozzi, i want to modify the code such that it counts how many times the RSI crossed over 70 in the last 30 bars. So the count will be a rolling count between period zero until 30 periods ago. Can this be done?

  

  VN

  Participant

  Topics: 5

  Replies: 51

  Been thanked: 0 times
  05/18/2020 at 4:08 PM #132166
  robertogozzi

  There you go:

  x = summation[31](Rsi[14](close) crosses over 70)

  1	x = summation[31](Rsi[14](close) crosses over 70)

  X will retain the value you are looking for.

  from current bar [0] up to 30 bars ago [30], it’s 31 bars.

  There’s not need to use loops here.

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17277

  Been thanked: 4126 times
  05/18/2020 at 4:32 PM #132173
  VN

  thanks Roberto! I did not think of using summation in this context, but that works nicely!

  I used this code to also count the number of times the current close was less than prior close, but that doesn’t return the right answer.

  x = summation[31](close < close[1])

  1	x = summation[31](close < close[1])

  Have i done something wrong?

  

  VN

  Participant

  Topics: 5

  Replies: 51

  Been thanked: 0 times
  05/18/2020 at 4:45 PM #132177
  Vonasi

  What you have coded will compare the current close to the previous close and then the 2nd to last  close to the one before that and then the third to last close to the one before that…. and so on and so on.

  If you want to compare the latest close to the 30 previous candles then you will need a loop.

  x = 0 for a = 1 to 30 if close < close[a] then x = x + 1 endif next

  1 2 3 4 5 6

  x = 0 for a = 1 to 30 if close < close[a] then x = x + 1 endif next

   

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  05/18/2020 at 5:26 PM #132183
  VN

  thanks vonasi..

  the above is part of a wider problem i am trying to code, but with not much success.

  I am trying to count the number of times the price changed direction in a specified period e.g. last 10 candles, in other words the number of times the candle colour changed in the last 10 candles.

  so for example, if the first 3 candles were green, but the forth was red, then the counter = 1 as that is the 1st time the close went below prior close.

  then candle 5 and 6 were both green then the counter = 2 since the close at candle 5 reversed  from red (4th candle) to green (5th candle). I don’t want to count the candles when the colour is same, only when they reverse.

  

  VN

  Participant

  Topics: 5

  Replies: 51

  Been thanked: 0 times
  05/18/2020 at 5:31 PM #132184
  robertogozzi

  Bullish = close > open Bearish = close < open Change = (Bullish AND Bearish[1]) OR (Bullish[1] AND Bearish) x = summation[10](Change)

  1 2 3 4

  Bullish = close > open Bearish = close < open Change  = (Bullish AND Bearish[1]) OR (Bullish[1] AND Bearish) x       = summation[10](Change)

  There you go.

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17277

  Been thanked: 4126 times
• Author
  Posts