I am looking for a PCF that will allow me to scan stocks in my watch list and tells me if any of those stocks have gapped 15% or higher in the past 90 days.  I am thinking it must have a series of something similar to:

((C-C1)/C1*100) OR ((C1-C2)/C2*100) OR ((C2-C3)/C2*100)......((C89-C90)/C90*100)

Technically, if it is true that there has been a gap up in the past 90 days I want a column in my watch list to tell me (with a checkmark for example) so I know to ignore that stock for now.

Suggestions on how to do this?

Thanks in advance

Probably the best way to do this would be to use the technique outlined on the following webpage.

Condition True at Least Once Over x Bars

This allows you to create a single formula checking for your gap up happening on just one bar and use it in a Custom PCF % True Indicator with the Period set to 90 to check for it happening at least once over those 90 bars.

Your example formula appears to be for a price percent change from one bar to the next. The one bar version of this can be written as follows.

ABS(C / C1 - 1) >= .15

If however you wanted a gap from the close to the open, it could be written as follows instead.

ABS(O / C1 - 1) >= .15

Thanks Bruce - I will give that a try.  Looks like it is exactly what I need.

Hi Bruce - I am having brain trouble here ;)

If I wanted to also flag the stocks that have had a gap down 15% or greater in the past 90 days how should I write the formula?  I tried a couple of things but my math inhibited brain isn't let me succeed!  Thanks in advance.

The Condition Formula as written checks for 15% changes in either direction (thats what the ABS() part is for).

If you just wanted to check for moving up it would be either the following using the closes.

C >= 1.15 * C1

Or the following checking for a gap on open.

O >= 1.15 * C1

With the following being a 15% move down based on the closes.

C <= .85 * C1

And the following checking for a gop down on open.

O <= .85 * C1

Thanks Bruce - that makes sense.  I was looking at the charts wrong last night.  Appreciate your help, once again!

You're welcome.