Tag: Market Aggregates

Stock Screener (‘Sentiment’) – Example 23: Define a time frame and classify daily, monthly and quarterly % fluctuations in closing prices within that timeframe into several 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

1–2 minutes

ATTN: This scan is an extension of an earlier scan (refer to Example 22: Define a time frame and classify the daily % fluctuations in closing prices within that timeframe into ‘n’ distinct categories), with the exception of extracting a few more data points in this scan.

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 col MARKET_COUNT(chg%(cl, cl a month ago) >= 25) as MChg >25% format 0
Add col MARKET_COUNT(chg%(cl, cl a month ago)<= -25) as MChg <-25% format 0

Add col MARKET_COUNT(chg%(cl, cl a month ago) >= 50) as MChg >50% format 0
Add col MARKET_COUNT(chg%(cl, cl a month ago)<= -50) as MChg <-50% format 0

Add col MARKET_COUNT(chg%(cl, cl 34 bars ago) >= 13) as 34BChg >13% format 0
Add col MARKET_COUNT(chg%(cl, cl 34 bars ago)<= -13) as 34BChg <-13% format 0

Add col MARKET_COUNT(chg%(cl, cl a quarter ago) >= 25) as QChg >25% format 0
Add col MARKET_COUNT(chg%(cl, cl a quarter ago)<= -25) as QChg <-25% format 0

Add Column chg%
Add Column chg%(cl, cl a month ago) as MChg
Add Column chg%(cl, cl 34 bars ago) as 34BChg
Add Column chg%(cl, cl a quarter ago) as QChg

Apply to niftymic250

Set report type to SUMMARY-DATEWISE

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

Continue reading “Stock Screener (‘Sentiment’) – Example 23: Define a time frame and classify daily, monthly and quarterly % fluctuations in closing prices within that timeframe into several distinct categories”

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

1–2 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.

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

Stock Screener (‘Sentiment’) – Example 21: Count and display the number and % of stocks that are currently trading above/below their respective n-bar Moving Average

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

1–2 minutes

This functionality was introduced in October 2023 (Version 23.10.1)

List symbols

Add Column Close
Add Column Volume format 0,000

Add Column IIF(cl > ema(50),1,0) as IsAbvEMA
 Group rows by IsAbvEMA

Add Column CHG%(cl,ema(50)) as Diff%
 Sort on Column Diff% desc

Add Column MARKET_COUNT(cl > ema(50)) as AbvEMA
Add Column MARKET_COUNT (cl < ema(50)) as BlwEMA
Add col MARKET_PERCENT(cl > ema(50)) as AbvEMA%
Add col MARKET_PERCENT(cl < ema(50)) as BlwEMA%

Apply to NIFTY500

plot ema(50)

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

Continue reading “Stock Screener (‘Sentiment’) – Example 21: Count and display the number and % of stocks that are currently trading above/below their respective n-bar Moving Average”