Hi Bruce,

Can you create a PCF for the following

1. Price opening below 50 MA and then closing above 50 MA with the close also being above the 8 EMA.

2.Can we also add a condition that the stockastics crossing from the oversold area.

3. Previous day close was a doji.

Regards,

MK

Pleaes try the following condition formula. It assumes the 50 MA is simple, a doji requires the body to be 5% of the candle or less, and that you are interested in the simple stochastic 12,3 %K crossing up through 20.

20 * ABS(O1 - C1) <= H1 - L1 AND XUP(STOC12.3, 20) AND C > AVGC50 AND AVGV50 > O AND C > XAVGC8

Your formula has significant enough changes that it is not functionally the same thing. There is a space between XUP and its opening parenthesis which should not be there. O (which is for Open in this case) got changed to OR when it needs to remain unchanged.

That said, the formula is pretty restrictive and would not have returned any results in a daily time frame when scanning the US Common Stocks WatchList.

Let's break it down into 3 sections.

A - Yesterday was a Doji.

20 * ABS(O1 - C1) <= H1 - L1

B - Stochastics crossed up from oversold.

XUP(STOC12.3, 20)

C - Price opened below but closed above SMA50 and is also above EMA8.

C > AVGC50 AND AVGV50 > O AND C > XAVGC8

A was true for 704 symbols.

B was true for 514 symbols.

C was true for 998 symbols.

But A and B only had 48 symbols in common.

A and C only had 116 symbols in common.

B and C only had 56 symbols in common.

And A, B, and C had no symbols in common.

Each requirement on its own isn't a problem, but the combination is was too restrictive to return any symbols from the US Common Stocks WatchList using yesterday's daily data.

Thank you Bruce, appreciate it.

Regards,

MK

You're welcome.