Please help

I am looking to scan for this condition:

CCI > 160 or

CCI  lower than -160  in any of the last 5 days. 

I am looking for stocks that have had overbought or oversold reading recently to reivew .

Please suggest a way to achieve this. 

Thanks,

Randy

What is the period of you CCI?

CCI INDICATOR

I will use the default in TC2000.

Create a Custom PCF % True Indicator using the following Boolean Formula:

ABS(H + L + C - AVGH14 - AVGL14 - AVGC14) * 2800 / 3 / (ABS(H + L + C - AVGH14 - AVGL14 - AVGC14) + ABS(H1 + L1 + C1 - AVGH14 - AVGL14 - AVGC14) + ABS(H2 + L2 + C2 - AVGH14 - AVGL14 - AVGC14) + ABS(H3 + L3 + C3 - AVGH14 - AVGL14 - AVGC14) + ABS(H4 + L4 + C4 - AVGH14 - AVGL14 - AVGC14) + ABS(H5 + L5 + C5 - AVGH14 - AVGL14 - AVGC14) + ABS(H6 + L6 + C6 - AVGH14 - AVGL14 - AVGC14) + ABS(H7 + L7 + C7 - AVGH14 - AVGL14 - AVGC14) + ABS(H8 + L8 + C8 - AVGH14 - AVGL14 - AVGC14) + ABS(H9 + L9 + C9 - AVGH14 - AVGL14 - AVGC14) + ABS(H10 + L10 + C10 - AVGH14 - AVGL14 - AVGC14) + ABS(H11 + L11 + C11 - AVGH14 - AVGL14 - AVGC14) + ABS(H12 + L12 + C12 - AVGH14 - AVGL14 - AVGC14) + ABS(H13 + L13 + C13 - AVGH14 - AVGL14 - AVGC14) + .000001) > 160

Then set the Period of the Custom PCF % True Indicator to 5 and the Average Type to Simple. We now have an indicator which will be above zero when a 14-Period CCI as greater than 160 or less than -160 during the most recent 5-bars.

This allows us to click on the Custom PCF % True Indicator and select Create Scan Condition to create a Condition for Greater Than 0 that should return true when your requirements are met.

Create Conditions from Your Chart