How to get the max or min of a subset?

• 02/21/2019 at 2:18 PM #91928
  thomas2004ch

  Hi,

  One can get the min or max of a dataset as myMIN = lowest[50](CLOSE). But now I want to get the min of last 30. Surely I can do this with a FOR loop. But it will be efficient when I can do as: min = lowest[last30](CLOSE).

  What I want is to get the double bottom with 50 bars. The first bottom should be inside the first 5 bars and the second should be inside the last 30 bars (from the 20th to the 50th).

  Is this possible?

  

  thomas2004ch

  Participant

  Topics: 27

  Replies: 39

  Been thanked: 1 time
  02/21/2019 at 3:58 PM #91936
  Nicolas

  Rough idea: use BARINDEX to count if the last lowest price saved in a variable is older than 30 bars or not. I let you think of it, let me now if it is not clear enough and I’ll try to code it accordingly to what I think about..

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4773 times
  02/21/2019 at 5:14 PM #91947
  robertogozzi

  Using FOR..NEXT will allow you to know on which bar that LOW happened, but if you don’t mind when it happend, this can do:

  Bottom1 = lowest[5](low) //lowest from bar 0 through bar 4 Bottom2 = lowest[30](low[21]) //lowest from bar 21 through bar 50

  1 2	Bottom1 = lowest[5](low)      //lowest from bar 0  through bar 4 Bottom2 = lowest[30](low[21]) //lowest from bar 21 through bar 50

   

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17153

  Been thanked: 4040 times
  02/22/2019 at 8:26 AM #92009
  thomas2004ch

  Many thanks!

  

  thomas2004ch

  Participant

  Topics: 27

  Replies: 39

  Been thanked: 1 time
• Author
  Posts