StockFetcher Forums · General Discussion · MULTIPLE filters at a time?<< >>Post Follow-up
regcapa
1 posts
msg #100191
Ignore regcapa
4/8/2011 10:52:26 PM

How do I get results searching MULTIPLE filters at a time? I have two stock filters that rarely pull stocks so I want to combine both filters in one search box to generate results.

Morken
7 posts
msg #100225
Ignore Morken
4/13/2011 6:16:35 AM

Yes, a great Idea.



scottechco1
2 posts
msg #100300
Ignore scottechco1
4/18/2011 12:37:14 PM

No one? SF?

Kevin_in_GA
4,553 posts
msg #100303
Ignore Kevin_in_GA
4/18/2011 5:35:00 PM

Yes, it can be done. It would be easiest to show you if you post the two filters, but here is the way to do it.

You have two or more filters that each use a separate set of conditions for entry. Let's say one is a long filter and looks like

Fetcher[

RSI(2) below 1
average volume(50) above 10000000
close above 10
]



and the other is a short version of the same filter, and looks like

Fetcher[

RSI(2) above 99
average volume(50) above 10000000
close above 10
]



Clearly a simple combination of these two would result in 0 stocks returned, because the two RSI requirements are mutually exclusive. But if you use the "count" function as follows, you can get both long and short plays to be pulled up in the same filter. It's done as follows:

Fetcher[

set{entry1, count(average volume(50) above 10000000, 1)}
set{entry2, count(close above 10, 1)}
set{entry, entry1 * entry2}

set{long1, count(rsi(2) below 1,1)}
set{long, entry * long1}

set{short1, count(rsi(2) above 99,1)}
set{short, entry * short1}

set{sum, long + short}

sum above 0.5

add column long
add column short

]



This coding is not really laid out in the SF user manual, but if you look around the forum you'll find examples of thse types of work-arounds.

Hope this helps.

scottechco1
2 posts
msg #100335
Ignore scottechco1
4/20/2011 9:27:53 PM

Thanks for the well-written explanation.

starfox182
24 posts
msg #100378
Ignore starfox182
4/23/2011 6:06:28 AM

Thanks, exactly what I needed too!!! :)

StockFetcher Forums · General Discussion · MULTIPLE filters at a time?<< >>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 2016 - 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