StockFetcher Forums · Filter Exchange · Is there a way to identify how many days highest/lowest close today is?<< >>Post Follow-up
stephenmcmahon83
12 posts
msg #150675
Ignore stephenmcmahon83
2/5/2020 1:52:22 PM

For 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.

xarlor
280 posts
msg #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
]



nibor100
522 posts
msg #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.


Copyright 2018 - 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.