Hi Bruce,

Is there anyway I can run a scan that picks up stocks that are currently between the 45 and 55ema on a 1min stime scale and teh 48ema and 52ema on a 5min time scale?

I'm looking to find stocks that are at both the 1min and 5min 50ema level but It's going ot be tough that the current price is at exactly both so if there is any other way that we could see when the 50emas are close to each other that woudl also be ideal.

Thanks!

Alternatively, is there a way of putting t he 50ema from a 5min timeframe on a 1min chart? That would be even better :D

I will start by saying it is not possible to add the 50ema from a 5-minute chart to a 1-minute chart. About the best you could do is multiply the period by five (or probably closeer would be (period-1) * 5 + 1) and that will almost never match exactly.

Checking for price to be between the 45 and 55ema can be written as follows.

ABS(XAVGC45 + XAVGC55 - 2 * C) <= ABS(XAVGC45 - XAVGC55)

Checking for price to be between the 48 and 52ema can be written as follows.

ABS(XAVGC48 + XAVGC52 - 2 * C) <= ABS(XAVGC48 - XAVGC52)

You can add both formulas to the same Condition Set and set the time frame of one to 1-minute and the time frame of the other to 5-minute.

A formula for price being near the 50ema depends on how close you need it to be. You could check for it being within $0.01 for example.

ABS(C - XAVGC50) <= .01

Or within say 0.1%.

ABS(C / XAVGC50 - 1) <= .001

But you may be better off with the moving average approach you already requested.