Stock Screener (‘Sentiment’) – Example 22: Define a time frame and classify the daily % fluctuations in closing prices within that timeframe into ‘n’ distinct categories

This is an example of a (sentiment-based) scan that uses the newly introduced market aggregate functions in the Advanced Scanner that ships with ChartAlert

4 minutes

This functionality was introduced in October 2023 (Version 23.10.1)

List data from "01-Sep-2023" 

Add col MARKET_COUNT(chg%<=-4) as Chg <=-4% format 0
Add col MARKET_COUNT(chg%<0 and chg%>-4) as Chg 0 To -4% format 0

Add col MARKET_COUNT(chg%>0 and chg%<4) as Chg 0 to 4% format 0
Add col MARKET_COUNT(chg%>=4) as Chg >=4% format 0

Add Column chg%

Apply to nifty500

Set report type to SUMMARY-DATEWISE

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

Purpose of the Scan

  1. The purpose of the scan is to process a list of symbols within a specified time period and then categorize the daily percentage changes in closing prices during that time into four distinct groups:
    • “less than or equal to -4%”
    • “between 0% and -4%”
    • “between 0% and 4%”
    • “greater than 4%”
  2. The next step involves counting the number of symbols in each of these four groups and presenting this count as a raw number relative to the total number of symbols.
  3. Furthermore, we will extract and display the actual percentage changes in the closing prices for each day within the specified time frame.
  4. Ultimately, we will present the results of the scan as a summary report, organized by date. Users will also have the option to access more detailed information about the scan results.
  5. This entire process will be applied to the components of the NIFTY500 index.

Let’s go!

Line 1

List data from "01-Sep-2023"

The “List data” function allows users to access past information about symbols from a selected group or portfolio for specific dates. In this scan code, our objective is to collect data beginning from September 1, 2023 (notated as “from “01-Sep-2023””).

Lines 2 and 3

Add col MARKET_COUNT(chg%<=-4) as Chg <=-4% format 0
Add col MARKET_COUNT(chg%<0 and chg%>-4) as Chg 0 To -4% format 0

The “Add col…” function, which can also be referred to as the “Add Column…” function, is utilized to present additional information within a scan results report.

A recently introduced function in the Advanced Scanner, namely the “MARKET_COUNT()”, acts as a tool for calculating market-wide variables or parameters.

In simpler terms, it enables you to perform a scan and keep a tally of various factors across an entire market.

In this particular scan code, the initial column, named “Chg <=-4%” (the title is customizable to your preferences), will calculate and display the count of symbols where the closing prices have decreased by more than 4% (“MARKET_COUNT(chg%<=-4)”) for the current day.

The second column, named “Chg 0 To -4%” (you can adjust the title as you see fit), will calculate and display the count of symbols where the closing prices have fallen within the range of 0% to 4% (“MARKET_COUNT(chg%<0 and chg%>-4)”) for the day.

Lines 4 and 5

Add col MARKET_COUNT(chg%>0 and chg%<4) as Chg 0 to 4% format 0
Add col MARKET_COUNT(chg%>=4) as Chg >=4% format 0

In this scan code, we have two more columns. The first one titled “Chg 0 to 4%”, which you can name as you prefer, counts and shows how many symbols had their closing prices increase by 0% to 4% during the day.

The second column titled “Chg >=4%”, whose title you can also customize, counts and displays the number of symbols that had their closing prices increase by more than 4% for the day.

Line 6

Add Column chg%

Throughout the process, as described in lines 2 to 5 above, our objective has been to categorize the daily percentage change in closing prices into four specific ranges: “less than or equal to -4%”, “between 0% and -4%”, “between 0% and 4%”, and “greater than or equal to 4%”.

In line 6, the “Apply to…” function is employed to introduce an extra column that will present the exact percentage change in the day’s closing price. This additional information serves the purpose of validating the range within which a symbol falls.

Line 7

Apply to nifty500

The “Apply to…” function applies the scanning process to the “nifty500” Index, that is, the scan will effectively examine all the constituent elements of NIFTY500.

Line 8

Set report type to SUMMARY-DATEWISE

The “Set report type to…” function permits users to decide how the initial scan results will be shown.

When you opt for the “SUMMARY-DATEWISE” function, the scan results will be displayed in a compact and summarized report format. This format allows you to delve into more granular or detailed scan results if needed.

In other words, the “SUMMARY-DATEWISE” option organizes and lists the data in chronological order, starting from September 1, 2023 (notated as “from “01-Sep-2023””). This date is specified because the scan code requests that the results be listed from that particular date (see Line 1 of the scan code above).

The Scan Report in ChartAlert

%d