[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



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/