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.

Scans - to exclude LSE with Market Cap Less £500 million

Hi Folks
In my PPO Scan, I am trying to exclude UK stocks that have a market Cap < $500m: The below doesn't appear to work!
Welcome any suggestions
thank you


[[type = stock] and [market cap > 2000]] // note the double [[ ]" here- rationale here is that the stock and market cap are combined - ie the mktcap restriction does not apple to other criteria



OR

[Group is ETFNOUI] // include ETF's BUT EXCLUDE Ultras and inverse ETF's

OR

[Exchange is CME]
OR
[[exchange is LSE] and [market cap > 1000000]]



AND


[group is not Sp600] // this is probably irrelevant as I have stated above Mkt cap > 2000


AND [group is not Sp400]
AND [country is not canada]
AND [group is NOT TSE300]


and [exchange is NOT NSE]
and [exchange is NOT OTCMKT]
and [exchange is not TSE]


// COUNTRY

and [country is not Canada] // this is probably irrelevant as I have stated above "exchange is not TSE"

AND

[
[Weekly PPO Signal(12,26,9,Weekly Close) <-12]

]

Rank by market cap

Comments

  • markdmarkd ✭✭✭
    I think you need one more pair of brackets around your "or" statements, to isolate them from your "and" statements. So the opening bracket would precede [[type is stock... and the closing bracket would precede AND [group is not sp600... etc.


  • markdmarkd ✭✭✭
    Try this:

    [ // "grand or" open

    [Group is ETFNOUI]

    OR

    [Exchange is CME]

    OR

    [[exchange is LSE] and [market cap > 1000000]]

    OR

    [ // stock conditions statement open
    [type = stock]
    and [market cap > 2000]
    and [exchange is NOT OTCMKT]
    and [group is not Sp600] // this is probably irrelevant as I have stated above Mkt cap > 2000
    AND [group is not Sp400]
    AND [country is not canada]
    and [exchange is NOT NSE]
    ] // stock conditions statement close

    ] // "grand or" close


    AND


    [Weekly PPO Signal(12,26,9,Weekly Close) <-12]


    Rank by market cap
Sign In or Register to comment.