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

Looking for pcf help.... Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
jaxricane
Posted : Monday, April 28, 2008 4:40:34 PM
Registered User
Joined: 11/13/2007
Posts: 15
Hello,


i am looking for a pcf that gives me , eod, stocks that have closed below their 50 ma ( rising) and above their 50 ma ( declining ) .....

thank you 

jaxricane
Bruce_L
Posted : Monday, April 28, 2008 4:47:36 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
If you just want Price above and below the Moving Average, you may wish to try one of the following:

Price Above 50-Period Simple Moving Average:

C > AVGC50

Price Below 50-Period Simple Moving Average:

C < AVGC50

Price Above 50-Period Exponential Moving Average:

C > XAVGC50

Price Below 50-Period Exponential Moving Average:

C < XAVGC50

If the Price must actually be increasing or decreasing in the same direction at the same time, you may wish to try the following instead:

Price Increasing Above 50-Period Simple Moving Average:

C > C1 AND C > AVGC50

Price Decreasing Below 50-Period Simple Moving Average:

C < C1 AND C < AVGC50

Price Increasing Above 50-Period Exponential Moving Average:

C > C1 AND C > XAVGC50

Price Decreasing Below 50-Period Exponential Moving Average:

C < C1 AND C < XAVGC50

If you are looking for crossover formulas instead, you may wish to try the following:

Price xUp SMA50:

C > AVGC50 AND C1 <= AVGC50.1

Price xDn SMA50:

C < AVGC50 AND C1 >= AVGC50.1

Price crossing SMA50 (either direction):

SGN(C - AVGC50) <> SGN(C1 - AVGC50.1)

Price xUp EMA50:

C > XAVGC50 AND C1 <= XAVGC50.1

Price xDn EMA50:

C < XAVGC50 AND C1 >= XAVGC50.1

Price crossing EMA50 (either direction):

SGN(C - XAVGC50) <> SGN(C1 - XAVGC50.1)

You may wish to review the following:

How to create a Personal Criteria Forumula (PCF)
Moving Average PCF Templates
Things to check if your moving averages don't "seem right" or "seem to match"
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
jaxricane
Posted : Monday, April 28, 2008 5:37:40 PM
Registered User
Joined: 11/13/2007
Posts: 15
thanks for your quick reply
Bruce_L
Posted : Monday, April 28, 2008 5:54:34 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
bubba1
Posted : Wednesday, June 11, 2008 9:45:10 PM
Registered User
Joined: 10/7/2004
Posts: 1

how to write formula using exponents ex: (a+b)^2   do I use EXP() and how.

Bruce_L
Posted : Thursday, June 12, 2008 7:53:46 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
bubba1,
Welcome to the forums. A very good foundation for learning how to use TeleChart can be gained by reviewing the following:

If you are new to TeleChart READ THIS FIRST!

EXP() is the Natural Exponent function and not what you would want to use for this. The syntax you already presented is what you would want. For example the Square of the Close would be:

C ^ 2

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