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.
Options

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

  • Options
    markdmarkd mod
    edited July 2020
    Unfortunately, as far as I know, the scan engine cannot scan for ratio symbol values (for instance, abc:xyz).
  • Options
    lmkwinlmkwin ✭✭
    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.
  • Options
    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.