Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Reverse formula Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
rjbama1
Posted : Sunday, February 10, 2019 12:34:29 PM
Registered User
Joined: 6/14/2014
Posts: 3

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

Bruce_L
Posted : Monday, February 11, 2019 11:11:58 AM


Worden Trainer

Joined: 10/7/2004
Posts: 64,759

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
rjbama1
Posted : Monday, February 11, 2019 11:43:22 AM
Registered User
Joined: 6/14/2014
Posts: 3

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

Bruce_L
Posted : Monday, February 11, 2019 11:44:48 AM


Worden Trainer

Joined: 10/7/2004
Posts: 64,759

You're welcome.



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