New version 18 available now


Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

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

Invert Formula Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
hhphoto2006
Posted : Thursday, May 03, 2018 2:20:16 PM
Registered User
Joined: 10/18/2008
Posts: 243

Hi Bruce

A while back you helped me with this formula that would scan for stocks that will eliminate the RED signal.

NOT(TrueInRow(NOT(XUP(XAVGC8, XAVGC13)), 57) > TrueInRow(NOT(H < XAVGC8 AND XAVGC8 < XAVGC13 AND XAVGC13 < XAVGC21), 57))

Could you help me inverting the formula so it will show stocks that have the red and neutral signal but NO GREEN

Thank you

Bruce_L
Posted : Thursday, May 03, 2018 2:26:58 PM


Worden Trainer

Joined: 10/7/2004
Posts: 63,442

I will just take a wild stab at what the green signal might be (seriously, I don't know what it might be from when this was asked).

NOT(TrueInRow(NOT(XDOWN(XAVGC8, XAVGC13)), 57) > TrueInRow(NOT(L > XAVGC8 AND XAVGC8 > XAVGC13 AND XAVGC13 > XAVGC21), 57))

Please give it a test. If it doesn't work, then providing the formula for the green signal would help a lot.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
hhphoto2006
Posted : Sunday, May 06, 2018 4:11:03 PM
Registered User
Joined: 10/18/2008
Posts: 243

I am sorry Bruce, the formula for the green signal is:

TrueInRow(NOT(XDOWN(XAVGC8, XAVGC13)), 57) > TrueInRow(NOT(L > XAVGC8 AND XAVGC8 > XAVGC13 AND XAVGC13 > XAVGC21), 57)

Bruce_L
Posted : Monday, May 07, 2018 9:08:16 AM


Worden Trainer

Joined: 10/7/2004
Posts: 63,442

You should be able to just put the whole thing in a NOT() function.

NOT(TrueInRow(NOT(XDOWN(XAVGC8, XAVGC13)), 57) > TrueInRow(NOT(L > XAVGC8 AND XAVGC8 > XAVGC13 AND XAVGC13 > XAVGC21), 57))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
hhphoto2006
Posted : Monday, May 07, 2018 3:33:40 PM
Registered User
Joined: 10/18/2008
Posts: 243

Ok I will try that

Thank you

Bruce_L
Posted : Monday, May 07, 2018 3:54:43 PM


Worden Trainer

Joined: 10/7/2004
Posts: 63,442

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.