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

[EquisMetaStock Group] Re: Formula that produces an NA Value



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/