|
PureBytes Links
Trading Reference Links
|
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@xxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxx>
> 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/
|