请教:
一、ACCESS(test.mdb)库表数据(如附件):
库表名ZJIF09 | ||||||
stockdate |
BK |
SP |
SK |
BP |
PRICE |
AMOUNT |
2013-09-01 09:30:00 |
0 |
0 |
0 |
0 |
2300 |
1 |
2013-09-02 14:43:00 |
1 |
0 |
0 |
0 |
2310 |
2 |
2013-09-02 14:44:00 |
1 |
0 |
0 |
0 |
2313 |
1 |
2013-09-02 15:05:00 |
0 |
1 |
0 |
0 |
2316 |
3 |
字段含义:
Stockdate:成交时间
BK :买开标志
SP :卖平标志
SK :卖开标志
BP :买平标志
PRICE :成交价格
AMOUNT:成交量
二、金字塔公式脚本:
//连接d:\test.mdb数据库
DATABASE('Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\test.mdb');
//检索数据库表
DBTABLE('Select * From @Code@ Order By StockDate');
//读取STOCKCLOSE字段数据
KD:=DBVALUE('BK'),LINETHICK0;
PD:=DBVALUE('SP'),LINETHICK0;
KK:=DBVALUE('SK'),LINETHICK0;
PK:=DBVALUE('BP'),LINETHICK0;
PRICE:= DBVALUE('PRICE');
KCVOL:= DBVALUE('AMOUNT');
BKCONDITION:= CROSS(KD,0.5),LINETHICK0;
SKCONDITION:= CROSS(KK,0.5),LINETHICK0;
BPCONDITION:= CROSS(PK,0.5),LINETHICK0;
SPCONDITION:= CROSS(PD,0.5),LINETHICK0;
DRAWNUMBER(BKCONDITION, LOW, PRICE,1,COLORRED,5);
DRAWICON(BKCONDITION, PRICE,10);
DRAWNUMBER(SKCONDITION, LOW, PRICE,1,COLORRED,5);
DRAWICON(SKCONDITION, PRICE,10);
DRAWNUMBER(BPCONDITION, LOW, PRICE,1,COLORGREEN,4);
DRAWICON(BPCONDITION, PRICE,11);
DRAWNUMBER(SPCONDITION, LOW, PRICE,1,COLORGREEN,4);
DRAWICON(SPCONDITION, PRICE,11);
BUY(BKCONDITION,KCVOL);
SELL(SPCONDITION,0);
BUYSHORT(SKCONDITION,KCVOL);
SELLSHORT(BPCONDITION,0);
从图中可以看到,14:44的加仓1手多单在图中并没有信号显示。
开多
2
这个?