52 week low in the past

Viewing 6 posts - 1 through 6 (of 6 total)

Author

Posts
04/25/2024 at 4:11 PM #231955 quote

marco7630
Participant

New

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

04/25/2024 at 6:11 PM #231956 quote
robertogozzi
Moderator

Legend
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")
```
Iván González thanked this post
04/29/2024 at 7:30 AM #232008 quote

marco7630
Participant

New

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

2024-04-29_08-29-31.png

05/04/2024 at 7:53 AM #232309 quote

marco7630
Participant

New

Hi Roberto,

Could you have a look. Thanks

gr Marco

05/06/2024 at 8:58 AM #232359 quote
robertogozzi
Moderator

Legend
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")
```
In addition, try replacing any occurrence of DATE (closing date) by OPENDATE (opening date).
05/07/2024 at 2:42 PM #232430 quote

marco7630
Participant

New

Thanks Roberto
Author

Posts