StockFetcher Forums · Public Filter List · all time highs<< >>Post Follow-up
MJ64
15 posts
msg #149347
Ignore MJ64
10/15/2019 1:50:45 PM

Looking for a filter that will show stocks say 5% from an all time high not just a 52 week high and with increasing volume ..

xarlor
585 posts
msg #149349
Ignore xarlor
10/15/2019 2:58:58 PM

For the purposes of highs and lows, SF is limited to the last 3 years. With that in mind, I wrote the filter looking for stocks that are within 5% of their 3-year high.

Fetcher[
close > 1
average volume(30) > 1234567

set{3YRhi,high 3-year high}
set{var1,close / 3YRhi}
set{PercentFromHi,1 - var1}
PercentFromHi < 0.05

add column 3YRhi
add column close
add column PercentFromHi
sort by column 7 ascending

draw price line at 3YRhi
do not draw percentfromhi
]



MJ64
15 posts
msg #149350
Ignore MJ64
10/15/2019 3:03:13 PM

Thanks

xarlor
585 posts
msg #149369
Ignore xarlor
10/17/2019 3:06:24 PM

Thanks to nibor, I was able to extend this filter to 15 years. It looks like that is the cap, it breaks if trying to add more.

Fetcher[

close > 1
average volume(30) > 1234567

set{x1,high 3-year high}
set{x2,x1 3 years ago}
set{x3,x2 3 years ago}
set{x4,x3 3 years ago}
set{x5,x4 3 years ago}
set{var1,max(x1,x2)}
set{var2,max(var1,x3)}
set{var3,max(var2,x4)}
set{15YH,max(var3,x5)}

set{z1,close / 15YH}
set{PercentFromHi,1 - z1}

PercentFromHi < 0.05

add column x1
add column x2
add column x3
add column x4
add column x5
add column 15YH

add column close
add column PercentFromHi
sort by column 12 ascending

draw price line at 15YH
do not draw percentfromhi
do not draw x5
]



MJ64
15 posts
msg #149371
Ignore MJ64
10/17/2019 6:27:46 PM

Thanks.

StockFetcher Forums · Public Filter List · all time highs<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2022 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.