摘要、科目全称记录的顺序不是太规范,就显示借方金额;需要结合月、凭证号、摘要进行判断,最后显示在借方金额这一行,月、凭证号这2个...
【吸筹&冲顶】副图指标:=REF(LOW;=SMA(ABS(LOW-VAR2 ,1 /SMA(MAX(LOW-VAR2,1 *1...
BB;=VOL/((HIGH-LOW *2-ABS(CLOSE-OPEN :BB*(HIGH-LOW ;BB*((HIGH-O...
=DYNAINFO(4 ˃=FINANCE(7 ˂=8000000000;1.0975 AND HIGH=OPEN;=X_1 A...
指标源码:=REF(LOW;=EMA(IF(CLOSE*1.2,=HHV(VAR3;21 -LLV(L;0;=LLV(LOW;=...
=INSUM('造纸行业';=INSUM('印刷包装';=INSUM('仪器仪表';=INSUM('医疗器械';=INSUM('...
20 ˂=QJ9*(MIN(OPEN,=QJ9*(JJ-MIN(CLOSE,=QJ9*(HIGH-MAX(OPEN,=QJ9*(...
中B:小B:小S:=L2_AMO(3,主买A:主卖A:IF(SAT˃大宗净流入:=(超B+大B -(超S+大S ,主动买卖差:=...
IF(XA_8,=MOD(FROMOPEN:XA_12 ;XA_15/REF(MA(XA_15,1 *XA_16 AND IF(...
{底部地量}:RSV,=(CLOSE-LLV(LOW,9 /(HHV(HIGH,9 -LLV(LOW;9 *100:K,=S...
2.显示不重复金额单号会重复出现,因此会输入多个重复的金额,借助COUNTIF判断单号是否为第一次出现。如果是返回B列的金额:区...
均价:=AMOUNT/(VOL*100 ;2 ;=EMA((均价-LLV(LOW,34 -LLV(LOW,=EMA(生1,10 ...
下面是Excel制作的自动出入库管理系统模板。今天我们需要根据C3单元格的产品编码,在F3、C5、F5、C7、F7、C9、F9单...
X_1 /MA(CLOSE,X_1 /MA(HY_INDEXC,X_1 /MA(INDEXC,X_1 *100,{====...
{VAR1:=DYNAINFO(17 *REF(MA(VOL,=DYNAINFO(7 =CLOSE AND DYNAINFO(1...