全周期净量指标公式

B34:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M33),CONST(M34) ),IF( FX=1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
B35:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M34),CONST(M35) ),IF( FX=1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
B36:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M35),CONST(M36) ),IF( FX=1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
B37:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M36),CONST(M37) ),IF( FX=1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
B38:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M37),CONST(M38) ),IF( FX=1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
B39:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M38),CONST(M39) ),IF( FX=1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
B40:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M39),CONST(M40+MINDIFF) ),IF( FX=1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
{卖方}
S01:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M00),CONST(M01) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S02:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M01),CONST(M02) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S03:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M02),CONST(M03) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S04:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M03),CONST(M04) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S05:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M04),CONST(M05) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S06:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M05),CONST(M06) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S07:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M06),CONST(M07) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S08:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M07),CONST(M08) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S09:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M08),CONST(M09) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S10:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M09),CONST(M10) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S11:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M10),CONST(M11) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S12:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M11),CONST(M12) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S13:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M12),CONST(M13) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S14:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M13),CONST(M14) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S15:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M14),CONST(M15) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S16:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M15),CONST(M16) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S17:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M16),CONST(M17) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S18:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M17),CONST(M18) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S19:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M18),CONST(M19) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S20:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M19),CONST(M20) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S21:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M20),CONST(M21) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S22:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M21),CONST(M22) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S23:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M22),CONST(M23) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S24:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M23),CONST(M24) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S25:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M24),CONST(M25) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S26:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M25),CONST(M26) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S27:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M26),CONST(M27) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S28:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M27),CONST(M28) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S29:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M28),CONST(M29) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S30:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M29),CONST(M30) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S31:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M30),CONST(M31) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S32:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M31),CONST(M32) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S33:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M32),CONST(M33) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S34:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M33),CONST(M34) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S35:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M34),CONST(M35) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S36:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M35),CONST(M36) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S37:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M36),CONST(M37) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S38:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M37),CONST(M38) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));
S39:=CONST(SUM(IF(RANGE(C,-MINDIFF+CONST(M38),CONST(M39) ),IF( FX=-1,0.9*V,IF(FX=0,0.5*V,0.1*V)),0),TT));

上一页  [1] [2] [3] [4]  下一页