September 27, 2023 - ChartAlert®

Stock Screener – Example 16: 3mo Relative Performance (% change of a portfolio’s components)

This is an example of a scan that demonstrates the enhanced “relperf()” and “rank()” functions; these functions can be used to compute and compare the % change of a portfolio’s components with any Index

1–2 minutes

This functionality was introduced in October 2023 (Version 23.10.1)

Below is an illustration of an enhanced scan that can be created using the Advanced Scanner in ChartAlert.

List symbols where relperf(cl,3,m) > Symbol Value(relperf(cl,3,m),NIFTY)

Add Column cl
Add Column Symbol Value(c,nifty) as CNifty
Add Column relperf(cl,3,m) as RP
Add Col Symbol Value(relperf(cl,3,m),NIFTY) as RPNifty
Add Column rank(relperf(cl,3,m), DESCENDING) as Rank

Sort on Column Rank 

Apply to Nifty

Below is a breakdown of the scan presented in a step-by-step manner.