How do I eliminate all ETFs from the scan below?

macdmacd

[type = stock] and [exchange = NYSE] and [ Close > 10]
and [macd line < 0]
and [macd line >= macd signal]
and [yesterday's macd line < yesterday's macd signal]
and [2 days ago macd line < 2 days ago macd signal]
and [3 days ago macd line < 3 days ago macd signal]

chubby

ADD and [group is not etf]

macdmacd

Thank you. That does eliminate many, but I still get over 15 "funds", like, (ACV) AllianzGI Diversified Income & Convertible Fund, (BGH) Babson Capital Global Short Duration High Yield Fund and others. Thoughts?

markd

I had a similar problem to eliminate partnerships, trusts, etc. for some of my lists, so I used these:

and [name not contains 'LP']
and [name not contains 'L P']
and [name not contains 'L.P.']
and [name not contains 'LLC']
and [name not contains 'Royalty']
and [name not contains 'Trust']

Obviously, there is not always uniformity in abbreviating issue names.

You could probably just use

and [name not contains 'Fund']

and/or any other word that seems to commonly occur in names of issues you don't want.

Sometimes you might want to eliminate classes of stock but keep the original symbol. If the symbol contains "/", you can eliminate it with:

and [symbol not contains "/"]

Not every instance of classes seems to use the "/" though. Also, if there are classes you do want that include the "/", you can't use this approach.

Note that "name" is not the same as "symbol". So "International Business Machines" is the name and "IBM" is the symbol. I know it's obvious, but it's a mistake I made, so...

macdmacd

Thank you!! I will try those changes. It seems to me, at least, that there should be a more simplistic means to eliminate such entities. Appreciate your detail and willingness to help!