-
Notifications
You must be signed in to change notification settings - Fork 4
Expand file tree
/
Copy pathpro_api.m
More file actions
160 lines (144 loc) · 7.09 KB
/
Copy pathpro_api.m
File metadata and controls
160 lines (144 loc) · 7.09 KB
1
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
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
classdef pro_api
%% Modified by LiYang_faruto 20181130
%{
% by LiYang_faruto
% Email:farutoliyang@foxmail.com
% 2018/12/01
-感谢Jimmy以及tushare社区核心成员的默默的付出
-基于Lianrui Fu发布的tushare_matlab_sdk进行修改，在此感谢
-感谢jsonlab作者 Qianqian Fang (q.fang <at> neu.edu)
完善功能：
-支持任意版本的MATLAB使用，原始SDK需要Matlab 2016b及以上版本
-其他一点代码细节处理
%}
%% Modified by LiYang_faruto 20181211
%{
table的表头不能使用数字开头，当获取 SHIBOR利率数据 等相关数据时，表头为
date on 1w 2w 1m 3m 6m 9m 1y
此时输出table格式有问题，转为cell格式输出
%}
%%
%---------------------------------------
% Tushare pro_api Matlab Interface
% Author(s) - Lianrui Fu (fulrbuaa#163{dot}com)
% Affiliation - National Laboratory of Pattern Recognition, Institute of Automation, Chinese Academy of Sciences
% Update Date - 2018-10-31
%---------------------------------------
% pro_api调用说明：
% 调用方式：
% results = api.query(api_name, param_name1, param_1, param_name2, param_2, ...);
% 具体参数与python接口参数一致
% 调用示例：
% token = 'c7b68d2a726dc747e6d6c4484a42b9275b7d8389a****************';
% api = pro_api(token);
% % stock_basic
% df_basic = api.query('stock_basic');
% disp(df_basic(1:10,:));
% % daily
% df_daily = api.query('daily', 'ts_code', '000001.SZ', 'start_date', '19990101', 'end_date', '');
% disp(df_daily(1:10,:));
% >>
% ts_code symbol name area industry market list_date
% ___________ ________ ______ ____ ________ ______ __________
%
% '000001.SZ' '000001' '平安银行' '深圳' '银行' '主板' '19910403'
% '000002.SZ' '000002' '万科A' '深圳' '全国地产' '主板' '19910129'
% '000004.SZ' '000004' '国农科技' '深圳' '生物制药' '主板' '19910114'
% '000005.SZ' '000005' '世纪星源' '深圳' '房产服务' '主板' '19901210'
% '000006.SZ' '000006' '深振业A' '深圳' '区域地产' '主板' '19920427'
% '000007.SZ' '000007' '全新好' '深圳' '酒店餐饮' '主板' '19920413'
% '000008.SZ' '000008' '神州高铁' '北京' '运输设备' '主板' '19920507'
% '000009.SZ' '000009' '中国宝安' '深圳' '综合类' '主板' '19910625'
% '000010.SZ' '000010' '美丽生态' '深圳' '建筑施工' '主板' '19951027'
% '000011.SZ' '000011' '深物业A' '深圳' '区域地产' '主板' '19920330'
%
% ts_code trade_date open high low close pre_close change pct_change vol amount
% ___________ __________ _____ _____ _____ _____ _________ ______ __________ __________ __________
%
% '000001.SZ' '20181030' 10.78 11.08 10.73 10.9 10.75 0.15 1.3953 1.5018e+06 1.6414e+06
% '000001.SZ' '20181029' 11.2 11.24 10.62 10.75 11.18 -0.43 -3.8462 1.5916e+06 1.7259e+06
% '000001.SZ' '20181026' 11.29 11.31 10.96 11.18 11.29 -0.11 -0.9743 1.3e+06 1.4488e+06
% '000001.SZ' '20181025' 10.8 11.29 10.71 11.29 11.04 0.25 2.2645 1.685e+06 1.8558e+06
% '000001.SZ' '20181024' 10.9 11.33 10.8 11.04 10.84 0.2 1.845 1.8294e+06 2.0262e+06
% '000001.SZ' '20181023' 11.2 11.22 10.73 10.84 11.15 -0.31 -2.7803 1.6025e+06 1.7593e+06
% '000001.SZ' '20181022' 10.81 11.46 10.78 11.15 10.76 0.39 3.6245 2.6455e+06 2.9327e+06
% '000001.SZ' '20181019' 9.95 10.78 9.92 10.76 10.09 0.67 6.6402 2.0837e+06 2.1736e+06
% '000001.SZ' '20181018' 10.29 10.29 10.06 10.09 10.33 -0.24 -2.3233 1.0012e+06 1.0157e+06
% '000001.SZ' '20181017' 10.5 10.55 10.14 10.33 10.37 -0.04 -0.3857 1.3509e+06 1.4003e+06
%% properties
properties
token = '';
http_url = 'http://api.tushare.pro';
tcp_url = 'tcp://tushare.pro';
end
%% methods
methods
%% api
function api = pro_api(token)
api.token = token;
end
%% query
function data = query(api, varargin)
data = [];
results.data = [];
results.msg = '';
try
num = length(varargin);
if num<1
results.msg = '第一个参数需要指定接口名称.';
elseif 0 ~= rem(num-1, 2) || num < 1
results.msg = '输入参数有缺失!';
else
params = cell2struct(varargin(3:2:end), varargin(2:2:end), 2);
end
struct_params.api_name = varargin{1};
struct_params.token = api.token;
struct_params.params = params;
if verLessThan('matlab','R2016b')
req_text = savejson('',struct_params);
else
req_text = jsonencode(struct_params);
end
try
res = urlread2(api.http_url, 'Post', req_text);
catch
results.msg = '抱歉：请检查网络设置.';
end
if verLessThan('matlab','R2016b')
results = loadjsonF(res);
else
results = jsondecode(res);
end
catch err
disp('产生异常，请检查！');
err.message
err.stack
end
if ~isempty(results.msg)
disp(results.msg);
end
if ~isempty(results.data) && ~isempty( results.data.items )
index = results.data.fields;
if verLessThan('matlab','R2016b')
data = cat(1, results.data.items{:});
else
data = cat(2, results.data.items{:})';
end
try
data = cell2table(data, 'VariableNames', index);
if ismember('trade_date',data.Properties.VariableNames)
data = sortrows(data,'trade_date','ascend');
end
if ismember('trade_time',data.Properties.VariableNames)
data = sortrows(data,'trade_time','ascend');
end
catch
if size(index,1) ~= 1
index = index';
end
data = [index;data];
end
end
end % EOF query
end % EOF methods
end