I would like the formula for scanning:  close above 50 day smvg in the last 20 days of 15% or more

and returns down within 1% of the 50 day avg.

                                                                                               thank you

                                                                                               lloyd rausch

Please try the following Condition Formula:

ABS(C / AVGC50 - 1) <= .01 AND (C1 >= 1.15 * AVGC50.1 OR C2 >= 1.15 * AVGC50.2 OR C3 >= 1.15 * AVGC50.3 OR C4 >= 1.15 * AVGC50.4 OR C5 >= 1.15 * AVGC50.5 OR C6 >= 1.15 * AVGC50.6 OR C7 >= 1.15 * AVGC50.7 OR C8 >= 1.15 * AVGC50.8 OR C9 >= 1.15 * AVGC50.9 OR C10 >= 1.15 * AVGC50.10 OR C11 >= 1.15 * AVGC50.11 OR C12 >= 1.15 * AVGC50.12 OR C13 >= 1.15 * AVGC50.13 OR C14 >= 1.15 * AVGC50.14 OR C15 >= 1.15 * AVGC50.15 OR C16 >= 1.15 * AVGC50.16 OR C17 >= 1.15 * AVGC50.17 OR C18 >= 1.15 * AVGC50.18 OR C19 >= 1.15 * AVGC50.19 OR C20 >= 1.15 * AVGC50.20)

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

Hi Bruce, How are you doing?  I have a short and quick question to ask you.  Before I proceed, I just want to let you know that I have searched the forum for an answer (in case it has already been discussed) but to no avail.  Your presence here in Worden has been so helpful that I wouldn't want to take up your time unnecessarily.   Can you help to write the command for low close doji and high close doji? Thanks.

I'm not a candlestick guy (at all). That said, my best guess would be that a Low Close Doji is a Gravestone Doji or Inverted Hammer and that a High Close Doji is a Dragonfly Doji or Hammer. The Boolean PCFs for Candlestick Patterns topic contains a fairly extensive (although clearly not exhaustive) list of Condition Formulas for candlestick patterns.

If my guesses are incorrect, further clarification from you as to what constitutes a Low Close Doji and High Close Doji would be required in order for me to help you create the Condition Formulas.

Where would I find the 5 formulas discussed in last nites tutorial video??

Here are the formulas discussed during last night's webinar:

Engulfing - Bullish
O1 > C1 AND C - O >= .7 * (H - L) AND C > O1 AND O < C1 AND H - L >= 1.2 * (AVGH10 - AVGL10)

Piercing - Bullish
O1 > C1 AND H1 - L1 >= AVGH10.1 - AVGL10.1 AND O < C1 AND C > C1 + .5 * (O1 - C1) AND C < O1

Three Inside Up (aka Confirmed Bullish Harami) - Bullish
O2 - C2 >= .7 * (H2 - L2) AND H2 - L2 >= AVGH10.2 - AVGL10.2 AND C1 > O1 AND O1 > C2 AND C1 < O2 AND C1 - O1 <= .6 * (O2 - C2) AND O > O1 AND O < C1 AND C > C1 AND C - O >= .7 * (H - L)

Hammer - Bullish
ABS(C - O) <= .2 * (H - L) AND ABS(O - C) >= .1 * (H - L) AND O - L >= .5 * (H - L) AND C - L >= .5 * (H - L) AND H - O <= .05 * (H - L) OR (H - C) <= .05 * (H - L) AND H - L >= .8 * (AVGH10 - AVGL10) AND L = MINL5 AND H > L

Morning Star - Bullish
O2 - C2 >= .7 * (H2 - L2) AND H2 - L2 >= AVGH10.2 - AVGL10.2 AND C1 < C2 AND O1 < C2 AND H - L >= AVGH10 - AVGL10 AND C - O >= .7 * (H - L) AND O > C1 AND O > O1

If it is a strict dojji where the open and close must be exactly equal, then a High Close Doji would be:

C > H1 AND O1 = C1

And a Low Close Doji would be:

C < L1 AND O1 = C1

If near doji's also count, then you would need to define how close the open and close need to be. Let's say the body needs to be less than or equal to 10% of the entire candle (or exactly equal if the high and the low are the same). Then a High Close Doji would be:

C > H1 AND ABS(O1 - C1) <= .1 * (H1 - L1)

And a Low Close Doji would be:

C < L1 AND ABS(O1 - C1) <= .1 * (H1 - L1)

Thanks Bruce!

Hi Bruce,I have another anateurish PCF question : I would like to sort my favourite list accordance to its "Stochastics RSI 9,9 %K1" and/or "MACD 2,6" reading.  Can you help? Best regards.

In TC2000 version 12.3 you can right click on the name of the plot, then click Sort By.

The stochastic line has two plots. One is the Period and %K, the second plot is %D. 

Thanks Stock Guy.  What is the PCF formula for "Stochastics RSI 9,9 %K1"?  I tried this :

(RSI9.9 - MIN(RSI19.9,2))/(MAX(RSI9.9,2) - MIN(RSI9.9,2))*100

, but it doesn't seem to display the same chart as the one produced by the TC2000's standard Stochastic RSI chart (with same periods).  Can you also assist with PCF formula for "MACD2,6"?  Hope you could help, I'm very confused at the moment but hope to learn the logic of the formula for future PCFs.  Regards.

I answered this question in the other topic you posted in: Stochrsi