[EquisMetaStock Group] How to remove 3 highest/lowest values in a range

["John Doe" <ms001122@xxxxxxxxxxx>]

Jose,

Believe me I know MS's limitations! I was just curious when you use the same
name twice, does MS "process" just the 2nd one or both? Also, your 2nd use
of xBoxedPrds itself refers to xBoxedPeriods
[xBoxedPds:=If(xBoxedPds=0,.000001,xBoxedPds);] - can this create errors?
Finally, in the the last argument
[xBoxedAvg:=Sum(If(x=xBoxed,x,0),pds)/xBoxedPds;], MS will refer to which
xBoxedPrds - the 1st or the 2nd? Just curious to know...

JD
=======================================================

From: "Jose" <josesilva22@xxxxxxxxx>
Reply-To: equismetastock@xxxxxxxxxxxxxxx
To: equismetastock@xxxxxxxxxxxxxxx
Subject: [EquisMetaStock Group] Re: How to remove 3 highest/lowest values in
a range
Date: Tue, 23 Mar 2004 01:58:50 -0000

John,

Unfortunately MetaStock provides limited formula space (2.5Kb) and
variable count (20).  Often we need to reuse variables just to get by.

But in this case, I'm just modifying xBoxedPds to avoid division by
zero errors, so I find it appropriate to reuse this variable.
Rename any variables to any name that suits you.

Take care not to lose sight of the forest by concentrating on the
trees.

jose '-)



--- In equismetastock@xxxxxxxxxxxxxxx, "John Doe" <ms001122@xxxx>
wrote:
 > Great job, but 2 minor Qs just occurred to me, Jose.
 > 1) You have xBoxedPds used twice, each time with a different
formula;
 > perhaps you should rename one of them to avoid any confusion
 > 2) You think LoMin should be renamed to LoMax as that appears more
 > appropriate?
 >
 > JD
 > ==========================================
 >
 > From: "Jose" <josesilva22@xxxx>
 > Reply-To: equismetastock@xxxxxxxxxxxxxxx
 > To: equismetastock@xxxxxxxxxxxxxxx
 > Subject: [EquisMetaStock Group] Re: How to remove 3 highest/lowest
values in
 > a range
 > Date: Fri, 19 Mar 2004 12:09:20 -0000
 >
 >
 > John, ignore my last post.
 > This is closer to what you want:
 >
 > ==========
 > Box filter
 > ==========
 > ---8<-----------------
 >
 > { Box filter v2.2 }
 > { Filters out three-highest/lowest values }
 > { ©Copyright 2004 Jose Silva }
 > { http://users.bigpond.com/prominex/pegasus.htm }
 > { Insert price or indicator formula
 >    to be box-filtered below}
 > x:=Mo(5);
 >
 > pds:=Input("Box filter lookback periods",
 >   2,2520,21);
 >
 > Hi1:=HHV(x,pds);
 > Hi2:=HHV(ValueWhen(1,x<Hi1,x),pds);
 > Hi3:=HHV(ValueWhen(1,x<Hi2,x),pds);
 > HiMin:=Min(Hi1,Min(Hi2,Hi3));
 >
 > Lo1:=LLV(x,pds);
 > Lo2:=LLV(ValueWhen(1,x>Lo1,x),pds);
 > Lo3:=LLV(ValueWhen(1,x>Lo2,x),pds);
 > LoMin:=Max(Lo1,Max(Lo2,Lo3));
 >
 > HiLim:=Max(HiMin,LoMin);
 > LoLim:=Min(HiMin,LoMin);
 > xBoxed:=If(x>HiLim,HiLim,If(x<LoLim,LoLim,x));
 > xBoxedPds:=Sum(x=xBoxed,pds);
 > xBoxedPds:=If(xBoxedPds=0,.000001,xBoxedPds);
 > xBoxedAvg:=Sum(If(x=xBoxed,x,0),pds)/xBoxedPds;
 >
 > x;xBoxedAvg;xBoxed
 >
 > ---8<-----------------
 >
 > jose '-)
 >

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar – get it now! 
http://toolbar.msn.com/go/onm00200415ave/direct/01/



 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
     http://groups.yahoo.com/group/equismetastock/

<*> To unsubscribe from this group, send an email to:
     equismetastock-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
     http://docs.yahoo.com/info/terms/