StockFetcher Forums · Filter Exchange · Filter signaling change of state<< 1 2 >>Post Follow-up
jimmyjazz
102 posts
msg #121021
Ignore jimmyjazz
7/15/2014 4:47:21 PM

This may be really simple, but I am stuck. I want to find stocks where a state defined by multiple indicators has changed as of the last close.

Say I want to find stocks where the close is above both the EMA(5) and SMA(5) but only those where that condition JUST became true. I don't want the whole list of stocks for which that condition is true, but rather just those for which the condition became true TODAY. (For instance, close has been above EMA(5) for several days but just now close exceeded SMA(5) to trigger.)

Does this make sense?

mktmole
325 posts
msg #121022
Ignore mktmole
7/15/2014 4:59:22 PM

try...
Fetcher[set{sma5 ,count(close crossed above ma(5),1)}
and add column sma5
set{ema5 ,count(close above ema(5),1)}
and add column ema5
set{both,sma5 + ema5}
and both above 1 and add column both
and Average Volume(90) is above 50000
and close is between 5 and 250
]



rgds
mm

jimmyjazz
102 posts
msg #121024
Ignore jimmyjazz
7/15/2014 5:35:41 PM

Nice! I'll mess with that. Thanks.

jimmyjazz
102 posts
msg #121025
Ignore jimmyjazz
7/15/2014 5:45:37 PM

OK, I think that's close, but it seems to signal stocks that meet both criteria, not the subset that JUST crossed the threshhold of meeting both criteria. How could I reduce the results to those where at least one of the two criteria has a count = 1?


mktmole
325 posts
msg #121026
Ignore mktmole
7/15/2014 5:55:22 PM

change: both above 0

jimmyjazz
102 posts
msg #121027
Ignore jimmyjazz
7/15/2014 5:57:51 PM

I'm not seeing it. This would include filter results where both were true for the last 5 weeks. I'm trying to only get results for a logical "AND" that just occured today. (In other words, EMA could have been true for weeks, but SMA just turned today, or vice versa. Or both just turned today.)

mktmole
325 posts
msg #121028
Ignore mktmole
7/15/2014 6:59:10 PM

search "A Complete Logic System"

jimmyjazz
102 posts
msg #121029
Ignore jimmyjazz
7/15/2014 7:31:37 PM

Now we're getting somewhere. Thank you very much!

duke56468
683 posts
msg #121030
Ignore duke56468
7/16/2014 5:16:28 PM

Maybe it is just this simple, you can keep adding indicators.

Fetcher[
sp500
close crossed above EMA(5)
]



arnis
18 posts
msg #121033
Ignore arnis
7/17/2014 10:44:46 AM

Could someone please show the "new" filter? I am not sure how to do that. Thank You Arnie

StockFetcher Forums · Filter Exchange · Filter signaling change of state<< 1 2 >>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.