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.

scan return incorrect results

isabelds
isabelds ✭
in Scanning
I created a scan in which I do not want the following 3 groups to be included, but the result of the scan only returns data for those 3 groups. What am I doing wrong?

this is the function I typed in:

and [ [group != Biotechnology] or [group != Pharmaceuticals] or [group != FinancialSector] ]

Thanks for your help!

Comments

  • markd
    markd mod


    Change "or" to "and".

    Biotech is not Pharmaceuticals, so it fits one of your "or" conditions (not Pharmaceuticals), so it's a hit.

    Same for the other two.

    Biotech is Biotech, so it violates one of your "and" conditions, so even if any other number of conditions is true, it won't be a hit because it violates that one "and" condition.

    So, ALL "and" conditions must be true to get a hit.

    But if you have a series of "or" conditions, only ONE has to be true to get a hit (provided all the "and" conditions in the same scan are also true).


    You can leave the syntax as is, or you can rewrite it:

    // previous things
    ...

    // exclude all these groups
    and [group != Biotechnology]
    and [group != Pharmaceuticals]
    and [group != FinancialSector]

    // next things

    ...
  • docuspec
    docuspec ✭
    Hi Mark. I tried the exact code you have right above to exclude Biotech & pharma stocks but when i run my scan with that code, I get zero returns.
    Ant thoughts?
  • docuspec
    docuspec ✭
    I got exclude to work by using "is not" instead of "!="

    and [group is not Biotechnology]
    and [group is not Pharmaceuticals]

    thanks and have a good weekend.
  • isabelds
    isabelds ✭
    Yes, that does work. Thank you.

Categories