Registered User
Joined: 6/14/2014
Posts: 4
|
I came across this formula and it works great for short/mid range UPTRENDS. Can you help in reversing the formula's critera so that it can work just as well in a mid/short range DOWNTREND?
xavgc50.20 < xavgc50.15 < xavgc50.10 AND xavgc50.10 < xavgc50.5 AND xavgc50.3 < xavgc34
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
First, let's rewrite your formula so it uses valid syntax.
XAVGC50.20 < XAVGC50.15 AND XAVGC50.15 < XAVGC50.10 AND XAVGC50.10 < XAVGC50.5 AND XAVGC50.3 < XAVGC34
Note the changes all revolve around the XAVGC50.20 < XAVGC50.15 < XAVGC50.10 section as you can't actually have three values in a serialized double < configuration. You need to divide that into two complete separate comparisons and then use AND to combine the comparisons.
So when we reverse this, we can just change < signs to > signs instead.
XAVGC50.20 > XAVGC50.15 AND XAVGC50.15 > XAVGC50.10 AND XAVGC50.10 > XAVGC50.5 AND XAVGC50.3 > XAVGC34
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Registered User
Joined: 6/14/2014
Posts: 4
|
Thanks Bruce, ever so much. The reverse formula is now doing what it should. I can now put away my aspirins. Thanks again and enjoy your day.
RJackson
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|