PureBytes Links
Trading Reference Links
|
Hi Roy,
So what can I do so that Explorer ignores the N/A and gives me a
result without discarding all results?
Thanks,
Dorsey
--- In equismetastock@xxxxxxxxxxxxxxx, "Roy Larsen" <rlarsen@xxxx>
wrote:
> Charlie
>
> IsUndefined() will work to the point that it gives a 0 (zero) when
the code is undefined, and a 1
> (one) when it is defined. That's great if all you want to know is
if the code is defined or not.
>
> But hang on a minute. He already knows that, because he gets an N/A
when it's undefined, and a
> legitimate value when it's defined. In fact the IsUndefined()
function is worse than the first
> problem because it's incapable of giving any value other than zero
or one.
>
> The sad truth is that IsDefined() and IsUndefined() are crippled
functions that solve very few of
> the problems one would expect them to. Using them to enclose code
restricts the possible outputs to
> zero and one, and leaving the problem code outside these functions
just perpetuates the N/A problem.
>
> These functions promise much and deliver virtually nothing. The
solution lies elsewhere.
>
>
> Kind regards
>
> Roy Larsen
> www.metastocktips.co.nz
> Free formulas and MS links
>
>
> ----- Original Message -----
> From: "Charlie" <huasang@xxxx>
> To: <equismetastock@xxxxxxxxxxxxxxx>
> Sent: Tuesday, November 09, 2004 9:43 PM
> Subject: Re: [EquisMetaStock Group] Re: Formula that produces an NA
Value
>
>
> >
> > Will IsUndefined() work?
> >
> > ----- Original Message -----
> > From: "Roy Larsen" <rlarsen@xxxx>
> > To: <equismetastock@xxxxxxxxxxxxxxx>
> > Sent: Tuesday, November 09, 2004 2:35 PM
> > Subject: Re: [EquisMetaStock Group] Re: Formula that produces an
NA Value
> >
> >
> >>
> >> Dorsey
> >>
> >> There are as many tricks for overcoming the problem you've
described. The
> >> most common culprits are
> >> BarsSince, and ValueWhen or one of the other Nth parameter type
functions.
> >> ValueWhen will be getting
> >> particular attention in the December newsletter, and the
principles that
> >> work for ValueWhen can also
> >> be applied to a number of other functions to minimise or
preferably
> >> eliminate the dreaded N/A plot.
> >>
> >> Kind regards
> >>
> >> Roy Larsen
> >> www.metastocktips.co.nz
> >> Free formulas and MS links
> >>
> >>
> >>
> >> ----- Original Message -----
> >> From: "pumrysh" <no_reply@xxxxxxxxxxxxxxx>
> >> To: <equismetastock@xxxxxxxxxxxxxxx>
> >> Sent: Tuesday, November 09, 2004 6:53 PM
> >> Subject: [EquisMetaStock Group] Re: Formula that produces an NA
Value
> >>
> >>
> >>>
> >>>
> >>> Dorsey,
> >>>
> >>> You will need to provide the formula if you expect useful help.
> >>>
> >>> Preston
> >>>
> >>>
> >>> --- In equismetastock@xxxxxxxxxxxxxxx, dodgereated
<no_reply@xxxx>
> >>> wrote:
> >>>>
> >>>>
> >>>> I am using a forumula that produces an NA sometimes as a value.
> >>>> Unfortunately when I use it in the explorer, the explorer
discards
> >>>> the stock with an error in the formula. How can I avoid this
> >>>> situation?
> >>>>
> >>>> Thanks,
> >>>>
> >>>> Dorsey
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> Yahoo! Groups Links
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>
> >>
> >>
> >>
> >>
> >>
> >> 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/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/
|