starfox182 24 posts msg #100704 - Ignore starfox182 |
5/13/2011 12:32:38 AM
If you have a filter that gives you 50 results - Filter A let's call it
You also have a filter that gives you 10 results - Filter B let's call it
Most are Filter B's results are on Filter A.
How do I configure it to make it so Filter A excludes the results from Filter B?
Thanks!
|
four 5,087 posts msg #100705 - Ignore four |
5/13/2011 12:49:37 AM
http://forums.stockfetcher.com/sfforums/?qrid=1305187355&mid=32279&isiframe=
|
starfox182 24 posts msg #100706 - Ignore starfox182 |
5/13/2011 1:47:13 AM
I read that thread and it just seemed to be about joining 2 filters together, but I may have understood it wrong. How do I exclude the results from one filter onto another?
Ex: Filter A has symbols: A, B, C, D, & E
Filter B has symbols: D & E
I want Filter A to show the results: A, B & C thus excluding Filter B
|
Kevin_in_GA 4,599 posts msg #100708 - Ignore Kevin_in_GA |
5/13/2011 6:43:36 AM
You can do this the following way:
Say filter 1 screens for stocks that have a MACD that just crossed above 3
and filter 2 screens for stocks where the weekly MACD has also just crossed above 3
You want stocks that meet the first condition (or set of conditions) from filter 1, but not those that also meet the conditions for filter 2.
For this example you can simply say the following
The example above hows you the syntax one can use. In this case it is straightforward because I am only looking at a single condition. To link multiple conditions together, you use a set statement with the count function (as I did here) and simply multiply all of the individual elements together in sequence to get a final set variable that will be either a 1 or 0 (if all conditions are met or not).
|
starfox182 24 posts msg #100712 - Ignore starfox182 |
5/13/2011 9:16:32 AM
Thanks!!!!! :)
|
mohk1234 1 posts msg #100944 - Ignore mohk1234 |
5/28/2011 1:40:21 AM
Hello Kevin_in_GA, I have been following all your posts and screens. I was hoping to chat with you for a sec. Can you contact me on my email at mohinvest@gmail.com?
Thanks!
|