Find highest value

• 06/13/2021 at 7:32 AM #171673
  mats6270

  Hello,

  In ProRealCode, how can  I find the highest, the second highest, 3rd highest value etc from any given number of values?

  /Mats

  

  mats6270

  Participant

  Topics: 2

  Replies: 1

  Been thanked: 0 times
  06/13/2021 at 10:12 AM #171676
  robertogozzi

  It’s not straightforward and a bit time consuming (the more positions you want to know, the slower it is).

  This example shows how to find out the Highest, the second highest and the third highest price within the last 100 periods:

  N = 100 Max1 = highest[N](high) //Highest value // now find the second highest value Max2 = 0 FOR i = 0 TO (N - 1) IF high[i] < Max1 THEN Max2 = max(Max2,high[i]) //second highest value ENDIF NEXT // now find the third highest value Max3 = 0 FOR i = 0 TO (N - 1) IF high[i] < Max2 THEN Max3 = max(Max3,high[i]) //third highest value ENDIF NEXT . . .

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

  N = 100 Max1 = highest[N](high)                //Highest value // now find the second highest value Max2 = 0 FOR i = 0 TO (N - 1)    IF high[i] < Max1 THEN       Max2 = max(Max2,high[i])         //second highest value    ENDIF NEXT // now find the third highest value Max3 = 0 FOR i = 0 TO (N - 1)    IF high[i] < Max2 THEN       Max3 = max(Max3,high[i])         //third highest value    ENDIF NEXT . . .

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 18045

  Been thanked: 4611 times
  06/13/2021 at 10:16 AM #171677
  robertogozzi

  One of the new instructions in the pipe is rumored to be ARRAY sorting, This would make the above code useless in most cases.
  Until then… it’s better than nothing!

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 18045

  Been thanked: 4611 times
• Author
  Posts