abokhalidf
7 posts
msg #36427
- Ignore abokhalidf |
6/23/2005 5:53:21 PM
HI to every one
Can some body help me to create a filter that shows stocks at new 52 weeks new low measured from Moving Average (20).
In other words, I want to see the stocks with the highest gap from MA (20) in 26 weeks.
Thanks
|
TheRumpledOne
6,411 posts
msg #36433
- Ignore TheRumpledOne |
6/23/2005 9:10:30 PM
DIFF52HI is the largest gap from ma(20) down to the close.
DIFF52LO is the largest gap from the close DOWN to the ma(20) that's why it's negative.
But you said 52 weeks then you said 26 weeks, so I am not sure.
26 week version:
MAY ALL YOUR FILLS BE COMPLETE.
|
abokhalidf
7 posts
msg #36436
- Ignore abokhalidf |
6/24/2005 3:30:29 AM
TheRumpledOne
Thanks a lot
you provided great help to me, I will use this filter to find stocks for different periods ( 52, 26, 12 weeks....etc)
The 26 weeks shall be corrected to 52 weeks in my question above.
I use this filter only when MA (50) is increasing, and it picks significant jump sometimes
Best regard
|
TheRumpledOne
6,411 posts
msg #36443
- Ignore TheRumpledOne |
6/24/2005 9:02:55 AM
Column E50XE50 will show you the number of days the ma(50) has been increasing (+) or decreasing (-). Sorting on this column puts the stocks with ma(50) increasing at the top of the list.
How do you like that?
MAY ALL YOUR FILLS BE COMPLETE.
|
abokhalidf
7 posts
msg #36460
- Ignore abokhalidf |
6/25/2005 6:06:46 AM
TheRumpledOne
Great help from you, appreciated.
I will use this filter like the following:
Moving Average (20) as an example
I will look to the stocks that are below the MA (20) as per the filter and I will add the following to the filter:
And RSI (2) is at new 12 weeks low
Then, I keep monitoring RSI (2) to start to go up (for example to cross 30) and this is an entry point. The target is optional or near the MA (20)
Exceptions:
I do not use this tactic under the below conditions
1- Gaps
2- Going below the selected Moving Average for the first time in long period for example 1 year
Best regard
|
TheRumpledOne
6,411 posts
msg #36461
- Ignore TheRumpledOne |
6/25/2005 11:33:38 AM
I think you are "teasing" me, Abokhalidf.
I took your idea but, once again, rather than filter out the stocks, I added the r12 column... if equal 1, then stock at rsi(2) 12 week low.
I sort r12 descending so the ones that are at 12 week low pop to the top!
Cool, eh?
MAY ALL YOUR FILLS BE COMPLETE.
|