How to count numberof instances in last 20 trading days

• 12/14/2020 at 7:54 PM #153750
  Alfy

  Hi guys, i have a code for distribution days below and i would like the code to calculate how many times in the last 20 trading days the condition is fulfilled. Can anyone help please?

  thanks in advance

  a=close b=close[1] c=volume d=volume[1] e=((a-b)/b)*100 j= high - low IF e<-0.1 and C>D OR E<0.1 AND A<0.25*J AND C>D THEN g=1 else g=0 ENDIF RETURN G COLOURED (255,0,0)

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

  a=close b=close[1] c=volume d=volume[1] e=((a-b)/b)*100 j= high - low IF e<-0.1 and C>D OR E<0.1 AND A<0.25*J AND C>D THEN g=1 else g=0 ENDIF RETURN G COLOURED (255,0,0)

   

  

  Alfy

  Participant

  Topics: 34

  Replies: 53

  Been thanked: 5 times
  12/14/2020 at 8:52 PM #153753
  fifi743

  ONCE count=0 a=close b=close[1] c=volume d=volume[1] e=((a-b)/b)*100 j= high - low IF e<-0.1 and C>D OR E<0.1 AND A<0.25*J AND C>D THEN g=1 count=count+1 else g=0 ENDIF RETURN G COLOURED (255,0,0),count

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

  ONCE count=0 a=close b=close[1] c=volume d=volume[1] e=((a-b)/b)*100 j= high - low IF e<-0.1 and C>D OR E<0.1 AND A<0.25*J AND C>D THEN g=1 count=count+1 else g=0 ENDIF RETURN G COLOURED (255,0,0),count

  counts each time G=1

  1 user thanked author for this post.

  Alfy

  

  fifi743

  Participant

  Topics: 10

  Replies: 994

  Been thanked: 489 times
  12/15/2020 at 8:36 AM #153792
  Vonasi

  Alfy – Please follow the forum rules in any future posts and use the ‘Insert PRT Code’ button whenever you put code in your posts. I edited your post to tidy it up! 🙂

  1 user thanked author for this post.

  Alfy

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1812 times
  12/15/2020 at 8:43 AM #153794
  Alfy

  First of all, thanks so much for your help. What I was trying to do was count how many times cumulatively G=1 in the last rolling 20 day period. Eyeballing it, currently we have had 3 occasions in the last 20 trading days when G=1 however your code shows only 1 occasion.

  Best regards

   

  

  Alfy

  Participant

  Topics: 34

  Replies: 53

  Been thanked: 5 times
  12/15/2020 at 9:06 AM #153801
  Nicolas

  You can make a summation of G for a rolling period with SUMMATION:

  a=close b=close[1] c=volume d=volume[1] e=((a-b)/b)*100 j= high - low IF e<-0.1 and C>D OR E<0.1 AND A<0.25*J AND C>D THEN g=1 else g=0 ENDIF RETURN G COLOURED (255,0,0),summation[20](g)

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

  a=close b=close[1] c=volume d=volume[1] e=((a-b)/b)*100 j= high - low IF e<-0.1 and C>D OR E<0.1 AND A<0.25*J AND C>D THEN g=1 else g=0 ENDIF RETURN G COLOURED (255,0,0),summation[20](g)

   

  2 users thanked author for this post.

  Alfy, GraHal

  

  Nicolas

  Keymaster

  Topics: 83

  Replies: 20898

  Been thanked: 4866 times
• Author
  Posts