JohnT328
53 posts
msg #149010
- Ignore JohnT328 |
8/29/2019 2:07:09 PM
Hi, I am looking for a filter that will include the below syntax:
"Price is greater than 5% above MA (375)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 15 and 1000 and weekly EMA (9) has been above MA (300) for more than 18 months and price has been above MA (300) for at least 18 months and optionable"
But I also want to include that price has been within a 10% range for the last 8 weeks
Can someone please assist. Thanks
|
xarlor
587 posts
msg #149011
- Ignore xarlor |
8/29/2019 2:53:02 PM
John, these 2 lines always return 0 results. They're too extreme.
Even halving that to 9 months was only showing a few results per year. I went with 6 months just to get something on the filter. You may have to tweak your parameters.
|
JohnT328
53 posts
msg #149013
- Ignore JohnT328 |
8/29/2019 3:30:22 PM
First, thank you for the quick response.
I think there might be something wrong here because when I run my filter with just this language, it returns over 117 stocks:
"Price is greater than 5% above MA (375)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 15 and 1000 and weekly EMA (9) has been above MA (300) for more than 18 months and price has been above MA (300) for at least 18 months and optionable"
I don't think your original two lines as noted below, contemplate my wording above...
weekly ema(9) > ma(300) for last 18 months
close > ma(300) for last 18 months
]
|
four
5,087 posts
msg #149014
- Ignore four |
8/29/2019 3:54:15 PM
I don't believe MONTHS can be used.
StockFetcher works with DAYS and WEEKS.
|
xarlor
587 posts
msg #149015
- Ignore xarlor |
8/29/2019 4:40:18 PM
four, I'm not sure that's right. I use MONTHS in several filters. It works, as well as YEARS. Here are some tests that check out.
|
xarlor
587 posts
msg #149016
- Ignore xarlor |
8/29/2019 4:48:31 PM
John, your filters are written in a syntax that SF does not parse. Take the lines below. You can see that it returns results that it shouldn't.
|
four
5,087 posts
msg #149018
- Ignore four
modified |
8/29/2019 9:47:47 PM
Thanks xarlor.
|