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...
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.
|
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
|