Can someone help me to make a screener with weekly highest high?

• 09/22/2020 at 8:35 AM #144944
  Alex C

  Hi,

  Can someone help me develop a screener with following criteria?

  1. High this week was the highest in 50 weeks
  2. High this week was at least 200% the high 50 weeks ago or greater than 150% of the lowest low the past year
  3. Volume this week is greater than 130% of average volume the past 50 weeks
  4. Closed this week greater than $20

  Thanks in advance for the help…

  

  Alex C

  Participant

  Topics: 2

  Replies: 3

  Been thanked: 0 times
  09/22/2020 at 9:02 AM #144954
  Nicolas

  Could you please update your profile with your country?

  Here is the screener code you are requesting:

  c1 = high>highest[50](high)[1] c2 = high>=high[50] c3 = volume>=1.3*average[50](volume) c4 = close>20 screener[c1 and c2 and c3 and c4]

  1 2 3 4 5 6

  c1 = high>highest[50](high)[1] c2 = high>=high[50] c3 = volume>=1.3*average[50](volume) c4 = close>20   screener[c1 and c2 and c3 and c4]

   

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20864

  Been thanked: 4777 times
  09/22/2020 at 10:16 AM #144970
  Alex C

  Updated.

  Thanks for your help 🙂

   

  I saw you can backtest strategies on prorealtime, how should i proceed to see if such a screener is producing any interesting results to look further into?

   

  Thanks in advance

  

  Alex C

  Participant

  Topics: 2

  Replies: 3

  Been thanked: 0 times
  09/22/2020 at 10:23 AM #144971
  Alex C

  Are you sure about the second criteria?

  High this week was at least 200% the high 50 weeks ago or greater than 150% of the lowest low the past year

  ?  c2 = high>=high[50]

   

   

  

  Alex C

  Participant

  Topics: 2

  Replies: 3

  Been thanked: 0 times
  09/22/2020 at 10:26 AM #144973
  Nicolas

  By learning to code? 😀

  You can simulate the percentage change of price over the stocks lists since the first detection of this screener criteria:

  if test = 0 then c1 = high>highest[50](high)[1] c2 = high>=high[50] c3 = volume>=1.3*average[50](volume) c4 = close>20 if c1 and c2 and c3 and c4 then test = 1 start = barindex endif endif screener[test](roc[max(1,barindex-start)])

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

  if test = 0 then c1 = high>highest[50](high)[1] c2 = high>=high[50] c3 = volume>=1.3*average[50](volume) c4 = close>20 if c1 and c2 and c3 and c4 then test = 1 start = barindex endif endif   screener[test](roc[max(1,barindex-start)])

   

   

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20864

  Been thanked: 4777 times
  09/22/2020 at 10:27 AM #144974
  Nicolas

  Sorry, you are right, you have to multiply the High[50] by 2:

  c2 = high>=high[50]*2

  1	c2 = high>=high[50]*2

   

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20864

  Been thanked: 4777 times
  09/22/2020 at 11:03 AM #144978
  Alex C

  Ok thanks again  I’ll learn the prorealcode syntax 🙂

  Great suggestion too 🙂

  How do I add the second part of the second criteria which I think isn’t complete:

  High this week was at least 200% the high 50 weeks ago or greater than 150% of the lowest low the past year

  c2 = high>=high[50]*2 OR high>lowest[52](low)*1.5

   

  and what does this 1 mean in the first criteria? high>highest[50](high)[1]

   

   

   

  

  Alex C

  Participant

  Topics: 2

  Replies: 3

  Been thanked: 0 times
  09/22/2020 at 11:06 AM #144979
  Nicolas

  Your syntax is correct for the c2 condition.

  The [1] is an offset 1 bar before the current one. Because the current high cannot be greater than the highest high on the current bar, otherwise it would be itself the highest high.

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20864

  Been thanked: 4777 times
• Author
  Posts