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.

Finding SCTR rank changes over a defined period

Hello can anyone help me with writing a scan to see SCTR rank changes ie say 60-75 for a defined period say over last week, and say defined group ie large cap stocks . I am new and looked at the technical scan writer cant seem to find correct syntax . Thank you !

Comments

  • So you want to know if the Current SCTR.large is 60-75 points different than it was 5 days ago?

    If you were looking for only increased values
    and [(SCTR.large - 5 days ago SCTR.large) >= 60]

    Decreased values you'd have to reverse it to take the 5 days ago reading minus the current to be < -60

    If looking for the up or down either way you can use the Absolute value

    and [AbsVal(SCTR.large - 5 days ago SCTR.large) >= 60]

    BTW, if you were looking for the "between 60 and 75" you would just use the same expression and then add another copy of the expression that says AND the expression is <= 75

    if you want to "see" the values you can use the Rank By as the last line in the scan. NO And in front of the Rank By statement.

    Rank By [AbsVal(SCTR.large - 5 days ago SCTR.large)]
Sign In or Register to comment.