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

[EquisMetaStock Group] formoula problem



PureBytes Links

Trading Reference Links



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/