Price above 200 MA for 5 months.

• 09/20/2022 at 10:11 PM #201111
  Mary

  Hello,
  How do you describe a condition for Screener where you want to screen stocks whose Price is above 200 Moving Average for 5 months straight, not less, not more, Exactly  5 months?

  Thank you.

  

  Mary

  Participant

  Topics: 35

  Replies: 40

  Been thanked: 4 times
  09/21/2022 at 10:31 AM #201131
  Nicolas

  You can code it like this, with a monthly timeframe that has sufficient history to compute a 200 period moving average:

  timeframe(monthly) c1 = summation[5](close>average[200])=5 screener[c1]

  1 2 3 4

  timeframe(monthly) c1 = summation[5](close>average[200])=5   screener[c1]

  or you can also make it on a daily timeframe, to check for the last 100 days (which is roughly 5 months of trading days)

  timeframe(daily) c1 = summation[100](close>average[200])=100 screener[c1]

  1 2 3 4

  timeframe(daily) c1 = summation[100](close>average[200])=100   screener[c1]

   

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4775 times
  09/21/2022 at 8:30 PM #201172
  Mary

  Thank you Nicolas!

  

  Mary

  Participant

  Topics: 35

  Replies: 40

  Been thanked: 4 times
• Author
  Posts