|
PureBytes Links
Trading Reference Links
|
Shouldn't this be:
if(C>(C-1),V,0)
Lionel Issen
lissen@xxxxxxxxxxxxxx
----- Original Message -----
From: "wdjd" <wdjd@xxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Sunday, December 24, 2000 9: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.
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: owner-metastock@xxxxxxxxxxxxx
> > > [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Bill Irwin
> > > Sent: Saturday, December 23, 2000 6:46 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,)?
> > >
> > > > -----Original Message-----
> > > > From: owner-metastock@xxxxxxxxxxxxx
> > > > [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of neo
> > > > Sent: Saturday, December 23, 2000 4:20 AM
> > > > To: metastock@xxxxxxxxxxxxx
> > > > Subject: RE: Need Help On If function
> > > >
> > > >
> > > > Yes, this is similar to what I did. The problem was that
> > > one color was
> > > > always plotting over another color at the 0 line. I ended up
> > > > just adding a
> > > > null function that is always 0 and plotting it as a wide
> > > > light gray for 0. I
> > > > plotted this on the chart last.
> > > >
> > > > It seems the MS should add a plain If, then function to it's
> > > > If, then, else.
> > > >
> > > > neo
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: owner-metastock@xxxxxxxxxxxxx
> > > > [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of j seed
> > > > Sent: Friday, December 22, 2000 3:29 PM
> > > > To: metastock@xxxxxxxxxxxxx
> > > > Subject: Re: Need Help On If function
> > > >
> > > >
> > > > neo,
> > > > This will only work with an oscillator! Place the following
> > > > at the end of
> > > > your formula and exchange your formula where indicated (not
> > > > in brackets):
> > > >
> > > > A:={YOUR CUSTOM FORMULA HERE};
> > > > Green:=If(A>Ref(A,-1),A,0);
> > > > Red:=If(A<Ref(A,-1),A,0);
> > > > Signal:=Mov(A,5,S);
> > > > Signal;
> > > > Green;
> > > > Red;
> > > >
> > > > This will give you a red, green, and moving average. If you
> > > > do not want the
> > > > moving average signal simply leave all signal references out of your
> > > > formula. Try placing a dark horizontal line at zero or add 0
> > > > to the end of
> > > > your formula so that 0 is the last thing plotted.
> > > >
> > > > J.
> > > >
> > > >
> > > > >From: "neo" <neo1@xxxxxxxxx>
> > > > >Reply-To: metastock@xxxxxxxxxxxxx
> > > > >To: <metastock@xxxxxxxxxxxxx>
> > > > >Subject: Need Help On If function
> > > > >Date: Fri, 22 Dec 2000 11:02:45 -0500
> > > > >
> > > > >I am trying to use the If function to break an indicator in
> > > > two so that it
> > > > >plots in green if up and red if down. The problem is that I
> > > > do not see a
> > > > >pure If function. The only one is an If, Then, Else. If I
> > > > put a 0 for else
> > > > >then I get a color dot there I do not want. Is there
> > > > something that could
> > > > >be
> > > > >put there that would plot no color?
> > > > >
> > > > >I have thought about creating a null function that would
> > > > plot in the same
> > > > >color as the background. Is there another way?
> > > > >
> > > > >neo
> > > > >
> > > >
> > > > _________________________________________________________________
> > > > Get your FREE download of MSN Explorer at http://explorer.msn.com
> > > >
> > > >
> > >
> > >
>
|