StockFetcher Forums · Filter Exchange · It pays to double check your Filter logic<< >>Post Follow-up
nibor100
1,010 posts
msg #153513
Ignore nibor100
8/12/2020 12:06:46 PM

A few days ago the following filter was posted and it struck me that it might not be delivering the specific results that the user was hoping for so below I've provided some comments that might be pertinent. In any case it always pays to look at several charts to see if you are getting what you expect.

Fetcher[
offset 95
average volume(30) > 300
price is below 2
set{30h,close 30 day high}
set{30l,close 30 day low}
set{dip1,30h/30l}
set{dip2,1 - dip1}
set{dip,dip2 * 100}
market cap above 500
add column 30h
add column 30l
add column dip
sort by column 7 descending
chart-time 7 months
]



1. This filter was designed to find specific stocks that dropped the least in the recent late winter market drop and it uses a series of set functions looking for values that occurred over a prior 30 day period.

a. It uses a specific offset number of days which means that any user will have to change that offset value if they want to cover the same timespan in the past as the day the filter was posted.
There is a way to set that date offset so it never would have to be changed, by using the following statement:

offset 3/24/2020

b. That filter appears to be also looking for stocks below $2 with specific average volume criteria but these are limiting the filter to those stocks that only meet those criteria at the end of the 30 day period not the beginning of the 30 day period which could effect results. Look at MFAs chart to get an idea of what I mean.

c. I believe Market Cap is one of the SF indicators that does not have access to historical values so it will only find stocks that meet the most recent Market Cap criteria which may exclude some that met it back in Feb.

d. If you examine the chart of SWN, which is about the 4th stock returned in the result list, you'll see that the stock really did not dip as much from early Feb, as it's results position would indicate, due to the fact that it had a mid March spike in price which affected the 30 day high being used by the Set statements.

Another possible way to look at the possible dips on an SF chart and results is to add the following Max Drawdown lines to the filter, a side benefit is you actually get specific max dd line drawn on the price chart:

add column Maxdd(30)
draw Maxdd(30)

Ed S.




StockFetcher Forums · Filter Exchange · It pays to double check your Filter logic<< >>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.