|
PureBytes Links
Trading Reference Links
|
Hi Dorsey
Did you get my reply to your private email? There is no panacea - the solution will depend on the
specific cause of the problem, not just the fact that there is a problem. Show me the code causing
the problem and I'll work out a specific solution. Without the code the best I can do (besides tell
you 101 things that it might be and how to fix it) is to say, find the problem and fix it.
The most common problem is a ValueWhen() for which the trigger expression never comes true. I tried
to tell you how to go about fixing that in my last reply. There may be a number of other causes, and
without more information I can't really be expected to nail it. I'm sure it can be fixed, I've done
it often enough, but I can't do it in a vacuum.
Kind regards
Roy Larsen
www.metastocktips.co.nz
Free formulas and MS links
----- Original Message -----
From: "dodgereated" <no_reply@xxxxxxxxxxxxxxx>
To: <equismetastock@xxxxxxxxxxxxxxx>
Sent: Friday, November 12, 2004 7:10 AM
Subject: [EquisMetaStock Group] Re: Formula that produces an NA Value
>
>
>
> 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 Links
>
>
>
>
>
>
>
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/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/
|