|
PureBytes Links
Trading Reference Links
|
The Null (N/A) plot problem is a sticky one. Once a null period has
been introduced into any formula, no amount of code massaging will get
rid of the N/A plot without the help of an external DLL.
I use a commercially available DLL to get rid of null periods:
---8<----------------
formula:=ROC(C,260,%);
valid:=IsDefined(formula);
noNull:=ExtFml("Xtend.Xtend",formula);
If(valid,noNull,0)
---8<----------------
> This really is a can of worms!
Not really. You are asking MetaStock to plot a value that is not yet
available.
jose '-)
http://www.metastocktools.com
--- In equismetastock@xxxxxxxxxxxxxxx, "Roy Larsen" <rlarsen@xxx>
wrote:
>
> Try this.
>
> Bars:=LastValue(Min(Cum(1)-1,260));
> If(Bars<260,0,ROC(C,Bars,percent));
>
>
> Roy
> www.metastocktips.co.nz
>
>
>
> ----- Original Message -----
> From: notharold
> To: equismetastock@xxxxxxxxxxxxxxx
> Sent: Tuesday, March 21, 2006 3:40 AM
> Subject: [EquisMetaStock Group] Re: How do you stop exploration
> rejecting data which is fewer days than formula
>
>
> Thanks for that. Unfortunately I still get the same problem:
>
> Error in column B: Period value out of valid range in ROC()
> function.
>
>
> This really is a can of worms! For years I have been doing searches
> which included time periods in the columns - I never really noticed
> that I was getting all these rejections. It means that any recently
> floated stocks get kicked out because there is not enough data to
> show, for example, the six month performance.
>
> Regards
>
>
>
>
> --- In equismetastock@xxxxxxxxxxxxxxx, "bellamy_29m" <bellamy_29m@>
> wrote:
>
> <snip>
>
> Try...
>
> if(lastvalue(cum(1))<=260,0,roc(c,260,%))
>
>
> MS does some wierd stuff sometimes, but I think this should work.
> If it doesn't there might be another way. Let me know if you need
> more help.
------------------------ Yahoo! Groups Sponsor --------------------~-->
Try Online Currency Trading with GFT. Free 50K Demo. Trade
24 Hours. Commission-Free.
http://us.click.yahoo.com/RvFikB/9M2KAA/U1CZAA/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/
|