Firstly hello to everyone, I'm not new to the board but this is my first post - I think.
I've been researching the camarilla formula for some time now and came across this formula which is supposed to work in Metastock. It doesn't in my version (9) but I have included it here in case anyone finds it useful.
I think it's only the way the formula is composed rather than the actual values, that are preventing it from working. So, if there are any metastock formula guru's out there, perhaps you could fix the problem
{---------------------------BEGIN---------------------}
Prd:=Input("Points From Nearest Pivot",.1,200,45);
D:=DayOfMonth()<>ValueWhen(2,1,DayOfMonth());
HighPd:=If(D OR Cum(1)=2,H,Max(H,PREV));
LowPd:=If(D OR Cum(1)=2,L,Min(L,PREV));
LastH:=ValueWhen(1,D,ValueWhen(2,1,HighPd));
LastL:=ValueWhen(1,D,ValueWhen(2,1,LowPd));
LastC:=ValueWhen(1,D,ValueWhen(2,1,C));
Pivot:=(LastH+LastL+LastC)/3;
R1:=((LastH/LastL))*LastC;
S1:=LastC-(R1-LastC);
R2:=(((LastH/LastL)+0.83)/1.83)*LastC;
S2:=LastC-(R2-LastC);
R3:=(((LastH/LastL)+2.66)/3.66)*LastC;
S3:=LastC-(R3-LastC);
If(R3-HHV(H,30)0,R3)ValueWhen(1,Pivot>0,Pivot));
If(R2-HHV(H,30)0,R2)ValueWhen(1,Pivot>0,Pivot));
If(R1-HHV(H,30)0,R1)ValueWhen(1,Pivot>0,Pivot));
ValueWhen(1,Pivot>0,Pivot);
If(LLV(L,30)-S10,S1)ValueWhen(1,Pivot>0,Pivot));
If(LLV(L,30)-S20,S2)ValueWhen(1,Pivot>0,Pivot));
If(LLV(L,30)-S30,S3)ValueWhen(1,Pivot>0,Pivot));
{--------------------------END---------------------}
Hope this is useful.