Subscription & data-feed pricing Class schedule

Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.

 Help with conditions returning values of +1, 0 or -1 Rate this Topic:
 Previous Topic · Next Topic Watch this topic · Print this topic ·
 Posted : Friday, November 23, 2018 1:45:03 PM
Platinum Customer

Joined: 12/4/2016
Posts: 5

You were helping out Chris55 with some questions around having conditions return +1 and/or -1 values.  My question is similar.

I understand that a Boolean condition will normally return +1 if true and 0 if not true.  How do you write a formula that would return a -1 if true and a 0 if not true?

I have some bullish and bearish conditions that I want to combine in to an oscillator in histogram style so the +1 and -1 are necessary.  Currently all the formulas return +1 or 0 and so the indicator never goes in to negative territory.

If conditions cannot return a -1 value, is it possible to have the boolean formula multiplied by -1?

Thank you.

Bruce_L
 Posted : Monday, November 26, 2018 10:00:17 AM

Worden Trainer

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

If you put a Boolean formula inside parentheses as part of a formula designed to return a numeric value it returns -1 if true and 0 if false.

If you put a Boolean formula inside an ABS() function as part of a formula designed to return a numeric value it returns 1 if true and 0 if false.

You can use the IIF() function to get a Boolean formula to return any numeric value you want when true or false.

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