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

  • markdmarkd mod
    edited July 27
    Unfortunately, as far as I know, the scan engine cannot scan for ratio symbol values (for instance, abc:xyz).
  • 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.
Sign In or Register to comment.