PPO Scan for Securities <-20 or >+20

dryan3

Folks - Please help !

I am trying to run a scan for securities with Weekly PPO <-20 or >+20.
Can you help ...the below is generating OTCMKT and INDEX that I wish to exclude.

thank you



[[type = stock] and [market cap > 2000]]
OR
[type is index]
OR
[[Group is ETF] and [group is ETFNOUI]]

OR

[Exchange is CME] OR [exchange is LSE]


AND

[group is not Sp600]
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]


and [country is not Canada]



AND [Weekly PPO Signal(12,26,9,Weekly Close) <-20]
OR
[Weekly PPO Signal(12,26,9,Weekly Close) >+20]

Rank by "marketcap"

markd

This does not get any OTCMKT or INDEX, but it only gets results for LSE. I think it does not get CME results because stocks and ETFs don't trade there. Also, ETF contains ETFNOUI. This gets 12 results on 5/13/17.

[

[ [type = stock] and [market cap > 2000] ]

OR [Group is ETF]


]

AND [[Exchange is CME] OR [exchange is LSE]]

AND [country is not canada]


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

AND [group is NOT TSE300]
AND [group is not Sp600]
AND [group is not Sp400]

AND

[
[Weekly PPO Signal(12,26,9,Weekly Close) <-20]
OR
[Weekly PPO Signal(12,26,9,Weekly Close) >+20]
]

Rank by market cap

markd

@dryan3 Here's a cleaned up version. It gets only LSE again, but only because +/-20 seems to be an extreme reading for the weekly chart on CME indexes, like $SILVER, and probably on the contracts, too. You can test this by lowering the +/- to say, 2 or 3. You get way too many LSE results that way, but it proves the scan logic is correct. So you might want to do a separate scan for CME.

Here's the cleaned up scan. Note the "or" bracket pairs are labelled to keep them straight:

[ // CME or other

[exchange is CME]

or

[ //LSE or other
[exchange is LSE]

and
[ // stock or etf
[[type = stock] and [market cap > 2000] ]

or

[Group is ETF]

] // stock or etf
] //LSE or other
] // CME or other

AND

[
[Weekly PPO Signal(12,26,9,Weekly Close) <-20]
OR
[Weekly PPO Signal(12,26,9,Weekly Close) >+20]
]

Rank by market cap

dryan3

Mark, this scan appears to miss some securities - such as Hetrz ? Also , ideally I would like to include etf's on the NYSE

Appreciate your help

Damien

markd

@dryan3 Hertz appears to be on the NYSE. This scan looks at LME and CME only. If you want to add exchanges, delete

[exchange is LSE]

and add in its place

[ [exchange is LSE ] or [exchange is NYSE ] or [ exchange is NASD] ]

dryan3

Mark

I have amended the scan to the below: I have also tried to exclude Ultras and inverse ETF's but the scan still includes these. I would appreciate any pointers
Thank you



[ // CME or other

[exchange is CME]

or

[ //LSE or other
[ [exchange is LSE ] or [exchange is NYSE ] or [ exchange is NASD] ]

OR

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

and
[ // stock or etf
[[type = stock] and [market cap > 2000] ]

or

[Group is ETF]

] // stock or etf
] //LSE or other
] // CME or other

AND

[
[Weekly PPO Signal(12,26,9,Weekly Close) <-15]
OR
[Weekly PPO Signal(12,26,9,Weekly Close) >+15]
]

Rank by market cap

markd

It might make more sense to write separate scans for ETFs and stocks. If you specify the exchanges in an "or" statement, it will include everything trading on those exchanges. There doesn't seem to be a way to scan for ONLY inverse and ultra, so I don't see a way to exclude them - if there were one, say a group named "InverseUltra", you would specify [group is not InverseUltra] outside the 'or' statement. Maybe a separate scan for CME, too.

So for stocks only, it would be

[ [exchange is NYSE] or [exchange is NASD] or [exchange is LSE] ]

and [group is not ETF]

AND

[
[Weekly PPO Signal(12,26,9,Weekly Close) <-15]
OR
[Weekly PPO Signal(12,26,9,Weekly Close) >+15]
]

Rank by market cap



For etfs only,

[group is ETFNOUI]

AND etc.

For CME

[exchange is CME]

AND etc.

If you want everything in one list, you can merge the results into that list.