| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 3/8/2006
Posts: 12
|
I'm trying to write a formula that finds stocks 40% above their 200ma by all i'm getting are thing like rus 1000 gold sac etc. can u help
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following:
Simple:
C >= AVGC200 * 1.4
Exponential:
C >= XAVGC200 * 1.4
It's a pretty large percentage to be above a Moving Average, so neither will return many results. You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/8/2006
Posts: 12
|
So percent is times 1.a number how would 100% be written
|
|
Registered User
Joined: 3/8/2006
Posts: 12
|
thx
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
In this particular case, yes. It really depends on what you are doing.
1 * something = 100% of that same something
You were looking for something 40% above something, or 140% of something, so 1.4 was the number to use.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |