摘要、科目全稱記錄的順序不是太規範,就顯示借方金額;需要結合月、憑證号、摘要進行判斷,最後顯示在借方金額這一行,月、憑證号這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...