hsinchou
1 posts
msg #35908
- Ignore hsinchou |
5/5/2005 2:59:48 PM
To help a newbie.
Can any help me design a search for MA(20), MA(50), MA(100), and MA(200) Crossover within the last 5 days and price range or all are within 2% of all MA?
Thank you in advance.
|
TheRumpledOne
6,411 posts
msg #35911
- Ignore TheRumpledOne |
5/5/2005 9:53:14 PM
Not 100% sure what you mean...
this will give the stocks where the close crossed above the ma(20):
this will give you stocks where the ma(20) crossed above the ma(50):
But what you may what is one of my "secret" displays:
Of course, add your own price and volume criteria!!
The ma_xover column can be sorted to show you stocks that most recently crossed over the ma20, then ma50, etc..
You can change the "crossed above" to "closed above" and then add the line "and c3 = 1111" to get stocks that are above all 4 moving averages!
You can do a lot with this filter now.
For the record, my good buddy, CEGIS, helped me with this "secret code " a long time ago.
MAY ALL YOUR FILLS BE COMPLETE.
|
marine2
963 posts
msg #35912
- Ignore marine2 |
5/6/2005 2:10:05 AM
To thin the filtered list down from what TheRumpledOne's filter gives you, you would perhaps add these extra lines to his filter:
and slow stochastic %D is below 20 previous 1 day
and price is between .25 to 10
and cci(14) is below 0
and price increasing previous 2 days
Of course you can always adjust the price of stock your after (example: 1 to 50 etc). Those lines I just showed you will significantly thin the stock picks down for you.
Goodluck and happy investing.
|
TheRumpledOne
6,411 posts
msg #35930
- Ignore TheRumpledOne |
5/7/2005 3:03:39 PM
Marine2:
You missed the point of the filter and thread completely!!
The whole idea with the C3 display column/variable is that you can sort on it and pick the stocks you want MANUALLY OR you can specify C3 = 1111 and get nothing but stocks that crossed over all 4 moving averages.
Adding other code DILUTES the filter.
Plus you can apply this filter to a WATCH LIST and track the movement of your favorites.
The point of this thread was to search for moving average crossovers!
|
hchou
1 posts
msg #35948
- Ignore hchou |
5/8/2005 11:52:37 PM
Thank you TheRumpleDone and Marine2.
I didn't quite get TheRumpleDone's filters. I am too new. I tried it and it's not what I am looking for.
What I am looking for is that MA(20), MA(50), MA(100), and MA(200) intersecting each other within X days (let's say last 5 days). I don't care which one is up or down as long as they are coming together recently. But I would like the current values of MAs to be within X percent of each other (let's say 3%).
Thank you for your help.
Hchou
|
marine2
963 posts
msg #35974
- Ignore marine2 |
5/12/2005 1:04:55 AM
TheRumpledOne, watered down or thinned out so myself and others wont have so many to choose from and becoming confused on just which one to choose from was my purpose. Again, you state your reasoning and I state mine. Let the forum members make their choice. No, Rump, you don't need to respond to this. Yes, Rump, like you always say, it's not the stock that is important but how you trade it.
Happy investing and sure make some money too!
|
TheRumpledOne
6,411 posts
msg #35986
- Ignore TheRumpledOne |
5/12/2005 11:17:01 PM
Marine, I understand what you mean.
However, when you sort the ma trend column the better candidates pop to the top.
So rather than limiting the picks, the filter allows the user the flexibility to sort.
One point, I download the results to Excel because I can sort on 3 columns as opposed to one.
MAY ALL YOUR FILLS BE COMPLETE.
|
marine2
963 posts
msg #35988
- Ignore marine2 |
5/13/2005 2:15:16 AM
Thanks Rump for the reply. You do have a great process there. It does show you the most encouraging ones. The more you work with these tools more keeps bubbling out and making things even better.
|
cegis
235 posts
msg #36012
- Ignore cegis |
5/16/2005 3:16:45 PM
TheRumpledOne,
Do you realize that you are ALREADY sorting on *FOUR* columns (a1, a2, a3, and a4) when you sort on c3?
As long as your nested set{}s don't go too deep, you can sort on as many columns as you want (in theory), using the same basic method. You can even mix ascending and descending sorting between the columns. Here's an example (to show the technique, not that this is a very usable filter in and of itself...):
(Note: I divided the close by 100 because SF was having issues with large numbers. I wanted to use xpppppccccc, not xppppp.ccccc, but this still works...)
HTH,
C
|
TheRumpledOne
6,411 posts
msg #36014
- Ignore TheRumpledOne |
5/16/2005 8:11:28 PM
CEGIS...lol I know that about c3!!
|