Hi

I have just run scan using following formula

(MAXH60 - MINL60) / (AVGH60 - AVGL60) * 100 and

AVGC30 / AVGC30.30

as per formula on video posted 7th Jan 2005 in your discussion forum and it came with all 5,800 odd stocks in US common stocks

The video said to give

(MAXH60 - MINL60) / (AVGH60 - AVGL60) * 100

a ranking of 50 or less to identiy consolidating stocks so I tried the following

(MAXH60 - MINL60) / (AVGH60 - AVGL60) * 100 =< 50 and

AVGC30 / AVGC30.30

but the scan came up with no results

I have not included the other 2 formulas on video for indicator etc as i am trying to get some results from initial scan

Any help please as to what I have done wrong or is this dormula outdated due to upgrades with platform

Thanks Jeff

The Trend/Consolidate 60 days Indicator Formula:

(MAXH60 - MINL60) / (AVGH60 - AVGL60) * 100

And the 60 Day Directional Move Indicator Formula:

AVGC30 / AVGC30.30

Should not be combined into a single formula. Nor should you probably be checking for the numeric value of the Trend/Consolidate 60 days Indicator Formula.

The video suggests using the formula as an EasyScan Condition with the EasyScan Rangefinder set to check for a Rank between 0 and 50. This will eliminate the approximately half of the available symbols with the highest values for the formula.

Scan for stocks bouncing in a lateral channel

It is not possible to check for the rank of a PCF using only the Personal Criteria Formula Language.

We are checking for the value of the 60 Day Directional Move Indicator Formula. So if you would rather create a Condition Formula which checks for the value to between .8 and 1.2 instead of setting these values in the EasyScan, you can certainly do so:

.8 <= AVGC30 / AVGC30.30 AND AVGC30 / AVGC30.30 <= 1.2

Or the slightly shorter:

ABS(AVGC30 / AVGC30.30 - 1) <= .2

PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!