Get each day’s highest/lowest MACD for the past 5 days

• 02/12/2023 at 5:03 PM #209556
  Trianenn

  Hello,

  I’m looking for a way to retrieve the highest and lowest MACD values (the blue line) for each day for the past five days.

  Could anyone please help me with that?

  

  Trianenn

  Participant

  Topics: 2

  Replies: 7

  Been thanked: 1 time
  02/13/2023 at 11:31 AM #209590
  Nicolas

  There are different ways to do, so could you just define how you want to use them or display them on the chart? So I could suggest the best solution.

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  02/13/2023 at 2:00 PM #209607
  Trianenn

  I’d like to average these numbers to draw a line on the MACD indicator. The purpose is to know when there seems to be an overreaction to the upside or downside.

  

  Trianenn

  Participant

  Topics: 2

  Replies: 7

  Been thanked: 1 time
  02/13/2023 at 3:04 PM #209614
  Nicolas

  Ok and it will be used on intraday timeframes such as 15-minutes for instance?

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  02/13/2023 at 4:41 PM #209625
  Trianenn

  Yes, that’s correct!

  Does that mean the code is dependent on the graph’s timeframe and there is no way to search for data in-between given dates?

  Does the graph has to have a 5-day history for the data to be retrieved?

  

  Trianenn

  Participant

  Topics: 2

  Replies: 7

  Been thanked: 1 time
  02/13/2023 at 6:07 PM #209632
  Nicolas

  I was thinking of different manner to do it, here is the code that calculate the mean of the last “period” days of highest and lowest MACD values.

  period = 5 // --------------------------- imacd=MACD[12,26,9](close) once hh = imacd once ll = imacd if IntradayBarIndex =0 then ii=ii+1 $hh[ii]=imacd $ll[ii]=imacd endif $hh[ii]=max(imacd,$hh[ii]) $ll[ii]=min(imacd,$ll[ii]) //mean if ii>period then sum = 0 for i = ii downto ii-period do sum=sum+($hh[i]+$ll[i])/2 next mean=sum/period endif return mean//,$hh[ii],$ll[ii]

  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

  period = 5   // --------------------------- imacd=MACD[12,26,9](close)   once hh = imacd once ll = imacd   if IntradayBarIndex =0 then ii=ii+1 $hh[ii]=imacd $ll[ii]=imacd endif   $hh[ii]=max(imacd,$hh[ii]) $ll[ii]=min(imacd,$ll[ii])   //mean if ii>period then sum = 0 for i = ii downto ii-period do sum=sum+($hh[i]+$ll[i])/2 next mean=sum/period endif   return mean//,$hh[ii],$ll[ii]

  1 user thanked author for this post.

  Trianenn

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  02/14/2023 at 9:11 AM #209646
  Trianenn

  Thanks a lot Nicolas!

  I’m going to give a try and see if I can tailor it further.

  Does the graph have to extend beyond the period (5 days) to calculate the values or can they be calculated independently of the graph’s history length?

  

  Trianenn

  Participant

  Topics: 2

  Replies: 7

  Been thanked: 1 time
  02/14/2023 at 9:44 AM #209648
  GraHal

  Link to above code added as Log 353 here …

  Snippet Link Library

  1 user thanked author for this post.

  Trianenn

  

  GraHal

  Participant

  Topics: 212

  Replies: 8789

  Been thanked: 2188 times
  02/14/2023 at 10:24 AM #209651
  Nicolas

  The chart must contained the X days history visible.

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  02/14/2023 at 1:30 PM #209663
  Trianenn

  Is there no way around it?

  Can’t we parse historical data even if it’s not on the current graph?

  

  Trianenn

  Participant

  Topics: 2

  Replies: 7

  Been thanked: 1 time
  02/15/2023 at 10:52 AM #209725
  Nicolas

  No, the highest and lowest values of an indicator calculated upon a data serie must read it and therefore must be visible on the chart.

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  02/15/2023 at 2:35 PM #209764
  Trianenn

  Understood, thanks Nicolas!

  

  Trianenn

  Participant

  Topics: 2

  Replies: 7

  Been thanked: 1 time
• Author
  Posts