Re: Need Help On If function

["Glen Wallace" <gcwallace@xxxxxxxx>]

I haven't been following this thread, but how about:

            If(Parameter1, Parameter2, Prev)

This will plot the previous value of the indicator if the condition is false.

I think Jim's zero-plot solution (below) would be the best workaround,
but to prevent the zero-plots from screwing up your Y-axis scale, set
or fix the minimum Y-axis value.  If you want to avoid the distracting
lines heading off the chart, you could also set the line style to a histogram.

Hope this helps.  Merry Christmas, all.


----- Original Message -----
From: "wdjd" <wdjd@xxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Sunday, December 24, 2000 7:13 AM
Subject: Re: Need Help On If function

> Neo
> The 'If' function is simply a true/false function.
> If, as an example, you wanted to know the volume on up days:
> If(C>O,V,0)
> and you wanted to eliminate the '0' you can simply rewrite the formula as
> V*(C>O)
> This will give you the same result. The true statement returns a 1.
> Therefore multiplication of the true expression by the desired result
> will give you the desired result and nothing else.
>
> Jim
>
> neo wrote:
>
> > Bill
> >
> > I have tried putting both nothing and "" but I get a syntax error. It
> > appears that MS is missing a simple If Then function. As stated before,
> > this is something the company should correct.
> >
> > neo
> >
> > -----Original Message-----
> > From: owner-metastock@xxxxxxxxxxxxx
> > [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Bill Irwin
> > Sent: Sunday, December 24, 2000 1:48 AM
> > To: metastock@xxxxxxxxxxxxx
> > Subject: RE: Need Help On If function
> >
> > But can't the Else be nothing?  I suppose I could answer this question by
> > trying it and seeing if I get a syntax error in the formula.  In Excel I
> > use "" as the Else option if I don't want to do anything.
> >
> >
> > > -----Original Message-----
> > > From: owner-metastock@xxxxxxxxxxxxx
> > > [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of neo
> > > Sent: Saturday, December 23, 2000 6:00 PM
> > > To: metastock@xxxxxxxxxxxxx
> > > Subject: RE: Need Help On If function
> > >
> > > >>>You mean it won't accept do nothing, as in IF(something is true, do
> > > something,)?<<<
> > >
> > > As far as I can tell MS does not have an If Then function. It
> > > only has an If
> > > Then Else function. This is something the company should correct.