Moving average screener

• 02/23/2023 at 2:18 AM #210216
  rob.es

  hi,

  I tried to write a screener to find stocks which the current high is equal to or very close to 200 simple moving average. but the results are so off:

  the attached is screenshot of one of the results that is not matching my code.

  thank you

  ma= Average[200](close) c1= ma-high <= ma * 0.95 screener [c1]

  1 2 3

  ma= Average[200](close) c1= ma-high <= ma * 0.95 screener [c1]

  

  rob.es

  Participant

  Topics: 5

  Replies: 11

  Been thanked: 2 times
  02/23/2023 at 6:21 AM #210218
  JS

  Hi Rob,

  If you want to use 5% of the MA as the maximum distance between (MA-High) then the code is:

  C1 = ma – High <= ma * 0.05

  Or better:

  C1 = Abs (ma – High) <= ma * 0.05

  

  JS

  Participant

  Topics: 27

  Replies: 1806

  Been thanked: 876 times
  02/23/2023 at 6:27 AM #210219
  rob.es

  thank you

  1 user thanked author for this post.

  JS

  

  rob.es

  Participant

  Topics: 5

  Replies: 11

  Been thanked: 2 times
• Author
  Posts