Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 4/15/2007(UTC)
Posts: 14
|
I am trying to develop a "narrow range day" scan. To determine if today is a NRD I want to look at the previous 24 days. Throw out the 2 highest days and the two lowest days. From the 20 days left I will take the average of the range (H-L)/20. I want my NRD to be less than the average of this 20 day range. Can someone tell me how do I write this scan so that the 2 highest and 2 lowest days are excluded from the average range?
Thanks
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602
|
Getting rid of the highest value might look something like:
a1:=sum(H,24)-HHV(H,24);
a2:=sum(L,24)-LLV(L,24);
a3:=(a1-a2)/22;
a3
The second one I am not so sure about.
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 4/15/2007(UTC)
Posts: 14
|
Thanks for the reply John. Yes, the second HH/LL is what is stumping me as well.
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
