what would be the correct scan formula where:

c more than 51c below c1

c less than 25c  below c1

and for above c1 also thanks. how do i add these money conditions to a scan filter or any value for that mattaer please.

Hi Bruce,  I am looking for " Pipe Bottoms "   I need it to be on a weekly basis.   After 3 or more weeks of a stock trending down    it  closes down once more @ the decline  should be unusually large/a much lower low. Then the nextweekstrading range should be very close to the previous week.  I hope this is clear  I know sometimes I have not been.  Thank You   Arnie

rbayliss40,
C more than 51 cents below C1 can be written as follows.

C < C1 - 51

C less than 25C below C1 can be writtin as follows.

C > C1 - 25

If you also want to require that C actually be below C1 then you can add this requirement as well.

C >  C1 - 25 AND C < C1

C more than 51 cents above C1 can be written as follows.

C > C1 + 51

C less than 25C above C1 can be writtin as follows.

C < C1 + 25

If you also want to require that C actually be above C1 then you can add this requirement as well.

C <  C1 + 25 AND C > C1

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

trout2,
The following Condition Formula checks for the high and low to all be lower when checking for the various bars trending down. It requires the two spikes to be more than the size of the average bar over the most recent 52 bars. It requires more than half of both spikes to be below the low prior to the spikes. It requires the two spikes to overlap each other by more than two thirds of the total range of the two spikes. 

H + H1 > 5 * ABS(H - H1) + L + L1 + 5 * ABS(L - L1) AND L2 - L > (H - L) / 2 AND L2 - L1 > (H1 - L1) / 2 AND H - L > AVGH52 - AVGL52 AND H1 - L1 > AVGH52 - AVGL52 AND H1 < H2 AND L1 < L2 AND H2 < H3 AND L2 < L3 AND H3 < H4 AND L3 < L4 AND H4 < H5 AND L4 < L5

There are no symbols in the US Common Stocks WatchList which currently meet the requirements hen using a Weekly time frame for this Condition Formula. There are 101 symbols which met the requirements at least once in the most recent year however.

You can plot the Condition Formula by using it as the Boolean Formula in a Custom PCF % True Indicator. This will allow you to see spikes on the bars where it has been true in the past to compare them visually to your expectations.

Pipe Bottoms andTops

thanks Bruce once again very helpfull

You're welcome.