Monthly (close-open), monthly timeframe

• 12/07/2021 at 11:32 AM #182929
  briac

  Hi , i am trying to do and indicator that returns me the summatory of the value (close-open) for the last 10 month but for each month separately, i mean: the last 10 januaries, the last 10 februaries, …..

  that is what i did,But it doesn´t work, i don´t know why

  Retorno = close[0]-open[0] for i=0 to 10 do Retorno = (close[i+12]-open[i+12]) + Retorno next Return Retorno

  1 2 3 4 5 6 7

  Retorno = close[0]-open[0]   for i=0 to 10 do Retorno = (close[i+12]-open[i+12]) + Retorno next   Return Retorno

  Thank you very much

  

  briac

  Participant

  Topics: 3

  Replies: 3

  Been thanked: 1 time
  12/07/2021 at 1:10 PM #182934
  JC_Bywan

  Hi, it’s because in the loop, with i+12 instead of i*12 you’re adding all the consecutive months before the one 12 ago instead of “jumping” every 12 months + with 0 to 10 you’re adding that 11 times instead of 9 times to first one to make a total of 10 + you’re counting current candle’s retorno several times inside the loop.

  Let’s try with this one to display on a monthly timeframe each month the sum of same-name 10 months as current month + previous same-name 9 one’s

  x=close[0]-open[0] y=0 Retorno=0 if barindex>120 then// wanting at least 10 times 12 months in history for i=1 to 9 do y = x[i*12] + y // y intermediate calculation of the 9 times before (close-open) next Retorno= y+x// adding y to current close-open endif return Retorno as "Retorno",0

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

  x=close[0]-open[0] y=0 Retorno=0   if barindex>120 then// wanting at least 10 times 12 months in history   for i=1 to 9 do   y = x[i*12] + y // y intermediate calculation of the 9 times before (close-open) next   Retorno= y+x// adding y to current close-open   endif   return Retorno as "Retorno",0

   

  

  JC_Bywan

  Moderator

  Topics: 20

  Replies: 2651

  Been thanked: 917 times
  12/07/2021 at 3:57 PM #182953
  briac

  Now is perfect, thank you very much, my idea was the following

  x=(close[0]*100/open[0])-100 // (close-open)% y=0 Retorno=0 if barindex>120 then for i=1 to 9 do y = x[i*12] + y // y intermediate calculation of the 9 times before (close-open) next Retorno= y+x// adding y to current close-open endif RetornoMedio = Retorno/10 //average return RetornoMedio ,0

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

  x=(close[0]*100/open[0])-100 // (close-open)% y=0 Retorno=0 if barindex>120 then for i=1 to 9 do y = x[i*12] + y // y intermediate calculation of the 9 times before (close-open) next Retorno= y+x// adding y to current close-open endif   RetornoMedio = Retorno/10 //average return RetornoMedio ,0

  An indicator that returns the average of (close-open)% of the last 10 months (for each month) to do seasonality studies for stocks.

  Thanks again

  1 user thanked author for this post.

  JC_Bywan

  

  briac

  Participant

  Topics: 3

  Replies: 3

  Been thanked: 1 time
• Author
  Posts