[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



PureBytes Links

Trading Reference Links

JD, you've either missed my reply
http://groups.yahoo.com/group/equismetastock/message/11402
or it's Groundhog Day all over again.

jose '-)

--- In equismetastock@xxxxxxxxxxxxxxx, "John Doe" <ms001122@xxxx> 
wrote:
> 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@xxxx>
> 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 Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/BefplB/TM
---------------------------------------------------------------------~->

 
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/