Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

FORMULA FOR "GAPPERS" IN TC2000 Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
maxirich
Posted : Tuesday, October 9, 2012 2:00:13 PM
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

 

Bruce_L
Posted : Tuesday, October 9, 2012 2:36:22 PM


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
maxirich
Posted : Tuesday, October 9, 2012 3:17:03 PM
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 

Bruce_L
Posted : Tuesday, October 9, 2012 3:25:48 PM


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