|
PureBytes Links
Trading Reference Links
|
Thanks Roy. I'll fiddle with this over the weekend and get back to you. It's
all starting to come back to me...
Is this (dumb) email address being published to all and sundry? Is getting
spam part and parcel of participating on this group?
Jim
----- Original Message -----
From: "Roy Larsen" <rlarsen@xxxxxxxxxxxxxx>
To: <Metastockusers@xxxxxxxxxxxxxxx>
Sent: Friday, November 05, 2004 1:34 PM
Subject: Re: [Metastockusers] Help with IF statement in formula
>
> priapus
>
> You've got the theory right. In this case substituting 1 is OK, but in
some circumstances another
> value such as 0.00001 might be more useful. MetaStock processes the
innermost parentheses first so
> the problem must be fixed BEFORE the division takes place. In the examples
below the If() function
> is processed before the division takes place, so the offending
divide-by-zero error is eliminated
>
> {test for (H-L)=0}
> Cum((( (CLOSE-LOW) - (HIGH-CLOSE) ) /
> If((HIGH - LOW)=0,1,(HIGH - LOW)) ) * VOLUME );
>
> {test for H=L}
> Cum((( (CLOSE-LOW) - (HIGH-CLOSE) ) /
> If((HIGH = LOW),1,(HIGH - LOW)) ) * VOLUME );
>
>
> {test for H=L, same as above but shortened}
> Cum((((C-L)-(H-C))/If((H-L)=0,1,H-L))*V);
>
> A similar question to this was addressed in this month's MetaStock Tips &
Tricks newsletter.
>
>
> Kind regards
>
> Roy Larsen
> www.metastocktips.co.nz
> Free formulas and MS links
>
> > I've recently joined the ranks of RT users and the following
> > indicator is annoying the bloody hell out of me, despite telling
> > MSWIN 9.0 to "Don't show futuure errors for this indicator in this
> > chart".
> >
> > What I think I need to do is create 2 statements such that
> >
> > 1. If the the denominator (HIGH - LOW) = 0, substitute CLOSE
> > 2. If VOL = 0, substitute 1
> >
> > [Improved OBV]
> > Cum((( (CLOSE-LOW) - (HIGH-CLOSE) ) / (HIGH - LOW)) * VOLUME )
> >
> > I hate to impose on the goodwill of this group without first
> > attempting a solution myself, but I'm rusty as hell. Are my steps
> > toward a solution headed in the right direction?
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/zMEolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Metastockusers/
<*> To unsubscribe from this group, send an email to:
Metastockusers-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|