RealTest User Guide
RealTest User Guide

 

 

Navigation: RealTest Script Language > Syntax Element Details >

#PercentRankN

 

 

 

 

Category

Cross-Sectional Functions

Description

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.

 

 

 

Copyright © 2020-2026 Systematic Solutions, LLC