| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 2/14/2011
Posts: 59
|
What is a formula for GAP only with say 2.5% either gap up or gap down?
My current formula using prior day close, after initial open is acurate, however as day moves on many stock meet criteria of PCF after they move over 2.5% from yesterdays close.
So I am looking for a GAP only PCF
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following Condition Formula.
ABS(O / C1 - 1) >= .025
PCF Formula Descriptions
Historical Graphs
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 2/14/2011
Posts: 59
|
Thanks Bruce
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 2/14/2011
Posts: 59
|
Bruce
ABS(O / C1 - 1) >= .03 only seems to result in - Gap Down Only Candiates
Is theer an OR statement for the oppisite a GAP up
What is the overall GAPPERS statement
Thanks again
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The formula as given is agnostic as to if the gap is up or down. That is what the ABS() portion of the formula does.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 2/14/2011
Posts: 59
|
Fouund the problem on my end thants again for the agnostic
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |