52 week low in the past

• 04/25/2024 at 4:11 PM #231955
  marco7630

  Hello,

  I would like to see all the stocks that had a 52 week low close on the 10th of novembre 2023.

  Thanks

   

  gr Marco

  

  marco7630

  Participant

  Topics: 47

  Replies: 109

  Been thanked: 17 times
  04/25/2024 at 6:11 PM #231956
  robertogozzi

  Try this one:

  Timeframe(Weekly) Wlow = close FOR j = 1 TO 51 Wlow = min(Wlow,close[j]) NEXT IF Date > 20231110 THEN Wlow = 999999999 ENDIF // Timeframe(Daily) myLow = Wlow Cond = 0 FOR i = 0 TO 230 IF Date[i] = 20231110 THEN IF close[i] = myLow[i] THEN IF low[i] <> high[i] THEN Cond = close[i] break ENDIF ENDIF ENDIF NEXT SCREENER[Cond](Cond AS "52w low")

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

  Timeframe(Weekly) Wlow = close FOR j = 1 TO 51    Wlow = min(Wlow,close[j]) NEXT IF Date > 20231110 THEN    Wlow = 999999999 ENDIF // Timeframe(Daily) myLow = Wlow Cond  = 0 FOR i = 0 TO 230    IF Date[i] = 20231110 THEN       IF close[i] = myLow[i] THEN          IF low[i] <> high[i] THEN             Cond = close[i]             break          ENDIF       ENDIF    ENDIF NEXT SCREENER[Cond](Cond AS "52w low")

   

  1 user thanked author for this post.

  Iván

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17190

  Been thanked: 4074 times
  04/29/2024 at 7:30 AM #232008
  marco7630

  Hi Roberto,

  Thanks.

   

  Unfortunately it does not work. The results i get are not 52 week lows on the 10th of november 23. In attachment you find the results.

  1 stock of which i am sure it was 52 week low on that date is not in the list. It is: VUZI

  Can you check? Thanks

   

  gr Marco

  

  marco7630

  Participant

  Topics: 47

  Replies: 109

  Been thanked: 17 times
  05/04/2024 at 7:53 AM #232309
  marco7630

  Hi Roberto,

  Could you have a look. Thanks

   

  gr Marco

  

  marco7630

  Participant

  Topics: 47

  Replies: 109

  Been thanked: 17 times
  05/06/2024 at 8:58 AM #232359
  robertogozzi

  You asked for the lowest CLOSE, this is the code for the lowest LOW:

  Timeframe(Weekly) Wlow = low FOR j = 1 TO 51 Wlow = min(Wlow,low[j]) NEXT IF Date > 20231110 THEN Wlow = 999999999 ENDIF // Timeframe(Daily) myLow = Wlow Cond = 0 FOR i = 0 TO 230 IF Date[i] = 20231110 THEN IF low[i] = myLow[i] THEN IF low[i] <> high[i] THEN Cond = low[i] break ENDIF ENDIF ENDIF NEXT SCREENER[Cond](Cond AS "52w low")

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

  Timeframe(Weekly) Wlow = low FOR j = 1 TO 51    Wlow = min(Wlow,low[j]) NEXT IF Date > 20231110 THEN    Wlow = 999999999 ENDIF // Timeframe(Daily) myLow = Wlow Cond  = 0 FOR i = 0 TO 230    IF Date[i] = 20231110 THEN       IF low[i] = myLow[i] THEN          IF low[i] <> high[i] THEN             Cond = low[i]             break          ENDIF       ENDIF    ENDIF NEXT SCREENER[Cond](Cond AS "52w low")

  In addition, try replacing any occurrence of DATE (closing date) by OPENDATE (opening date).

   

  

  robertogozzi

  Moderator

  Topics: 69

  Replies: 17190

  Been thanked: 4074 times
  05/07/2024 at 2:42 PM #232430
  marco7630

  Thanks Roberto

  

  marco7630

  Participant

  Topics: 47

  Replies: 109

  Been thanked: 17 times
• Author
  Posts