monthly moving average in daily chart

• 11/30/2018 at 5:31 PM #86108
  Nuno

  Hi

  i created an indicator in order to simulate a 20 month moving average  ((h+l+c)/3))  in a daily chart. When i use it, the indicator is ok

  But when i translate it in ProScreener, the result is different

  For example, for the french stock SCR (SCOR Euronext Paris), the variable ‘compteur’  used to  calculate the number of month is egual to 12 instead of 20 for 20 month moving Average, so the value moving average is false

  why ??? is it a proscreener limit?

  here the code for the indicator

  thank you for help

  Nuno

  once monthlyHigh = undefined once monthlyLow = undefined once monthlyClose = undefined dailyHigh = DHigh(1) dailyLow = DLow(1) if month <> month[1] then monthlyHigh = Highest[max(1,BarIndex - lastMonthBarIndex)](dailyHigh) monthlyLow = Lowest[max(1,BarIndex - lastMonthBarIndex)](dailyLow) monthlyClose = DClose(1) lastMonthBarIndex = BarIndex h20 = h19 h19 = h18 h18 = h17 h17 = h16 h16 = h15 h15 = h14 h14 = h13 h13 = h12 h12 = h11 h11 = h10 h10 = h9 h9 = h8 h8 = h7 h7 = h6 h6 = h5 h5 = h4 h4 = h3 h3 = h2 h2 = h1 h1 = monthlyHigh l20 = l19 l19 = l18 l18 = l17 l17 = l16 l16 = l15 l15 = l14 l14 = l13 l13 =l12 l12 = l11 l11 = l10 l10 = l9 l9 =l8 l8 = l7 l7 = l6 l6 = l5 l5 = l4 l4 = l3 l3 = l2 l2 = l1 l1 = monthlyLow a20 = a19 a19 = a18 a18 = a17 a17 = a16 a16 = a15 a15 = a14 a14 = a13 a13 = a12 a12 = a11 a11 = a10 a10 = a9 a9 = a8 a8 = a7 a7 = a6 a6 = a5 a5 = a4 a4 = a3 a3 = a2 a2 = a1 a1 = monthlyClose compteur = compteur+1 endif tp1=(h1+l1+a1)/3 tp2=(h2+l2+a2)/3 tp3=(h3+l3+a3)/3 tp4=(h4+l4+a4)/3 tp5=(h5+l5+a5)/3 tp6=(h6+l6+a6)/3 tp7=(h7+l7+a7)/3 tp8=(h8+l8+a8)/3 tp9=(h9+l9+a9)/3 tp10=(h10+l10+a10)/3 tp11=(h11+l11+a11)/3 tp12=(h12+l12+a12)/3 tp13=(h13+l13+a13)/3 tp14=(h14+l14+a14)/3 tp15=(h15+l15+a15)/3 tp16=(h16+l16+a16)/3 tp17=(h17+l17+a17)/3 tp18=(h18+l18+a18)/3 tp19=(h19+l19+a19)/3 tp20=(h20+l20+a20)/3 avg20 = (tp1+tp2+tp3+tp4+tp5+tp6+tp7+tp8+tp9+tp10+tp11+tp12+tp13+tp14+tp15+tp16+tp17+tp18+tp19+tp20)/20 RETURN AVG20

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103

  once monthlyHigh = undefined once monthlyLow = undefined once monthlyClose = undefined dailyHigh = DHigh(1) dailyLow = DLow(1)   if month <> month[1] then monthlyHigh = Highest[max(1,BarIndex - lastMonthBarIndex)](dailyHigh) monthlyLow = Lowest[max(1,BarIndex - lastMonthBarIndex)](dailyLow) monthlyClose = DClose(1) lastMonthBarIndex = BarIndex   h20 = h19 h19 = h18 h18 = h17 h17 = h16 h16 = h15 h15 = h14 h14 = h13 h13 = h12 h12 = h11 h11 = h10 h10 = h9 h9 = h8 h8 = h7 h7 = h6 h6 = h5 h5 = h4 h4 = h3 h3 = h2 h2 = h1 h1 = monthlyHigh   l20 = l19 l19 = l18 l18 = l17 l17 = l16 l16 = l15 l15 = l14 l14 = l13 l13  =l12 l12 = l11 l11 = l10 l10 = l9 l9  =l8 l8 = l7 l7 = l6 l6 = l5 l5 = l4 l4 = l3 l3 = l2 l2 = l1 l1 = monthlyLow   a20 = a19 a19 = a18 a18 = a17 a17 = a16 a16 = a15 a15 = a14 a14 = a13 a13 = a12 a12 = a11 a11 = a10 a10 = a9 a9 = a8 a8 = a7 a7 = a6 a6 = a5 a5 = a4 a4 = a3 a3 = a2 a2 = a1 a1 = monthlyClose   compteur = compteur+1   endif   tp1=(h1+l1+a1)/3 tp2=(h2+l2+a2)/3 tp3=(h3+l3+a3)/3 tp4=(h4+l4+a4)/3 tp5=(h5+l5+a5)/3 tp6=(h6+l6+a6)/3 tp7=(h7+l7+a7)/3 tp8=(h8+l8+a8)/3 tp9=(h9+l9+a9)/3 tp10=(h10+l10+a10)/3 tp11=(h11+l11+a11)/3 tp12=(h12+l12+a12)/3 tp13=(h13+l13+a13)/3 tp14=(h14+l14+a14)/3 tp15=(h15+l15+a15)/3 tp16=(h16+l16+a16)/3 tp17=(h17+l17+a17)/3 tp18=(h18+l18+a18)/3 tp19=(h19+l19+a19)/3 tp20=(h20+l20+a20)/3   avg20 = (tp1+tp2+tp3+tp4+tp5+tp6+tp7+tp8+tp9+tp10+tp11+tp12+tp13+tp14+tp15+tp16+tp17+tp18+tp19+tp20)/20   RETURN AVG20

   

  

  Nuno

  Participant

  Topics: 8

  Replies: 36

  Been thanked: 0 times
  11/30/2018 at 6:46 PM #86110
  robertogozzi

  ProScreener allows only a lookback of 254 bars, so I guess 20 month by roughly 21 daily bars each yields 420 approx. which is too much!

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17131

  Been thanked: 4030 times
  11/30/2018 at 7:44 PM #86116
  Nuno

  thank you for your reply Roberto

  so i don’t understand why some stocks have ‘compteur’ > 20 ( SEE SCREENSHOT ) and value Moving Average is ok ???

  here is the proscreener code

  timeframe(default) once monthlyHigh = undefined once monthlyLow = undefined once monthlyClose = undefined once compteur = 0 dailyHigh = DHigh(1) dailyLow = DLow(1) if month <> month[1] then monthlyHigh = Highest[max(1,BarIndex - lastMonthBarIndex)](dailyHigh) monthlyLow = Lowest[max(1,BarIndex - lastMonthBarIndex)](dailyLow) monthlyClose = DClose(1) lastMonthBarIndex = BarIndex h20 = h19 h19 = h18 h18 = h17 h17 = h16 h16 = h15 h15 = h14 h14 = h13 h13 = h12 h12 = h11 h11 = h10 h10 = h9 h9 = h8 h8 = h7 h7 = h6 h6 = h5 h5 = h4 h4 = h3 h3 = h2 h2 = h1 h1 = monthlyHigh l20 = l19 l19 = l18 l18 = l17 l17 = l16 l16 = l15 l15 = l14 l14 = l13 l13 =l12 l12 = l11 l11 = l10 l10 = l9 l9 =l8 l8 = l7 l7 = l6 l6 = l5 l5 =l4 l4 = l3 l3 = l2 l2 = l1 l1 = monthlyLow a20 = a19 a19 = a18 a18 = a17 a17 = a16 a16 = a15 a15 = a14 a14 = a13 a13 = a12 a12 = a11 a11 = a10 a10 = a9 a9 = a8 a8 = a7 a7 = a6 a6 = a5 a5 = a4 a4 = a3 a3 = a2 a2 = a1 a1 = monthlyClose compteur = compteur+1 endif tp1=(h1+l1+a1)/3 tp2=(h2+l2+a2)/3 tp3=(h3+l3+a3)/3 tp4=(h4+l4+a4)/3 tp5=(h5+l5+a5)/3 tp6=(h6+l6+a6)/3 tp7=(h7+l7+a7)/3 tp8=(h8+l8+a8)/3 tp9=(h9+l9+a9)/3 tp10=(h10+l10+a10)/3 tp11=(h11+l11+a11)/3 tp12=(h12+l12+a12)/3 tp13=(h13+l13+a13)/3 tp14=(h14+l14+a14)/3 tp15=(h15+l15+a15)/3 tp16=(h16+l16+a16)/3 tp17=(h17+l17+a17)/3 tp18=(h18+l18+a18)/3 tp19=(h19+l19+a19)/3 tp20=(h20+l20+a20)/3 avg20 = (tp1+tp2+tp3+tp4+tp5+tp6+tp7+tp8+tp9+tp10+tp11+tp12+tp13+tp14+tp15+tp16+tp17+tp18+tp19+tp20)/20 CONDITION1 = avg20 > 0 SCREENER[condition1](compteur as "compteur")

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106

  timeframe(default) once monthlyHigh = undefined once monthlyLow = undefined once monthlyClose = undefined once compteur = 0 dailyHigh = DHigh(1) dailyLow = DLow(1)   if month <> month[1] then monthlyHigh = Highest[max(1,BarIndex - lastMonthBarIndex)](dailyHigh) monthlyLow = Lowest[max(1,BarIndex - lastMonthBarIndex)](dailyLow) monthlyClose = DClose(1) lastMonthBarIndex = BarIndex   h20 = h19 h19 = h18 h18 = h17 h17 = h16 h16 = h15 h15 = h14 h14 = h13 h13 = h12 h12 = h11 h11 = h10 h10 = h9 h9 = h8 h8 = h7 h7 = h6 h6 = h5 h5 = h4 h4 = h3 h3 = h2 h2 = h1 h1 = monthlyHigh   l20 = l19 l19 = l18 l18 = l17 l17 = l16 l16 = l15 l15 = l14 l14 = l13 l13  =l12 l12 = l11 l11 = l10 l10 = l9 l9  =l8 l8 = l7 l7 = l6 l6 = l5 l5 =l4 l4 = l3 l3 = l2 l2 = l1 l1 = monthlyLow   a20 = a19 a19 = a18 a18 = a17 a17 = a16 a16 = a15 a15 = a14 a14 = a13 a13 = a12 a12 = a11 a11 = a10 a10 = a9 a9 = a8 a8 = a7 a7 = a6 a6 = a5 a5 = a4 a4 = a3 a3 = a2 a2 = a1 a1 = monthlyClose   compteur = compteur+1   endif   tp1=(h1+l1+a1)/3 tp2=(h2+l2+a2)/3 tp3=(h3+l3+a3)/3 tp4=(h4+l4+a4)/3 tp5=(h5+l5+a5)/3 tp6=(h6+l6+a6)/3 tp7=(h7+l7+a7)/3 tp8=(h8+l8+a8)/3 tp9=(h9+l9+a9)/3 tp10=(h10+l10+a10)/3 tp11=(h11+l11+a11)/3 tp12=(h12+l12+a12)/3 tp13=(h13+l13+a13)/3 tp14=(h14+l14+a14)/3 tp15=(h15+l15+a15)/3 tp16=(h16+l16+a16)/3 tp17=(h17+l17+a17)/3 tp18=(h18+l18+a18)/3 tp19=(h19+l19+a19)/3 tp20=(h20+l20+a20)/3   avg20 = (tp1+tp2+tp3+tp4+tp5+tp6+tp7+tp8+tp9+tp10+tp11+tp12+tp13+tp14+tp15+tp16+tp17+tp18+tp19+tp20)/20   CONDITION1 = avg20 > 0 SCREENER[condition1](compteur as "compteur")

   

  

  Nuno

  Participant

  Topics: 8

  Replies: 36

  Been thanked: 0 times
  11/30/2018 at 8:44 PM #86122
  robertogozzi

  Sorry, my fault, you are not using directly a moving average, so the 254-limit does not apply in this case.

  Which instruments are you applying the scrrener?

  On the Daily TF?

   

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17131

  Been thanked: 4030 times
  11/30/2018 at 9:15 PM #86124
  Nuno

  The screener is apply in french Stocks on daily Timeframe

  

  Nuno

  Participant

  Topics: 8

  Replies: 36

  Been thanked: 0 times
  12/01/2018 at 1:06 AM #86136
  robertogozzi

  I have tested it on many instruments and I think the problem could be that some stocks are not traded everyday and there are many “holes” (some stocks report 1 or 2 tradind days in a month) and this may lead to such odd results.

  I’m afraid I cannot be of great help.

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17131

  Been thanked: 4030 times
  12/01/2018 at 1:00 PM #86141
  Nuno

  Thank you Roberto

  some stocks   (Scor SCR / Fleuri Michon FLE ) in France Stocks  with variable ‘compteur’ = 12 are liquid stocks  and are traded everyday

  If someone have an idea?

  

  Nuno

  Participant

  Topics: 8

  Replies: 36

  Been thanked: 0 times
  12/01/2018 at 1:09 PM #86142
  Nuno

  here in a daily graph about SCR with the indicator

  all is ok but in Proscreener, value is false

  help are welcome

  

  Nuno

  Participant

  Topics: 8

  Replies: 36

  Been thanked: 0 times
  12/03/2018 at 12:07 PM #86244
  Nicolas

  Sorry if I’m wrong but the indicator value compared to the one returned by the screener is not the same in any case:

  SCREENER[condition1](avg20)//(compteur as "compteur")

  1	SCREENER[condition1](avg20)//(compteur as "compteur")

  robertogozzi wrote:

  so the 254-limit does not apply in this case.

  The 254 bars limit do apply in this case. 254 candlesticks is far from enough to count 20 months on a daily timeframe, so I can’t understand why we get counter of more than 20..because if I change the “compteur” variable incrementing with:

  if day<>day[1] then compteur = compteur+1 endif

  1 2 3

  if day<>day[1] then compteur = compteur+1 endif

  the max value I get is 255..

  2 users thanked author for this post.

  Nuno, robertogozzi

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  12/03/2018 at 10:08 PM #86269
  Nuno

  Hi Nicolas,

  thank you for your reply

  i made de changes about

  SCREENER[condition1](avg20)//(compteur as "compteur")

  1	SCREENER[condition1](avg20)//(compteur as "compteur")

  but the moving average value in proscreener is incorrect  because compteur < 20 (for average 20 month)

  in the monthly and daily charts, moving average value is the same

   

  About the 254 limit, i dont undestand why some value have the variable compteur > 20 . for theses stocks moving average value in Proscreener are ok (se screenshot)

  what is false in my code about the variable compteur?

  

  Nuno

  Participant

  Topics: 8

  Replies: 36

  Been thanked: 0 times
  12/04/2018 at 8:27 AM #86282
  Nicolas

  Nothing is wrong in your code, I’m trying to know why your count variable is incrementing while it is not possible due to the bars limitation.

  By the way, you’ll not be able to calculate correctly your 20 months moving average in ProScreener on the daily timeframe, and that was the purpose of your initial query. Once I know more about the count issue, I will let you know.

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  12/04/2018 at 9:22 AM #86285
  Nuno

  Ok

  thank you Nicolas

  

  Nuno

  Participant

  Topics: 8

  Replies: 36

  Been thanked: 0 times
  12/10/2018 at 8:47 AM #86644
  Nicolas

  I can now confirm that if the months count increase more than expected is that because some of the instruments haven’t regular quote and therefore less days in a month than as usual.

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  12/11/2018 at 7:51 AM #86740
  Nuno

  Ok thank you Nicolas

   

  

  Nuno

  Participant

  Topics: 8

  Replies: 36

  Been thanked: 0 times
• Author
  Posts