❶ 通達信副圖指標公式,左上角指標數值總是顯示小數點兩位數,怎麼去掉
副圖指標來顯示數值源的小數位數是可以按需要自行設置的,方法如下:
滑鼠右擊指標公式,選擇「修改當前指標公式」(或直接組合鍵Alt+S),打開公式編輯器後打開「顯示小數」下拉菜單,選項中有預設位數(兩位)、和固定0位、固定1——4位,根據自己需要選擇其一即可。
❷ 求excel表格公式:目標值xx%,達成目標xx%的得0.6分,未達成目標xx%得0分)
這就是個簡單的if公式,看樓上幾位同志回答也沒有問題不明白為什麼不採納。
假定源數據在A1,要自動判斷的結果單元格是B1,
則公式B1=IF(A1>XX%,0.6,0)
❸ 用EXCEL做"規劃求解"時總是彈出"目標單元格的內容必須是公式",該怎麼解決啊,急用,請賜教.在線等
http://club.excelhome.net/dispbbs.asp?BoardID=1&ID=296756&replyID=&skin=0
http://club.excelhome.net/dispbbs.asp?boardID=3&ID=65648&page=33
❹ 求高手做個黃金目標主圖指標公式,見補充
高點:=10;
低點:=10;
高點選擇:=1;
低點選擇:=1;
波浪尺1:=0;
波浪尺2:=1;
PURC:=CONST(FINDHIGH(H,0,高點*10,高點選擇));
PLZ:=CONST(BARSLAST(PURC=H))+1;
頂X:=CONST(IF(PLZ=1,H,REF(H,PLZ-1)));
QQT:=CONST(FINDLOW(L,0,低點*10,低點選擇));
PLL:=CONST(BARSLAST(QQT=L))+1;
低X:=CONST(IF(PLL=1,L,REF(L,PLL-1)));
DRAWKLINE(H,O,L,C);
頂點:頂X,COLORRED;
底點:低X,COLORRED;
波動速率:=100*((頂X-低X)/(IF(PLL>PLZ,低X,頂X)))/(PLL-PLZ),NODRAW,COLORMAGENTA;
波動幅度:=((頂X-低X)/(IF(PLL>PLZ,低X,頂X)))*100;
波動價位:=(頂X-低X)*(IF(PLL>PLZ,1,-1));
BPURC:=CONST(FINDHIGH(H,0,(IF(波浪尺1>0,波浪尺1,IF(PLZ<PLL,高點,低點)))*5,波浪尺2));
BPLZ:=CONST(BARSLAST(BPURC=H))+1;
BQQT:=CONST(FINDLOW(L,0,(IF(波浪尺1>0,波浪尺1,IF(PLZ<PLL,高點,低點)))*5,波浪尺2));
BPLL:=CONST(BARSLAST(BQQT=L))+1;
BLC1:=CONST(FINDHIGH(H,0,(IF(波浪尺1>0,波浪尺1,IF(PLZ<PLL,高點,低點)))*5,波浪尺2));
BLC2:=CONST(BARSLAST(BPURC=H))+1;
BLC頂X:=CONST(IF(BPLZ=1,H,REF(H,BPLZ-1)));
BLC3:=CONST(FINDLOW(L,0,(IF(波浪尺1>0,波浪尺1,IF(PLZ<PLL,高點,低點)))*5,波浪尺2));
B6C4:=CONST(BARSLAST(BQQT=L))+1;
BLC低X:=CONST(IF(BPLL=1,L,REF(L,BPLL-1)));
BASE:=IF(波動速率<0,BLC頂X,BLC低X)COLORRED;
BLCX:=IF(波動速率<0,-1,1);
BLCZ:=(頂點-底點)*(IF(PLL>PLZ,1,-1));
B618:=BASE+(BLCZ*0.618)COLORRED,DOTLINE;
B382:=BASE+(BLCZ*0.382)COLORRED,DOTLINE;
B05:=BASE+(BLCZ*0.5)COLORRED,DOTLINE;
B809:=BASE+(BLCZ*0.809)COLORRED,DOTLINE;
B191:=BASE+(BLCZ*0.191)COLORRED,DOTLINE;
B100:=BASE+(BLCZ*1)COLORRED;
B200:=BASE+(BLCZ*2)COLORRED;
B11:=BASE+(BLCZ*1.191)COLORRED;
B12:=BASE+(BLCZ*1.382)COLORRED;
B13:=BASE+(BLCZ*1.5)COLORRED;
B14:=BASE+(BLCZ*1.618)COLORRED;
B15:=BASE+(BLCZ*1.809)COLORRED;
BZ1:=BASE+(BLCZ*0.236)COLORRED;
BZ2:=BASE+(BLCZ*1.236)COLORRED;
BZ3:=BASE+(BLCZ*2.236)COLORRED;
B11B:=BASE+(BLCZ*2.191)COLORRED;
B12B:=BASE+(BLCZ*2.382)COLORRED;
B13B:=BASE+(BLCZ*2.5)COLORRED;
B14B:=BASE+(BLCZ*2.618)COLORRED;
B15B:=BASE+(BLCZ*2.809)COLORRED;
B300:=BASE+(BLCZ*3)COLORRED;
XZDD:=IF(PLL>PLZ,BPLL,BPLZ);
STICKLINE(CURRBARSCOUNT=XZDD ,BASE,B300,0,0),COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,B05,'---------0.500')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,BASE,'---------BASE')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,B618,'---------0.618')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,B809,'---------0.809')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,B382,'---------0.382')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,B191,'---------0.191')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,B100,'---------1.000')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,B11,'---------1.191')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,B12,'---------1.382')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,B13,'---------1.500')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,B14,'---------1.618')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,B15,'---------1.809')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,B200,'---------2.000')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,B11B,'---------2.191')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,B12B,'---------2.382')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,B13B,'---------2.500')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,B14B,'---------2.618')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,B15B,'---------2.809')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,B300,'---------3.000')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,BZ1,'---------0.236')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,BZ2,'---------1.236')COLORRED;
DRAWTEXT(CURRBARSCOUNT=XZDD,BZ3,'---------2.236')COLORRED;
QADQ:=IF(PLL>PLZ,PLL,PLZ);
QADH:=IF(PLL>PLZ,PLZ,PLL);
QHL1:=IF(PLL>PLZ,L,H);
QHL2:=IF(PLL>PLZ,H,L);
DRAWLINE(CURRBARSCOUNT=QADQ,QHL1,CURRBARSCOUNT=QADH,QHL2,0)COLORRED;
DRAWLINE(CURRBARSCOUNT=QADH,QHL2,CURRBARSCOUNT=XZDD,QHL1,0)COLORRED;
❺ 通達信選股公式修改選目標出現的位置
XG:(IF(CLOSE/REF(CLOSE,1)>=1.099ANDVOL/REF(VOL,1)<1,1,0));
❻ 請高手將這個指標中的目標出現A和目標出現B改成選股公式,非常感謝!
AA:=LLV(LOW,36);
BB:=HHV(HIGH,30);
DD:=(EMA(((CLOSE-AA)/(BB-AA))*(4),4))*(25);
股神
:=DD;
股海
:=(((DD-LLV(DD,21))/(HHV(DD,21)-LLV(DD,21)))*(4))*(25);
目標出現B:=CROSS(股海,90)
AND
(股神<40);
目標出現A:=(COUNT((股神>REF(股神,1)),1)=1)
AND
(REF(股神,1)<REF(REF(股神,1),1))
AND
(股神<10);
XG:目標出現B+目標出現A>=1;
❼ 麻煩朋友將下面公式中出現「目標出現」改寫成通達信的選股公式
VAR1:=(CLOSE-LLV(LOW,36))/(HHV(HIGH,36)-LLV(LOW,36))*100;
VAR2:=SMA(VAR1,3,1);
VAR3:=SMA(VAR2,3,1);
VAR4:=SMA(VAR3,3,1);
VAR5:=CROSS(VAR3,VAR4) AND VAR3<20;
VAR8:=CROSS(VAR2,VAR3) AND VAR3>80 AND VAR3>VAR4;
AA:=LLV(LOW,36);
BB:=HHV(HIGH,30);
DD:=(EMA(((CLOSE-AA)/(BB-AA))*(4),4))*(25);
股神:=DD;
股海:=(((DD-LLV(DD,21))/(HHV(DD,21)-LLV(DD,21)))*(4))*(25);
目標出現B:IF(CROSS(股海,90) AND (股神<40),70,0);
跟蹤:10;
目標出現A:IF((COUNT((股神>REF(股神,1)),1)=1) AND (REF(股神,1)<REF(REF(股神,1),1)) AND (股神<跟蹤),50,0);
{希望幫到你}
❽ 老是提示目標單元格內需要是公式,可是我輸入的就是公式啊
fx那一欄裡面只有表達式,不是公式。公式好歹有個類似x=y這樣的等式。
❾ 哪位大師可以把這個指標的選股公式寫出來,要求出現做多和做空時提醒,
B:=ZIG(3,5)*100;
G:=MA(B,2);
D:=CROSS(B,G);
買入信號: FILTER(D=1,5);