how can i scan for not in watchlist

murthysuresh

how can i scan for stocks that is not in my watchlist.
for eg i want to get stocks that meets all the other criteria and its not in my favorite list 66
[TYPE = STOCK] AND [DAILY SMA(20,DAILY VOLUME) >400000] AND [MONTHLY RANGE = MONTHLY MAX(7, MONTHLY RANGE)] AND [[EXCHANGE IS NASDAQ] OR [EXCHANGE IS AMEX] OR [EXCHANGE IS NYSE]] AND [DAILY SMA(20,DAILY CLOSE) > .5] AND [FAVORITES LIST != 66]

lmkwin

[FAVORITES LIST != 66]
or
[
[TYPE = STOCK] AND [DAILY SMA(20,DAILY VOLUME) >400000]
AND [[EXCHANGE IS NASDAQ] OR [EXCHANGE IS AMEX] OR [EXCHANGE IS NYSE]]
]

AND [MONTHLY RANGE = MONTHLY MAX(7, MONTHLY RANGE)] AND [DAILY SMA(20,DAILY CLOSE) > .5]

markd

I don't see anything wrong with the original scan. Does it work?

If not, how did you add the favorites list criteria to the scan? If you typed it in, the scan engine may not recognize it - this has happened to me. Instead, select the list from the Chartlist drop down and add it to the scan and edit the operator - try "is not" if "!=" doesn't work.

Also, lmkwin's order is better - favorites list at the top. However, I would change his "or" to "and". If you say "or", the scan should pick up EVERYTHING not in the favorites list.

lmkwin

I could be incorrect but I think the AND would make the "List" have to meet the 2nd set of requirements. There may be Foreign Stocks or ETF's or Mutual Funds or low volume securities in the "List", that would then be excluded from the last line of the scan because they couldn't pass the 2nd line of requirements.

markd

As I understand it, he does not want the scan to return anything in the list (because his favorites operator "!=" , not "=")

murthysuresh

nope. my scan does not work. it brings in duplicates daily. basically i want to filter out monthly moves that is not in my favorites.

murthysuresh

the working answer is as follows. to use a "IS NOT"
[type = stock]
and [Daily SMA(20,Daily Volume) >400000]
and [monthly range = monthly max(7, monthly range)]
and [[exchange is Nasdaq] or [exchange is AMEX] OR [exchange is NYSE]]
and [Daily SMA(20,Daily Close) > .5]

and [FAVORITES LIST IS NOT 66]// US_increaesd_monthlyRange

markd

I've had trouble with the "!=" operator, too. "is not" works better.