H5 ve L5 i de ekleyebilir misiniz formüle

Merhabalar,

Aşağıdaki gibi deneyebilirsiniz,

AYLIK CAMARİLLA

NW:=ROC(MONTH()<>ref(MONTH(),-1),1,$)<0;
x1t:=LastValue(ValueWhen(1,NW=-1,Cum(1)));
WH:=ValueWhen(1,Nw,Ref(HighestSince(1,Nw,H),-1));
WL:=ValueWhen(1,Nw,Ref(LowestSince(1,Nw,L),-1));
WCL:=ValueWhen(1,Nw,Ref(C,-1));
H4:=if(cum(1)=>x1t,((WH-WL)*1.1/2+WCL),0);
H3:=if(cum(1)=>x1t,((WH-WL)*1.1/4+WCL),0);
H2:=if(cum(1)=>x1t,((WH-WL)*1.1/6+WCL),0);
H1:=if(cum(1)=>x1t,((WH-WL)*1.1/12+WCL),0);
L1:=if(cum(1)=>x1t, (WCL-(WH-WL)*1.1/12),0); L2:=if(cum(1)=>x1t, (WCL-(WH-WL)*1.1/6),0); L3:=if(cum(1)=>x1t, (WCL-(WH-WL)*1.1/4),0);
L4:=if(cum(1)=>x1t,(WCL-(WH-WL)*1.1/2),0);H4;H3;H2;H1;L1;L2;L3;L4

HAFTALIK CAMARİLLA

H12:=LastValue(highestsince(1.,DAYOFWEEK()<ref(DAYOFWEEK(),-1),H )); L12:=LastValue(lowestsince(1.,DAYOFWEEK()<ref(DAYOFWEEK(),-1),L));
H4 := (0.55*(H12-L12)) + C;
H3 := (0.275*(H12-L12)) + C;
H2: = (0.183*(H12-L12)) + C;
H1 := (0.0916*(H12-L12))+ C;
L1 := C - (0.0916*(H12-L12));
L2 := C - (0.183*(H12-L12));
L3 := C - (0.275*(H12-L12));
L4 := C - (0.55*(H12-L12));
L4;L3;L2;L1;H1;H2;H3;H4

 

İyi Çalışmalar