# 查詢歷史成交
- Python
- Proto
- C#
- Java
- C++
- JavaScript
history_deal_list_query(code='', deal_market=TrdMarket.NONE, start='', end='', trd_env=TrdEnv.REAL, acc_id=0, acc_index=0)
介紹
查詢指定交易業務帳戶的歷史成交列表。
該介面只支援實盤交易,不支援模擬交易。參數
參數 類型 說明 code str 代碼過濾 只回傳此代碼對應的成交數據
不傳則回傳所有deal_market TrdMarket 成交標的所屬市場過濾 - 成交標的市場過濾,會回傳該市場下的成交數據
- 預設值為NONE,會回傳帳戶下所有市場的成交數據
start str 開始時間 - 嚴格按 YYYY-MM-DD HH:MM:SS 或 YYYY-MM-DD HH:MM:SS.MS 格式傳
- 期貨時區指定,請參見 OpenD 設定
end str 結束時間 - 嚴格按 YYYY-MM-DD HH:MM:SS 或 YYYY-MM-DD HH:MM:SS.MS 格式傳
- 期貨時區指定,請參見 OpenD 設定
trd_env TrdEnv 交易環境 僅支援 TrdEnv.REAL(真實環境),模擬環境暫不支援查詢成交數據acc_id int 交易業務帳戶 ID - acc_id 和 acc_index 都可用於指定交易業務帳戶,二選一即可,建議使用 acc_id。
- 當 acc_id 傳 0 時, 以 acc_index 指定的帳戶為準
- 當 acc_id 傳 ID 號時(不為 0 ),以 acc_id 指定的帳戶為準
acc_index int 交易業務帳戶列表中的帳戶序號 - acc_id 和 acc_index 都可用於指定交易業務帳戶,二選一即可,建議使用 acc_id。acc_index 會在新開立/註銷帳戶時發生變動,導致您指定的帳戶與實際交易帳戶不一致。
- acc_index 預設為 0,表示指定第 1 個交易業務帳戶
- start 和 end 的組合如下
Start 類型 End 類型 說明 str str start 和 end 分別為指定的日期 None str start 為 end 往前 90 天 str None end 為 start 往後 90 天 None None start 為往前 90 天,end 當前日期
回傳
參數 類型 說明 ret RET_CODE 介面調用結果 data pd.DataFrame 當 ret == RET_OK 時,回傳交易成交列表 str 當 ret != RET_OK 時,回傳錯誤描述 - 交易成交列表格式如下:
欄位 類型 說明 trd_side TrdSide 交易方向 deal_id str 成交號 order_id str 訂單號 code str 股票編號 stock_name str 股票名稱 deal_market TrdMarket 成交標的所屬市場 qty float 成交數量 期權期貨單位是"張"price float 成交價格 精確到小數點後 3 位,超過部分四捨五入create_time str 建立時間 期貨時區指定,請參見 OpenD 設定counter_broker_id int 對手經紀號 僅港股有效counter_broker_name str 對手經紀名稱 僅港股有效status DealStatus 成交狀態 jp_acc_type SubAccType 日本帳戶類型 僅對日本券商生效
- 交易成交列表格式如下:
Example
from futu import *
trd_ctx = OpenSecTradeContext(filter_trdmarket=TrdMarket.HK, host='127.0.0.1', port=11111, security_firm=SecurityFirm.FUTUSECURITIES)
ret, data = trd_ctx.history_deal_list_query()
if ret == RET_OK:
print(data)
if data.shape[0] > 0: # 如果成交列表不為空
print(data['deal_id'][0]) # 獲取歷史成交的第一個成交號
print(data['deal_id'].values.tolist()) # 轉為 list
else:
print('history_deal_list_query error: ', data)
trd_ctx.close()
2
3
4
5
6
7
8
9
10
11
- Output
code stock_name deal_market deal_id order_id qty price trd_side create_time counter_broker_id counter_broker_name status jp_acc_type
0 HK.00388 香港交易所 HK 5056208452274069375 4665291631090960915 100.0 370.0 BUY 2020-09-17 21:15:59.979 5 OK N/A
5056208452274069375
['5056208452274069375']
2
3
4
# Trd_GetHistoryOrderFillList.proto
介紹
查詢指定交易業務帳戶的歷史成交列表。
該介面只支援實盤交易,不支援模擬交易。參數
message C2S
{
required Trd_Common.TrdHeader header = 1; //交易公共參數頭
required Trd_Common.TrdFilterConditions filterConditions = 2; //過濾條件
}
message Request
{
required C2S c2s = 1;
}
2
3
4
5
6
7
8
9
10
- 交易公共參數頭結構,參見 TrdHeader
- 過濾條件結構,參見 TrdFilterConditions
- 回傳
message S2C
{
required Trd_Common.TrdHeader header = 1; //交易公共參數頭
repeated Trd_Common.OrderFill orderFillList = 2; //歷史成交列表
}
message Response
{
//以下3個欄位每條協議都有,註釋說明在 InitConnect.proto 中
required int32 retType = 1 [default = -400];
optional string retMsg = 2;
optional int32 errCode = 3;
optional S2C s2c = 4;
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
協議 ID
2222
uint GetHistoryOrderFillList(TrdGetHistoryOrderFillList.Request req);
virtual void OnReply_GetHistoryOrderFillList(FTAPI_Conn client, uint nSerialNo, TrdGetHistoryOrderFillList.Response rsp);
介紹
查詢指定交易業務帳戶的歷史成交列表。
該介面只支援實盤交易,不支援模擬交易。參數
message C2S
{
required Trd_Common.TrdHeader header = 1; //交易公共參數頭
required Trd_Common.TrdFilterConditions filterConditions = 2; //過濾條件
}
message Request
{
required C2S c2s = 1;
}
2
3
4
5
6
7
8
9
10
- 交易公共參數頭結構,參見 TrdHeader
- 過濾條件結構,參見 TrdFilterConditions
- 回調
message S2C
{
required Trd_Common.TrdHeader header = 1; //交易公共參數頭
repeated Trd_Common.OrderFill orderFillList = 2; //歷史成交列表
}
message Response
{
//以下3個欄位每條協議都有,註釋說明在 InitConnect.proto 中
required int32 retType = 1 [default = -400];
optional string retMsg = 2;
optional int32 errCode = 3;
optional S2C s2c = 4;
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
- Example
public class Program : FTSPI_Trd, FTSPI_Conn {
FTAPI_Trd trd = new FTAPI_Trd();
public Program() {
trd.SetClientInfo("csharp", 1); //設置客户端信息
trd.SetConnCallback(this); //設置連接回調
trd.SetTrdCallback(this); //設置交易回調
}
public void Start() {
trd.InitConnect("127.0.0.1", (ushort)11111, false);
}
public void OnInitConnect(FTAPI_Conn client, long errCode, String desc)
{
Console.Write("Trd onInitConnect: ret={0} desc={1} connID={2}\n", errCode, desc, client.GetConnectID());
if (errCode != 0)
return;
TrdCommon.TrdHeader header = TrdCommon.TrdHeader.CreateBuilder()
.SetAccID(281756457888247915L)
.SetTrdEnv((int)TrdCommon.TrdEnv.TrdEnv_Real)
.SetTrdMarket((int)TrdCommon.TrdMarket.TrdMarket_HK)
.Build();
TrdCommon.TrdFilterConditions filter = TrdCommon.TrdFilterConditions.CreateBuilder().Build();
TrdGetHistoryOrderFillList.C2S c2s = TrdGetHistoryOrderFillList.C2S.CreateBuilder()
.SetHeader(header)
.SetFilterConditions(filter)
.Build();
TrdGetHistoryOrderFillList.Request req = TrdGetHistoryOrderFillList.Request.CreateBuilder().SetC2S(c2s).Build();
uint seqNo = trd.GetHistoryOrderFillList(req);
Console.Write("Send TrdGetHistoryOrderFillList: {0}\n", seqNo);
}
public void OnDisconnect(FTAPI_Conn client, long errCode) {
Console.Write("Trd onDisConnect: {0}\n", errCode);
}
public void OnReply_GetHistoryOrderFillList(FTAPI_Conn client, uint nSerialNo, TrdGetHistoryOrderFillListResponse rsp)
{
Console.Write("Reply: TrdGetHistoryOrderFillList: {0}\n", nSerialNo);
Console.Write("accID: {0}\n", rsp.S2C.Header.AccID);
}
public static void Main(String[] args) {
FTAPI.Init();
Program trd = new Program();
trd.Start();
while (true)
Thread.Sleep(1000 * 600);
}
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
- Output
Trd onInitConnect: ret=0 desc= connID=6827861023441251037
Send TrdGetHistoryOrderFillList: 3
Reply: TrdGetHistoryOrderFillList: 3
accID: 281756457888247915
2
3
4
int getHistoryOrderFillList(TrdGetHistoryOrderFillList.Request req);
void onReply_GetHistoryOrderFillList(FTAPI_Conn client, int nSerialNo, TrdGetHistoryOrderFillList.Response rsp);
介紹
查詢指定交易業務帳戶的歷史成交列表。
該介面只支援實盤交易,不支援模擬交易。參數
message C2S
{
required Trd_Common.TrdHeader header = 1; //交易公共參數頭
required Trd_Common.TrdFilterConditions filterConditions = 2; //過濾條件
}
message Request
{
required C2S c2s = 1;
}
2
3
4
5
6
7
8
9
10
- 交易公共參數頭結構,參見 TrdHeader
- 過濾條件結構,參見 TrdFilterConditions
- 回調
message S2C
{
required Trd_Common.TrdHeader header = 1; //交易公共參數頭
repeated Trd_Common.OrderFill orderFillList = 2; //歷史成交列表
}
message Response
{
//以下3個欄位每條協議都有,註釋說明在 InitConnect.proto 中
required int32 retType = 1 [default = -400];
optional string retMsg = 2;
optional int32 errCode = 3;
optional S2C s2c = 4;
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
- Example
public class TrdDemo implements FTSPI_Trd, FTSPI_Conn {
FTAPI_Conn_Trd trd = new FTAPI_Conn_Trd();
public TrdDemo() {
trd.setClientInfo("javaclient", 1); //設置客户端信息
trd.setConnSpi(this); //設置連接回調
trd.setTrdSpi(this); //設置交易回調
}
public void start() {
trd.initConnect("127.0.0.1", (short)11111, false);
}
@Override
public void onInitConnect(FTAPI_Conn client, long errCode, String desc)
{
System.out.printf("Trd onInitConnect: ret=%b desc=%s connID=%d\n", errCode, desc, client.getConnectID());
if (errCode != 0)
return;
TrdCommon.TrdHeader header = TrdCommon.TrdHeader.newBuilder()
.setAccID(281756457888247915L)
.setTrdEnv(TrdCommon.TrdEnv.TrdEnv_Real_VALUE)
.setTrdMarket(TrdCommon.TrdMarket.TrdMarket_US_VALUE)
.build();
TrdCommon.TrdFilterConditions filter = TrdCommon.TrdFilterConditions.newBuilder()
.setBeginTime("2021-03-01 00:00:00")
.setEndTime("2021-04-01 00:00:00")
.build();
TrdGetHistoryOrderFillList.C2S c2s = TrdGetHistoryOrderFillList.C2S.newBuilder()
.setHeader(header)
.setFilterConditions(filter)
.build();
TrdGetHistoryOrderFillList.Request req = TrdGetHistoryOrderFillList.Request.newBuilder().setC2S(c2s).build();
int seqNo = trd.getHistoryOrderFillList(req);
System.out.printf("Send TrdGetHistoryOrderFillList: %d\n", seqNo);
}
@Override
public void onDisconnect(FTAPI_Conn client, long errCode) {
System.out.printf("Trd onDisConnect: %d\n", errCode);
}
@Override
public void onReply_GetHistoryOrderFillList(FTAPI_Conn client, int nSerialNo, TrdGetHistoryOrderFillList.Response rsp) {
if (rsp.getRetType() != 0) {
System.out.printf("TrdGetHistoryOrderFillList failed: %s\n", rsp.getRetMsg());
}
else {
try {
String json = JsonFormat.printer().print(rsp);
System.out.printf("Receive TrdGetHistoryOrderFillList: %s\n", json);
} catch (InvalidProtocolBufferException e) {
e.printStackTrace();
}
}
}
public static void main(String[] args) {
FTAPI.init();
TrdDemo trd = new TrdDemo();
trd.start();
while (true) {
try {
Thread.sleep(1000 * 600);
} catch (InterruptedException exc) {
}
}
}
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
- Output
Send TrdGetHistoryOrderFillList: 2
Receive TrdGetHistoryOrderFillList: {
"retType": 0,
"retMsg": "",
"errCode": 0,
"s2c": {
"header": {
"trdEnv": 1,
"accID": "281756457888247915",
"trdMarket": 2
},
"orderFillList": [{
"trdSide": 1,
"fillID": "449150869556176742",
"fillIDEx": "20210330_15680495_SQSWWgSYCStLVb7BDmx7kgAARgy31Nc1_SQSWWgSYCStLVb7BDmx7kgAARgy31Nc1.4",
"orderID": "6664320708369556828",
"orderIDEx": "20210330_15680495_SQSWWgSYCStLVb7BDmx7kgAARgy31Nc1",
"code": "FUTU",
"name": "富途控股",
"qty": 34.0,
"price": 127.64,
"createTime": "2021-03-30 09:34:24.019",
"secMarket": 2,
"createTimestamp": 1.617111264019109E9,
"updateTimestamp": 1.617111264019109E9,
"status": 0
}]
}
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Futu::u32_t GetHistoryOrderFillList(const Trd_GetHistoryOrderFillList::Request &stReq);
virtual void OnReply_GetHistoryOrderFillList(Futu::u32_t nSerialNo, const Trd_GetHistoryOrderFillList::Response &stRsp) = 0;
介紹
查詢指定交易業務帳戶的歷史成交列表。
該介面只支援實盤交易,不支援模擬交易。參數
message C2S
{
required Trd_Common.TrdHeader header = 1; //交易公共參數頭
required Trd_Common.TrdFilterConditions filterConditions = 2; //過濾條件
}
message Request
{
required C2S c2s = 1;
}
2
3
4
5
6
7
8
9
10
- 交易公共參數頭結構,參見 TrdHeader
- 過濾條件結構,參見 TrdFilterConditions
- 回調
message S2C
{
required Trd_Common.TrdHeader header = 1; //交易公共參數頭
repeated Trd_Common.OrderFill orderFillList = 2; //歷史成交列表
}
message Response
{
//以下3個欄位每條協議都有,註釋說明在 InitConnect.proto 中
required int32 retType = 1 [default = -400];
optional string retMsg = 2;
optional int32 errCode = 3;
optional S2C s2c = 4;
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
- Example
class Program : public FTSPI_Qot, public FTSPI_Trd, public FTSPI_Conn
{
public:
Program() {
m_pTrdApi = FTAPI::CreateTrdApi();
m_pTrdApi->RegisterTrdSpi(this);
m_pTrdApi->RegisterConnSpi(this);
}
~Program() {
if (m_pTrdApi != nullptr)
{
m_pTrdApi->UnregisterTrdSpi();
m_pTrdApi->UnregisterConnSpi();
FTAPI::ReleaseTrdApi(m_pTrdApi);
m_pTrdApi = nullptr;
}
}
void Start() {
m_pTrdApi->InitConnect("127.0.0.1", 11111, false);
}
virtual void OnInitConnect(FTAPI_Conn* pConn, Futu::i64_t nErrCode, const char* strDesc) {
cout << "connect" << endl;
// 組包
Trd_GetHistoryOrderFillList::Request req;
Trd_GetHistoryOrderFillList::C2S *c2s = req.mutable_c2s();
Trd_Common::TrdHeader *header = c2s->mutable_header();
header->set_accid(281756456003951537L);
header->set_trdenv(1);
header->set_trdmarket(1);
Trd_Common::TrdFilterConditions *filter = c2s->mutable_filterconditions();
filter->set_begintime("2021-05-01 00:00:00");
filter->set_endtime("2021-06-01 00:00:00");
m_GetHistoryOrderFillListSerialNo = m_pTrdApi->GetHistoryOrderFillList(req);
cout << "Request GetHistoryOrderFillList SerialNo: " << m_GetHistoryOrderFillListSerialNo << endl;
}
virtual void OnReply_GetHistoryOrderFillList(Futu::u32_t nSerialNo, const Trd_GetHistoryOrderFillList::Response &stRsp){
if(nSerialNo == m_GetHistoryOrderFillListSerialNo)
{
cout << "OnReply_GetHistoryOrderFillList SerialNo: " << nSerialNo << endl;
// 解析內部結構打印出來
// ProtoBufToBodyData和UTF8ToLocal函數的定義參見Sample中的tool.h文件
string resp_str;
ProtoBufToBodyData(stRsp, resp_str);
cout << UTF8ToLocal(resp_str) << endl;
}
}
protected:
FTAPI_Trd *m_pTrdApi;
Futu::u32_t m_GetHistoryOrderFillListSerialNo;
};
int32_t main(int32_t argc, char** argv)
{
FTAPI::Init();
{
Program program;
program.Start();
getchar();
}
protobuf::ShutdownProtobufLibrary();
FTAPI::UnInit();
return 0;
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
- Output
connect
Request GetHistoryOrderFillList SerialNo: 4
OnReply_GetHistoryOrderFillList SerialNo: 4
{
"retType": 0,
"retMsg": "",
"errCode": 0,
"s2c": {
"header": {
"trdEnv": 1,
"accID": "281756456003951537",
"trdMarket": 1
}
}
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
GetHistoryOrderFillList(req);
介紹
查詢指定交易業務帳戶的歷史成交列表。
該介面只支援實盤交易,不支援模擬交易。參數
message C2S
{
required Trd_Common.TrdHeader header = 1; //交易公共參數頭
required Trd_Common.TrdFilterConditions filterConditions = 2; //過濾條件
}
message Request
{
required C2S c2s = 1;
}
2
3
4
5
6
7
8
9
10
- 交易公共參數頭結構,參見 TrdHeader
- 過濾條件結構,參見 TrdFilterConditions
- 回傳
message S2C
{
required Trd_Common.TrdHeader header = 1; //交易公共參數頭
repeated Trd_Common.OrderFill orderFillList = 2; //歷史成交列表
}
message Response
{
//以下3個欄位每條協議都有,註釋說明在 InitConnect.proto 中
required int32 retType = 1 [default = -400];
optional string retMsg = 2;
optional int32 errCode = 3;
optional S2C s2c = 4;
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
- Example
import ftWebsocket from "futu-api";
import { ftCmdID } from "futu-api";
import { Common, Qot_Common, Trd_Common } from "futu-api/proto";
import beautify from "js-beautify";
function TrdGetHistoryOrderFillList(){
const { RetType } = Common
const { TrdEnv, TrdMarket } = Trd_Common
let [addr, port, enable_ssl, key] = ["127.0.0.1", 33333, false, 'ec16fde057a2e7a0'];
let websocket = new ftWebsocket();
websocket.onlogin = (ret, msg)=>{
if (ret) { // 登錄成功
websocket.GetAccList({
c2s: {
userID: 0,
},
}).then((res) => {
let { retType,s2c: { accList } } = res
if(retType == RetType.RetType_Succeed){
let acc = accList.filter((item)=>{
return item.trdEnv != TrdEnv.TrdEnv_Simulate && item.trdMarketAuthList.some((auth)=>{ return auth == TrdMarket.TrdMarket_HK})
})[0]; // 樣例取第一個香港市場真實環境帳戶
const req = {
c2s: {
header: {
trdEnv: acc.trdEnv,
accID: acc.accID,
trdMarket: TrdMarket.TrdMarket_HK,
},
filterConditions:{
beginTime:"2021-09-01 00:00:00",
endTime:"2021-09-30 00:00:00",
},
},
};
websocket.GetHistoryOrderFillList(req)
.then((res) => {
let { errCode, retMsg, retType,s2c } = res
console.log("GetHistoryOrderFillList: errCode %d, retMsg %s, retType %d", errCode, retMsg, retType);
if(retType == RetType.RetType_Succeed){
let data = beautify(JSON.stringify(s2c), {
indent_size: 2,
space_in_empty_paren: true,
});
console.log(data);
}
})
.catch((error) => {
console.log("error:", error);
});
}
})
.catch((error) => {
console.log("GetAccList error:", error);
});
} else {
console.log("error", msg);
}
};
websocket.start(addr, port, enable_ssl, key);
//關閉行情連接,連接不再使用之後,要關閉,否則佔用不必要資源
//同時OpenD也限制了最多128條連接
//也可以一個頁面或者一個項目維護一條連接,這裏範例請求一次建立一條連接
setTimeout(()=>{
websocket.stop();
console.log("stop");
}, 5000); // 5秒後斷開
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
- Output
GetHistoryOrderFillList: errCode 0, retMsg , retType 0
{
"header": {
"trdEnv": 1,
"accID": "281756455988249902",
"trdMarket": 1
},
"orderFillList": [{
"trdSide": 1,
"fillID": "932511865781776209",
"fillIDEx": "20210913_5915950_OD|pM+9NqXZAaxnZYpScrsjT4zHWtlk1_OD|pM+9NqXZAaxnZYpScrsjT4zHWtlk1.2",
"orderID": "4883217202603317248",
"orderIDEx": "20210913_5915950_OD|pM+9NqXZAaxnZYpScrsjT4zHWtlk1",
"code": "00700",
"name": "",
"qty": 100,
"price": 480,
"createTime": "2021-09-13 16:45:00.606",
"counterBrokerID": 5,
"counterBrokerName": "",
"secMarket": 1,
"createTimestamp": 1631522700.605828,
"updateTimestamp": 1631522700.531,
"status": 0
}, {
"trdSide": 1,
"fillID": "2611798069690910040",
"fillIDEx": "20210913_5915950_OD|rILqM3WaKl2rXYpRYuigcJmBKtRld_OD|rILqM3WaKl2rXYpRYuigcJmBKtRld.2",
"orderID": "9128832000130556480",
"orderIDEx": "20210913_5915950_OD|rILqM3WaKl2rXYpRYuigcJmBKtRld",
"code": "00700",
"name": "",
"qty": 100,
"price": 480,
"createTime": "2021-09-13 16:40:19.183",
"counterBrokerID": 5,
"counterBrokerName": "",
"secMarket": 1,
"createTimestamp": 1631522419.18269,
"updateTimestamp": 1631522419.005,
"status": 0
}]
}
stop
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
介面限制
- 同一帳戶ID(acc_id) 每 30 秒內最多請求 10 次查詢歷史成交介面
提示
- 歷史成交,按照時間的“倒序”進行排列,即:後成交的記錄在前,先成交的記錄在後
- Python
- Proto
- C#
- Java
- C++
- JavaScript
history_deal_list_query(code='', deal_market=TrdMarket.NONE, start='', end='', trd_env=TrdEnv.REAL, acc_id=0, acc_index=0)
介紹
查詢指定交易業務帳戶的歷史成交列表。
該介面只支援實盤交易,不支援模擬交易。參數
參數 類型 說明 code str 代碼過濾 只回傳此代碼對應的成交數據
不傳則回傳所有deal_market TrdMarket 成交標的所屬市場過濾 - 成交標的市場過濾,會回傳該市場下的成交數據
- 預設值為NONE,會回傳帳戶下所有市場的成交數據
start str 開始時間 - 嚴格按 YYYY-MM-DD HH:MM:SS 或 YYYY-MM-DD HH:MM:SS.MS 格式傳
- 期貨時區指定,請參見 OpenD 設定
end str 結束時間 - 嚴格按 YYYY-MM-DD HH:MM:SS 或 YYYY-MM-DD HH:MM:SS.MS 格式傳
- 期貨時區指定,請參見 OpenD 設定
trd_env TrdEnv 交易環境 僅支援 TrdEnv.REAL(真實環境),模擬環境暫不支援查詢成交數據acc_id int 交易業務帳戶 ID - acc_id 和 acc_index 都可用於指定交易業務帳戶,二選一即可,建議使用 acc_id。
- 當 acc_id 傳 0 時, 以 acc_index 指定的帳戶為準
- 當 acc_id 傳 ID 號時(不為 0 ),以 acc_id 指定的帳戶為準
acc_index int 交易業務帳戶列表中的帳戶序號 - acc_id 和 acc_index 都可用於指定交易業務帳戶,二選一即可,建議使用 acc_id。acc_index 會在新開立/註銷帳戶時發生變動,導致您指定的帳戶與實際交易帳戶不一致。
- acc_index 預設為 0,表示指定第 1 個交易業務帳戶
- start 和 end 的組合如下
Start 類型 End 類型 說明 str str start 和 end 分別為指定的日期 None str start 為 end 往前 90 天 str None end 為 start 往後 90 天 None None start 為往前 90 天,end 當前日期
回傳
參數 類型 說明 ret RET_CODE 介面調用結果 data pd.DataFrame 當 ret == RET_OK 時,回傳交易成交列表 str 當 ret != RET_OK 時,回傳錯誤描述 - 交易成交列表格式如下:
欄位 類型 說明 trd_side TrdSide 交易方向 deal_id str 成交號 order_id str 訂單號 code str 股票編號 stock_name str 股票名稱 deal_market TrdMarket 成交標的所屬市場 qty float 成交數量 期權期貨單位是"張"price float 成交價格 精確到小數點後 3 位,超過部分四捨五入create_time str 建立時間 期貨時區指定,請參見 OpenD 設定counter_broker_id int 對手經紀號 僅港股有效counter_broker_name str 對手經紀名稱 僅港股有效status DealStatus 成交狀態 jp_acc_type SubAccType 日本帳戶類型 僅對日本券商生效
- 交易成交列表格式如下:
Example
from moomoo import *
trd_ctx = OpenSecTradeContext(filter_trdmarket=TrdMarket.US, host='127.0.0.1', port=11111, security_firm=SecurityFirm.FUTUINC)
ret, data = trd_ctx.history_deal_list_query()
if ret == RET_OK:
print(data)
if data.shape[0] > 0: # 如果成交列表不為空
print(data['deal_id'][0]) # 獲取歷史成交的第一個成交號
print(data['deal_id'].values.tolist()) # 轉為 list
else:
print('history_deal_list_query error: ', data)
trd_ctx.close()
2
3
4
5
6
7
8
9
10
11
- Output
code stock_name deal_market deal_id order_id qty price trd_side create_time counter_broker_id counter_broker_name status jp_acc_type
0 US.AAPL 蘋果 US 5056208452274069375 4665291631090960915 100.0 370.0 BUY 2020-09-17 21:15:59.979 5 OK N/A
5056208452274069375
['5056208452274069375']
2
3
4
# Trd_GetHistoryOrderFillList.proto
介紹
查詢指定交易業務帳戶的歷史成交列表。
該介面只支援實盤交易,不支援模擬交易。參數
message C2S
{
required Trd_Common.TrdHeader header = 1; //交易公共參數頭
required Trd_Common.TrdFilterConditions filterConditions = 2; //過濾條件
}
message Request
{
required C2S c2s = 1;
}
2
3
4
5
6
7
8
9
10
- 交易公共參數頭結構,參見 TrdHeader
- 過濾條件結構,參見 TrdFilterConditions
- 回傳
message S2C
{
required Trd_Common.TrdHeader header = 1; //交易公共參數頭
repeated Trd_Common.OrderFill orderFillList = 2; //歷史成交列表
}
message Response
{
//以下3個欄位每條協議都有,註釋說明在 InitConnect.proto 中
required int32 retType = 1 [default = -400];
optional string retMsg = 2;
optional int32 errCode = 3;
optional S2C s2c = 4;
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
協議 ID
2222
uint GetHistoryOrderFillList(TrdGetHistoryOrderFillList.Request req);
virtual void OnReply_GetHistoryOrderFillList(MMAPI_Conn client, uint nSerialNo, TrdGetHistoryOrderFillList.Response rsp);
介紹
查詢指定交易業務帳戶的歷史成交列表。
該介面只支援實盤交易,不支援模擬交易。參數
message C2S
{
required Trd_Common.TrdHeader header = 1; //交易公共參數頭
required Trd_Common.TrdFilterConditions filterConditions = 2; //過濾條件
}
message Request
{
required C2S c2s = 1;
}
2
3
4
5
6
7
8
9
10
- 交易公共參數頭結構,參見 TrdHeader
- 過濾條件結構,參見 TrdFilterConditions
- 回調
message S2C
{
required Trd_Common.TrdHeader header = 1; //交易公共參數頭
repeated Trd_Common.OrderFill orderFillList = 2; //歷史成交列表
}
message Response
{
//以下3個欄位每條協議都有,註釋說明在 InitConnect.proto 中
required int32 retType = 1 [default = -400];
optional string retMsg = 2;
optional int32 errCode = 3;
optional S2C s2c = 4;
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
- Example
public class Program : MMSPI_Trd, MMSPI_Conn {
MMAPI_Trd trd = new MMAPI_Trd();
public Program() {
trd.SetClientInfo("csharp", 1); //設置客户端信息
trd.SetConnCallback(this); //設置連接回調
trd.SetTrdCallback(this); //設置交易回調
}
public void Start() {
trd.InitConnect("127.0.0.1", (ushort)11111, false);
}
public void OnInitConnect(MMAPI_Conn client, long errCode, String desc)
{
Console.Write("Trd onInitConnect: ret={0} desc={1} connID={2}\n", errCode, desc, client.GetConnectID());
if (errCode != 0)
return;
TrdCommon.TrdHeader header = TrdCommon.TrdHeader.CreateBuilder()
.SetAccID(281756457888247915L)
.SetTrdEnv((int)TrdCommon.TrdEnv.TrdEnv_Real)
.SetTrdMarket((int)TrdCommon.TrdMarket.TrdMarket_HK)
.Build();
TrdCommon.TrdFilterConditions filter = TrdCommon.TrdFilterConditions.CreateBuilder().Build();
TrdGetHistoryOrderFillList.C2S c2s = TrdGetHistoryOrderFillList.C2S.CreateBuilder()
.SetHeader(header)
.SetFilterConditions(filter)
.Build();
TrdGetHistoryOrderFillList.Request req = TrdGetHistoryOrderFillList.Request.CreateBuilder().SetC2S(c2s).Build();
uint seqNo = trd.GetHistoryOrderFillList(req);
Console.Write("Send TrdGetHistoryOrderFillList: {0}\n", seqNo);
}
public void OnDisconnect(MMAPI_Conn client, long errCode) {
Console.Write("Trd onDisConnect: {0}\n", errCode);
}
public void OnReply_GetHistoryOrderFillList(MMAPI_Conn client, uint nSerialNo, TrdGetHistoryOrderFillListResponse rsp)
{
Console.Write("Reply: TrdGetHistoryOrderFillList: {0}\n", nSerialNo);
Console.Write("accID: {0}\n", rsp.S2C.Header.AccID);
}
public static void Main(String[] args) {
MMAPI.Init();
Program trd = new Program();
trd.Start();
while (true)
Thread.Sleep(1000 * 600);
}
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
- Output
Trd onInitConnect: ret=0 desc= connID=6827861023441251037
Send TrdGetHistoryOrderFillList: 3
Reply: TrdGetHistoryOrderFillList: 3
accID: 281756457888247915
2
3
4
int getHistoryOrderFillList(TrdGetHistoryOrderFillList.Request req);
void onReply_GetHistoryOrderFillList(MMAPI_Conn client, int nSerialNo, TrdGetHistoryOrderFillList.Response rsp);
介紹
查詢指定交易業務帳戶的歷史成交列表。
該介面只支援實盤交易,不支援模擬交易。參數
message C2S
{
required Trd_Common.TrdHeader header = 1; //交易公共參數頭
required Trd_Common.TrdFilterConditions filterConditions = 2; //過濾條件
}
message Request
{
required C2S c2s = 1;
}
2
3
4
5
6
7
8
9
10
- 交易公共參數頭結構,參見 TrdHeader
- 過濾條件結構,參見 TrdFilterConditions
- 回調
message S2C
{
required Trd_Common.TrdHeader header = 1; //交易公共參數頭
repeated Trd_Common.OrderFill orderFillList = 2; //歷史成交列表
}
message Response
{
//以下3個欄位每條協議都有,註釋說明在 InitConnect.proto 中
required int32 retType = 1 [default = -400];
optional string retMsg = 2;
optional int32 errCode = 3;
optional S2C s2c = 4;
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
- Example
public class TrdDemo implements MMSPI_Trd, MMSPI_Conn {
MMAPI_Conn_Trd trd = new MMAPI_Conn_Trd();
public TrdDemo() {
trd.setClientInfo("javaclient", 1); //設置客户端信息
trd.setConnSpi(this); //設置連接回調
trd.setTrdSpi(this); //設置交易回調
}
public void start() {
trd.initConnect("127.0.0.1", (short)11111, false);
}
@Override
public void onInitConnect(MMAPI_Conn client, long errCode, String desc)
{
System.out.printf("Trd onInitConnect: ret=%b desc=%s connID=%d\n", errCode, desc, client.getConnectID());
if (errCode != 0)
return;
TrdCommon.TrdHeader header = TrdCommon.TrdHeader.newBuilder()
.setAccID(281756457888247915L)
.setTrdEnv(TrdCommon.TrdEnv.TrdEnv_Real_VALUE)
.setTrdMarket(TrdCommon.TrdMarket.TrdMarket_US_VALUE)
.build();
TrdCommon.TrdFilterConditions filter = TrdCommon.TrdFilterConditions.newBuilder()
.setBeginTime("2021-03-01 00:00:00")
.setEndTime("2021-04-01 00:00:00")
.build();
TrdGetHistoryOrderFillList.C2S c2s = TrdGetHistoryOrderFillList.C2S.newBuilder()
.setHeader(header)
.setFilterConditions(filter)
.build();
TrdGetHistoryOrderFillList.Request req = TrdGetHistoryOrderFillList.Request.newBuilder().setC2S(c2s).build();
int seqNo = trd.getHistoryOrderFillList(req);
System.out.printf("Send TrdGetHistoryOrderFillList: %d\n", seqNo);
}
@Override
public void onDisconnect(MMAPI_Conn client, long errCode) {
System.out.printf("Trd onDisConnect: %d\n", errCode);
}
@Override
public void onReply_GetHistoryOrderFillList(MMAPI_Conn client, int nSerialNo, TrdGetHistoryOrderFillList.Response rsp) {
if (rsp.getRetType() != 0) {
System.out.printf("TrdGetHistoryOrderFillList failed: %s\n", rsp.getRetMsg());
}
else {
try {
String json = JsonFormat.printer().print(rsp);
System.out.printf("Receive TrdGetHistoryOrderFillList: %s\n", json);
} catch (InvalidProtocolBufferException e) {
e.printStackTrace();
}
}
}
public static void main(String[] args) {
MMAPI.init();
TrdDemo trd = new TrdDemo();
trd.start();
while (true) {
try {
Thread.sleep(1000 * 600);
} catch (InterruptedException exc) {
}
}
}
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
- Output
Send TrdGetHistoryOrderFillList: 2
Receive TrdGetHistoryOrderFillList: {
"retType": 0,
"retMsg": "",
"errCode": 0,
"s2c": {
"header": {
"trdEnv": 1,
"accID": "281756457888247915",
"trdMarket": 2
},
"orderFillList": [{
"trdSide": 1,
"fillID": "449150869556176742",
"fillIDEx": "20210330_15680495_SQSWWgSYCStLVb7BDmx7kgAARgy31Nc1_SQSWWgSYCStLVb7BDmx7kgAARgy31Nc1.4",
"orderID": "6664320708369556828",
"orderIDEx": "20210330_15680495_SQSWWgSYCStLVb7BDmx7kgAARgy31Nc1",
"code": "FUTU",
"name": "富途控股",
"qty": 34.0,
"price": 127.64,
"createTime": "2021-03-30 09:34:24.019",
"secMarket": 2,
"createTimestamp": 1.617111264019109E9,
"updateTimestamp": 1.617111264019109E9,
"status": 0
}]
}
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
moomoo::u32_t GetHistoryOrderFillList(const Trd_GetHistoryOrderFillList::Request &stReq);
virtual void OnReply_GetHistoryOrderFillList(moomoo::u32_t nSerialNo, const Trd_GetHistoryOrderFillList::Response &stRsp) = 0;
介紹
查詢指定交易業務帳戶的歷史成交列表。
該介面只支援實盤交易,不支援模擬交易。參數
message C2S
{
required Trd_Common.TrdHeader header = 1; //交易公共參數頭
required Trd_Common.TrdFilterConditions filterConditions = 2; //過濾條件
}
message Request
{
required C2S c2s = 1;
}
2
3
4
5
6
7
8
9
10
- 交易公共參數頭結構,參見 TrdHeader
- 過濾條件結構,參見 TrdFilterConditions
- 回調
message S2C
{
required Trd_Common.TrdHeader header = 1; //交易公共參數頭
repeated Trd_Common.OrderFill orderFillList = 2; //歷史成交列表
}
message Response
{
//以下3個欄位每條協議都有,註釋說明在 InitConnect.proto 中
required int32 retType = 1 [default = -400];
optional string retMsg = 2;
optional int32 errCode = 3;
optional S2C s2c = 4;
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
- Example
class Program : public MMSPI_Qot, public MMSPI_Trd, public MMSPI_Conn
{
public:
Program() {
m_pTrdApi = MMAPI::CreateTrdApi();
m_pTrdApi->RegisterTrdSpi(this);
m_pTrdApi->RegisterConnSpi(this);
}
~Program() {
if (m_pTrdApi != nullptr)
{
m_pTrdApi->UnregisterTrdSpi();
m_pTrdApi->UnregisterConnSpi();
MMAPI::ReleaseTrdApi(m_pTrdApi);
m_pTrdApi = nullptr;
}
}
void Start() {
m_pTrdApi->InitConnect("127.0.0.1", 11111, false);
}
virtual void OnInitConnect( MMAPI_Conn* pConn, moomoo::i64_t nErrCode, const char* strDesc) {
cout << "connect" << endl;
// 組包
Trd_GetHistoryOrderFillList::Request req;
Trd_GetHistoryOrderFillList::C2S *c2s = req.mutable_c2s();
Trd_Common::TrdHeader *header = c2s->mutable_header();
header->set_accid(281756456003951537L);
header->set_trdenv(1);
header->set_trdmarket(1);
Trd_Common::TrdFilterConditions *filter = c2s->mutable_filterconditions();
filter->set_begintime("2021-05-01 00:00:00");
filter->set_endtime("2021-06-01 00:00:00");
m_GetHistoryOrderFillListSerialNo = m_pTrdApi->GetHistoryOrderFillList(req);
cout << "Request GetHistoryOrderFillList SerialNo: " << m_GetHistoryOrderFillListSerialNo << endl;
}
virtual void OnReply_GetHistoryOrderFillList(moomoo::u32_t nSerialNo, const Trd_GetHistoryOrderFillList::Response &stRsp){
if(nSerialNo == m_GetHistoryOrderFillListSerialNo)
{
cout << "OnReply_GetHistoryOrderFillList SerialNo: " << nSerialNo << endl;
// 解析內部結構打印出來
// ProtoBufToBodyData和UTF8ToLocal函數的定義參見Sample中的tool.h文件
string resp_str;
ProtoBufToBodyData(stRsp, resp_str);
cout << UTF8ToLocal(resp_str) << endl;
}
}
protected:
MMAPI_Trd *m_pTrdApi;
moomoo::u32_t m_GetHistoryOrderFillListSerialNo;
};
int32_t main(int32_t argc, char** argv)
{
MMAPI::Init();
{
Program program;
program.Start();
getchar();
}
protobuf::ShutdownProtobufLibrary();
MMAPI::UnInit();
return 0;
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
- Output
connect
Request GetHistoryOrderFillList SerialNo: 4
OnReply_GetHistoryOrderFillList SerialNo: 4
{
"retType": 0,
"retMsg": "",
"errCode": 0,
"s2c": {
"header": {
"trdEnv": 1,
"accID": "281756456003951537",
"trdMarket": 1
}
}
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
GetHistoryOrderFillList(req);
介紹
查詢指定交易業務帳戶的歷史成交列表。
該介面只支援實盤交易,不支援模擬交易。參數
message C2S
{
required Trd_Common.TrdHeader header = 1; //交易公共參數頭
required Trd_Common.TrdFilterConditions filterConditions = 2; //過濾條件
}
message Request
{
required C2S c2s = 1;
}
2
3
4
5
6
7
8
9
10
- 交易公共參數頭結構,參見 TrdHeader
- 過濾條件結構,參見 TrdFilterConditions
- 回傳
message S2C
{
required Trd_Common.TrdHeader header = 1; //交易公共參數頭
repeated Trd_Common.OrderFill orderFillList = 2; //歷史成交列表
}
message Response
{
//以下3個欄位每條協議都有,註釋說明在 InitConnect.proto 中
required int32 retType = 1 [default = -400];
optional string retMsg = 2;
optional int32 errCode = 3;
optional S2C s2c = 4;
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
- Example
import mmWebsocket from "moomoo-api";
import { mmCmdID } from "moomoo-api";
import { Common, Qot_Common, Trd_Common } from "moomoo-api/proto";
import beautify from "js-beautify";
function TrdGetHistoryOrderFillList(){
const { RetType } = Common
const { TrdEnv, TrdMarket } = Trd_Common
let [addr, port, enable_ssl, key] = ["127.0.0.1", 33333, false, 'ec16fde057a2e7a0'];
let websocket = new mmWebsocket();
websocket.onlogin = (ret, msg)=>{
if (ret) { // 登錄成功
websocket.GetAccList({
c2s: {
userID: 0,
},
}).then((res) => {
let { retType,s2c: { accList } } = res
if(retType == RetType.RetType_Succeed){
let acc = accList.filter((item)=>{
return item.trdEnv != TrdEnv.TrdEnv_Simulate && item.trdMarketAuthList.some((auth)=>{ return auth == TrdMarket.TrdMarket_HK})
})[0]; // 樣例取第一個香港市場真實環境帳戶
const req = {
c2s: {
header: {
trdEnv: acc.trdEnv,
accID: acc.accID,
trdMarket: TrdMarket.TrdMarket_HK,
},
filterConditions:{
beginTime:"2021-09-01 00:00:00",
endTime:"2021-09-30 00:00:00",
},
},
};
websocket.GetHistoryOrderFillList(req)
.then((res) => {
let { errCode, retMsg, retType,s2c } = res
console.log("GetHistoryOrderFillList: errCode %d, retMsg %s, retType %d", errCode, retMsg, retType);
if(retType == RetType.RetType_Succeed){
let data = beautify(JSON.stringify(s2c), {
indent_size: 2,
space_in_empty_paren: true,
});
console.log(data);
}
})
.catch((error) => {
console.log("error:", error);
});
}
})
.catch((error) => {
console.log("GetAccList error:", error);
});
} else {
console.log("error", msg);
}
};
websocket.start(addr, port, enable_ssl, key);
//關閉行情連接,連接不再使用之後,要關閉,否則佔用不必要資源
//同時OpenD也限制了最多128條連接
//也可以一個頁面或者一個項目維護一條連接,這裏範例請求一次建立一條連接
setTimeout(()=>{
websocket.stop();
console.log("stop");
}, 5000); // 5秒後斷開
}
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
- Output
GetHistoryOrderFillList: errCode 0, retMsg , retType 0
{
"header": {
"trdEnv": 1,
"accID": "281756455988249902",
"trdMarket": 1
},
"orderFillList": [{
"trdSide": 1,
"fillID": "932511865781776209",
"fillIDEx": "20210913_5915950_OD|pM+9NqXZAaxnZYpScrsjT4zHWtlk1_OD|pM+9NqXZAaxnZYpScrsjT4zHWtlk1.2",
"orderID": "4883217202603317248",
"orderIDEx": "20210913_5915950_OD|pM+9NqXZAaxnZYpScrsjT4zHWtlk1",
"code": "00700",
"name": "",
"qty": 100,
"price": 480,
"createTime": "2021-09-13 16:45:00.606",
"counterBrokerID": 5,
"counterBrokerName": "",
"secMarket": 1,
"createTimestamp": 1631522700.605828,
"updateTimestamp": 1631522700.531,
"status": 0
}, {
"trdSide": 1,
"fillID": "2611798069690910040",
"fillIDEx": "20210913_5915950_OD|rILqM3WaKl2rXYpRYuigcJmBKtRld_OD|rILqM3WaKl2rXYpRYuigcJmBKtRld.2",
"orderID": "9128832000130556480",
"orderIDEx": "20210913_5915950_OD|rILqM3WaKl2rXYpRYuigcJmBKtRld",
"code": "00700",
"name": "",
"qty": 100,
"price": 480,
"createTime": "2021-09-13 16:40:19.183",
"counterBrokerID": 5,
"counterBrokerName": "",
"secMarket": 1,
"createTimestamp": 1631522419.18269,
"updateTimestamp": 1631522419.005,
"status": 0
}]
}
stop
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
介面限制
- 同一帳戶ID(acc_id) 每 30 秒內最多請求 10 次查詢歷史成交介面
提示
- 歷史成交,按照時間的“倒序”進行排列,即:後成交的記錄在前,先成交的記錄在後