Average in indicator returns flat spots

• 03/24/2020 at 4:06 PM #123156
  Vonasi

  This simple indicator that just calculates an average of the closing position as a percentage of range returns flat spots on the indicator where the average is clearly not being calculated correctly and the value does not change over many candles.

  The attached images are of DJI daily.

  p = 3 closeperc = ((close-low)/(high-low))*100 avg = average[p,1](closeperc) return avg

  1 2 3 4 5 6

  p = 3   closeperc = ((close-low)/(high-low))*100 avg = average[p,1](closeperc)   return avg

   

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1810 times
  03/24/2020 at 4:41 PM #123167
  Nicolas

  Congratulations for being able to successfully recode a stochastic from scratch! 😆 (no offense)

  sto = Stochastic[1,1] avg = average[p,1](sto)

  1 2	sto = Stochastic[1,1] avg = average[p,1](sto)

  EDIT: topic is not in the right section! 😉

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20829

  Been thanked: 4742 times
  03/24/2020 at 5:10 PM #123171
  robertogozzi

  Vonasi, you’ll have to move it yourself to the correct support forum!

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 16497

  Been thanked: 3656 times
  03/24/2020 at 5:37 PM #123180
  Vonasi

  Nicolas wrote:

  Congratulations for being able to successfully recode a stochastic from scratch!

  I actually hadn’t twigged that it was the same calculation!

  Interestingly if you put the two calculations on in the same indicator the stochastic one calculates just fine but my version doesn’t.

  p = 3 closeperc = ((close-low)/(high-low))*100 avg = average[p,1](closeperc) sto = Stochastic[1,1] avg2 = average[p,1](sto) return avg,avg2

  1 2 3 4 5 6 7 8 9

  p = 3   closeperc = ((close-low)/(high-low))*100 avg = average[p,1](closeperc)   sto = Stochastic[1,1] avg2 = average[p,1](sto)   return avg,avg2

  I actually think this is the right place for this topic as it is clearly a data or calculation error which is a platform issue.

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1810 times
  03/24/2020 at 5:41 PM #123182
  Vonasi

  I’ve done a little more testing and the variable closeperc calculates correctly. The issue is with the exponential average calculation. If I use a simple average then it calculates correctly.

  1 user thanked author for this post.

  GraHal

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1810 times
  03/24/2020 at 5:56 PM #123184
  GraHal

  More worrying revelations?

  

  GraHal

  Participant

  Topics: 204

  Replies: 8433

  Been thanked: 2048 times
  03/24/2020 at 6:05 PM #123185
  robertogozzi

  Your code works fine for me, both lines overlap.

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 16497

  Been thanked: 3656 times
  03/24/2020 at 7:06 PM #123189
  Vonasi

  robertogozzi wrote:

  Your code works fine for me, both lines overlap.

  Really? That is very odd. On the DJI daily?

  I feel a switch it off and back on again happening if so.

   

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1810 times
  03/24/2020 at 7:34 PM #123192
  robertogozzi

  DAX Daily.

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 16497

  Been thanked: 3656 times
  03/24/2020 at 8:24 PM #123196
  Vonasi

  Dow Jones not DAX

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1810 times
  03/24/2020 at 11:24 PM #123203
  robertogozzi

  DJI daily.

  The one below is your original code.

  The one above is this one (with modifications to avoid division by 0):

  p = 3 x = max(pipsize,range) //closeperc = ((close-low)/(high-low))*100 closeperc = ((close-low)/x)*100 avg = average[p,1](closeperc) sto = Stochastic[1,1] avg2 = average[p,1](sto) return avg AS "Avg",avg2 AS "Stoch"

  1 2 3 4 5 6 7 8 9

  p = 3 x = max(pipsize,range) //closeperc = ((close-low)/(high-low))*100 closeperc = ((close-low)/x)*100 avg = average[p,1](closeperc) sto = Stochastic[1,1] avg2 = average[p,1](sto) return avg AS "Avg",avg2 AS "Stoch"

  Apart from a few candles, both blue and red lines overlap.

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 16497

  Been thanked: 3656 times
• Author
  Posts