StockFetcher Forums · General Discussion · Not getting the intended results<< >>Post Follow-up
JohnT328
53 posts
msg #160929
Ignore JohnT328
3/14/2024 6:05:17 PM

Hi, I am not getting the intended results with this syntax - what language is incorrect?

Price is greater than 5% above MA (63) 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 daily EMA (9) has been above MA (63) for more than 4 months and price has been above MA (50) for at least 4 months and optionable and add column industry and draw RSI(14)

xarlor
587 posts
msg #160930
Ignore xarlor
3/14/2024 7:51:15 PM

Looks fine. What are you expecting to see that is missing or what are you seeing that shouldn't be there?

JohnT328
53 posts
msg #160931
Ignore JohnT328
3/14/2024 8:24:14 PM

For example, these stocks come up in the results and they do not meet the criteria of the filter:

MRO, CVE, HAL

JohnT328
53 posts
msg #160932
Ignore JohnT328
3/15/2024 7:01:23 AM

Hello, can anyone find the issue why this filter is showing results that do not match up with the syntax?

snappyfrog
731 posts
msg #160933
Ignore snappyfrog
3/15/2024 8:46:21 AM

Making it clickable:

Fetcher[
Price is greater than 5% above MA (63)
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 daily EMA (9) has been above MA (63) for more than 4 months
and price has been above MA (50) for at least 4 months
and optionable
add column industry
and draw RSI(14)
]



snappyfrog
731 posts
msg #160934
Ignore snappyfrog
3/15/2024 8:50:38 AM



styliten
303 posts
msg #160935
Ignore styliten
3/15/2024 9:15:16 AM

If you use DEBUG FILTER, you will see

and daily EMA (9) has been above MA (63) for more than 4 months
and close has been above MA (50) for at least 4 months

did not filter out anything. You can use COUNT instead:

and count(EMA(9) < MA (63), 80) < 0.5
and count(close < MA (50), 80) < 0.5

IMG-3804

xarlor
587 posts
msg #160937
Ignore xarlor
3/15/2024 2:49:44 PM

Alternatively, change your wording to:
and daily EMA (9) has been above MA (63) for last 4 months
and price has been above MA (50) for last 4 months

Fetcher[
Price is greater than 5% above MA (63)
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 daily EMA (9) has been above MA (63) for last 4 months
and price has been above MA (50) for last 4 months
and optionable
add column industry
and draw RSI(14)
]



StockFetcher Forums · General Discussion · Not getting the intended results<< >>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.