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 |

Need help with PCF Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
OWO
Posted : Saturday, March 23, 2019 11:52:20 AM
Registered User
Joined: 5/7/2010
Posts: 14

Please help!

Looking to write PCF on how to find 

YTD% change yearly (for example how much a stock has moved from JAN till NOW MAR)

and stock price is greater than $15

and Vol is greater than 250000

2nd PCF

Stop price drop is equal or greater than 3 standard deviation of its Bollinger band.

Thank oyou

Bruce_L
Posted : Monday, March 25, 2019 10:20:51 AM


Worden Trainer

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

You can do the price greater than $15 and volume greater than 250,000 shares in a daily time frame as follows (this returns true or false and is a condition formula).

C > 15 AND V > 250000

Your YTD% Change can be written as follows (it returns a numeric value and is an indicator formula instead of a condition formula), but the time frame of this formulas needs to be yearly instead of daily (the formula is for a 1 period price percent change).

100 * (C / C1 - 1)

You can add both conditions to the same scan and set the requirements of the YTD% change as desired (or use it as a WatchList column and sort instead).

A condition formula for price being below the bottom band of simple Bollinger Bands 20, 2.00 can be written as follows.

C < BBBOT(3, 20)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
cjagresta
Posted : Sunday, March 31, 2019 5:52:44 PM
Registered User
Joined: 12/4/2006
Posts: 2

Good Evening!

Im trying to create a scan that will find bullish hammers at multi month/year lows on increasing volume. Any help would be appreciated. Thank you, Chris.

Bruce_L
Posted : Monday, April 1, 2019 12:33:17 PM


Worden Trainer

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

Are the bullish hammers in a daily time frame or a monthly or yearly time frame?



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
cjagresta
Posted : Monday, April 1, 2019 8:10:56 PM
Registered User
Joined: 12/4/2006
Posts: 2

QUOTE (Bruce_L)

Are the bullish hammers in a daily time frame or a monthly or yearly time frame?

Sorry Bruce, daily time frame. Thank you!

Bruce_L
Posted : Tuesday, April 2, 2019 11:41:46 AM


Worden Trainer

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

The basic bullish hammer requirements come from the Boolean PCFs for Candlestick Patterns topic (although I am not using the entire formula). The top if the body is within 5% of the top of the candle and constitutes 10% to 20% of the entire candle. That candle has to have a range of at least 80% of the average over the most recent 10 candles.

We are checking for the low of this candle to be the low of the most recent 23 bars (should be a bit more than a month) using the following daily condition formula.

H > L AND 20 * GREATEST(O, C) >= 19 * H + L AND H - L <= 10 * ABS(O - C) AND 5 * ABS(O - C) <= H - L AND 5 * H - L >= 4 * AVG(H - L, 10) AND L = MINL23

You would then add this to the same scan as a condition formula checking for the low of the current month to be the monthly low over multiply months (multiply the desired value by 12 if interested in years instead).

So the monthly condition formula for a 6 month low would be:

L = MINL6

And the monthly conidtion fomula for a 3 year low would be:

L = MINL36



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
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.