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 |

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

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

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
rjbama1
 Posted : Monday, February 11, 2019 11:43:22 AM
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

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

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

 Forum Jump Customer Training & Support - Ask a Trainer - TC2000 version 12/18 - Ask a Trainer - TC2000 version 7 - Ask a Trainer - StockFinder 5.0 - PCFs, EasyScan and Custom Indicators General Discussions - Stock and Market Talk - TC2000 version 12 or 18 - TC2000 version 7 - StockFinder 5.0 - RealCode for StockFinder 5.0 Tutorial Videos - TC2000 version 12 tutorial videos - TC2000 version 7 tutorial videos 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.