Error found in ProRealTime ProScreener tool.

• 03/24/2016 at 11:19 AM #4200
  drecio

  Hi, I think there is an error in ProrealTime ProScreener.

  I wrote an easy Year To Date % performance code, but it is not working:

  There is a radio button to toogle between lowest/highest values. The thing is it shows only the lowest values for NYSE, NASDAQ, EURONEXT, etc.. But if I want to show the highest values for these markets then shows nothing.

  Please note that If I choose another market like France 40 then it does show both the highest and lowest values, It’s a bit weird.
  This is the code. Kind Regards.

  if date=20151231 then // You can change this date to whatever you want and you'll get the same result. No highest values d1=Close endif // YTD % //var=((close/d1)-1)*100 var=((close-d1)/d1)*100 SCREENER (var as "s")

  1 2 3 4 5 6 7 8 9

  if date=20151231 then // You can change this date to whatever you want and you'll get the same result. No highest values    d1=Close endif   // YTD % //var=((close/d1)-1)*100 var=((close-d1)/d1)*100   SCREENER (var as "s")

   

  

  drecio

  Participant

  Topics: 2

  Replies: 1

  Been thanked: 0 times
  03/24/2016 at 11:48 AM #4211
  Nicolas

  Hi drecio,

  Please tell us what is the number of matches for the screener that dont return anything ?

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4774 times
  03/24/2016 at 6:50 PM #4275
  drecio

  Hi you can find attached 2 screenshots of a NYSE screening. In both cases (lowest and highest values) there are 3220 matches. But the list only is populated when lowest values are selected, if you select highest values the list shows nothing.

  Regards

   

  

  drecio

  Participant

  Topics: 2

  Replies: 1

  Been thanked: 0 times
  03/24/2016 at 8:26 PM #4294
  Nicolas

  Thanks for your examples. I will investigate more deeply to find what cause this behaviour.

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4774 times
  03/25/2016 at 4:30 PM #4383
  Nicolas

  I found how to solve your problem. It seems that your d1 variable were set to 0 because there were no candle at this date. So ProScreener met a bug that It cannot divide something by 0 (zero divide error that many coders known 🙂 )

  So here is the code that solve this issue. If the daily candle dont exist, then the previous candle is taken.

  once d1set = 0 if d1set = 0 then d1=close endif if date>=20151231 then d1set = 1 endif var=((close-d1)/d1)*100 SCREENER(var as "s")

  1 2 3 4 5 6 7 8 9 10 11

  once d1set = 0 if d1set = 0 then d1=close endif   if date>=20151231 then d1set = 1 endif   var=((close-d1)/d1)*100 SCREENER(var as "s")

   

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4774 times
• Author
  Posts