CountIf Function

• 05/18/2018 at 7:30 PM #70806
  dburgh

  Hello,

  I am looking for help creating a CountIf Function for PRT. Essentially something I can pass a Boolean condition and integer value and then check how many times the Boolean condition was true in the last integer value bars. For example,

  CountIf ( Close[0] <= Close[1] , 10 ) // this ideally would return the number of times the close was below or equal to the previous low in the previous 10 bars. Possible values would be 0 to 10 with 0 being 0 occurrences and 10 being all 10 bars it was true.

  Here is an early attempt

  count = 0 trigger = 0 no_of_bars = 10 for count = 0 to no_of_bars do if condition[count] then trigger += 1 next return trigger

  1 2 3 4 5 6 7 8 9

  count = 0 trigger = 0 no_of_bars = 10   for count = 0 to no_of_bars do if condition[count] then trigger += 1 next   return trigger

   

  Thanks,

  David

  

  dburgh

  Participant

  Topics: 9

  Replies: 59

  Been thanked: 5 times
  05/18/2018 at 8:16 PM #70807
  robertogozzi

  This will do the trick

  summation[10]( Close[0] <= Close[1])

  1	summation[10]( Close[0] <= Close[1])

  it will return the number of occurrences of the condition within parenthesis after scanning the number of bars within brackets.

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17151

  Been thanked: 4040 times
  05/21/2018 at 12:06 PM #71001
  dburgh

  Awesome. Thank you.

  

  dburgh

  Participant

  Topics: 9

  Replies: 59

  Been thanked: 5 times
  09/06/2018 at 8:27 PM #79898
  GraHal

  Snippet added as Row 63 here Snippet Link Library

  Good explanation @robertogozzi

   

  1 user thanked author for this post.

  robertogozzi

  

  GraHal

  Participant

  Topics: 212

  Replies: 8790

  Been thanked: 2189 times
• Author
  Posts