29 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)
    And
    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.

  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.

Leave a Reply to Tinu Winson Cancel reply

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