|
A1:=AMOUNT;
AA1:=SUM(IF(A1>=4000000 AND CLOSE>REF(CLOSE,1),A1,0),0);
超级资金:AA1+SUM(IF(A1>=4000000 AND CLOSE<REF(CLOSE,1),REVERSE(A1),0),0),COLORMAGENTA;
AA2:=SUM(IF(A1<4000000 AND A1>=1000000 AND CLOSE>REF(CLOSE,1),A1,0),0);
大户资金:AA2+SUM(IF(A1<4000000 AND A1>=1000000 AND CLOSE<REF(CLOSE,1),REVERSE(A1),0),0),COLORYELLOW;
AA3:=SUM(IF(A1<1000000 AND A1>=500000 AND CLOSE>REF(CLOSE,1),A1,0),0);
中户资金:AA3+SUM(IF(A1<1000000 AND A1>=500000 AND CLOSE<REF(CLOSE,1),REVERSE(A1),0),0),COLORCYAN;
AA4:=SUM(IF(A1<500000 AND CLOSE>REF(CLOSE,1),A1,0),0);
散户资金:AA4+SUM(IF(A1<500000 AND CLOSE<REF(CLOSE,1),REVERSE(A1),0),0),COLORGREEN;
201111711205427539.png
| 
