Hello,

I am having trouble building an easy scan for a Pullback Scan, using the RSI 2 Period, and other defined parameters, including  Average Volume, Historical Volatility, ADX and the all important N-1, in the last trading days, closing price. Below is the "formula" in its complete form, with all the values shown.

I am not specifically looking for a PCF, but would probably need one for the close for trading days, as per N-1, as well as the X%, for the percentage of price below the previous days close.

 1. The stock price must be above $5 per share and close above its 200‐day simple moving average. 

The only requirements which would seem to absolutely require creating formulas of any sort are 3, 5 and 6.

And 3 is because there isn't a built in indicator for Historical Volatility. You can create a Custom PCF Indicator for a 100-period Historical Volatility by using the following Indicator Formula as the Formula in a Custom PCF Indicator. You can add a Custom PCF Indicator to the chart by choosing Add Plot to Chart (the green + in the upper left of the chart) and choosing Custom PCF Indicator from the list.

Adding and Moving Indicators
Historical Volatility (HV)

1600*SQR((LOG(C/C1)^2 +LOG(C1/C2)^2 +LOG(C2/C3)^2 +LOG(C3/C4)^2 +LOG(C4/C5)^2 +LOG(C5/C6)^2 +LOG(C6/C7)^2 +LOG(C7/C8)^2 +LOG(C8/C9)^2 +LOG(C9/C10)^2 +LOG(C10/C11)^2 +LOG(C11/C12)^2 +LOG(C12/C13)^2 +LOG(C13/C14)^2 +LOG(C14/C15)^2 +LOG(C15/C16)^2 +LOG(C16/C17)^2 +LOG(C17/C18)^2 +LOG(C18/C19)^2 +LOG(C19/C20)^2 +LOG(C20/C21)^2 +LOG(C21/C22)^2 +LOG(C22/C23)^2 +LOG(C23/C24)^2 +LOG(C24/C25)^2 +LOG(C25/C26)^2 +LOG(C26/C27)^2 +LOG(C27/C28)^2 +LOG(C28/C29)^2 +LOG(C29/C30)^2 +LOG(C30/C31)^2 +LOG(C31/C32)^2 +LOG(C32/C33)^2 +LOG(C33/C34)^2 +LOG(C34/C35)^2 +LOG(C35/C36)^2 +LOG(C36/C37)^2 +LOG(C37/C38)^2 +LOG(C38/C39)^2 +LOG(C39/C40)^2 +LOG(C40/C41)^2 +LOG(C41/C42)^2 +LOG(C42/C43)^2 +LOG(C43/C44)^2 +LOG(C44/C45)^2 +LOG(C45/C46)^2 +LOG(C46/C47)^2 +LOG(C47/C48)^2 +LOG(C48/C49)^2 +LOG(C49/C50)^2 +LOG(C50/C51)^2 +LOG(C51/C52)^2 +LOG(C52/C53)^2 +LOG(C53/C54)^2 +LOG(C54/C55)^2 +LOG(C55/C56)^2 +LOG(C56/C57)^2 +LOG(C57/C58)^2 +LOG(C58/C59)^2 +LOG(C59/C60)^2 +LOG(C60/C61)^2 +LOG(C61/C62)^2 +LOG(C62/C63)^2 +LOG(C63/C64)^2 +LOG(C64/C65)^2 +LOG(C65/C66)^2 +LOG(C66/C67)^2 +LOG(C67/C68)^2 +LOG(C68/C69)^2 +LOG(C69/C70)^2 +LOG(C70/C71)^2 +LOG(C71/C72)^2 +LOG(C72/C73)^2 +LOG(C73/C74)^2 +LOG(C74/C75)^2 +LOG(C75/C76)^2 +LOG(C76/C77)^2 +LOG(C77/C78)^2 +LOG(C78/C79)^2 +LOG(C79/C80)^2 +LOG(C80/C81)^2 +LOG(C81/C82)^2 +LOG(C82/C83)^2 +LOG(C83/C84)^2 +LOG(C84/C85)^2 +LOG(C85/C86)^2 +LOG(C86/C87)^2 +LOG(C87/C88)^2 +LOG(C88/C89)^2 +LOG(C89/C90)^2 +LOG(C90/C91)^2 +LOG(C91/C92)^2 +LOG(C92/C93)^2 +LOG(C93/C94)^2 +LOG(C94/C95)^2 +LOG(C95/C96)^2 +LOG(C96/C97)^2 +LOG(C97/C98)^2 +LOG(C98/C99)^2 +LOG(C99/C100)^2-(LOG(C/C100)^2)/100)/100)

A Condition Formula for being down at least 3 of the most recent 4 bars can be written as:

ABS(C < C1) - (C1 < C2) - (C2 < C3) - (C3 < C4) >= 3

A Condition Formula for being down at least 4 of the most recent 5 bars can be written as:

ABS(C < C1) - (C1 < C2) - (C2 < C3) - (C3 < C4) - (C4 < C5) >= 4

A Condition Formula for being down at least 5 of the most recent 6 bars can be written as:

ABS(C < C1) - (C1 < C2) - (C2 < C3) - (C3 < C4) - (C4 < C5) - (C5 < C6) >= 5

A Condition Formula for the low of the current bar being at least 3% below the previous close can be written as:

L <= .97 * C1

A Condition Formula for the low of the current bar being at least 4% below the previous close can be written as:

L <= .96 * C1

A Condition Formula for the low of the current bar being at least 5% below the previous close can be written as:

L <= .95 * C1

A Condition Formula for the low of the curretn bar being at least 6% below the previous close can be written as:

L <= .94 * C1

All of the other Conditions can be created by adding indicators to the chart and selecting Create Scan Condition to create the desired condition.

Create Conditions from Your Chart

You can click on Price History on the chart and select Create Scan Condition to create a condition for Price History being Greater Than 5.

You can add a 200-period simple moving average to the chart and click on Price History to select Create Scan Condition for a condition for price being above the 200-period simple moving average.

You can add a Volume to the chart with a 21-period simple moving average and then click on the 21-period simple moving average of volume to select Create Scan Condition for that moving average being Greater Than 250000.

You can click on the Historical Volatility Custom PCF Indicator from above and select Create Scan Condition to check for the Custom PCF Indicator being Greater Than 30.

You can add a 10-period ADX indicator to the chart and click on it to select Create Scan Condition to create a condition for ADX being greater than 30.

You can add a 2-period RSI indicator to the chart and click on it to select Create Scan Condition to create a condition for the RSI being less then 5 (or 10, 15 or 20 if desired instead).

Once you have created all of the conditions, you would add them to the same EasyScan.

Building a Scan with Multiple Conditions

TC2000 doesn't actually have any backtesting capabilities, so the actual buy would be up to you. Condition Formulas checking for the low being a certain percentage below the previous close was covered above.

Wow, this is great Bruce.

I really do appreciate it, I will build the scan and report back.

Thanks again for pointing me in the right direction.

Thank you & All the best

David

pcf for 5 day trend vs market  thx .nd

It is not possible to create the 5 Day Price Trend vss Market as a Personal Criteria Formula.

5 Day Price Trend vss Market is one of the built in Morningstar fundamental criteria however, so you can plot it on the chart, use it as a WatchList Column or use it as an EasyScan Condition.

Price Trend vs Market
Morningstar Fundamentals
Historical Fundamentals
Sorting with Pre-Built Columns (3:30)
Building a Scan with Multiple Conditions (7:29)