Hi guys

Don't know if this is easy but can i please request two pcfs that do the following:

PCF 1: Finds stocks that are between 5% to 0% away from touching the bottom of a 20 Simple moving average. Also the reverse for one approaching the top of the moving average.

PCF 2: Stocks where price is inbetween the 20 moving average and the 50 moving average. Screenshot below demonstrates the area.

Thanks!

I think for the second PCF condition, i might have found a solution just by clicking on price and selecting create scan condition. Than i defined a condition for price to be above the 20 MA and repeated the same steps for price to be below the 50 MA. 

But for the first PCF requirement, still having trouble,

At or below but within 5% of 20 period simple moving average.

.95 * AVGC20 <= C AND C <= AVGC20

At or above but within 5% of the 20 period simple moving average.

AVGC20 <= C AND C <= 1.05 * AVGC20

Between 20 and 50 period simple moving averages.

(AVGC20 <= C AND C <= AVGC50) OR {AVGC50 <= C AND C <= AVGC20)

Thanks Bruce. Will certainly make an effort to learn how to create my own pcfs. Appreciate all the support

For some reason this is returning an error when i try to compile it:

(AVGC20 <= C AND C <= AVGC50) OR (AVGC50 <= C AND C <= AVGC20)

I made a minor adjustment to the formula (the opening parenthesis to the second part of the formula). Please try the new version.

Got it working, thanks

You're welcome.

hi bruce 

can u help with pcf showing price opening at or very near sma 20. The closer the better

O / AVGC20 > .98 AND O / AVGC20 < 1.02

This will find stocks where the Open is within 2% above or below the SMA 20

Note that the SMA20 at the open may be different than the SMA20 now.

The open being within $0.01 of the current 20 period SMA would be the following.

ABS(O - AVGC20) <= .01

But the open being within $0.01 of the 20 period SMA at the open would be the following.

ABS(O - (SUM(C1, 19) + O) / 20) <= .01

If we went within 0.25% of the current SMA20.

ABS(O / AVGC20 - 1) <= .0025

But if we went within 0.25% of the SMA20 at the open.

ABS(O / ((SUM(C1, 19) + O) / 20) - 1) <= .0025

thanx bruce

.just what i was looking for

You're welcome.