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

#### vrinx3547

##### New member
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.

Last edited:
Solution
I don't do scans often, but you should be able to mangle this code into something that would work...
Code:
``````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
I don't do scans often, but you should be able to mangle this code into something that would work...
Code:
``````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

### Not the exact question you're looking for?

Start a new thread and receive assistance from our community.

87k+ Posts
178 Online

## The Market Trading Game Changer

Join 2,500+ subscribers inside the useThinkScript VIP Membership Club
• Exclusive indicators
• Proven strategies & setups
• Private Discord community
• Exclusive members-only content
• Add-ons and resources
• 1 full year of unlimited support

### Frequently Asked Questions

What is useThinkScript?

useThinkScript is the #1 community of stock market investors using indicators and other tools to power their trading strategies. Traders of all skill levels use our forums to learn about scripting and indicators, help each other, and discover new ways to gain an edge in the markets.

How do I get started?

We get it. Our forum can be intimidating, if not overwhelming. With thousands of topics, tens of thousands of posts, our community has created an incredibly deep knowledge base for stock traders. No one can ever exhaust every resource provided on our site.

If you are new, or just looking for guidance, here are some helpful links to get you started.

What are the benefits of VIP Membership?