MOVING AVRAGE AS SUPPORT SCREENER

• 02/27/2023 at 8:32 AM #210572
  ALBERT77

  Sometimes moving averages can act as support and resistance. I am trying to write a screener that price just crossed over a moving average that acted as a resistance in the last 100 candles.

  C1= ExponentialAverage[I](close) C2=CLOSE CROSSES OVER C1 C3=summation[100]((CLOSE-C1)>0)=1 C4=summation[100]((C1-CLOSE)< (0.005*CLOSE))=2 FOR I= 20 TO 50 DO IF ( C2 AND C3 AND C4) THEN PERIOD=I ENDIF NEXT SCREENER(PERIOD AS "PERIOD")

  1 2 3 4 5 6 7 8 9 10

  C1= ExponentialAverage[I](close) C2=CLOSE CROSSES OVER C1 C3=summation[100]((CLOSE-C1)>0)=1 C4=summation[100]((C1-CLOSE)< (0.005*CLOSE))=2 FOR I= 20 TO 50 DO IF ( C2 AND C3 AND C4) THEN PERIOD=I ENDIF NEXT SCREENER(PERIOD AS "PERIOD")

  

  ALBERT77

  Participant

  Topics: 2

  Replies: 3

  Been thanked: 0 times
  02/27/2023 at 11:36 AM #210589
  Nicolas

  I haven’t look at your conditions, but in your loop, you should refer to your condition at the time of I:

  C1= ExponentialAverage[I](close) C2=CLOSE CROSSES OVER C1 C3=summation[100]((CLOSE-C1)>0)=1 C4=summation[100]((C1-CLOSE)< (0.005*CLOSE))=2 FOR I= 20 TO 50 DO IF ( C2[I] AND C3[I] AND C4[I]) THEN PERIOD=I ENDIF NEXT SCREENER(PERIOD AS "PERIOD")

  1 2 3 4 5 6 7 8 9 10

  C1= ExponentialAverage[I](close) C2=CLOSE CROSSES OVER C1 C3=summation[100]((CLOSE-C1)>0)=1 C4=summation[100]((C1-CLOSE)< (0.005*CLOSE))=2 FOR I= 20 TO 50 DO IF ( C2[I] AND C3[I] AND C4[I]) THEN   PERIOD=I ENDIF NEXT SCREENER(PERIOD AS "PERIOD")

   

  1 user thanked author for this post.

  ALBERT77

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4775 times
  02/27/2023 at 11:57 AM #210592
  Nicolas

  I think the code should be like this, considering you are looking for an EMA between periods 20 to 50 that act as a resistance:

  FOR I= 20 TO 50 DO C1= ExponentialAverage[I](close) C2=CLOSE CROSSES OVER C1 C3=summation[100]((CLOSE-C1)>0)=1 C4=summation[100]((C1-CLOSE)< (0.005*CLOSE))=2 IF ( C2 AND C3 AND C4) THEN PERIOD=I ENDIF NEXT SCREENER(PERIOD AS "PERIOD")

  1 2 3 4 5 6 7 8 9 10

  FOR I= 20 TO 50 DO C1= ExponentialAverage[I](close) C2=CLOSE CROSSES OVER C1 C3=summation[100]((CLOSE-C1)>0)=1 C4=summation[100]((C1-CLOSE)< (0.005*CLOSE))=2 IF ( C2 AND C3 AND C4) THEN   PERIOD=I ENDIF NEXT SCREENER(PERIOD AS "PERIOD")

  The results will always be the longest period found, because the loop will go to the end.

  1 user thanked author for this post.

  ALBERT77

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4775 times
  02/27/2023 at 7:26 PM #210613
  ALBERT77

  Results are not correct.

  for example ,  it screens CVS as a result with ema50 as answer, but last price is not crossing above ema50, in last candles there are other candles above ema50 while we want all below ema50 with one very close to it (with exception of last crossing candle)

  

  

  ALBERT77

  Participant

  Topics: 2

  Replies: 3

  Been thanked: 0 times
  02/28/2023 at 5:28 PM #210666
  Nicolas

  Ok, let’s restart from scratch, what do you mean with:

  ALBERT77 wrote:

  that acted as a resistance in the last 100 candles

  Please?

  

  Nicolas

  Keymaster

  Topics: 81

  Replies: 20863

  Been thanked: 4775 times
  03/01/2023 at 2:05 AM #210692
  ALBERT77

  For example on the following stock (BBAI) EMA 54 acted as a resistance twice in the past similar to resistance lines , now in the pullback it is very close to it again and there is possibility to bounce back again. I am trying to write a screener to examine a range of moving averages for every stock and find any moving average that acted like this example.

   

  

  ALBERT77

  Participant

  Topics: 2

  Replies: 3

  Been thanked: 0 times
  03/01/2023 at 2:22 AM #210694
  ALBERT77

  I forgot to say that in screener formula that i post, it tries to find moving when price finally crosses over moving. Later i will modify it to find them when price pullback to moving.

  

  ALBERT77

  Participant

  Topics: 2

  Replies: 3

  Been thanked: 0 times
• Author
  Posts