wrong results with simple moving average rebound screener

• 10/02/2017 at 9:20 AM #47971
  lore

  Hi,
  I have been using this very simple screener for a while to look for stocks in uptrend rebounding on the 50 days moving average. It was actually working until I started to obtain also values below the moving average as in the file attached. Cannot find on what I am wrong.
  This is the screener code

  a=Average[50] c1= summation[30](close>a)=30 c2=low<a screener [c1 and c2]

  1 2 3 4 5 6 7

  a=Average[50]   c1= summation[30](close>a)=30   c2=low<a   screener [c1 and c2]

  and attached you see the file with one of the stocks I get: there are also a few closes below the 50 day moving average when I put the condition of the last 50 closes being above it.

  thank you

  

  lore

  Participant

  Topics: 1

  Replies: 2

  Been thanked: 0 times
  10/02/2017 at 11:20 AM #47983
  Nicolas

  This is odd, your code should work correctly. On the NASQAQ stocks list, I do not get any result right now, do you still have that problem this morning?

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4775 times
  10/02/2017 at 12:02 PM #47989
  lore

  yes … i keep on getting results below the moving averge.. especially the most recent ones

  

  lore

  Participant

  Topics: 1

  Replies: 2

  Been thanked: 0 times
  10/02/2017 at 12:53 PM #48001
  Nicolas

  Do you have live subscription to NASDAQ Stocks list? Still don’t have any results in my screener window today for this code. Do you?

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4775 times
  10/03/2017 at 5:31 AM #48077
  lore

  have these results today

  and they apear to be correct

  this is weird because yesterday I got completely wrong results with the same code

  

  lore

  Participant

  Topics: 1

  Replies: 2

  Been thanked: 0 times
  10/16/2017 at 8:16 AM #49485
  Nicolas

  About this issue, I heard that it was a problem in Daily timeframe only and it has now been fixed, do you agree?

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4775 times
  01/13/2021 at 5:12 PM #157675
  dave_moz

  Hi,

  I see this is an old post but I think I’m seeing a similar issue in that ProScreener returns different values of EMA than what is actually on the chart.

  Doing some tests I see that ProScreener thinks the EMA200 is ~1.5% lower than what it actually is.

  Did you resolve your issue and does this sound anything like the same thing?

   

  Thanks.

  

  dave_moz

  Participant

  Topics: 4

  Replies: 10

  Been thanked: 1 time
  01/13/2021 at 5:59 PM #157686
  Nicolas

  Your problem is not related, a 200 periods EMA needs more than 254 bars to calculate, which is the history limit of ProScreener, therefore the value may differ. I suggest you use an arithmetic moving average instead, SMA200 is ok.

  1 user thanked author for this post.

  dave_moz

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4775 times
  01/14/2021 at 12:03 PM #157797
  dave_moz

  I see, that makes sense.

  Thank you.

  

  dave_moz

  Participant

  Topics: 4

  Replies: 10

  Been thanked: 1 time
• Author
  Posts