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

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