Blake: Here are two possible scans.
Because the scans give the close for 10 days after each day the conditions are met, the scans have to stop looking for hits 10 days ago. So the scans below run from trading days -30 to -10. That's a month, or 20 trading days.
I wasn't sure whether you wanted the stock to close at the highest high in 52 weeks (250 days) or the highest close. So these scans give both.
Here's the highest close in 52 weeks:
output="hi.lst"; integer i; for i=-30 to -10 step 1 do if close(i)=max(i,-250+i,cl) and vol(i)>=1.5*avgvol(i,-49+i) then println symbol:-7, "52-week high: ", date(i), " ", Close(i):6:2, " ", " 1 day after high: ", " ", Close(i+1):6:2, " ", " 2 days after high: ", " ", Close(i+2):6:2, " ", " 3 days after high: ", " ", Close(i+3):6:2, " ", " 4 days after high: ", " ", Close(i+4):6:2, " ", " 5 days after high: ", " ", Close(i+5):6:2, " ", " 6 days after high: ", " ", Close(i+6):6:2, " ", " 7 days after high: ", " ", Close(i+7):6:2, " ", " 8 days after high: ", " ", Close(i+8):6:2, " ", " 9 days after high: ", " ", Close(i+9):6:2, " ", " 10 days after high: ", " ", Close(i+10):6:2; endif; next i;
The output will look like this:
AAII 52-week high: 02/18/1999 26.00 1 day after high: 26.16 2 days after high: 26.56 3 days after high: 26.50 4 days after high: 26.50 5 days after high: 25.50 6 days after high: 26.00 7 days after high: 25.50 8 days after high: 25.50 9 days after high: 24.75 10 days after high: 24.50 AAII 52-week high: 02/19/1999 26.16 1 day after high: 26.56 2 days after high: 26.50 3 days after high: 26.50 4 days after high: 25.50 5 days after high: 26.00 6 days after high: 25.50 7 days after high: 25.50 8 days after high: 24.75 9 days after high: 24.50 10 days after high: 23.38 AATI 52-week high: 03/08/1999 24.50 1 day after high: 24.62 2 days after high: 24.62 3 days after high: 24.38 4 days after high: 24.56 5 days after high: 24.62 6 days after high: 24.44 7 days after high: 24.50 8 days after high: 24.50 9 days after high: 24.50 10 days after high: 24.50 AATI 52-week high: 03/09/1999 24.62 1 day after high: 24.62 2 days after high: 24.38 3 days after high: 24.56 4 days after high: 24.62 5 days after high: 24.44 6 days after high: 24.50 7 days after high: 24.50 8 days after high: 24.50 9 days after high: 24.50 10 days after high: 24.50 ABDR 52-week high: 02/23/1999 65.75 1 day after high: 62.50 2 days after high: 65.12 3 days after high: 67.75 4 days after high: 65.75 5 days after high: 65.12 6 days after high: 63.88 7 days after high: 65.12 8 days after high: 68.88 9 days after high: 69.12 10 days after high: 68.38 ABE 52-week high: 02/25/1999 14.19 1 day after high: 14.62 2 days after high: 14.44 3 days after high: 13.50 4 days after high: 13.94 5 days after high: 13.69 6 days after high: 13.25 7 days after high: 13.25 8 days after high: 13.38 9 days after high: 13.62 10 days after high: 14.00 ADAM 52-week high: 02/25/1999 6.50 1 day after high: 5.69 2 days after high: 6.38 3 days after high: 6.12 4 days after high: 5.75 5 days after high: 5.81 6 days after high: 5.75 7 days after high: 5.69 8 days after high: 5.75 9 days after high: 5.62 10 days after high: 6.00 ADRX 52-week high: 02/24/1999 65.88 1 day after high: 66.50 2 days after high: 67.88 3 days after high: 67.62 4 days after high: 66.75 5 days after high: 68.44 6 days after high: 70.12 7 days after high: 71.94 8 days after high: 71.69 9 days after high: 76.53 10 days after high: 77.00 ADRX 52-week high: 03/03/1999 68.44 1 day after high: 70.12 2 days after high: 71.94 3 days after high: 71.69 4 days after high: 76.53 5 days after high: 77.00 6 days after high: 78.50 7 days after high: 77.38 8 days after high: 77.25 9 days after high: 74.00 10 days after high: 73.38 ADVP 52-week high: 03/01/1999 43.50 1 day after high: 47.50 2 days after high: 46.88 3 days after high: 48.12 4 days after high: 49.25 5 days after high: 48.50 6 days after high: 46.62 7 days after high: 48.62 8 days after high: 50.00 9 days after high: 54.88 10 days after high: 54.88 ADVP 52-week high: 03/02/1999 47.50 1 day after high: 46.88 2 days after high: 48.12 3 days after high: 49.25 4 days after high: 48.50 5 days after high: 46.62 6 days after high: 48.62 7 days after high: 50.00 8 days after high: 54.88 9 days after high: 54.88 10 days after high: 55.00 ADVP 52-week high: 03/04/1999 48.12 1 day after high: 49.25 2 days after high: 48.50 3 days after high: 46.62 4 days after high: 48.62 5 days after high: 50.00 6 days after high: 54.88 7 days after high: 54.88 8 days after high: 55.00 9 days after high: 56.62 10 days after high: 57.06 ADVP 52-week high: 03/05/1999 49.25 1 day after high: 48.50 2 days after high: 46.62 3 days after high: 48.62 4 days after high: 50.00 5 days after high: 54.88 6 days after high: 54.88 7 days after high: 55.00 8 days after high: 56.62 9 days after high: 57.06 10 days after high: 56.38 ADVP 52-week high: 03/12/1999 54.88 1 day after high: 54.88 2 days after high: 55.00 3 days after high: 56.62 4 days after high: 57.06 5 days after high: 56.38 6 days after high: 57.44 7 days after high: 56.75 8 days after high: 55.00 9 days after high: 55.38 10 days after high: 54.12 ADVP 52-week high: 03/15/1999 54.88 1 day after high: 55.00 2 days after high: 56.62 3 days after high: 57.06 4 days after high: 56.38 5 days after high: 57.44 6 days after high: 56.75 7 days after high: 55.00 8 days after high: 55.38 9 days after high: 54.12 10 days after high: 55.00
To get the stock closing at the highest high in 52 weeks, use this one:
output="hi.lst"; integer i; for i=-30 to -10 step 1 do if close(i)=max(i,-250+i,hi) and vol(i)>=1.5*avgvol(i,-49+i) then println symbol:-7, "52-week high: ", date(i), " ", Close(i):6:2, " ", " 1 day after high: ", " ", Close(i+1):6:2, " ", " 2 days after high: ", " ", Close(i+2):6:2, " ", " 3 days after high: ", " ", Close(i+3):6:2, " ", " 4 days after high: ", " ", Close(i+4):6:2, " ", " 5 days after high: ", " ", Close(i+5):6:2, " ", " 6 days after high: ", " ", Close(i+6):6:2, " ", " 7 days after high: ", " ", Close(i+7):6:2, " ", " 8 days after high: ", " ", Close(i+8):6:2, " ", " 9 days after high: ", " ", Close(i+9):6:2, " ", " 10 days after high: ", " ", Close(i+10):6:2; endif; next i; |