StockFetcher Forums · Filter Exchange · Is there a way to identify how many days highest/lowest close today is? << >>Post Follow-up
 stephenmcmahon8312 postsmsg #150675- Ignore stephenmcmahon83 2/5/2020 1:52:22 PMFor example, if you have list of stocks, and stock ABC just reached the highest close in the most recent 86 days, have an 86 show up in a column. If it is the lowest close in 86 days, have a -86 show up. If stock BCD just reached a 6 day highest close, have a 6 show up, and so on and so forth, in one column for your entire list of stocks. I know it is possible to have a 1 show up if todays close is the highest close in the last xx days (your choice), but Id really prefer the actual numerical that identifes exactly how high or low todays closing price is. Any assistance here would be greatly appreciated. xarlor280 postsmsg #150707- Ignore xarlor 2/7/2020 1:00:40 AM Fetcher[ chart-time 1 year set{var1,days(high equals 52-week high,212)} add column var1 {Days since 52-week high} draw high 52-week high sort column 5 descending ] nibor100522 postsmsg #150722- Ignore nibor100 2/8/2020 10:26:59 AM@stephenmcmahon83, The filter below should provide you the numbers you want in 1 column based on your request. note however it does not count any stock whose most recent close = the close of the prior day. Ed S. Fetcher[ close > 2 volume above 200000 set{var12, close - close 1 day ago} add column var12 show stocks where abs(var12) is above 0 set{var1, days(close < close 1 day ago,100)} set{var2, -1 * days(close > close 1 day ago,100)} set{rundays, var1 + var2} add column rundays ]
 StockFetcher Forums · Filter Exchange · Is there a way to identify how many days highest/lowest close today is? << >>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.