looking for stocks where the daily close has been above the 12 EMA for 42 days.

[vrinx3547]

I need to know how to scan in thinkorswim for a stock price that closed above or below a moving average for a certain number of days. EXAMPLE: On a chart the price has consistently closed above the 12 exponential moving average for 42 days. how would I scan for this? I am looking for stocks where the daily close has been above the 12 EMA for 42 days. Thank you.

 

[mashume]

I don't do scans often, but you should be able to mangle this code into something that would work...

def length = 42
def above = if close > MovAvgExponential(price = CLOSE, length = 12) then 1 else 0;
plot eureka = if sum(above, length) == length then 1 else double.nan;

the basic idea is to write a series (above) with the value of 1 if the close is greater than the EMA or 0 if it is below and then sum that series. If the sum of the series is the same as the length all of the value in the series are 1 and we know that the close has been above the ema for each of the last 42 bars.

Hope that helps,
-mashume