I created a PCF with your code as follows:

MAXH5 > MAXH5.5 AND MAXH5.5 > MAXH5.10 AND MAXH5.10 > MAXH5.15 AND MAXH5.15 > MAXH5.20 AND MAXH5.20 > MAXH5.25 AND MINL5 > MINL5.5 AND MINL5.5 > MINL5.10 AND MINL5.10 > MINL5.15 AND MINL5.15 > MINL5.20 AND MINL5.20 > MINL5.25 AND H < H1 AND H1 < H2 AND H2 < H3


Then I created an Easy Scan of
Russell 3000
with the PCF as a condition

Some of the results seem to be in weekly downtrends.

---------------------------------------------------

By using a your PCF to find 3 down days as follows:


H < H1 AND H1 < H2 AND H2 < H3 AND L < L1 AND L1 < L2 AND L2 < L3 AND (H3 >= H4 OR L3 >= L4) 


...I get mostly good results. But, I'd like to create an EZ scan that takes the Russell 3000 stocks and picks out only the ones with 3 consecutive down days (as the above code seems to do), and add the condition that the stocks must be above their 50-day SMA. 

PS: Is there a way to futher limit the stocks to those with an uptrending 50-day SMA or 10-day SMA?

Thanks again Bruce!

,,,For example, the other condition to add could be that the 50-day SMA is above the 200-day SMA, 
and the 20-day SMA is above the 40-day SMA 

I created this PCF for consecutive highs and when I test it reads true or false but when I use it on my chart even for DJ-30 components it reads FORMULA ERROR!!! Not enough data to calculate

When I use similar formula for consecutive lows there is no problem

{10H} ABS(C > C9 AND C > C8 AND C > C7 AND C > C6 AND C > C5 AND C > C4 AND C > C3 AND C > C2 AND C >C1)*H AND C<XAVGC200

The part of the formula requiring the most data is the XAVGC200.

Select Databank | Personal Criteria Formulas and make sure Include criteria which require more than 250 days of history (slower) is checked.

If this does not resolve the issue, please contact technical support.

That said, I am not sure what the * H thing is supposed to do this in this case. This will cause the formula to return a numeric value for the part of the formula before the AND and true or false for the portion of the formua after the end.

You probably want either:

C > MAXC9.1 AND C < XAVGC200

Or:

H > MAXH9.1 AND C < XAVGC200

I understand your response but when I test it reads true or false it just doesn't show on chart as the

{10 DAY LOW} ABS(C < C9 AND C < C8 AND C < C7 AND C < C6 AND C < C5 AND C < C4 AND C < C3 AND C < C2 AND C < C1) * L AND C > XAVGC200  

Reads True or false on tests and shows on chart 

Thank you Bruce

Even if it works (because the part before the AND is either zero or not zero), you really shouldn't write it that way.

That should either be (probably the first one if you want it to match the old version):

C < MINC9.1 AND C > XAVGC200

Or:

L < MINL9.1 AND C > XAVGC200

Okay thank you Bruce!!

You're welcome. Note I did make a change to the formulas. They had used MINC9, MAXC9, MINL9, and MAXH9, but should have used MINC9.1, MAXC9.1, MINL9.1, and MAXH9.1.