StockFetcher Forums · General Discussion · Help with Filter<< >>Post Follow-up
JohnT328
27 posts
msg #148515
Ignore JohnT328
7/14/2019 6:59:17 PM

Hi, trying to get a filter with this criteria:

Price is more than 5% below MA (600) and exchange is not OTCBB and exchange is not ETF and exchange is not AMEX and volume is above 1,000,000 and price is between 5 and 1000 and price has been below MA (600) for more than 12 months and price was more than 15% below MA (600) within the last 5 months and optionable

If we must use weekly MA (129) in lieu of daily MA (600) that is fine.

When I run this filter, I am not returning any stocks, which does not make sense so I must be doing something wrong. For example, the stock NWL should turn up in this filter because it meets all of the above criteria but it does not.

Can someone please help. Thanks

xarlor
163 posts
msg #148516
Ignore xarlor
7/14/2019 7:33:31 PM

JohnT328, the maximum MA is 400 on SF. Maximum weekly MA is 100. I don't know if this invalidates your strategy, but I wrote one using the weekly MA(100). NWL still did not show up, but could be due to the MA(600) condition.

Fetcher[
/* Maximum MA is 400. Maximum weekly MA is 100 */

optionable
market not otcbb
market not etf
market not amex

set{var1,price}
set{var2,weekly ma(100)}
set{var3,var1/var2}
set{var4,1-var3}
set{var5,count(var4 > 0.05,15)}
var5 > 0

volume > 1000000
close between 5 and 1000
close < var2 for past 12 months

set{var6,count(var4 > 0.15,100)}
var6 > 0
add column var6


draw weekly ma(100)
add column var4

do not draw var2
do not draw var5
do not draw var6
]



JohnT328
27 posts
msg #148518
Ignore JohnT328
7/14/2019 7:51:36 PM

What is the max monthly MA we can use with Stockfetcher?

Not sure why NWL didn't show up in your filter...I think it still should of....

xarlor
163 posts
msg #148521
Ignore xarlor
modified
7/14/2019 9:58:59 PM

I found the problem, here is the corrected filter, and NWL does show now:

Fetcher[
/* Maximum MA is 400. Maximum weekly MA is 100 */

optionable
market not otcbb
market not etf
market not amex

set{var1,price}
set{var2,weekly ma(100)}
set{var3,var1/var2}
set{var4,1-var3}
set{var5,count(var4 > 0.05,1)}
var5 > 0

volume > 1000000
close between 5 and 1000

set{var6,count(var4 > 0.15,100)}
var6 > 0
add column var6

set{var7,count(close < var2,251)}
var7 > 250

draw weekly ma(100)
add column var4

do not draw var2
do not draw var5
do not draw var6
do not draw var7
]



According to the usage guide, weekly and daily are all that is supported. I tried using monthly and yearly with MA but it didn't work, it reverts back to daily.

Fetcher[
draw monthly ma(5)
draw yearly ma(2)
]



StockFetcher Forums · General Discussion · 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 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