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.

% Price below most recent 52 week high

Abuelo
Abuelo ✭
in Scanning
This has to be a simple scan but my mind isn't working this morning .... how do I write a scan for % < last 52 week high and rank by this value? .... Goal is to find stocks which are at least 20% below their last 52 week low .... Thanks ....

DaveB

Best Answer

  • markd
    markd mod
    edited February 2019 Answer ✓
    You will probably want to include an upper and lower bound, or you will get too many hits. So for instance, this gets stocks between 70 and 80 per cent of the one year high.

    and [close < Upper Price Chan(251) * 0.8]
    and [close > Upper Price Chan(251) * 0.7]

    I'm not sure what you mean by rank by value. If you mean by close

    rank by close

    If you mean by percent of one year high

    rank by [close/Upper Price Chan(251)]

Answers

  • Abuelo
    Abuelo ✭
    markd .... thanks .... exactly what I was looking for .... couldn't remember the "channels"

Categories