to make a watchlist column to find stocks that have closed below the 5SMA each day for the last 5 days. Thank you.

Doing this using a single formula could be done as:

C < AVGC5 AND C1 < AVGC5.1 AND C2 < AVGC5.2 AND C3 < AVGC5.3 AND C4 < AVGC5.4

There is a way to do this which allows you to easily adjust the number of days however.

Select Add Plot to Chart (the green + in the upper left of the chart) and choose Custom PCF % True Indicator from the list. You can start typing Custom PCF % True Indicator in the Search box after selecting Add Plot to Chart to quickly bring it to the top of the list to make it easier to find and select.

Adding and Moving Indicators (7:19)

Then click on the Custom PCF % True Indicator and select Edit so you can use the following settings:

- Period: 5
- Average Type: Simple
- Boolean Formula: C < AVGC5

You can then click on the Custom PCF % True Indicator and select Create Scan Condition to create a condition for the Custom PCF % True Indicator being greater than 99.99. This will be true if and only if the Boolean Formula was true for all of the bars during the period.

Create Conditions from Your Chart (5:25)

The nice thing about this is that you can change the period setting from 5 to something else and then use Create Scan Condition again to easily check for a different number of bars.