Re: [EquisMetaStock Group] Re: How do you stop exploration rejecting data which is fewer days than formula

["Roy Larsen" <rlarsen@xxxxxxxxxxxxxx>]

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@xxx> 
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 LINKS 

  a..  Visit your group "equismetastock" on the web.
    
  b..  To unsubscribe from this group, send an email to:
   equismetastock-unsubscribe@xxxxxxxxxxxxxxx
    
  c..  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


--------------------------------------------------------------------------------



[Non-text portions of this message have been removed]



------------------------ 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/