| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
 Gold Customer
Joined: 1/21/2012
Posts: 28
|
Formula for ema 5 day X ema20 confdition
exponential 5 day ma X exponential 20 day ma
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
A Condition Formula for EMA5 crossing up through EMA20 can be written as follows.
XAVGC5 > XAVGC20 AND XAVGC5.1 <= XAVGC20.1
A Condition Formula for EMA5 crossing down through EMA20 can be written as follows.
XAVGC5 < XAVGC20 AND XAVGC5.1 >= XAVGC20.1
A Condition Formula for EMA5 crossing through EMA20 in either direction can be written as follows.
SGN(XAVGC5 - XAVGC20) <> SGN(XAVGC5.1 - XAVGC20.1)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 1/21/2012
Posts: 28
|
QUOTE (Bruce_L) A Condition Formula for EMA5 crossing up through EMA20 can be written as follows.
XAVGC5 > XAVGC20 AND XAVGC5.1 <= XAVGC20.1
A Condition Formula for EMA5 crossing down through EMA20 can be written as follows.
XAVGC5 < XAVGC20 AND XAVGC5.1 >= XAVGC20.1
A Condition Formula for EMA5 crossing through EMA20 in either direction can be written as follows.
SGN(XAVGC5 - XAVGC20) <> SGN(XAVGC5.1 - XAVGC20.1)
Thanks, Bruce!
|
|
Registered User
Joined: 3/10/2013
Posts: 41
|
Hi Bruce,
I have this scan set-up and in a watchlist colum but do not get results - however it does show on the chart - can you please help. Thanks Aubrey
SGN(AVGC21 - AVGC200) <> SGN(AVGC21.1 - AVGC200.1) OR SGN(AVGC21 - AVGC200) <> SGN(AVGC21.2 - AVGC200.2) OR SGN(AVGC21 - AVGC200) <> SGN(AVGC21.3 - AVGC2001.3)
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
If you are getting different results on the chart than in a WatchList Column I would start by deleting and re-adding the WatchList Column. If that does not work, then please contact technical support.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |