deprez
60 posts
msg #28022
- Ignore deprez |
8/24/2003 9:06:00 PM
Hi,
I want to get a 26 day high not including today.
I want today to be greater than 26 day high.
I tried
Any suggestions welcome. Thanks.
|
murknd
62 posts
msg #28023
- Ignore murknd |
8/24/2003 9:56:28 PM
deprez,
You can tweak with ...
... or ...
but I have a feeling you want the new 26 day high to be higher then the high the last 26 days ... and you don't necessarily want the high to be higher than the previous day for each of the last 26 days (like the count filter above) ... if so this is problematic I think. I too have tried this in trying to create a box breakout filter. Here's a 10 day filter that does that, but you can imagine it could get a little hairy if you want 26 days or even longer. Read my Box Theoy Filters post in Filter Exchange on the details. At the same time once you write this filter it will work, but it would not be very friendly if you wanted to frequently change the number of days. I'm going to keep working on this.
D
|
deprez
60 posts
msg #28024
- Ignore deprez |
8/24/2003 10:38:48 PM
Thanks for your help. I read the box theory posts.
Its seems that box theory is but a glorified view of a new peak.
I thought with a simple lag on the high we would have the same
results that Darvas showed.
You seem to be searching for something similar in your filter.
Unfortunately, I think your filter starts at a fixed time period in the past and may not achieve/assign BoxHigh as a true PEAK. I think it is important to get that peak so that our breakout is significant i.e. continues a trending peak-trough progression.
I have not yet read Darvas' book, but have read numerous postings and web sites illustrating the idea. I think it is just common sense to buy a stock on break-out which continues upward peak-trough progrssion.
|
deprez
60 posts
msg #28025
- Ignore deprez |
8/24/2003 10:43:33 PM
I realize that a 26 day high does not necessarily give a PEAK either.
It is very possible that the peak was 35 days ago and myhigh is on the slippery slope. In these cases, I aver that further analysis may be necessary.
|
deprez
60 posts
msg #28026
- Ignore deprez |
8/24/2003 10:47:15 PM
My real question to Stock Fetcher is
why doesn't the LAG FUNCTION work in my example.
|
murknd
62 posts
msg #28028
- Ignore murknd |
8/24/2003 11:51:22 PM
... it does work if you get the syntax correct
try this ...
but I still don't think that's what we're looking for.
The filter I posted works (it does identify the peak 10 days ago) for 10 days and will work for 26 days ... and will work for 26 weeks - you just have to decide over what duration you want to make sure all the highs have been lower until today ... as I said the only problem is it can get rather hairy and long if you want long periods of time or if you want to change the frequency often.
D
|
murknd
62 posts
msg #28029
- Ignore murknd |
8/25/2003 12:20:49 AM
I think this is VERY close - check it out!!
D
|