52 Week High "X" days ago

• 09/15/2018 at 6:24 PM #80596
  David M

  Hi All,

  New to ProRealCode and ProRealTime.

  Seeking to have a simple Market Screener that allows me to not only search for tickers making a new 52-week high, (i.e. previous daily close = 52-week high), but also to have a variable input for how many days ago it reached a 52-week high (i.e. 5-days ago, 10-days ago, 20-days ago etc.).

  Hope this is clear and imagine this is relatively easy…can anyone help?

  Thanks in advance!

  Best,

  Dave

   

  

  David M

  Participant

  Topics: 1

  Replies: 3

  Been thanked: 0 times
  09/15/2018 at 9:06 PM #80612
  robertogozzi

  There you go:

  52-week high X days ago

  TIMEFRAME(weekly) MyHigh = highest[52](high) //highest in 52 weeks TIMEFRAME(daily) x = (high[10] = MyHigh) //10 days ago was true? TIMEFRAME(default) SCREENER [x]

  1 2 3 4 5 6

  TIMEFRAME(weekly) MyHigh = highest[52](high)  //highest in 52 weeks TIMEFRAME(daily) x = (high[10] = MyHigh)     //10 days ago was true? TIMEFRAME(default) SCREENER [x]

  You can change lookback numbers as they best fit your requirements.

  3 users thanked author for this post.

  PGH, Nicolas, David M

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17138

  Been thanked: 4032 times
  09/23/2018 at 4:27 PM #81125
  David M

  Roberto,

  Much appreciated!…Thank you!

  Wondering if you could help with two small refinements:

  (1) Can we add a variable/condition that filters based on volume (i.e. filter for stocks that have 20-day avg. daily volume greater than 1MM) with the idea being that the “1MM” can be modified?

  (2) Can we add a variable/condition that filters based on a price range (i.e. screen for stocks between X and Y such as $70-$100?)… and again, idea being that the range (or X’s and Y’s) can be modified?

  Thank you in advance!…Really appreciate your help!

  Best,

  Dave

  

  David M

  Participant

  Topics: 1

  Replies: 3

  Been thanked: 0 times
  09/24/2018 at 9:42 AM #81166
  robertogozzi

  David M wrote:

  (1) Can we add a variable/condition that filters based on volume (i.e. filter for stocks that have 20-day avg. daily volume greater than 1MM) with the idea being that the “1MM” can be modified?
  (2) Can we add a variable/condition that filters based on a price range (i.e. screen for stocks between X and Y such as $70-$100?)… and again, idea being that the range (or X’s and Y’s) can be modified?

  On which TF would you like the filters to be applied, Weekly, Daily or Default?
  

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17138

  Been thanked: 4032 times
  09/24/2018 at 12:20 PM #81177
  David M

  Not sure what “default” means but targeting “Daily”.

  appreciate your help Roberto, did go through the various trading videos and even numerous scans in the library to try and do it myself…just couldn’t make those refinements work.

  Thanks in advance!

  Dave

  

  David M

  Participant

  Topics: 1

  Replies: 3

  Been thanked: 0 times
  09/24/2018 at 3:27 PM #81212
  robertogozzi

  This is the updated version (not tested):

  52-week High x Days ago + Volume & Price Range

  TIMEFRAME(weekly) MyHigh = highest[52](high) //highest in 52 weeks TIMEFRAME(daily) x = (high[10] = MyHigh) //10 days ago was true? y = average[20](Volume) > 1000000 //change both Periods and Volume to what best suits your needs z = close >= 0 AND close <= 99999 //change both values to fit your desired range a = x AND y AND z TIMEFRAME(default) //default TF is the one you select for the screener to be executed SCREENER [a]

  1 2 3 4 5 6 7 8 9 10 11

  TIMEFRAME(weekly) MyHigh = highest[52](high)         //highest in 52 weeks   TIMEFRAME(daily) x = (high[10] = MyHigh)            //10 days ago was true? y = average[20](Volume) > 1000000  //change both Periods and Volume to what best suits your needs z = close >= 0 AND close <= 99999  //change both values to fit your desired range a = x AND y AND z   TIMEFRAME(default)                 //default TF is the one you select for the screener to be executed SCREENER [a]

   

   

  1 user thanked author for this post.

  David M

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17138

  Been thanked: 4032 times
  09/30/2018 at 7:24 PM #81630
  David M

  Hi Roberto,

  Just played around with it and it seems to be working perfectly!

  Thanks again for this…greatly appreciated! 🙂

  Happy Trading,

  Dave

  

  David M

  Participant

  Topics: 1

  Replies: 3

  Been thanked: 0 times
  06/12/2023 at 12:51 PM #215999
  OllieB

  Hi,

  Could i ask for a little help to refine this please?  The screener above returns stocks whose 52W high was EXACTLY 10 days ago.

  How can I return a list of stocks where the current price is under the 52W high but that 52W high didn’t appear in the last 10 days? I want to ignore stocks where the 52W high has appeared within the last 10days but the stock price is currently under the 52W high (of more than 10 days ago)?

  I’ve tried with summation but with no luck 🙁

  Thanks.

  

  OllieB

  Participant

  Topics: 10

  Replies: 24

  Been thanked: 4 times
  06/12/2023 at 1:01 PM #216000
  OllieB

  I’ve tried this but couldn’t get it to work…

   

  hh = highest[250](high)   // Find the highest value in last 250 days
  c0 = summation[10](close < hh) = 10  // For last 10 days check that it is less than the highest 250D value

  screener[c0]

   

  

  OllieB

  Participant

  Topics: 10

  Replies: 24

  Been thanked: 4 times
  06/12/2023 at 11:53 PM #216037
  robertogozzi

  There you go:

  TIMEFRAME(weekly) MyHigh = highest[52](high) //highest in 52 weeks // TIMEFRAME(daily) x = (summation[10](high < MyHigh) = 10)//in the last 10 days MyHigh has not been reached y = average[20](Volume) > 1000000 //change both Periods and Volume to what best suits your needs z = close >= 1000 AND close <= 999999 //change both values to fit your desired price range w = close < MyHigh[11] //price below MyHigh for at least 11 days // TIMEFRAME(default) //default TF a = x AND y AND z AND w SCREENER [a]

  1 2 3 4 5 6 7 8 9 10 11 12

  TIMEFRAME(weekly) MyHigh = highest[52](high)             //highest in 52 weeks // TIMEFRAME(daily) x = (summation[10](high < MyHigh) = 10)//in the last 10 days MyHigh has not been reached y = average[20](Volume) > 1000000      //change both Periods and Volume to what best suits your needs z = close >= 1000 AND close <= 999999  //change both values to fit your desired price range w = close < MyHigh[11]                 //price below MyHigh for at least 11 days // TIMEFRAME(default)                     //default TF a = x AND y AND z AND w SCREENER [a]

   

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17138

  Been thanked: 4032 times
  06/13/2023 at 10:44 AM #216111
  OllieB

  Hi Roberto,

  Thank you very much for the quick and concise reply.  It works like a dream.

   

  

  OllieB

  Participant

  Topics: 10

  Replies: 24

  Been thanked: 4 times
• Author
  Posts