Hi Bruce,

I know that I can compare a price (open, hi, lo, last) to another price that is, for example, the highest value of the last 24 values.

Such as   ((MAXH24 - C) * 100) / MAXH24 > 1.0   to find a symbol that has dropped by over 1% from the high of the last 24 periods.

I would like to do the same type of scan for the ema, macd, histogram, but cannot find a way to make the MIN and MAX tools work with the XAVG tools.  For example, a symbol trading with the macd at the lowest value in the last 24 periods.  I've tried several ways, logical and illogical, but I only get Formula Errors.

Please help.

Dennis

There is nothing special about XAVG which makes it so it don't work with the MIN() and MAX() functions. For example I can write the following to identify the lowest value of a 26-period exponential moving average during the most recent 24-periods:

MIN(XAVGC26,24)

But the MIN() and MAX() functions work do not work on other functions or compound formulas with more than a single indicator in them. So the followng would not work (even though it doesn't have an exponential moving average in it):

MIN(H - L,24)

Now there is a technique for determining the minimum and maximum values of up to 32 individual items using the Personal Criteria Formula Language outlined in the Min Max PCFs topic. That said, it would be severe overkill for checking to see if MACD is currently at its lowest point in 24 bars.

You could create a Condition Formula for an exponential MACD 12,26 being at it lowest point in 24 bars as:

XAVGC12 - XAVGC26 <= XAVGC12.1 - XAVGC26.1 AND XAVGC12 - XAVGC26 <= XAVGC12.2 - XAVGC26.2 AND XAVGC12 - XAVGC26 <= XAVGC12.3 - XAVGC26.3 AND XAVGC12 - XAVGC26 <= XAVGC12.4 - XAVGC26.4 AND XAVGC12 - XAVGC26 <= XAVGC12.5 - XAVGC26.5 AND XAVGC12 - XAVGC26 <= XAVGC12.6 - XAVGC26.6 AND XAVGC12 - XAVGC26 <= XAVGC12.7 - XAVGC26.7 AND XAVGC12 - XAVGC26 <= XAVGC12.8 - XAVGC26.8 AND XAVGC12 - XAVGC26 <= XAVGC12.9 - XAVGC26.9 AND XAVGC12 - XAVGC26 <= XAVGC12.10 - XAVGC26.10 AND XAVGC12 - XAVGC26 <= XAVGC12.11 - XAVGC26.11 AND XAVGC12 - XAVGC26 <= XAVGC12.12 - XAVGC26.12 AND XAVGC12 - XAVGC26 <= XAVGC12.13 - XAVGC26.13 AND XAVGC12 - XAVGC26 <= XAVGC12.14 - XAVGC26.14 AND XAVGC12 - XAVGC26 <= XAVGC12.15 - XAVGC26.15 AND XAVGC12 - XAVGC26 <= XAVGC12.16 - XAVGC26.16 AND XAVGC12 - XAVGC26 <= XAVGC12.17 - XAVGC26.17 AND XAVGC12 - XAVGC26 <= XAVGC12.18 - XAVGC26.18 AND XAVGC12 - XAVGC26 <= XAVGC12.19 - XAVGC26.19 AND XAVGC12 - XAVGC26 <= XAVGC12.20 - XAVGC26.20 AND XAVGC12 - XAVGC26 <= XAVGC12.21 - XAVGC26.21 AND XAVGC12 - XAVGC26 <= XAVGC12.22 - XAVGC26.22 AND XAVGC12 - XAVGC26 <= XAVGC12.23 - XAVGC26.23

And even this is probably overkill in TC2000 version 12.4. You can just click on the MACD indicator and select Create Scan Condition to create a New Low condition.

Create Conditions from Your Chart (5:25)