StockFetcher Forums · General Discussion · Difficult problems need smart guy's help: How to find stocks earn above 5% each month?<< >>Post Follow-up
rrrbbbggguo
29 posts
msg #58400
Ignore rrrbbbggguo
12/21/2007 5:07:06 PM

Can anyone help with this:

How to find stocks earn above 5% each month in recent two months?

I have thought it long time, but can't figure out.

nikoschopen
2,824 posts
msg #58403
Ignore nikoschopen
12/21/2007 6:28:50 PM

This will calculate the stock's cumulative daily performance for the previous four weeks (see the "%chg" column) and for another previous four weeks prior to that (%chg (-1mo) column).

Fetcher[
set{chg, sum(day change,20)}
set{%chg, count(chg above 5,1) * count(chg 4 weeks ago above 5,1)}
%chg above 0
add column chg{%chg}
add column chg 4 weeks ago{%chg (-1mo)}
]



rrrbbbggguo
29 posts
msg #58406
Ignore rrrbbbggguo
12/21/2007 9:16:19 PM

Niko:

Looks great! thank you!

Could you also make a filter that solve the problem of:

stochastic drop over 90% in recent 1-3 months?

TheRumpledOne
6,358 posts
msg #58411
Ignore TheRumpledOne
modified
12/21/2007 10:11:40 PM

Fetcher[
/* 5 weeks performance display */

set{chg, sum(day change,5)}
set{chg10, count(chg > 10, 100) }

add column chg10
add column chg{%chg(wk)}
add column chg 1 week ago{%chg (-1wk)}
add column chg 2 weeks ago{%chg (-2wk)}
add column chg 3 weeks ago{%chg (-3wk)}
add column chg 4 weeks ago{%chg (-4wk)}

market is nasdaq 100

sort column 6 descending
]



Thanks for the idea Niko!!





StockFetcher Forums · General Discussion · Difficult problems need smart guy's help: How to find stocks earn above 5% each month?<< >>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