Radiscreen can RANK.

Define {rankPefDvMo2018}
Uses [Price Change 26 week] [DolVol] [Country] [ADR/ADS Stock] [Price as % of 52 Week High] [PE-Forward EPS Est Y1]
Deblank [Price Change 26 week] [DolVol] [Country] [ADR/ADS Stock] [Price as % of 52 Week High] [PE-Forward EPS Est Y1]
Keep :[Price as % of 52 Week High]>88
Keep :[PE-Forward EPS Est Y1]>3
Keep :[Country]="USA"
Keep :[ADR/ADS Stock]="F"
Create [r1] :RANK([DolVol],[[DolVol]])
Create [r2] :RANK([Price Change 26 week],[[Price Change 26 week]])
Create [r3] :RANK([PE-Forward EPS Est Y1],[[PE-Forward EPS Est Y1]])
Create [rAll] :[r1]-[r2]+[r3]
FinalSort Descending [rAll]
End

"Since Radiscreen runs off excel spreadsheets, you can use a range of in-built excel functions, PERCENTRANK is one, and RANK is another. NB the RANK function reverses the parameters, so you have lines that look like:
Create [RkEE] :Rank([EBITDAtoEV],[[EBITDAtoEV]])
and then you can sort, filter etc on these custom columns."
http://www.datahelper.com/mi/search.phtml?nofool=y...

Mechanical Investing FAQ

---

Contact Shrewd'm
Contact the developer of these message boards.