| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/18/2008
Posts: 260
|
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
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
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
|
|
Registered User
Joined: 10/18/2008
Posts: 260
|
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)
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
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
|
|
Registered User
Joined: 10/18/2008
Posts: 260
|
Ok I will try that
Thank you
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |