67 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

    1. Hi sushil Kumar,

      You can use below query for 52 week crossover
      LatestClose Crossed above LatestSma(close,200)

        1. Hello,

          Apologies, but I’m afraid that your message isn’t entirely clear. Could you please provide more details on what you are referring to? It would be helpful if you could share an example image for reference purposes. This way, we can better understand your request and create a scan that meets your requirements.

          Make sure you send the image to this email ID: [email protected]

  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.

    thanks

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

  11. 1st 15 minute candle (day opening ki), uske baad ki sab 15 minutes ki candle inside bar ho, or baad me 15 minutes ki koi bhi candle 1st 15 minutes ko break kare vo chartink me kese dale ?
    Jo candle break kare vo kisi bhi number ki candle ho, no specific ki 5th candle break kare.

  12. I want to create a scan as below :
    1) Weekly closing of stocks greater then high of last 1 month closing , this high of last month is 5-10% high of previous 6 months of that stock.
    OR
    2) Weekly closing of stocks greater then high of 6 month closing , this high of 6 month is 5-10% high of last month of that stock.
    Example Bodal Chemicals — high of Jul month 2020 was 87.20, high of jan month was 84.70. In march 1st week , stock closed at 88. above both the highs of 87.20 and 84.70.

  13. 1st 15 minute candle (day opening ki), uske baad ki sab 15 minutes ki candle inside bar ho, or baad me 15 minutes ki koi bhi candle 1st 15 minutes ko break kare vo chartink me kese dale ?
    Jo candle break kare vo kisi bhi number ki candle ho, no specific ki 5th candle break kare.

  14. How to write a scan for below query.
    Stock recently crossed 52week high and made new high but it came back to retest the previous 52week high, how to scan such stocks?

    Example: ABC stock crossed ₹100 which is 52week high and gone to ₹140(new high) but came back to ₹100 retest.

  15. Hi Team,

    How to get scanner for below 2 scenario’s:

    1. crossed 52week high in last 7 days and currently trading below 52week high
    example: stock crossed 100Rs which is 52week high and current price is 80Rs

    2. crossed 52week high and made a new 52week high and currently trading below NEW 52week high and above OLD 52week high.
    example: stock crossed 100Rs which is 52week high and made a new high of 120Rs current price is 110Rs

        1. the below scenario should also give the result of previous 7 days.

          2. crossed 52week high in previous 7 days and made a new 52week high and currently trading below NEW 52week high and above OLD 52week high.
          example: stock crossed 100Rs which is 52week high and made a new high of 120Rs current price is 110Rs

  16. I want a screener by which i can sort stocks which are 20% down fron yearly high.

    5min close crossed over yearly % change * number 20

    I have made it by my own , please tell me will this work as my requirement

Leave a Reply

Your email address will not be published.