Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Pullback in Uptrend Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
willie moe
Posted : Saturday, June 30, 2012 4:08:42 PM
Registered User
Joined: 8/25/2010
Posts: 117

Bruce,

Can you help me create a pcf to find the following:

Average daily volume >250,000

Closing price > 5

5 Day Average Vol must be below last 30 days

50 Day Price EMA in an uptrend

Low of last 2 days must also be low of last 10 days

I know I can alot of this in a EasyScan but if you could fill in the blanks I would appreciate it.

Thanks,

Wm

Bruce_L
Posted : Monday, July 2, 2012 10:18:25 AM


Worden Trainer

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

The following Condition Formula uses a 35-Period Average Daily Volume and defines an EMA uptrend as the 10-Period Linear Regression Slope and Net Change over the same period of the EMA both being positive.

AVGV35 >= 250000 AND C > 5 AND AVGV5 < AVGV30.5 AND XAVGC50 > XAVGC50.9 AND 9 * (XAVGC50 - XAVGC50.9) + 7 * (XAVGC50.1 - XAVGC50.8) + 5 * (XAVGC50.2 - XAVGC50.7) + 3 * (XAVGC50.3 - XAVGC50.6) + XAVGC50.4 > XAVGC50.5 AND MINL2 = MINL10

Personal Criteria Formula Conditions
Using Linear Regression vs Classical Peaks/Valleys for Divergence Analysis
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
willie moe
Posted : Monday, July 2, 2012 2:09:16 PM
Registered User
Joined: 8/25/2010
Posts: 117

Bruce,

Is everything I wanted to include in the formula you created?

I don't see the low of the last 2 days being the low of the last 10 days.

I couldn't figure out how to do that with a pcf.

Please advise and thanks for your help.

William

Bruce_L
Posted : Monday, July 2, 2012 2:37:30 PM


Worden Trainer

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

It was not included, but I have added it to the Condition Formula in the original response.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
willie moe
Posted : Monday, July 2, 2012 2:57:04 PM
Registered User
Joined: 8/25/2010
Posts: 117

Thanks again. This service is extremely helpful and appreciated.

Wm

willie moe
Posted : Monday, July 2, 2012 5:46:20 PM
Registered User
Joined: 8/25/2010
Posts: 117

Bruce,

I am getting an error when I copy and paste the formula.

Argument missing near <

hayesamichael1
Posted : Tuesday, July 3, 2012 1:12:40 AM
Registered User
Joined: 8/26/2010
Posts: 37

Bruce

I am also getting same error

 

http://screencast.com/t/RMRILu7JcYw

 

Thanks Mike

Bruce_L
Posted : Tuesday, July 3, 2012 8:46:09 AM


Worden Trainer

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

I'm not quite sure how it happened since I tested the formula before copying and pasting it into the forums, but there was a missing V in the formula. AVGV5 was in the formula as AVG5. It has been corrected above.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
sganz
Posted : Tuesday, July 3, 2012 6:13:29 PM
Registered User
Joined: 3/8/2009
Posts: 2

I am new to TC2000 and trying to do something similar - but am basically looking for stocks that have recently hit 52 week highs (say within the past 15 days or so), but are currently at a pullback of 5-8% off those recent highs - how can I go about doing this?  I see screens for new highs and % from new highs, but no real way to say "New high in last X days" AND currently at 92% - 95% of this recent high"

Thanks for any ideas and insights

Steve

Bruce_L
Posted : Tuesday, July 3, 2012 10:08:48 PM


Worden Trainer

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

Please try the following Condition Formula:

.92 * MAXH15 <= C AND C <= .95 * MAXH15 AND MAXH15 = MAXH252



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
sganz
Posted : Wednesday, July 4, 2012 10:46:59 AM
Registered User
Joined: 3/8/2009
Posts: 2

That worked great - I can tweak it from here I think - thank you for the prompt reply

Steve

Bruce_L
Posted : Wednesday, July 4, 2012 10:58:43 AM


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.