Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

New Members: Be sure to confirm your email address by clicking on the link that was sent to your email inbox. You will not be able to post messages until you click that link.

etf scanning for moving averages up by \$symbol:\$spx ratio

hello

how can i done this scan with an expression like "symbol:\$spx > sma(5-,symbol:\$spx)"?

thanks!

--
[group is ETF]
and [Liquidity > 999,999]
and [group is ETFNOUI]
and [SMA(20,VOLUME) >= 30,000]

and [ symbol:\$spx > sma(5-,symbol:\$spx) ]

// perc diff sma20
RANK BY [ PctDiff(close,sma(20,close))]
--

Comments

• mod
edited July 27
Unfortunately, as far as I know, the scan engine cannot scan for ratio symbol values (for instance, abc:xyz).
• ✭✭
You could try the PctRelative function from the Technical Indicators dropdown. Might not be exactly what you are looking for but it's an option inside the scan engine.

and [PctRelative(20,\$spx) > SMA(5,PctRelative(20,\$spx) )]

It passes syntax and does return 368 results

[group is ETF]
and [Liquidity > 999,999]
and [group is ETFNOUI]
and [SMA(20,VOLUME) >= 30,000]

//and [ symbol:\$spx > sma(5-,symbol:\$spx) ]
and [PctRelative(20,\$spx) > SMA(5,PctRelative(20,\$spx) )]

// perc diff sma20
RANK BY [ PctDiff(close,sma(20,close))]

You can even use it as a Rank by

rank by [PctRelative(20,\$spx)]

With the PctRelative you can also use \$Sector and \$Industry where the \$spx is. In fact, you can use ANY valid symbol in that position. With ETF's they are NOT assigned to sectors or industries so that would be good to use in an ETF scan, but something to keep in mind.
• PLEASE HELP; All I want is a scan with 50 and 100 ema for stocks and etfs. With rel st of over 80. 100 is enough Thank you
Sign In or Register to comment.