Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

easy scan formula Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
lloydrau
Posted : Tuesday, July 16, 2013 5:48:59 PM
Registered User
Joined: 7/15/2010
Posts: 5

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

Bruce_L
Posted : Wednesday, July 17, 2013 8:17:06 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

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!



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
tbf
Posted : Wednesday, July 17, 2013 8:23:35 AM
Registered User
Joined: 7/7/2013
Posts: 10

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.

Bruce_L
Posted : Wednesday, July 17, 2013 8:31:01 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

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.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
andisboy
Posted : Wednesday, July 17, 2013 9:19:02 AM
Registered User
Joined: 5/23/2012
Posts: 2

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

Bruce_L
Posted : Wednesday, July 17, 2013 9:56:41 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
tbf
Posted : Wednesday, July 17, 2013 9:59:01 AM
Registered User
Joined: 7/7/2013
Posts: 10

QUOTE (Bruce_L)

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.

  High Close Doji = a doji followed by a candle which closes above the high the doji.  Low Close Doji = doji followed by a candle which closes below the low of the doji.  Thanks Bruce.

Bruce_L
Posted : Wednesday, July 17, 2013 10:08:01 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

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)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
tbf
Posted : Wednesday, July 17, 2013 11:20:02 AM
Registered User
Joined: 7/7/2013
Posts: 10

Thanks Bruce!

tbf
Posted : Wednesday, July 31, 2013 11:36:26 AM
Registered User
Joined: 7/7/2013
Posts: 10

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.

StockGuy
Posted : Thursday, August 1, 2013 10:48:47 AM

Administration

Joined: 9/30/2004
Posts: 9,187

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. 

tbf
Posted : Friday, August 2, 2013 9:25:41 AM
Registered User
Joined: 7/7/2013
Posts: 10

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.

StockGuy
Posted : Friday, August 2, 2013 11:53:46 AM

Administration

Joined: 9/30/2004
Posts: 9,187

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

Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.