Need a scan that will show a close above 1 week SMA

Kevin

what have {weekly SMA(18,weekly volume) >40000, Thanks in advance

lmkwin

So you'd select the Close from the Price drop down and the SMA from the Technical Indicators dropdown. Then change the Close to Weekly Close. Change the Volume in the SMA to Close and the period to 1, add weekly in fron of SMA and weekly in front of close and see what you get.

It would look like this but this is not formated with parenthesis and brackets.

weekly close > weekly SMA1,weekly close

markd

Kevin didn't say crossing above MA, but if he wants that

weekly close x weekly SMA1,weekly close

Kevin

Sorry, typing is awful, want to see price close above 18 week SMA, Thanks

Kevin

I would like to run this scan every day and see price cross above the 18 week SMA as it happens each day, hope this makes sense. Appreciate all help

Kevin

so what I have is [weekly close X SMA(18,weekly close)]

markd

Should work.

A couple of notes.

You also need to specify a "universe" - a group of stocks that have something in common - like

[group is sp500]

or it could be a set of characteristics like

[[exchange is NYSE] or [exchange is NASD]]
and [market cap > 1000]
and [sma(20, volume) > 50,000]

or something similar. That should come first, at the very top of your scan. And then add your setup condition:

and [weekly close x SMA(18,weekly close)]

Kevin

Thanks Markd and Imkwim for your help.

RAClose

Markd: This may be a dumb question, but with a weekly scan using SMA, is the timing such as 18 based on 18 days or 18 weeks? And is the volume based on the open/close or the entire day? I've never really thought of this before until your reply, Thank you

markd

The default (what the scan engine assumes you mean, if you don't add a time frame modifier) is days.

So, if you write

and [close x sma(18, close)]

the scan engine looks for a crossover in the daily time frame - yesterday, the daily close was below yesterday's sma 18, and today, today's close is above today's sma 18 (note both terms, close AND sma, change in value each day (most of the time)).

But if you write

and [weekly close x weekly sma(18, weekly close)]

the scan engine compares last week's values this week's values.

The scan engine always returns values based on the most recent data update. Updates occur all day long for both price and volume, so if you run a scan during the day, it considers the most recent update "final" data for every time frame, even though it isn't yet.

So, if you want "true" results, it's best to run your scan after the final daily update (usually around 6 pm eastern) for daily time frame scans, and after the last Friday update for weekly scans.

If you run a daily or weekly scan in the middle of market hours, and then again after the final update, you will get different results. Some symbols that were hits during the day aren't hits at the final (because the price has changed), while symbols passed over during the day show up in the final. There can be exceptions with extreme market behavior, but that's the general result.