| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
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
|
|
Registered User
Joined: 11/13/2007
Posts: 15
|
thanks for your quick reply
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 1
|
how to write formula using exponents ex: (a+b)^2 do I use EXP() and how.
|
|
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
|
|
|
Guest-1 |