Count Crossovers and Crossunders

• 10/23/2016 at 9:33 AM #15344
  nickp104

  Hi,

  I’m trying to count the number of times a short moving average crosses over or crosses under a long moving average over a number of bars. Any help would be gratefully received.

  

  nickp104

  Participant

  Topics: 3

  Replies: 3

  Been thanked: 0 times
  10/23/2016 at 1:04 PM #15361
  Nicolas

  Hmmm this question of “how much time something occurred in the past through x bars ” have been asked many times. I assume I should make a video for this 🙂

  So firstly, you have to define how much bars you want to lookback:

  lookback = 20 //20 bars lookback

  1	lookback = 20 //20 bars lookback

  Then define the conditions you’d like to be tested through this lookback period:

  c1 = average[7] crosses over average[21]

  1	c1 = average[7] crosses over average[21]

  Finally, count how much time this “c1” condition returned true (so condition value would be 1) in the past with the summation instruction:

  x = summation[lookback](c1)

  1	x = summation[lookback](c1)

  Now you have your variable x which contain the number of times the condition “c1” occurred through “lookback”. Happy testing.

  3 users thanked author for this post.

  manel, Philippo, nickp104

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20828

  Been thanked: 4741 times
  10/23/2016 at 3:56 PM #15370
  nickp104

  Nicolas thanks – and apologies. I assume if had looked harder I would have found the answer in your other posts. Really good of you to help me out and very much appreciated. Nick

  

  nickp104

  Participant

  Topics: 3

  Replies: 3

  Been thanked: 0 times
• Author
  Posts