RRC Stock Screener – Example 6: Use a timing condition to filter symbols present in a particular quadrant

Sectoral Rotation, or Relative Rotational charts, are a powerful visual tool in assessing how different sectors compare in terms of their relative strength and momentum; it’s easier to spot stronger and weaker sectors, thus highlighting possible changes in market leadership and trends in asset performance

8 minutes

This functionality, pertaining to Relative Rotational Charts (RRC), was introduced in October 2023.


RRC Scan Example #6:
Look for stocks that are currently present in a particular quadrant, and for how long they have been present there, by checking for a specific timing condition and then filtering the results

List symbols where 
pattern is RRC Q2
AND barssince(pattern is RRCQ1toQ2) > barssince(pattern is RRCQ3toQ2)

Add column barssince(pattern is RRCQ1toQ2) as BS1
Add column barssince(pattern is RRCQ3toQ2) as BS2

Add Column RSRATIO as RSR
Add Column RSMOMENTUM as RSM
Add Column RRCSTATUS as Status
Add Column RRCSTATUS a bar ago as PvsStatus
Add Column RRCQUADRANT as Quad chart
Add Column RRCQUADRANT a bar ago as QuadYest chart

Apply to NIFTYTOTAL

Purpose of the Scan

The purpose of this scan code is to look for NIFTYTOTAL component stocks that are currently present in a particular quadrant (“RRC Q2”), and for how long they have been present in that quadrant.

This will be done by checking for a specific timing condition (BS1 > BS2) and then filtering the results.

One of the timing condition (“BS1”) looks for how long ago did a symbol move from quadrant Q1 to Q2, and the other timing condition (“BS2”) looks for how long ago did a symbol move from quadrant Q3 to Q2.

It will also display the number of bars since the occurrence of two different events (“RRCQ1toQ2” and “RRCQ3toQ2”) for those qualifying stocks.



Lines 1 through 3

List symbols where 
pattern is RRC Q2
AND barssince(pattern is RRCQ1toQ2) > barssince(pattern is RRCQ3toQ2)

The “List symbols where …” function establishes a condition that stocks must meet in order to be included in the scan results.

The “pattern is RRC Q2” function looks for symbols that are presently residing in the RRC Q2 quadrant. Please note that the Q2 quadrant is where leaders or stocks outperforming the underlying benchmark (say, NIFTY) reside.

The “pattern is RRCQ1toQ2” function looks for *when* the stocks newly moved into the RRC Q2 quadrant from the Q1 quadrant (Improving Relative Strength), while the “pattern is RRCQ3toQ2” function looks for *when* the stocks newly moved into the RRC Q2 quadrant from the Q3 quadrant (Weakening Relative Momentum).

The “barssince(pattern is RRCQ1toQ2)” function computes the number of bars (time elapsed) since the event “pattern is RRCQ1toQ2”, and the “barssince(pattern is RRCQ3toQ2)” function computes the number of bars since the event “pattern is RRCQ3toQ2”.

Then, the scan code will compare the number of bars (a unit of time in trading) since the “RRCQ1toQ2” pattern occurred to the number of bars since the “RRCQ3toQ2” pattern occurred, and will only consider those stocks where the number of bars since “RRCQ1toQ2” is greater than the number of bars since “RRCQ3toQ2.”


Lines 4 and 5

Add column barssince(pattern is RRCQ1toQ2) as BS1
Add column barssince(pattern is RRCQ3toQ2) as BS2

The scan will create a new column (“Add Column“) called “BS1” in the scan results table. It will show the number of bars since the “RRCQ1toQ2” event occurred for each stock that meets the criteria.

Similarly to the previous step, the scan will create another new column called “BS2” in the scan results table. It will display the number of bars since the “RRCQ3toQ2” event occurred for each qualifying stock.

The column titles “BS1” and “BS2″can be modified or personalized to your preference.


Line 6

Add Column RSRATIO as RSR

This line instructs the scan to create a column (“Add Column“) called “RSR” and list the values of the “RSRATIO” function into it. This is done to make it easier to work with the RSRATIO data.

The column title “RSR” can be modified or personalized to your preference.


Line 7

Add Column RSMOMENTUM as RSM

Similarly, this line creates a column (“Add Column“) called “RSM” and copies the values of the “RSMOMENTUM” function into it. Again, it’s for convenience and analysis.

The column title “RSM” can be modified or personalized to your preference.



Line 8

Add Column RRCSTATUS as Status

Here, a new column called “Status” is added (“Add Column“), and it contains information related to the stocks’ status or condition (“RRCSTATUS“) in the context of a Relative Rotational chart’s (RRC) scatter plot.

The column title “Status” can be modified or personalized to your preference.


Line 9

Add Column RRCSTATUS a bar ago as PvsStatus

This line creates another column (“Add Column“) called “PvsStatus” and lists values of the “RRCSTATUS” function from one bar ago (“a bar ago“) into it. It helps in comparing the current status with its previous status.

The column title “PvsStatus” can be modified or personalized to your preference.


Line 10

Add Column RRCQUADRANT as Quad chart

A new column named “Quad” is created (“Add Column“), and it contains information related to the stocks’ status or condition (“RRCQUADRANT“).

The “RRCQUADRANT” function helps us figure out which quadrant a symbol falls into on the Relative Rotational chart (RRC), and it gives us one of the labels like “Q2” (which is the same as LEADERS) or “Q4” (which is the same as LAGGARDS) to describe its position.

The function “chart” allows the RS-RATIO and RS-MOMENTUM indicators to be plotted an the chart should you open a symbol’s chart from within the scan results report.

The column title “Quad” can be modified or personalized to your preference.


Line 11

Add Column RRCQUADRANT a bar ago as QuadYest chart

This one creates a column (“Add Column“) called “QuadYest” and displays values of the “RRCQUADRANT” function from one bar ago (“a bar ago“) into it. This allows for comparisons between the current quadrant and the one from the previous bar.

The function “chart” allows the RS-RATIO and RS-MOMENTUM indicators to be plotted an the chart should you open a symbol’s chart from within the scan results report.

The column title “QuadYest” can be modified or personalized to your preference.


Line 12

Apply to NIFTYTOTAL

Finally, the “Apply to …” function specifies the scan to be applied to a specific group of stocks that make up the “NIFTYTOTAL” Index.


The Scan Report in ChartAlert

%d