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 585 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 728 posts msg #160933 - Ignore snappyfrog |
3/15/2024 8:46:21 AM
Making it clickable:
|
snappyfrog 728 posts msg #160934 - Ignore snappyfrog |
3/15/2024 8:50:38 AM
|
styliten 302 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
|
xarlor 585 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
|