StockFetcher Forums · General Discussion · Questions on creating filter<< >>Post Follow-up
4 posts
msg #81716
Ignore bensim
10/25/2009 10:12:40 AM

Dear all, I am trying to create a filter in SF 2.0 to generate a list of stocks which meet the following criteria:

a. price above 50
b. Average volume of last 30 days > 250000
c. 10 day exponential ma > 20 day exponential ma > 200 day exponential ema
d. MACD: fast period - 9 days, slow period - 15 days, signal line - 9 days. MACD rises above signal line
e. MACD Histogram (9,15,9) rises above zero
f. Slow stochastic: %K period - 9 days, %D period - 15 days and %K cross above %D
g. Plot the various charts and lines
This is what I have done and I hope that someone can let me know whether it is correct. Thanks and cheers.

Show stocks where close is above 50
and average volume(30) is above 250000 do not draw average volume(30)
and EMA(10) is above EMA(20)
and EMA(10) is above EMA(200)
and EMA(20) is above EMA(200)

and Show stocks where MACD Fast Line(9,15) crossed above the MACD Slow Line(9,15)

and show stocks where MACD Histogram(9,15,9) crossed above 0

and Show stocks where Slow Stochastic(15,9) Fast %K crossed above Slow Stochastic(15,9)

and draw EMA(10)
and draw EMA(20)
and draw EMA(200)
and draw MACD Fast Line(9,15)
and draw MACD Slow Line(9,15)
and draw MACD Histogram(9,15,9)
and draw Slow stochastic(15,9)

2,817 posts
msg #81723
Ignore chetron
10/25/2009 12:39:49 PM

you only have to use "and", if you don't use carriage return
there is no value added to the phrase "show stocks where/that".
if you use an unnested measure for filtering, it is drawn automatically.
a measure can never cross itself on the same day
histograms are only 2 value, never 3.
fast/slow line crosses is the same as the histogram cross, redundant

close is above 50
average volume(30) is above 250000
do not draw average volume(30)
EMA(10) is above EMA(20)
EMA(10) is above EMA(200)
EMA(20) is above EMA(200)

MACD Histogram(9,15) crossed above 0

Slow Stochastic(15,9) %K crossed above Slow Stochastic(15,9) %d


4 posts
msg #81757
Ignore bensim
10/26/2009 9:43:13 AM

Many thanks. Will try it out.

StockFetcher Forums · General Discussion · Questions on creating filter<< >>Post Follow-up

*** Disclaimer *** 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. does not recommend particular securities., 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