Registered User Joined: 5/5/2015 Posts: 20
|
Hi Bruce,
-- Request --
Can you help me set up a watchlist column to do the following:
Condition 1, STOC13.3 < 45 and XAVGC21 > XAVGC34 column displays -1 (or +1)
Condition 2, STOC13.3 > 65 and XAVGC21 < XAVGC34 column displays +1 (or -1)
When both Conditions are false, column displays 0.
It doesn't matter which condition is assigned the +1 (or -1) as they'll be color coded anyways.
------------------------------------
-- Question --
If above request were restated as follows,
Can a watchlist column be set up to display the value of (STOC13.3 * 2) - 100 when either condition is true
[(STOC13.3 * 2) - 100 < -30 and XAVGC21 > XAVGC34] or
[(STOC13.3 * 2) - 100 > 30 and XAVGC21 < XAVGC34]
and display 0 when both conditions are false.
I don't have a use for this, I'm just curious if it can be done.
thank you,
carlson
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following Indicator Formula for your first request.
(STOC13.3 > 65 and XAVGC21 < XAVGC34) - (STOC13.3 < 45 and XAVGC21 > XAVGC34)
Please try the following Indicator Formula for your second request.
(STOC13.3 * 2 - 100) * ABS((STOC13.3 * 2 - 100 < -30 AND XAVGC21 > XAVGC34) OR (STOC13.3 * 2 - 100 > 30 AND XAVGC21 < XAVGC34))
Personal Criteria Formulas
-Bruce Personal Criteria Formulas TC2000 Support Articles
|