Not getting wanted barssince result in screener

• 08/05/2025 at 10:47 AM #249360
  sgrech

  some very simply code  below (in theory) and I can’t explain some of the results  eg the screen returns MNG (UK) where the close was last below 20ma 4 bars ago but 32 is returned – this is driving me nuts what on earth am I doing wrong?

  timeframe(monthly)
  ma = average[20](close)

  c1 = barssince(close < ma)

  SCREENER[c1](c1 as “bars”)

   

   

  

  sgrech

  Participant

  Topics: 17

  Replies: 32

  Been thanked: 2 times
  08/05/2025 at 11:12 AM #249363
  robertogozzi

  The line

  c1 = barssince(close < ma)

  1	c1 = barssince(close < ma)

  assigns C1 the bar where the condition has been met, which will ALWAYS retain a value other than 0, so it will always be true, thus returning ALL instruments.

  Try changing the last line so that it only scans the instruments where the condition has only been met within the last 5 (or any other number of your choice) bars:

  SCREENER[c1 <= 5](c1 as “bars”)

  1	SCREENER[c1 <= 5](c1 as “bars”)

   

   

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17743

  Been thanked: 4406 times
  08/05/2025 at 11:40 AM #249366
  JS

  Hi,

  I’m getting the right results…

  Did you set the “Period” to “Month”… ?

  

  JS

  Participant

  Topics: 27

  Replies: 2173

  Been thanked: 1233 times
  08/05/2025 at 11:49 AM #249368
  JS

  It is also possible that your “data” has not yet been adjusted to dividends…

  1 user thanked author for this post.

  robertogozzi

  

  JS

  Participant

  Topics: 27

  Replies: 2173

  Been thanked: 1233 times
  08/05/2025 at 3:16 PM #249378
  sgrech

  So I was not adjusting for dividend, data now look consistent.  Thanks so much.

   

  This leads onto a separate question, should adjustment be enabled or disabled.  The chart for the particular asset I was looking is massively different probably becuase it has a hefty 10% yield!

  

  sgrech

  Participant

  Topics: 17

  Replies: 32

  Been thanked: 2 times
  08/05/2025 at 3:37 PM #249383
  JS

  When you use a “screener” you always have to adjust the data for dividend because a “screener” works with “real-time” data (data adjusted for dividend)…

  

  JS

  Participant

  Topics: 27

  Replies: 2173

  Been thanked: 1233 times
• Author
  Posts