I was wondering if you could assist me with the creation of a formula....

I would like to scan for stocks where (4) days ago (4 bars ago including the present day)  the stock was at a high in comparison to the most recent (3) days of trading, as well as the (3) previous days prior to making the high. 

If you can help me with this, I can add other criteria on my own to elaborate the scan further.

Thanks,

Peter

Please try the following Condition Formula:

MAXH3 < H3 AND H3 > MAXH3.4

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

Is there a good formula to scan for real tight consolidation on the daily

would you be able to help with this, the formula for real tight consolidation on the daily, basically the candles got real small and tight, Thanks.

Nick

Can you confirm what MAXH3.4 means? Is that Max high for the last 3 days including the present session, and 4 more days prior?

MAXH3 is the max high of the latest 3 bars as of 4 bars ago.

Thank you!

Is anybody able to help?

Nick, do a seperate post and they will answer you specifically.

ndominique6,
One possible way to define a tight consolidation would be to check for the highest high over an arbitrary period to be less than a certain percentage above the lowest low over an arbitrary period.

For example, if you wanted to check for the total range over the most recent 10 bars being less than 1%, it would be:

MAXH10 < 1.01 * MINL10

If you want to eliminate completely flat stocks, you could check for the high and low to not be the same:

MAXH10 < 1.01 * MINL10 AND MAXH10 <> MINL10