[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 Roy - that does the trick.


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