Day: October 13, 2023

Stock Screener – Example 20: List all instances of a n-mo Price Performance greater than 100% in the last 5+ years

This is an example of a scan (all instances of a 100%+ return in any ‘n’-month rolling period in the last ‘m’ years) that can be written using the Advanced Scanner that ships with ChartAlert.

1–2 minutes

ATTN: This scan is similar to an earlier scan (refer to Example 19: n-month Price Performance greater than 100% in the last 5+ years), with the exception that we’re actually going to extract data in this scan.

List data from "01-Jan-2018" 
where chg%(cl, cl 2 months ago) > 100

Add Column date 2 months ago as Dt2mAgo
Add Column close 
Add Column close 2 months ago as C2mAgo

Add Column chg%(cl, cl 2 months ago) as 2moChg
Add Column SymbolValue(chg%(cl, cl 2 months ago),NIFTY) as 2moChgNifty

Apply to nifty500

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

Continue reading “Stock Screener – Example 20: List all instances of a n-mo Price Performance greater than 100% in the last 5+ years”