All time average in an indicator.

• 07/04/2018 at 11:28 AM #75196
  Vonasi

  I’m coding an indicator and I wanted to calculate an all time average of a value in it but I couldn’t get a value out of it. Here a simplified version of the first attempt:

  a = (my calculation) c = c + 1 d = d + a ave = d / c

  1 2 3 4 5 6

  a = (my calculation)   c = c + 1 d = d + a   ave = d / c

  I then changed it to this and it works:

  a = (my calculation) if a > 0 then c = c + 1 d = d + a endif ave = d / c

  1 2 3 4 5 6 7 8

  a = (my calculation)   if a > 0 then c = c + 1 d = d + a endif   ave = d / c

  I’m trying to understand why one works and the other doesn’t – can anyone explain?

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
  07/04/2018 at 11:36 AM #75197
  Nicolas

  First time you made the calculation, d is equal to 0 and thus made a division by zero error.

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  07/04/2018 at 12:03 PM #75200
  Vonasi

  Is this because the values are calculated live/on the fly? My brain is thinking the value is set at bar close but that might be because it has spent too much time doing end of bar strategies!

  So it is the same if you want to use the AVERAGE instruction – you must do this:

  a = (my calculation) if a > 0 then d = average[21](a) endif

  1 2 3 4 5

  a = (my calculation) if a > 0 then d = average[21](a) endif

  or even this slightly messy version:

  a = (my calculation) Once a = 0.000000000000001 d = average[21](a)

  1 2 3 4 5

  a = (my calculation) Once a = 0.000000000000001   d = average[21](a)

  or even this:

  a = max((my calculation), 0.000000000000001) d = average[21](a)

  1 2 3

  a = max((my calculation), 0.000000000000001)   d = average[21](a)

   

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
• Author
  Posts