StockFetcher Forums · General Discussion · Filter returning incorrect results... why?<< >>Post Follow-up
erikjanssen
3 posts
msg #135899
Ignore erikjanssen
5/14/2017 3:43:30 PM

I'm using a filter that shows me when the MACD Histogram goes up while the StochRSI goes down. The results do not match the filter. It gives me totally random stocks, some of which are going down and some are going up. Why? Not even the Average Volume filter is returning correct results. I manually calculated the 30day average volume and it was below the 50k that I wrote in the filter.

MACD Histogram(12,26,9) has been increasing for the last 2 days
and StochRSI(14,14) has been decreasing for the last 2 days
and StochRSI(14,14) above 0
and market is not AMEX
and market is not OTCBB
and market is not ETF
and add column sector
and add column market
and Average Volume(30) above 50000

four
5,087 posts
msg #135900
Ignore four
5/14/2017 4:11:42 PM

"StochRSI(14,14) above 0 "

Do you mean: StochRSI(14,14) above .5

erikjanssen
3 posts
msg #135901
Ignore erikjanssen
5/14/2017 4:33:15 PM

"Do you mean: StochRSI(14,14) above .5"

No, I meant 0. But even without that line it still returns false results.
This also isn't working:
"StochRSI(14,14) < 1 in the last 5 days"

The first result I pulled up didn't get below 1 within the past 25 days. It's supposed to show me results that got below 1 in the last 5 days. What's going on?

four
5,087 posts
msg #135902
Ignore four
5/14/2017 4:44:39 PM

The StochRSI ranges between 0.0 and 1.0.
Midpoint is .5 not 0.

four
5,087 posts
msg #135904
Ignore four
modified
5/14/2017 9:44:48 PM

Having StockFetcher show daily values -- no variables for MACD and STOCHRSI

Fetcher[
and Average Volume(30) above 50000 and add column volume(30)
and market is not AMEX
and market is not OTCBB
and market is not ETF
add column separator
MACD Histogram(12,26,9) has been increasing for the last 2 days
add column MACD Histogram(12,26,9) 3 day ago
and add column MACD Histogram(12,26,9) 2 day ago
and add column MACD Histogram(12,26,9) 1 day ago
and add column MACD Histogram(12,26,9) 0 day ago
add column separator
and StochRSI(14,14) has been decreasing for the last 2 days
add column stochrsi(14,14) 3 day ago
and add column stochrsi(14,14) 2 day ago
and add column stochrsi(14,14) 1 day ago
and add column stochrsi(14,14) 0 day ago
and StochRSI(14,14) above 0.5 and draw stochrsi(14,14) line .5
add column separator
and add column sector
and add column market
]



Having StockFetcher show daily values -- variables for MACD and STOCHRSI

Fetcher[
and Average Volume(30) above 50000 and add column volume(30)
and market is not AMEX
and market is not OTCBB
and market is not ETF
add column separator
AND set{MH, MACD Histogram(12,26,9)}
AND MH has been increasing for the last 2 days
add column MACD Histogram(12,26,9) 3 day ago
and add column MACD Histogram(12,26,9) 2 day ago
and add column MACD Histogram(12,26,9) 1 day ago
and add column MACD Histogram(12,26,9) 0 day ago
add column separator
AND set{SR, StochRSI(14,14)}
AND SR has been decreasing for the last 2 days
and add column stochrsi(14,14) 3 day ago
and add column stochrsi(14,14) 2 day ago
and add column stochrsi(14,14) 1 day ago
and add column stochrsi(14,14) 0 day ago
and SR above 0.5 and draw SR line .5
add column separator
and add column sector
and add column market
]



erikjanssen
3 posts
msg #135906
Ignore erikjanssen
5/14/2017 10:31:01 PM

That looks fine in the table of results on here, but when I load the ticker on my charting software the numbers don't match and the ticker shouldn't have been valid for the screen. Is there something wrong with the market data for stockfetcher? Because it isn't matching up.

StockFetcher Forums · General Discussion · Filter returning incorrect results... why?<< >>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.