# RRC Stock Screener – Example 10: Transitioning from Q1 to Q2 in the last ‘n’ bars

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

5 minutes

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

## RRC Scan Example #10: Symbols transitioning from quadrant Q1 (improving relative strength) to quadrant Q2 (leaders or outperformers) within the last three bars of data

``````List symbols where
pattern is RRCQ1 3 bars ago
AND pattern is RRCQ2

Add Column RRCSTATUS a bar ago as PvsStatus

Apply to NIFTYTOTAL``````

#### Purpose of the Scan

The purpose of this scan is to create a list of stock symbols (comprising the NIFTYTOTAL Index) that were in a quadrant called “RRCQ1” (“pattern is RRCQ1”) three time periods ago (“3 bars ago”), and at the same time, they are currently in a quadrant known as “RRCQ2” (“AND pattern is RRCQ2”).

To put it simply, this scan is designed to identify symbols that have transitioned from quadrant Q1 (indicating improving relative strength) to quadrant Q2 (indicating leaders or outperformers) at any point within the last three bars of data.

#### Lines 1 through 3

``````List symbols where
pattern is RRCQ1 3 bars ago
AND pattern is RRCQ2``````

This first line tells the scan code to create a list of stock symbols (“List symbols where …“) that meet certain conditions.

The function “pattern is RRCQ1 3 bars ago” implies that we’re looking for symbols that were in the quadrant Q1 (“RRCQ1“) three time periods (or bars) ago (“3 bars ago“).

In addition to the first condition (“AND“), we also want the symbols to currently be residing in quadrant Q2 (“pattern is RRCQ2“).

#### Line 3

``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 4

``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 5

``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 6

``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 7

``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 8

``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 9

``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.