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.

PPO Scan for Securities <-20 or >+20

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"

Comments

  • markdmarkd ✭✭✭
    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
  • markdmarkd ✭✭✭
    edited May 13
    @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
  • 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
  • markdmarkd ✭✭✭
    @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] ]
  • 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
  • markdmarkd ✭✭✭
    edited May 15
    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.

Sign In or Register to comment.