StockFetcher Forums · General Discussion · Need help with filter<< >>Post Follow-up
msteve
6 posts
msg #157626
Ignore msteve
9/22/2021 6:38:35 AM

I'm new here. Need simple filter for last day's open less than prior day's low. Tried many variations, and nothing seems to work.

styliten
303 posts
msg #157627
Ignore styliten
modified
9/22/2021 9:51:31 AM

where open is below low 1 day ago

where open is more than 3% below low 1 day ago

where open divided by low 1 day ago between 0.97 and 0.999999 (i.e. open < low 1 day ago, but within the 3% threshold)

where count(open is below low 1 day ago, 10) > 0.5 (i.e., happened at least once in the last 10 days)

etc., etc.


nibor100
1,044 posts
msg #157628
Ignore nibor100
9/22/2021 9:57:50 AM

This might be what you want:

Fetcher[
open is less than low 1 day ago
add column open add column low 1 day ago
]



There are several sample filters under the Examples header on the SF webpage that could have given you some starting points.

Also at the bottom of the SF webpage is the SF manual/ Usage guide

Ed S.

msteve
6 posts
msg #157630
Ignore msteve
9/22/2021 12:26:26 PM

Thanks! I appreciate it.

StockFetcher Forums · General Discussion · Need help with filter<< >>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.