StockFetcher Forums · Filter Exchange · Filter not getting the correct results<< >>Post Follow-up
JohnT328
53 posts
msg #157510
Ignore JohnT328
9/7/2021 8:59:51 PM

Hi, I am trying to run this filter and I don't seem to be getting all the results that this filter should generate. For example, MSFT should meet all the requirements but it does not show up in the results. What is wrong with the syntax?

Price is greater than 3% above MA (129) and exchange is not OTCBB and exchange is not ETF and exchange is not AMEX and volume is above 5,000,000 and price is between 15 and 1000 and EMA (9) has been above MA (129) for more than 2 months and price has been above EMA (97) for at least 2 months and price has been above EMA (17) for the last 10 days and add column sector and add column Historical Volatility(100,1) and optionable

THanks

wantonellis
161 posts
msg #157515
Ignore wantonellis
9/8/2021 7:02:30 AM

Fetcher[
Price is greater than 3% above MA(129)
exchange is not OTCBB
exchange is not ETF
exchange is not AMEX
volume is above 5,000,000
price is between 15 and 1000
count(EMA(9) > MA(129),41) equal 41 /* around 20 trading days equal 1 month */
count(price > EMA(97),41) equal 41
count(price has been above EMA(17),10) equal 10
add column sector
add column Historical Volatility(100,1)
stock is optionable
]



nibor100
1,044 posts
msg #157516
Ignore nibor100
9/8/2021 10:18:36 AM

@JohnT328,

1. I believe you syntax works fine, if you run the filter after hours; as your volume requirement of 5M is not reached for many stocks until later in the day.

If I change that line to
volume 1 day ago is above 5,000,000
then I get 23 results including MSFT on a scan at 10:15am today.

2. You can always check your filter for any single stock symbol by clicking on the Star drop down and choosing Check filter for symbol which gives you a line by line breakdown for your chosen symbol vs. your filter lines.

Ed S.



StockFetcher Forums · Filter Exchange · Filter not getting the correct 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.