Hi Bruce.

I was looking to create a scan with the following conditions and wondered if you could help?

I want to find conditions where

1. The 3EMA crossed above and remained above the 8EMA 

2. Price has crossed above the 20 SMA during the past 20 days

Any help would be great!  Thanks

I am not sure if this means you just want 3 above 8 with price possibly even having crossed back down through the 20.

XAVGC3 > XAVGC8 AND CountTrue(XUP(C, AVGC20), 20) > 0

If you want 3 to have just crossed up the 8 with price above the 20 but below sometime during the previous 20 bars.

XUP(XAVGC3, XAVGC8) AND C > AVGC20 AND CountTrue(C1 < AVGC20, 20) > 0

Or some other interpretation entirely.

Thanks Bruce! Perfect.

Me again, Bruce!

Would you be able to provide the following PCF for a scan?

1. Price above the 50 SMA

2. Price within 15% of its 52 week high

3. Min earnings growth last quarter > 40%

Cheers!

Please try the following condition formula.

C > AVGC50 AND 100 * C >= 85 MAXH252

It is not possible to include fundamentals in a Personal Criteria Formula. You need to use fundamentals as WatchList Columns, sorts and EasyScan Conditions. There is no earnings growth rate last quarter fundamental available.

Morningstar Fundamental Data Definitions

ok, thanks!

Me agian :)

I am trying to replicate an IBD column for daily % volume change measured against the 50 MA of its volume.  Thanks Bruce!

I can only guess at what the calculation of that might be.

The net change in volume compared to the previous bar would be:

V - V1

And the average volume would be:

AVGV50

So the net change in volume expressed as a percentage of the average volume would be:

100 * (V - V1) / AVGV50

But if I were going to compare volume to AVGV50, I would probably not look at the change in volume, but how far volume was above or below the average volume.

100 * (V / AVGV50 - 1)

Thanks again Bruce!!

Hi Bruce!  I'm struggling with this condition signal on a chart and wondered if you could help?

I am only guessing as to the syntax used in the supplied code. We do not have a way to test if it is Monday or Tuesday, but you can limit yourself to using the formula on Monday or Tuesday.

C - C3 < C2 - C5 AND STOC4 <= 20

Thanks as always!

Hi Bruce, I know you've covered this before but I'm looking for a simple cross scan of DMI+ over the DMI - Looking for when the DMI+(14) has crossed above the DMI-(14) in the past one day. Is this possible?

If you mean between the previous bar and current bar.

XUP(DIPLUS14, DIMINUS14)

If you mean between two bars ago and one bar ago.

XUP(DIPLUS14.1, DIMINUS14.1)

If you mean either of the above and it has to stay above.

XUP(DIPLUS14, DIMINUS14, 2)

If you mean either of the first two and it can cross back down and still qualify.

CountTrue(XUP(DIPLUS14, DIMINUS14), 2) > 0 

You rock!

You're welcome.