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

dryan3
dryan3 ✭
in Scanning
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

  • markd
    markd mod
    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.


  • markd
    markd mod
    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

Categories