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

eiler2005

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))]
--

markd

Unfortunately, as far as I know, the scan engine cannot scan for ratio symbol values (for instance, abc:xyz).

lmkwin

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.

DKIRK68947

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

lmkwin

@DKIRK68947

Have you used the Help on StockCharts to writing this scan?

https://support.stockcharts.com/doku.php?id=scans:advanced_scan_syntax:relative_strength_scans

https://support.stockcharts.com/doku.php?id=scans:advanced_scan_syntax:sctr_scans

StockCharts has SCTR reports for RS as well

https://support.stockcharts.com/doku.php?id=reports:sctrs