| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 1/11/2005
Posts: 10
|
Attempting to decipher the formula for the GAPPERS in the prebuilt formula section under INDICATORS in TC2000. The formula listed is -1*(L>H1) + -2*(H<L1). This formula provides a result of GAP UP or GAP DOWN or nothing. In looking at the formula I can't figure out how the results are obtained. Appreciate your help. Also when are the results determined?? one minute? ten minutes? EOD? etc
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The formula as given would actually return 1 or 2, not Gap Up or Gap Down. There isn't a way for you to get a formula to display Gap Up or Gap Down. That is something done behind the scenes for when this is used as a WatchList Column.
What happens is that (L>H1) returns -1 when true and 0 when false. And (H<L1) also returns -1 when true and 0 when false. They multiply this by negative one and negative two so the formula returns 1 when L > H1 and returns 2 when H < L1.
PCF Formula Descriptions
The formula is normally going to be daily.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/11/2005
Posts: 10
|
BRUCE : That's what I thought but it does display Gap up or down. Give it a try
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Yes, the pre-built formula displays gap up or gap down (I said that was done behind the scenes in my original response). What you can't do is create your own formula that returns Gap Up or Gap Down (even if you use the exact same formula. Give it a try.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |