kuhllax24
3 posts
msg #43829
- Ignore kuhllax24 |
5/17/2006 10:01:52 PM
Hey everyone, having a little problem writing this in my filter and was looking for some guidance. Basically I'm trying to filter out high beta stocks. The criteria I'm using is:
(Max High of the last 10 days - Max Low of the last 10 days)/Close > 10%
or
(Max High of the last 10 days - Max Low of the last 10 days) > 5
The problem is threefold:
1) I don't know how to ask for the max high and max low of the last 10 days;
2) I don't know how to tell Stockfetcher to find stocks, in which the difference of the high high and low low divided by the close is greater than 10% (basically given Stockfetcher a simple calculation);
3) Does Stockfetcher even have an "or" function? I've only seen "and" used.
Any help would be greatly appreciated.
|
itrademan
70 posts
msg #43830
- Ignore itrademan |
5/18/2006 12:26:55 AM
Try this
|
kuhllax24
3 posts
msg #46449
- Ignore kuhllax24 |
8/17/2006 10:58:46 PM
itrademen,
Thank you so much for devising the high-beta filter for me, I implemented it right after you put it on the forum. I never could've come up with that on my own.
I've noticed, however, that after a couple of months of using it I'm only getting a certain kind of stock: basically any stock that's above $40. It looks like when I implemented the filter, the function "SelStck above 1" always gives me a result of 2. That means that Stockfetcher will only filter stocks that over the past 10 days had an increase of over 10% between its max high and max low, AND the stock price has changed by more than $5 over the last 10 years. Hence the reason why stocks only $40, because lower-priced stocks maybe had a 10% swing in 10 days, but its stock price wasn't changing by $5 in 10 days.
I would like an either/or function, so that it returns stocks that either increased over 10% or had its stock price change by $5.
Can you (or anyone else) help me with the formula? Basically tweaking it so that SelStck does indeed give me an either/or function.
Thank you again.
|
TheRumpledOne
6,411 posts
msg #46468
- Ignore TheRumpledOne |
8/18/2006 2:47:20 PM
Change this
SelStck > 1
to
SelStck > 0
HTH.
|
kuhllax24
3 posts
msg #46470
- Ignore kuhllax24 |
8/18/2006 2:52:17 PM
That made it work.
Thank you so much.
And may all your fills be complete.
|