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