35 thoughts on “52-week high/low scan”

  1. 1 day ago Max(7,Latest High ) -1 day ago Min(7,Latest Low ). —– what does this mean ? total calculation is 1 day ago but whats this latest high means. ?

    1. 1 day ago max(..) in this context relates to the max function, which calculates the maximum based on the latest high (you can also calculate the maximum a day ago using a offset of 1/2/3.. for the parameters in the max)

  2. What is the exact difference between
    Latest close greater than max(30, 1 day ago close)
    Latest close greater than 1 day ago max(30, latest close)

    1. In this case, its the same and would produce the same results. The ability to have a offset for min/max function allows you to control the dataset for all measures that are within the function. So, you can have a filter like, “close greater than 1 day ago max(20, Latest open + 1 day ago high)”

  3. Hi Akash ,

    I want to know whether todays low is lower than the lows of previous 5 days, so i have written following scan function but its not showing any result. Is it written correctly, please let me know.Thanks

    Latest Min(5,Latest Low ) Greater than Latest Low

  4. How to use Max and Min function?
    Inside of Max function (Duration,Value) what it is described, what is the outcome of parameter?
    If I pass
    Latest max(5, latest close) what is the meaning of entire function?

  5. Hi,
    Can anyone help me to get stocks

    Calculate the range between the true high of the last two days and the true low of the last two days
    2. Calculate this true range in two day blocks for the previous three occasions
    3. Current range is lower than the previous three ranges

  6. Thanks for sharing the post. The way you narrated the post is good and understanding. After reading this post and the links you provide in comments I learned some new things. Keep posting. Please let me know for the upcoming posts.

  7. Please give me a scan which tells me 52 week high for a particular date in the past. For eg if I want the 52 week high prices of Nifty 500 Stocks as on 31 Mar 2020 what should be the scan.

      1. [0] 15 minute Macd Line ( 26,12,9 ) >= [0] 15 minute Max ( 24 , [0] 15 minute Macd Line ( 26,12,9 ) )

        please help me to understand the above code

        1. Hello,
          It checks if current MACD line (15 min) is greater than maximum than previous 24 candles macd line value. Correct scan for the same would be:

          “[0] 15 minute Macd Line ( 26,12,9 ) >= [-1] 15 minute Max ( 24 , [0] 15 minute Macd Line ( 26,12,9 ) )”

  8. Hi,
    This is not giving correct scans as you have not put BRACKET before dividing by 3. So, it is dividing by 3 only last entry and not sum of all 3 entries. I think you should put a Bracket for sum of 3 (High,Low,Close) and then divide by 3. When I tried with Bracket it is giving error. Can you redo and post.

  9. hi,

    how can i scan for stocks that have broken out (break out) of the last high (not previous high) during the 6 months, ie i want to scan stocks that have cross the last high within 6 months time.


  10. What is the syntax of latest high above then last 10days high
    Is there any specific syntax to identify breakout for intraday

Leave a Reply

Your email address will not be published. Required fields are marked *