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

RE: Need Help On If function



PureBytes Links

Trading Reference Links

neo,

I'm going to give you a "wild" suggestion that may just work and honestly I 
have not tried it myself but have been a victim of the problem. There is one 
metastock indicator that does not plot...that is the "ref" statement when it 
is misused! By misused, I mean that you cannot plot into the future so there 
is no plot. My suggestion is to use a ref({your formula},+6) wherever you 
wish the no plot. Remember the reference must be to the positive(looks 
forward) not the negative(looks back). I openly admit this is off the wall 
but it might do the trick.

J.


>From: "neo" <neo1@xxxxxxxxx>
>Reply-To: metastock@xxxxxxxxxxxxx
>To: <metastock@xxxxxxxxxxxxx>
>Subject: RE: Need Help On If function
>Date: Sun, 24 Dec 2000 11:53:55 -0500
>
> >>>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<<<
>
>Jim
>
>Interesting way to look at it but it seems it would result in the same
>problem. If the logical expression is false then the entire expression 
>would
>return a 0 which is the same problem. I want a simple If Then rather than 
>an
>If Then Else so that if the expression is not true then nothing would be
>plotted. I think MS needs to add an If Then expression. This way if the
>expression were true then the formula would be executed. If it were not 
>true
>then nothing would happen rather than have a 0 returned.
>
>Thanks, neo
>

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com