Hi Bruce

Would you help me With a PCF where price is between 2 EMA for example the 13 and 21.

Thank you

If you want this to be directional, this would just be an exponential MACD 13, 21.

MACD13.21

If you want the distance without giving an indication of which is above or below, you can take the absolute value of this.

ABS(MACD13.21)

MACD & MACD Histogram

Never thought of it this way. Pretty cool.

Elder like to use two moving averages and calls the space in between them the "Value Zone". This can be used as a condition column to see which tickers meet his criteria.

Sweet.

And after reading Al_Gorithm's response, it is obvious I mis-read the question. Please try the following instead.

(XAVGC13 <= C AND C <= XAVGC21) OR (XAVGC21 <= C AND C <= XAVGC13)

Or the slight shorter:

ABS(XAVGC13 + XAVGC21 - 2 * C) <= ABS(MACD13.21)

Thank you Bruce

I am glad Al_Gorithm comented on the post since that is exacltly what I was thinking about. Just a quick follow up. Some times price just enters this zone but does not close inside, can I replace C in the formula for L that way I don't missed the stocks that ennter the zone and bounce closing higher?

Thanks again 

Yes you can, but if you want to check for any part of the bar being inside the moving average:

LEAST(XAVGC13, XAVGC21) <= H AND L <= GREATEST(XAVGC13, XAVGC21)

Great Thank you

Happy to help. Caffeine has its advantages. LOL.