Day: September 21, 2023

Stock Screener – Example 13: Multiple Parameters Multiple Values; Yearly PP; Top & Bottom 20

This is an example of an optimized scan that demonstrates some enhanced functionality; it can replace the need for writing several scans (as was required in the older versions of ChartAlert)

1–2 minutes

This functionality was introduced in October 2023 (Version 23.10.1)

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

This one enhanced scan, wherein multiple parameters/ variables can now accept multiple values/ inputs, now replaces the need for writing atleast 44 separate scans as was required in the previous versions of ChartAlert.

[BEGIN Top20 Year1-Year2]
Set OptVar Year1 = Min:2001, Max:2022, Step:1
Set OptVar Year2 = Min:2002, Max:2023, Step:1

Set Var Bar1 = BARATDATE("31-Mar-Year1")
Set Var Bar2 = BARATDATE("31-Mar-Year2")

Set Var C1 = ValueAt(Bar1)
Set Var C2 = ValueAt(Bar2)

List symbols
Add Column C1
Add Column C2
Add Column Chg%(C2,C1) as chg%
Sort on Column chg% desc limit 20
Apply to Nifty
[END]


[BEGIN Bottom20 Year1-Year2]
Set OptVar Year1 = Min:2001, Max:2022, Step:1
Set OptVar Year2 = Min:2002, Max:2023, Step:1

Set Var Bar1 = BARATDATE("31-Mar-Year1")
Set Var Bar2 = BARATDATE("31-Mar-Year2")

Set Var C1 = ValueAt(Bar1)
Set Var C2 = ValueAt(Bar2)

List symbols
Add Column C1
Add Column C2
Add Column Chg%(C2,C1) as chg%
Sort on Column chg% limit 20
Apply to Nifty
[END]

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

Continue reading “Stock Screener – Example 13: Multiple Parameters Multiple Values; Yearly PP; Top & Bottom 20”