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 can i scan for not in watchlist

murthysuresh
murthysuresh ✭
in Scanning
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]

Comments

  • lmkwin
    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
    markd mod
    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
    lmkwin ✭✭
    edited July 2020
    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
    markd mod
    As I understand it, he does not want the scan to return anything in the list (because his favorites operator "!=" , not "=")
  • murthysuresh
    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
    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
    markd mod
    I've had trouble with the "!=" operator, too. "is not" works better.

Categories