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.

How to exclude ETF from type?

I understand [type = stock} or [type is stock], but how do I exclude the ETF's that get included?

Best Answers

  • gordgord admin
    edited September 2014 Accepted Answer
    ETF's are actually stocks which is why they are included in your scan. However if you only want single stock issues without any ETF stock baskets, just eliminate that group as follows.

    [type = stock]
    and [ group is not ETF ]

    Note you can also use the same technique in other ways, example; eliminate all S&P500 stocks from your scan

    [type = stock]
    and [ group is not SP500 ]
  • gordgord admin
    edited September 2014 Accepted Answer
    Yes there is a problem with the "OR" condition, its a common problem.

    This is the way your scan is written,
    1) find all stocks, not ETF's which meet this criteria

    [TYPE = STOCK]
    AND [GROUP IS NOT ETF]
    AND [COUNTRY IS US]
    AND [YESTERDAY'S MAX(30,SCTR ) < 45]
    AND [SCTR > 45]

    2) OR any symbols, (stocks, etf's, mutuals etc), any country which meet

    OR
    [YESTERDAY'S MAX(60,SCTR ) < 30]
    AND [SCTR > 30]

    I assume you want the first section to limit the scope to non ETF USA stocks, then the second part to be "either or" on the SCTR criteria. The "OR" conditions need to be contained with an extra set of brackets. I've split the scan into one liners to make it easier to see what each criteria is doing.

    [TYPE = STOCK]
    AND [GROUP IS NOT ETF]
    AND [COUNTRY IS US]
    AND
    [ [YESTERDAY'S MAX(30,SCTR ) < 45] AND [SCTR > 45]
    OR
    [YESTERDAY'S MAX(60,SCTR ) < 30] AND [SCTR > 30] ]

    hope this helps
    Gord

Answers

  • • For the last intraday update:
    [TYPE = STOCK] AND [GROUP IS NOT ETF] AND [COUNTRY IS US] AND [YESTERDAY'S MAX(30,SCTR )< 45] AND [SCTR>45] OR [YESTERDAY'S MAX(60,SCTR )< 30] AND [SCTR>30]
    This still produces a list that has ETF's in the Universe column.
    Did I use the proper phrasing?
Sign In or Register to comment.