Scan on specific date

• 02/09/2019 at 3:46 PM #90936
  prevailution

  Hi,

  I have put in a code for the proscreener that gives live data, or results for end of day scan.

  Am I able to specify the scan to stop at a certain date and see scan results for previous days?

  

  prevailution

  Participant

  Topics: 4

  Replies: 7

  Been thanked: 0 times
  02/11/2019 at 12:18 PM #91036
  Nicolas

  Yes of course, you can base your conditions with any of the date&time instructions: https://www.prorealcode.com/documentation/category/dateandtime/

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4774 times
  02/11/2019 at 2:04 PM #91058
  prevailution

  Thank you for there reply. Sorry I am very new to coding and keep getting syntax error adding the date.

  I want to add Date[N] to this scan

  ONCE Periods = 20 //last 20 bars ONCE PerCent = Periods * 0.9 //90% of times on the rise ONCE RsiNum = 14 MyRsi = rsi[RsiNum](close) SCREENER[summation[Periods](MyRsi > MyRsi[1]) >= PerCent]

  1 2 3 4 5

  ONCE Periods = 20             //last 20 bars ONCE PerCent = Periods * 0.9  //90% of times on the rise ONCE RsiNum  = 14 MyRsi = rsi[RsiNum](close) SCREENER[summation[Periods](MyRsi > MyRsi[1]) >= PerCent]

  How would I do this?

  

  prevailution

  Participant

  Topics: 4

  Replies: 7

  Been thanked: 0 times
  02/11/2019 at 5:18 PM #91081
  Nicolas

  So you want to know if this condition:

  summation[Periods](MyRsi > MyRsi[1]) >= PerCent

  1	summation[Periods](MyRsi > MyRsi[1]) >= PerCent

   
  was true at a specific date only?

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4774 times
  02/11/2019 at 6:46 PM #91091
  prevailution

  Yes I would like to search by date, all stocks that had RSI rising for 20 periods 90% of the time.

  Basically scan for January 6th for example which stocks met this condition at the end of day

  Are you able to add a “search by date” code within the scan?

   

  

  prevailution

  Participant

  Topics: 4

  Replies: 7

  Been thanked: 0 times
  02/13/2019 at 3:10 PM #91300
  Nicolas

  I think that it would work correctly with the below code:

  ONCE Periods = 20 //last 20 bars ONCE PerCent = Periods * 0.9 //90% of times on the rise ONCE RsiNum = 14 MyRsi = rsi[RsiNum](close) idate = 20190106 if summation[Periods](MyRsi > MyRsi[1]) >= PerCent and date=idate then test=1 endif SCREENER[test]

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

  ONCE Periods = 20             //last 20 bars ONCE PerCent = Periods * 0.9  //90% of times on the rise ONCE RsiNum  = 14 MyRsi = rsi[RsiNum](close)   idate = 20190106   if summation[Periods](MyRsi > MyRsi[1]) >= PerCent and date=idate then test=1 endif     SCREENER[test]

  Change “idate” with the date of your choice in YYYYMMDD format.

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4774 times
  02/15/2019 at 2:21 PM #91461
  prevailution

  Nicolas wrote:

  I think that it would work correctly with the below code:

  ONCE Periods = 20 //last 20 bars<br /> ONCE PerCent = Periods * 0.9 //90% of times on the rise<br /> ONCE RsiNum = 14<br /> MyRsi = rsi[RsiNum](close)</p> <p>idate = 20190106</p> <p>if summation[Periods](MyRsi > MyRsi[1]) >= PerCent and date=idate then<br /> test=1<br /> endif</p> <p>SCREENER[test]

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

  ONCE Periods = 20 //last 20 bars ONCE PerCent = Periods * 0.9 //90% of times on the rise ONCE RsiNum = 14 MyRsi = rsi[RsiNum](close) idate = 20190106 if summation[Periods](MyRsi > MyRsi[1]) >= PerCent and date=idate then test=1 endif SCREENER[test]

  Change “idate” with the date of your choice in YYYYMMDD format.

  Yes that’s perfect! Thank you so much!

  

  prevailution

  Participant

  Topics: 4

  Replies: 7

  Been thanked: 0 times
  02/16/2019 at 10:32 AM #91511
  prevailution

  Nicolas wrote:

  I think that it would work correctly with the below code:

  ONCE Periods = 20 //last 20 bars<br /> ONCE PerCent = Periods * 0.9 //90% of times on the rise<br /> ONCE RsiNum = 14<br /> MyRsi = rsi[RsiNum](close)</p> <p>idate = 20190106</p> <p>if summation[Periods](MyRsi > MyRsi[1]) >= PerCent and date=idate then<br /> test=1<br /> endif</p> <p>SCREENER[test]

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

  ONCE Periods = 20 //last 20 bars ONCE PerCent = Periods * 0.9 //90% of times on the rise ONCE RsiNum = 14 MyRsi = rsi[RsiNum](close) idate = 20190106 if summation[Periods](MyRsi > MyRsi[1]) >= PerCent and date=idate then test=1 endif SCREENER[test]

  Change “idate” with the date of your choice in YYYYMMDD format.

  Nicolas one last thing, are you able to add a volume parameter in this code?

  Such that I can input a minimum volume number to filter out the low volume stocks?

  

  prevailution

  Participant

  Topics: 4

  Replies: 7

  Been thanked: 0 times
  02/18/2019 at 11:06 AM #91618
  Nicolas

  Sure, here it is: (adjust the minVolume setting, default is set to 1M)

  ONCE Periods = 20 //last 20 bars ONCE PerCent = Periods * 0.9 //90% of times on the rise ONCE RsiNum = 14 MyRsi = rsi[RsiNum](close) idate = 20190106 minVolume = 1000000 if summation[Periods](MyRsi > MyRsi[1]) >= PerCent and date=idate and volume>minVolume then test=1 endif SCREENER[test]

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

  ONCE Periods = 20             //last 20 bars ONCE PerCent = Periods * 0.9  //90% of times on the rise ONCE RsiNum  = 14 MyRsi = rsi[RsiNum](close) idate = 20190106 minVolume = 1000000   if summation[Periods](MyRsi > MyRsi[1]) >= PerCent and date=idate and volume>minVolume then test=1 endif     SCREENER[test]

   

  1 user thanked author for this post.

  prevailution

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4774 times
  02/18/2019 at 11:38 AM #91621
  prevailution

  Nicolas wrote:

  Sure, here it is: (adjust the minVolume setting, default is set to 1M)

  ONCE Periods = 20 //last 20 bars<br /> ONCE PerCent = Periods * 0.9 //90% of times on the rise<br /> ONCE RsiNum = 14<br /> MyRsi = rsi[RsiNum](close)<br /> idate = 20190106<br /> minVolume = 1000000</p> <p>if summation[Periods](MyRsi > MyRsi[1]) >= PerCent and date=idate and volume>minVolume then<br /> test=1<br /> endif</p> <p>SCREENER[test]

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

  ONCE Periods = 20 //last 20 bars ONCE PerCent = Periods * 0.9 //90% of times on the rise ONCE RsiNum = 14 MyRsi = rsi[RsiNum](close) idate = 20190106 minVolume = 1000000 if summation[Periods](MyRsi > MyRsi[1]) >= PerCent and date=idate and volume>minVolume then test=1 endif SCREENER[test]

  Great, thanks so much Nicolas

  

  prevailution

  Participant

  Topics: 4

  Replies: 7

  Been thanked: 0 times
  02/18/2019 at 2:29 PM #91642
  Vonasi

  prevailution – please don’t hit the ‘Quote’ button for every reply – especially if there is code in the post that you are quoting! Quoting is only necessary if you want to highlight one particular part of someone’s reply that you are responding to or if there are several people in a conversation and you want to show exactly who you are answering. Do this by highlighting the section of interest and then click on ‘Quote’. It is rarely necessary to quote someone’s whole post including their own code back to them – especially in a conversation between only two people! 🙂

  

  Vonasi

  Moderator

  Topics: 192

  Replies: 5088

  Been thanked: 1811 times
• Author
  Posts