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

[EquisMetaStock Group] Re: formoula problem



PureBytes Links

Trading Reference Links



Thanks Jose,

it was very clever solution...






--- In equismetastock@xxxxxxxxxxxxxxx, "Jose Silva" 
<josesilva22@xxxx> wrote:
> 
> Vpazopoulos, check out this related post:
> http://finance.groups.yahoo.com/group/equismetastock/message/16884
> 
> jose '-)
> 
> 
> --- In equismetastock@xxxxxxxxxxxxxxx, "vpazopoulos" 
<vpazopoulos@xxxx
> > wrote:
> > 
> > 
> > I am trying to make some experiments and create some formulas my 
own
> > and I always meet the following problem.
> >  
> > When I have a variable inside a formula which have values only 
from
> > one certain daily bar and after this but not before this...
> > if then this variable is being used in the formula, all the basic
> > and final indicator formula gets values in the chart ONLY after 
this
> > variable has values and not before even if all other variables 
have
> > values from the beggining of the chart.
> >  
> > For example :
> >  
> > mov1:=Mov(CLOSE,50,S) ;
> > mov2:=Mov(CLOSE,120,S) ;
> >  
> > rule1:=mov1 < CLOSE AND Ref(mov1,-1) > Ref(CLOSE,-1) ;
> > rule2:=mov2 < CLOSE AND Ref(mov2,-1) > Ref(CLOSE,-1) ;
> >  
> > final:=Cum(rule1) + Cum(rule2) ;
> >  
> > ValueWhen(1,final<>Ref(final,-1),CLOSE);
> >  
> >  
> > This formula have values only after mov2 have values. 
> >  
> > But then I need to use some explorations, or other formulas to 
get
> > values from this formula and all results are beggining from when
> > mov2 have values.
> >  
> >  
> > I think this is a problem because of the N/A values ( like 
excel ) ,
> > but in excel there is the command   IF(iserror(....)  .... which
> > helps to tell the formula calculate 0 instead of N/A .
> >  
> >  
> >  
> > How can i solve this problem ?
> > Is there a way to not have errors because of variables inside 
> > formulas that are not having values from the beggining of the 
charts
> > and are being team up with other variables that have ???
> >  
> > Is there a way to have 0 instead of nothing in the chart for the 
> > periods before exist ????








------------------------ Yahoo! Groups Sponsor --------------------~--> 
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/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/