For each date, evaluates a formula for each symbol, calculates the percent rank of each symbol's value among all symbols on that date, determines which symbol has the specified percentile, and stores that symbol's formula value in the data array for every symbol.
Syntax
#PercentRankN(pctl)formula
Parameters
pctl - rank percentile (cannot be an expression or formula)
Notes
The pctl argument is a percent rank from 0 (lowest value) to 100 (highest value): #PercentRankN(0) returns the lowest value and #PercentRankN(100) the highest.
Example
PriceWith50thPctlToday: #PercentRankN(50) Close
Notes
If the formula result is nan (not a number -- unable to calculate)then that stock is not included in the ranking list (reducing the total count). The selected percentile value is still stored for every symbol, so its stored result is not nan.