How to exclude ETF from type?

MadisonMdot

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

gord

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 ]

gord

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

MadisonMdot

• 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?