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

dryan3

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

markd

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

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