编写要求:
公式在线网
网友求助:
A1:=WINNER(HB)*100-WINNER(B31)*100;
A2:=WINNER(B31)*100-WINNER(B32)*100;
A3:=WINNER(B32)*100-WINNER(B33)*100;
A4:=WINNER(B33)*100-WINNER(B34)*100;
A5:=WINNER(B34)*100-WINNER(B35)*100;
A6:=WINNER(B35)*100-WINNER(B36)*100;
A7:=WINNER(B36)*100-WINNER(B37)*100;
A8:=WINNER(B37)*100-WINNER(B38)*100;
A9:=WINNER(B38)*100-WINNER(B39)*100;
A10:=WINNER(B39)*100-WINNER(B310)*100;
A11:=WINNER(B310)*100-WINNER(B311)*100;
A12:=WINNER(B311)*100-WINNER(B312)*100;
A13:=WINNER(B312)*100-WINNER(B313)*100;
A14:=WINNER(B313)*100-WINNER(B314)*100;
A15:=WINNER(B314)*100-WINNER(B315)*100;
A16:=WINNER(B315)*100-WINNER(B316)*100;
A17:=WINNER(B316)*100-WINNER(B317)*100;
A18:=WINNER(B317)*100-WINNER(B318)*100;
A19:=WINNER(B318)*100-WINNER(B319)*100;
A20:=WINNER(B319)*100-WINNER(B320)*100;
A21:=WINNER(B320)*100-WINNER(B321)*100;
A22:=WINNER(B321)*100-WINNER(B322)*100;
A23:=WINNER(B322)*100-WINNER(B323)*100;
A24:=WINNER(B323)*100-WINNER(B324)*100;
A25:=WINNER(B324)*100-WINNER(B325)*100;
A26:=WINNER(B325)*100-WINNER(B326)*100;
A27:=WINNER(B326)*100-WINNER(B327)*100;
A28:=WINNER(B327)*100-WINNER(B328)*100;
A29:=WINNER(B328)*100-WINNER(B329)*100;
A30:=WINNER(B329)*100-WINNER(B330)*100;
A31:=WINNER(B330)*100-WINNER(B331)*100;
A32:=WINNER(B331)*100-WINNER(B332)*100;
A33:=WINNER(B332)*100-WINNER(B333)*100;
A34:=WINNER(B333)*100-WINNER(B334)*100;
A35:=WINNER(B334)*100-WINNER(B335)*100;
A36:=WINNER(B335)*100-WINNER(B336)*100;
A37:=WINNER(B336)*100-WINNER(B337)*100;
A38:=WINNER(B337)*100-WINNER(B338)*100;
A39:=WINNER(B338)*100-WINNER(B339)*100;
A40:=WINNER(B339)*100-WINNER(B340)*100;
A41:=WINNER(B340)*100-WINNER(B341)*100;
A42:=WINNER(B341)*100-WINNER(B342)*100;
A43:=WINNER(B342)*100-WINNER(B343)*100;
A44:=WINNER(B343)*100-WINNER(B344)*100;
A45:=WINNER(B344)*100-WINNER(B345)*100;
A46:=WINNER(B345)*100-WINNER(B346)*100;
A47:=WINNER(B346)*100-WINNER(B347)*100;
A48:=WINNER(B347)*100-WINNER(B348)*100;
A49:=WINNER(B348)*100-WINNER(B349)*100;
A50:=WINNER(B349)*100-WINNER(LB)*100;
MAX1:=MAX(MAX(MAX(MAX(MAX(MAX(MAX(MAX(MAX(A1,A2),A3),A4),A5),A6),A7),A8),A9),A10);
MAX2:=MAX(MAX(MAX(MAX(MAX(MAX(MAX(MAX(MAX(A11,A12),A13),A14),A15),A16),A17),A18),A19),A20);
MAX3:=MAX(MAX(MAX(MAX(MAX(MAX(MAX(MAX(MAX(A21,A22),A23),A24),A25),A26),A27),A28),A29),A30);
MAX4:=MAX(MAX(MAX(MAX(MAX(MAX(MAX(MAX(MAX(A31,A32),A33),A34),A35),A36),A37),A38),A39),A40);
MAX5:=MAX(MAX(MAX(MAX(MAX(MAX(MAX(MAX(MAX(A41,A42),A43),A44),A45),A46),A47),A48),A49),A50);
MAX6:=MAX(MAX(MAX(MAX(MAX1,MAX2),MAX3),MAX4),MAX5);
筹码线:IF(MAX6=A1,HB,IF(MAX6=A2,B31,IF(MAX6=A3,B32,IF(MAX6=A4,B33,IF(MAX6=A5,B34,IF(MAX6=A6,B35,IF(MAX6=A7,B36,IF(MAX6=A8,B37,IF(MAX6=A9,B38,IF(MAX6=A10,B39,
IF(MAX6=A11,B310,IF(MAX6=A12,B311,IF(MAX6=A13,B312,IF(MAX6=A14,B313,IF(MAX6=A15,B314,IF(MAX6=A16,B315,IF(MAX6=A17,B316,IF(MAX6=A18,B317,IF(MAX6=A19,B318,IF(MAX6=A20,B319,
IF(MAX6=A21,B320,IF(MAX6=A22,B321,IF(MAX6=A23,B322,IF(MAX6=A24,B323,IF(MAX6=A25,B324,IF(MAX6=A26,B325,IF(MAX6=A27,B326,IF(MAX6=A28,B327,IF(MAX6=A29,B328,IF(MAX6=A30,B329,
IF(MAX6=A31,B330,IF(MAX6=A32,B331,IF(MAX6=A33,B332,IF(MAX6=A34,B333,IF(MAX6=A35,B334,IF(MAX6=A36,B335,IF(MAX6=A37,B336,IF(MAX6=A38,B337,IF(MAX6=A39,B338,IF(MAX6=A40,B339,
IF(MAX6=A41,B340,IF(MAX6=A42,B341,IF(MAX6=A43,B342,IF(MAX6=A44,B343,IF(MAX6=A45,B344,IF(MAX6=A46,B345,IF(MAX6=A47,B346,IF(MAX6=A48,B347,IF(MAX6=A49,B348,IF(MAX6=A50,B349,LB)))))))))))))))))))))))))))))))))))))))))))))))))),LINETHICK2,COLORFF00FF;
STICKLINE(CROSS(C,筹码线),C,O,1,0),COLOR00FFFF;
筹码价位低:=COST(0.001);
筹码价位1:=COST(0.001)+(COST(99.999)-COST(0.001))/10;
筹码价位2:=COST(0.001)+(COST(99.999)-COST(0.001))/10*2;
筹码价位3:=COST(0.001)+(COST(99.999)-COST(0.001))/10*3;
筹码价位4:=COST(0.001)+(COST(99.999)-COST(0.001))/10*4;
筹码价位5:=COST(0.001)+(COST(99.999)-COST(0.001))/10*5;
筹码价位6:=COST(0.001)+(COST(99.999)-COST(0.001))/10*6;
筹码价位7:=COST(0.001)+(COST(99.999)-COST(0.001))/10*7;
筹码价位8:=COST(0.001)+(COST(99.999)-COST(0.001))/10*8;
筹码价位9:=COST(0.001)+(COST(99.999)-COST(0.001))/10*9;
筹码价位高:=COST(99.999);
区间最大筹码:=MAX(MAX(MAX(MAX(WINNER(筹码价位1)-WINNER(筹码价位低),WINNER(筹码价位2)-WINNER(筹码价位1)),MAX(WINNER(筹码价位3)-WINNER(筹码价位2),WINNER(筹码价位4)-WINNER(筹码价位3))),MAX(MAX(WINNER(筹码价位5)-WINNER(筹码价位4),WINNER(筹码价位6)-WINNER(筹码价位5)),MAX(WINNER(筹码价位7)-WINNER(筹码价位6),WINNER(筹码价位8)-WINNER(筹码价位7)))),MAX(WINNER(筹码价位9)-WINNER(筹码价位8),WINNER(筹码价位高)-WINNER(筹码价位9)));
筹码密集均价:=IF(区间最大筹码=WINNER(筹码价位1)-WINNER(筹码价位低),(筹码价位1+筹码价位低)/2,IF(区间最大筹码=WINNER(筹码价位2)-WINNER(筹码价位1),(筹码价位2+筹码价位1)/2,IF(区间最大筹码=WINNER(筹码价位3)-WINNER(筹码价位2),(筹码价位3+筹码价位2)/2,IF(区间最大筹码=WINNER(筹码价位4)-WINNER(筹码价位3),(筹码价位4+筹码价位3)/2,IF(区间最大筹码=WINNER(筹码价位5)-WINNER(筹码价位4),(筹码价位5+筹码价位4)/2,IF(区间最大筹码=WINNER(筹码价位6)-WINNER(筹码价位5),(筹码价位6+筹码价位5)/2,IF(区间最大筹码=WINNER(筹码价位7)-WINNER(筹码价位6),(筹码价位7+筹码价位6)/2,IF(区间最大筹码=WINNER(筹码价位8)-WINNER(筹码价位7),(筹码价位8+筹码价位7)/2,IF(区间最大筹码=WINNER(筹码价位9)-WINNER(筹码价位8),(筹码价位9+筹码价位8)/2,(筹码价位高+筹码价位9)/2)))))))));
MA(筹码密集均价,1),COLORRED,LINETHICK2;
筹码密集度:=WINNER(筹码密集均价*1.1)-WINNER(筹码密集均价*0.9);
A1:=WINNER(HB)*100-WINNER(B31)*100;
A2:=WINNER(B31)*100-WINNER(B32)*100;
A3:=WINNER(B32)*100-WINNER(B33)*100;
A4:=WINNER(B33)*100-WINNER(B34)*100;
A5:=WINNER(B34)*100-WINNER(B35)*100;
A6:=WINNER(B35)*100-WINNER(B36)*100;
A7:=WINNER(B36)*100-WINNER(B37)*100;
A8:=WINNER(B37)*100-WINNER(B38)*100;
A9:=WINNER(B38)*100-WINNER(B39)*100;
A10:=WINNER(B39)*100-WINNER(B310)*100;
A11:=WINNER(B310)*100-WINNER(B311)*100;
A12:=WINNER(B311)*100-WINNER(B312)*100;
A13:=WINNER(B312)*100-WINNER(B313)*100;
A14:=WINNER(B313)*100-WINNER(B314)*100;
A15:=WINNER(B314)*100-WINNER(B315)*100;
A16:=WINNER(B315)*100-WINNER(B316)*100;
A17:=WINNER(B316)*100-WINNER(B317)*100;
A18:=WINNER(B317)*100-WINNER(B318)*100;
A19:=WINNER(B318)*100-WINNER(B319)*100;
A20:=WINNER(B319)*100-WINNER(B320)*100;
A21:=WINNER(B320)*100-WINNER(B321)*100;
A22:=WINNER(B321)*100-WINNER(B322)*100;
A23:=WINNER(B322)*100-WINNER(B323)*100;
A24:=WINNER(B323)*100-WINNER(B324)*100;
A25:=WINNER(B324)*100-WINNER(B325)*100;
A26:=WINNER(B325)*100-WINNER(B326)*100;
A27:=WINNER(B326)*100-WINNER(B327)*100;
A28:=WINNER(B327)*100-WINNER(B328)*100;
A29:=WINNER(B328)*100-WINNER(B329)*100;
A30:=WINNER(B329)*100-WINNER(B330)*100;
A31:=WINNER(B330)*100-WINNER(B331)*100;
A32:=WINNER(B331)*100-WINNER(B332)*100;
A33:=WINNER(B332)*100-WINNER(B333)*100;
A34:=WINNER(B333)*100-WINNER(B334)*100;
A35:=WINNER(B334)*100-WINNER(B335)*100;
A36:=WINNER(B335)*100-WINNER(B336)*100;
A37:=WINNER(B336)*100-WINNER(B337)*100;
A38:=WINNER(B337)*100-WINNER(B338)*100;
A39:=WINNER(B338)*100-WINNER(B339)*100;
A40:=WINNER(B339)*100-WINNER(B340)*100;
A41:=WINNER(B340)*100-WINNER(B341)*100;
A42:=WINNER(B341)*100-WINNER(B342)*100;
A43:=WINNER(B342)*100-WINNER(B343)*100;
A44:=WINNER(B343)*100-WINNER(B344)*100;
A45:=WINNER(B344)*100-WINNER(B345)*100;
A46:=WINNER(B345)*100-WINNER(B346)*100;
A47:=WINNER(B346)*100-WINNER(B347)*100;
A48:=WINNER(B347)*100-WINNER(B348)*100;
A49:=WINNER(B348)*100-WINNER(B349)*100;
A50:=WINNER(B349)*100-WINNER(LB)*100;
MAX1:=MAX(MAX(MAX(MAX(MAX(MAX(MAX(MAX(MAX(A1,A2),A3),A4),A5),A6),A7),A8),A9),A10);
MAX2:=MAX(MAX(MAX(MAX(MAX(MAX(MAX(MAX(MAX(A11,A12),A13),A14),A15),A16),A17),A18),A19),A20);
MAX3:=MAX(MAX(MAX(MAX(MAX(MAX(MAX(MAX(MAX(A21,A22),A23),A24),A25),A26),A27),A28),A29),A30);
MAX4:=MAX(MAX(MAX(MAX(MAX(MAX(MAX(MAX(MAX(A31,A32),A33),A34),A35),A36),A37),A38),A39),A40);
MAX5:=MAX(MAX(MAX(MAX(MAX(MAX(MAX(MAX(MAX(A41,A42),A43),A44),A45),A46),A47),A48),A49),A50);
MAX6:=MAX(MAX(MAX(MAX(MAX1,MAX2),MAX3),MAX4),MAX5);
筹码线:=IF(MAX6=A1,HB,IF(MAX6=A2,B31,IF(MAX6=A3,B32,IF(MAX6=A4,B33,IF(MAX6=A5,B34,IF(MAX6=A6,B35,IF(MAX6=A7,B36,IF(MAX6=A8,B37,IF(MAX6=A9,B38,IF(MAX6=A10,B39,
IF(MAX6=A11,B310,IF(MAX6=A12,B311,IF(MAX6=A13,B312,IF(MAX6=A14,B313,IF(MAX6=A15,B314,IF(MAX6=A16,B315,IF(MAX6=A17,B316,IF(MAX6=A18,B317,IF(MAX6=A19,B318,IF(MAX6=A20,B319,
IF(MAX6=A21,B320,IF(MAX6=A22,B321,IF(MAX6=A23,B322,IF(MAX6=A24,B323,IF(MAX6=A25,B324,IF(MAX6=A26,B325,IF(MAX6=A27,B326,IF(MAX6=A28,B327,IF(MAX6=A29,B328,IF(MAX6=A30,B329,
IF(MAX6=A31,B330,IF(MAX6=A32,B331,IF(MAX6=A33,B332,IF(MAX6=A34,B333,IF(MAX6=A35,B334,IF(MAX6=A36,B335,IF(MAX6=A37,B336,IF(MAX6=A38,B337,IF(MAX6=A39,B338,IF(MAX6=A40,B339,
IF(MAX6=A41,B340,IF(MAX6=A42,B341,IF(MAX6=A43,B342,IF(MAX6=A44,B343,IF(MAX6=A45,B344,IF(MAX6=A46,B345,IF(MAX6=A47,B346,IF(MAX6=A48,B347,IF(MAX6=A49,B348,IF(MAX6=A50,B349,LB))))))))))))))))))))))))))))))))))))))))))))))))));
筹码价位低:=COST(0.001);
筹码价位1:=COST(0.001)+(COST(99.999)-COST(0.001))/10;
筹码价位2:=COST(0.001)+(COST(99.999)-COST(0.001))/10*2;
筹码价位3:=COST(0.001)+(COST(99.999)-COST(0.001))/10*3;
筹码价位4:=COST(0.001)+(COST(99.999)-COST(0.001))/10*4;
筹码价位5:=COST(0.001)+(COST(99.999)-COST(0.001))/10*5;
筹码价位6:=COST(0.001)+(COST(99.999)-COST(0.001))/10*6;
筹码价位7:=COST(0.001)+(COST(99.999)-COST(0.001))/10*7;
筹码价位8:=COST(0.001)+(COST(99.999)-COST(0.001))/10*8;
筹码价位9:=COST(0.001)+(COST(99.999)-COST(0.001))/10*9;
筹码价位高:=COST(99.999);
区间最大筹码:=MAX(MAX(MAX(MAX(WINNER(筹码价位1)-WINNER(筹码价位低),WINNER(筹码价位2)-WINNER(筹码价位1)),MAX(WINNER(筹码价位3)-WINNER(筹码价位2),WINNER(筹码价位4)-WINNER(筹码价位3))),MAX(MAX(WINNER(筹码价位5)-WINNER(筹码价位4),WINNER(筹码价位6)-WINNER(筹码价位5)),MAX(WINNER(筹码价位7)-WINNER(筹码价位6),WINNER(筹码价位8)-WINNER(筹码价位7)))),MAX(WINNER(筹码价位9)-WINNER(筹码价位8),WINNER(筹码价位高)-WINNER(筹码价位9)));
筹码密集均价:=IF(区间最大筹码=WINNER(筹码价位1)-WINNER(筹码价位低),(筹码价位1+筹码价位低)/2,IF(区间最大筹码=WINNER(筹码价位2)-WINNER(筹码价位1),(筹码价位2+筹码价位1)/2,IF(区间最大筹码=WINNER(筹码价位3)-WINNER(筹码价位2),(筹码价位3+筹码价位2)/2,IF(区间最大筹码=WINNER(筹码价位4)-WINNER(筹码价位3),(筹码价位4+筹码价位3)/2,IF(区间最大筹码=WINNER(筹码价位5)-WINNER(筹码价位4),(筹码价位5+筹码价位4)/2,IF(区间最大筹码=WINNER(筹码价位6)-WINNER(筹码价位5),(筹码价位6+筹码价位5)/2,IF(区间最大筹码=WINNER(筹码价位7)-WINNER(筹码价位6),(筹码价位7+筹码价位6)/2,IF(区间最大筹码=WINNER(筹码价位8)-WINNER(筹码价位7),(筹码价位8+筹码价位7)/2,IF(区间最大筹码=WINNER(筹码价位9)-WINNER(筹码价位8),(筹码价位9+筹码价位8)/2,(筹码价位高+筹码价位9)/2)))))))));
BETWEEN(C,筹码线,MA(筹码密集均价,1));