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 |

Help with a pcf Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Rich_Idiot
Posted : Tuesday, May 29, 2012 10:25:03 PM
Registered User
Joined: 1/6/2012
Posts: 11

1. The stock must be above $5 per share and close above its 200‐day simple moving
average.

2. The stock's average daily volume over the past 21 days (one trading month) must be
at least 250,000 shares per day.

3. The stock's 100 day historical volatility is above 30.

4. The stock's 10 day Average Directional Index (ADX) is above 30.

5. The stock has closed down 2 or more days in a row.

6. Today the stock must close at least X% (X= 4%, 5%, or 6%) below its Y‐period moving
average (Y = 4, 5, or 6).

Bruce_L
Posted : Wednesday, May 30, 2012 7:41:43 AM


Worden Trainer

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

QUOTE (Rich_Idiot)
1. The stock must be above $5 per share and close above its 200‐day simple moving average.

2. The stock’s average daily volume over the past 21 days (one trading month) must be at least 250,000 shares per day.

3. The stock’s 100 day historical volatility is above 30.

5. The stock has closed down 2 or more days in a row.

Please try the following Condition Formula:

C > 5 AND C > AVGC200 AND AVGV21 >= 250000 AND 1600 * SQR((LOG(C / C1) ^ 2 + LOG(C1 / C2) ^ 2 + LOG(C2 / C3) ^ 2 + LOG(C3 / C4) ^ 2 + LOG(C4 / C5) ^ 2 + LOG(C5 / C6) ^ 2 + LOG(C6 / C7) ^ 2 + LOG(C7 / C8) ^ 2 + LOG(C8 / C9) ^ 2 + LOG(C9 / C10) ^ 2 + LOG(C10 / C11) ^ 2 + LOG(C11 / C12) ^ 2 + LOG(C12 / C13) ^ 2 + LOG(C13 / C14) ^ 2 + LOG(C14 / C15) ^ 2 + LOG(C15 / C16) ^ 2 + LOG(C16 / C17) ^ 2 + LOG(C17 / C18) ^ 2 + LOG(C18 / C19) ^ 2 + LOG(C19 / C20) ^ 2 + LOG(C20 / C21) ^ 2 + LOG(C21 / C22) ^ 2 + LOG(C22 / C23) ^ 2 + LOG(C23 / C24) ^ 2 + LOG(C24 / C25) ^ 2 + LOG(C25 / C26) ^ 2 + LOG(C26 / C27) ^ 2 + LOG(C27 / C28) ^ 2 + LOG(C28 / C29) ^ 2 + LOG(C29 / C30) ^ 2 + LOG(C30 / C31) ^ 2 + LOG(C31 / C32) ^ 2 + LOG(C32 / C33) ^ 2 + LOG(C33 / C34) ^ 2 + LOG(C34 / C35) ^ 2 + LOG(C35 / C36) ^ 2 + LOG(C36 / C37) ^ 2 + LOG(C37 / C38) ^ 2 + LOG(C38 / C39) ^ 2 + LOG(C39 / C40) ^ 2 + LOG(C40 / C41) ^ 2 + LOG(C41 / C42) ^ 2 + LOG(C42 / C43) ^ 2 + LOG(C43 / C44) ^ 2 + LOG(C44 / C45) ^ 2 + LOG(C45 / C46) ^ 2 + LOG(C46 / C47) ^ 2 + LOG(C47 / C48) ^ 2 + LOG(C48 / C49) ^ 2 + LOG(C49 / C50) ^ 2 + LOG(C50 / C51) ^ 2 + LOG(C51 / C52) ^ 2 + LOG(C52 / C53) ^ 2 + LOG(C53 / C54) ^ 2 + LOG(C54 / C55) ^ 2 + LOG(C55 / C56) ^ 2 + LOG(C56 / C57) ^ 2 + LOG(C57 / C58) ^ 2 + LOG(C58 / C59) ^ 2 + LOG(C59 / C60) ^ 2 + LOG(C60 / C61) ^ 2 + LOG(C61 / C62) ^ 2 + LOG(C62 / C63) ^ 2 + LOG(C63 / C64) ^ 2 + LOG(C64 / C65) ^ 2 + LOG(C65 / C66) ^ 2 + LOG(C66 / C67) ^ 2 + LOG(C67 / C68) ^ 2 + LOG(C68 / C69) ^ 2 + LOG(C69 / C70) ^ 2 + LOG(C70 / C71) ^ 2 + LOG(C71 / C72) ^ 2 + LOG(C72 / C73) ^ 2 + LOG(C73 / C74) ^ 2 + LOG(C74 / C75) ^ 2 + LOG(C75 / C76) ^ 2 + LOG(C76 / C77) ^ 2 + LOG(C77 / C78) ^ 2 + LOG(C78 / C79) ^ 2 + LOG(C79 / C80) ^ 2 + LOG(C80 / C81) ^ 2 + LOG(C81 / C82) ^ 2 + LOG(C82 / C83) ^ 2 + LOG(C83 / C84) ^ 2 + LOG(C84 / C85) ^ 2 + LOG(C85 / C86) ^ 2 + LOG(C86 / C87) ^ 2 + LOG(C87 / C88) ^ 2 + LOG(C88 / C89) ^ 2 + LOG(C89 / C90) ^ 2 + LOG(C90 / C91) ^ 2 + LOG(C91 / C92) ^ 2 + LOG(C92 / C93) ^ 2 + LOG(C93 / C94) ^ 2 + LOG(C94 / C95) ^ 2 + LOG(C95 / C96) ^ 2 + LOG(C96 / C97) ^ 2 + LOG(C97 / C98) ^ 2 + LOG(C98 / C99) ^ 2 + LOG(C99 / C100) ^ 2 - (LOG(C / C100) ^ 2) / 100) / 100) > 30 AND C < C1 AND C1 < C2

QUOTE (Rich_Idiot)
4. The stock’s 10 day Average Directional Index (ADX) is above 30.

I do not know of a way to create a formula for ADX which is short enough to be practical.

You could create a Condition for ADX by click on the ADX indicator on the chart and select Create Scan Condition. You could then include the this Condition as an EasyScan Condition which also used your other Conditions as EasyScan Conditions. The resulting EasyScan would only return symbols in its List to Scan which met the requirements of all of your EasyScan Conditions. 

This same technique could be used for most of your Conditions and the resulting Conditions would be more efficient than Condition Formulas for the same requirements.

QUOTE (Rich_Idiot)
6. Today the stock must close at least X% (X= 4%, 5%, or 6%) below its Y‐period moving average (Y = 4, 5, or 6).

You need to actually specify the desired X or Y to create a Condition Formula. It is not possible to create an adjustable Condition Formula which will accept user inputs.

Historical Volatility (HV)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Rich_Idiot
Posted : Friday, June 1, 2012 9:24:23 PM
Registered User
Joined: 1/6/2012
Posts: 11

Bruce on the above formula what would be formula/PCF be for #6 IF

6. Today the stock must close at least X% (X= 4%) below its Y‐period moving average (Y = 4)

albertm
Posted : Saturday, June 2, 2012 11:22:14 AM
Registered User
Joined: 5/28/2012
Posts: 12

I like your criteria for your scan, but what are you looking to do with this scan?  What will it show you?

I'm new to creating my own formulas and such and would really like to know how to use certain criteria to generate trading ideas. 

Obviously you want stocks over 250,000 shares/day and a close over $5.  You also want stocks that are breaking out?  I'm not sure what you want to do and I'm curious.

Thanks Rich Idiot,

-Mike

Rich_Idiot
Posted : Saturday, June 2, 2012 12:10:37 PM
Registered User
Joined: 1/6/2012
Posts: 11

Mike I am trying to create a PullBack scan to find stocks in an uptrend that are pulling back and this scan has specific entry for entering the pullback after it opens at least a X% from where it closed the previous day after closing down a few days in a row.

 

donny aka Ribh_Idiot

Rich_Idiot
Posted : Saturday, June 2, 2012 12:11:26 PM
Registered User
Joined: 1/6/2012
Posts: 11

QUOTE (Rich_Idiot)

Mike I am trying to create a PullBack scan to find stocks in an uptrend that are pulling back and this scan has specific entry for entering the pullback after it opens at least a X% from where it closed the previous day after closing down a few days in a row.

 

donny aka Rich_Idiot

albertm
Posted : Saturday, June 2, 2012 1:43:41 PM
Registered User
Joined: 5/28/2012
Posts: 12

I like it.

Stocks need to be in an uptrend, hopefully you'll find stocks hitting support and bouncing.  Have you used this in the past?  If so, how successful?

-Mike

Rich_Idiot
Posted : Saturday, June 2, 2012 4:46:28 PM
Registered User
Joined: 1/6/2012
Posts: 11

QUOTE (albertm)

I like it.

Stocks need to be in an uptrend, hopefully you'll find stocks hitting support and bouncing.  Have you used this in the past?  If so, how successful?

-Mike

 

Mike I have used different versions and IF you get all criteria lined up it is about 70-75% success on short term (1-3 day or less) exits.  What you are looking for is stocks that have been in an uptrend and are pulling back due to profit taking etc and then this allows you to play the bounce after the pullback

Bruce_L
Posted : Monday, June 4, 2012 8:43:37 AM


Worden Trainer

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

A Condition Formula for price being at least 4% below its 4-Period Simple Moving Average could be written as:

C <= .96 * AVGC4

Adding this to the original combined Condition would result in:

C > 5 AND C > AVGC200 AND AVGV21 >= 250000 AND 1600 * SQR((LOG(C / C1) ^ 2 + LOG(C1 / C2) ^ 2 + LOG(C2 / C3) ^ 2 + LOG(C3 / C4) ^ 2 + LOG(C4 / C5) ^ 2 + LOG(C5 / C6) ^ 2 + LOG(C6 / C7) ^ 2 + LOG(C7 / C8) ^ 2 + LOG(C8 / C9) ^ 2 + LOG(C9 / C10) ^ 2 + LOG(C10 / C11) ^ 2 + LOG(C11 / C12) ^ 2 + LOG(C12 / C13) ^ 2 + LOG(C13 / C14) ^ 2 + LOG(C14 / C15) ^ 2 + LOG(C15 / C16) ^ 2 + LOG(C16 / C17) ^ 2 + LOG(C17 / C18) ^ 2 + LOG(C18 / C19) ^ 2 + LOG(C19 / C20) ^ 2 + LOG(C20 / C21) ^ 2 + LOG(C21 / C22) ^ 2 + LOG(C22 / C23) ^ 2 + LOG(C23 / C24) ^ 2 + LOG(C24 / C25) ^ 2 + LOG(C25 / C26) ^ 2 + LOG(C26 / C27) ^ 2 + LOG(C27 / C28) ^ 2 + LOG(C28 / C29) ^ 2 + LOG(C29 / C30) ^ 2 + LOG(C30 / C31) ^ 2 + LOG(C31 / C32) ^ 2 + LOG(C32 / C33) ^ 2 + LOG(C33 / C34) ^ 2 + LOG(C34 / C35) ^ 2 + LOG(C35 / C36) ^ 2 + LOG(C36 / C37) ^ 2 + LOG(C37 / C38) ^ 2 + LOG(C38 / C39) ^ 2 + LOG(C39 / C40) ^ 2 + LOG(C40 / C41) ^ 2 + LOG(C41 / C42) ^ 2 + LOG(C42 / C43) ^ 2 + LOG(C43 / C44) ^ 2 + LOG(C44 / C45) ^ 2 + LOG(C45 / C46) ^ 2 + LOG(C46 / C47) ^ 2 + LOG(C47 / C48) ^ 2 + LOG(C48 / C49) ^ 2 + LOG(C49 / C50) ^ 2 + LOG(C50 / C51) ^ 2 + LOG(C51 / C52) ^ 2 + LOG(C52 / C53) ^ 2 + LOG(C53 / C54) ^ 2 + LOG(C54 / C55) ^ 2 + LOG(C55 / C56) ^ 2 + LOG(C56 / C57) ^ 2 + LOG(C57 / C58) ^ 2 + LOG(C58 / C59) ^ 2 + LOG(C59 / C60) ^ 2 + LOG(C60 / C61) ^ 2 + LOG(C61 / C62) ^ 2 + LOG(C62 / C63) ^ 2 + LOG(C63 / C64) ^ 2 + LOG(C64 / C65) ^ 2 + LOG(C65 / C66) ^ 2 + LOG(C66 / C67) ^ 2 + LOG(C67 / C68) ^ 2 + LOG(C68 / C69) ^ 2 + LOG(C69 / C70) ^ 2 + LOG(C70 / C71) ^ 2 + LOG(C71 / C72) ^ 2 + LOG(C72 / C73) ^ 2 + LOG(C73 / C74) ^ 2 + LOG(C74 / C75) ^ 2 + LOG(C75 / C76) ^ 2 + LOG(C76 / C77) ^ 2 + LOG(C77 / C78) ^ 2 + LOG(C78 / C79) ^ 2 + LOG(C79 / C80) ^ 2 + LOG(C80 / C81) ^ 2 + LOG(C81 / C82) ^ 2 + LOG(C82 / C83) ^ 2 + LOG(C83 / C84) ^ 2 + LOG(C84 / C85) ^ 2 + LOG(C85 / C86) ^ 2 + LOG(C86 / C87) ^ 2 + LOG(C87 / C88) ^ 2 + LOG(C88 / C89) ^ 2 + LOG(C89 / C90) ^ 2 + LOG(C90 / C91) ^ 2 + LOG(C91 / C92) ^ 2 + LOG(C92 / C93) ^ 2 + LOG(C93 / C94) ^ 2 + LOG(C94 / C95) ^ 2 + LOG(C95 / C96) ^ 2 + LOG(C96 / C97) ^ 2 + LOG(C97 / C98) ^ 2 + LOG(C98 / C99) ^ 2 + LOG(C99 / C100) ^ 2 - (LOG(C / C100) ^ 2) / 100) / 100) > 30 AND C < C1 AND C1 < C2 AND C <= .96 * AVGC4



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Rich_Idiot
Posted : Tuesday, June 5, 2012 5:20:23 PM
Registered User
Joined: 1/6/2012
Posts: 11

THANKS Bruce!!!

 

Donny aka Rich_Idiot

Bruce_L
Posted : Tuesday, June 5, 2012 5:39:28 PM


Worden Trainer

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

You're welcome.



-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.