AMain_demo_Tushare_Fund
by LiYang_faruto
Email:farutoliyang@foxmail.com
2019/01/01
通过Tushare Pro获取数据样例(使用 Tushare_MATLAB_FSDK)
Tushare_MATLAB_FSDK see
Contents
A Little Clean Work
tic; % clear; % clc; % close all; format compact;
全局参数
gPara.len_demo = 8;
tushare api connect
输入您自己的Token,查看位置 https://tushare.pro/user/token
YourTushareToken_char = TushareToken; token = YourTushareToken_char; api = pro_api(token);
公募基金列表
tic; tData = api.query('fund_basic','market','E'); tData(1:gPara.len_demo,:) toc;
ans = 8×25 table ts_code name management custodian fund_type found_date due_date list_date issue_date delist_date issue_amount m_fee c_fee duration_year p_value min_amount exp_return benchmark status invest_type type trustee purc_startdate redm_startdate market ___________ ___________________________ ____________ ____________ _________ __________ ________ __________ __________ ___________ ____________ _____ _____ _____________ _______ ____________ __________ ________________________________________________________________________ ______ ___________ ____________ _______ ______________ ______________ ______ '511270.SH' '海富通上证10年期地方政府债ETF' '海富通基金' '中国银行' '债券型' '20181012' [] [] '20180628' [] [60.4575] 0.25 0.1 [] 1 [ 0.1000] [] '上证10年期地方政府债指数收益率' 'I' '被动指数型' '契约型开放式' [] [] [] 'E' '512850.SH' '中信建投北京50ETF' '中信建投基金' '招商银行' '股票型' '20180927' [] [] '20180702' [] [ 2.7953] 0.6 0.1 [] 1 [ 0.1000] [] '中证北京50指数收益率' 'I' '被动指数型' '契约型开放式' [] [] [] 'E' '168601.SZ' '汇安裕阳三年定期开放' '汇安基金' '中国光大银行' '混合型' '20180927' [] [] '20180808' [] [ 2.1433] 1.5 0.25 [] 1 [1.0000e-03] [] '沪深300指数收益率*60%+中国债券总指数收益率*40%' 'I' '混合型' '契约型开放式' [] [] [] 'E' '512860.SH' '华安MSCI中国A股国际ETF' '华安基金' '中国农业银行' '股票型' '20180927' [] [] '20180801' [] [ 3.2163] 0.5 0.1 [] 1 [ 0.1000] [] 'MSCI中国A股国际指数收益率(经汇率调整)' 'I' '被动指数型' '契约型开放式' [] [] [] 'E' '159960.SZ' '恒生国企' '平安大华基金' '中国银行' '股票型' '20180921' [] '20181022' '20180907' [] [ 5.1057] 0.5 0.1 [] 1 [ 0.1000] [] '恒生中国企业指数收益率(经汇率调整)' 'I' '被动指数型' '契约型开放式' [] '20181022' '20181022' 'E' '501062.SH' '南方瑞合三年' '南方基金' '中国建设银行' '混合型' '20180906' [] [] '20180806' [] [14.3326] 1.5 0.25 [] 1 [1.0000e-04] [] '沪深300指数收益率*40%+上证国债指数收益率*40%+中证港股通综合指数(人民币)收益率*20%' 'I' '混合型' '契约型开放式' [] [] [] 'E' '510600.SH' '沪50ETF' '申万菱信基金' '中国工商银行' '股票型' '20180903' [] '20180920' '20180625' [] [ 3.7578] 0.5 0.1 [] 1 [ 0.1000] [] '上证50指数' 'L' '被动指数型' '契约型开放式' [] '20180920' '20180920' 'E' '501061.SH' '金选300C' '中金基金' '中国建设银行' '股票型' '20180830' [] '20180925' '20180723' [] [ 0.7771] 0.5 0.15 [] 1 [1.0000e-03] [] '中证中金优选300指数收益率*95%+银行活期存款利率(税后)*5%' 'L' '被动指数型' '契约型开放式' [] '20180925' '20180925' 'E' 时间已过 1.209736 秒。
公募基金公司
tic;
tData = api.query('fund_company');
tData(1:gPara.len_demo,:)
toc;
ans = 8×17 table name shortname province city address phone office website chairman manager reg_capital setup_date end_date employees main_business org_code credit_code _________________________ _________ ________ ___________ __________________________________________ ______________________________________________ _______________________________________________________________________ _____________________ ________ _______ ____________ __________ ________ _________ ____________________________________________________________________________________________________________________ ___________ ____________________ '北京广能投资基金管理有限公司' '广能基金' '北京' '北京市' '北京市朝阳区北四环中路27号院5号楼2712-2715A' [] '北京市朝阳区北四环中路27号院5号楼2712-2715A' 'www.gnfund.cn' '刘锡潜' '杨运成' [ 10000] '20111031' [] [ 10] [] '584419680' [] '平安银行股份有限公司' '平安银行' '广东' '深圳市' '广东省深圳市罗湖区深南东路5047号' '86-755-82080387' '广东省深圳市罗湖区深南东路5047号' 'www.bank.pingan.com' '谢永林' '胡跃飞' [1.7170e+06] '19871222' [] [32744] '主要业务:贷款,拆借,存放等同业业务,债券投资.' '192185379' '91440300192185379H' '宏源证券股份有限公司' '宏源证券' '新疆' '乌鲁木齐市' '新疆维吾尔自治区乌鲁木齐市文艺路233号宏源大厦' '86-991-2301870' '新疆维吾尔自治区乌鲁木齐市文艺路233号宏源大厦' 'www.hysec.com' '冯戎' '冯戎' [3.9724e+05] '19930525' [] [ 5347] '主要业务:代理买卖证券.' '228593068' [] '陕西省国际信托股份有限公司' '陕国投' '陕西' '西安市' '陕西省西安市高新区科技路50号金桥国际广场C座' '86-29-88897633,86-29-81870266,86-29-81870262' '陕西省西安市高新区科技路50号金桥国际广场C座' 'www.siti.com.cn' '薛季民' '姚卫东' [3.9640e+05] '19850105' [] [ 498] '主营业务:房地产及实业,信托业' '220530273' '91610000220530273T' '东北证券股份有限公司' '东北证券' '吉林' '长春市' '吉林省长春市生态大街6666号' '86-431-85096806' '吉林省长春市生态大街6666号' 'www.nesc.cn' '李福春' '何俊岩' [2.3405e+05] '19880824' [] [ 3005] '主营业务:证券经纪业务,证券承销与保荐业务,证券自营业务,证券资产管理业务和信用交易业务等.' '664275090' '91220000664275090B' '国元证券股份有限公司' '国元证券' '安徽' '合肥市' '安徽省合肥市梅山路18号' '86-551-62207323,86-551-62207968' '安徽省合肥市梅山路18号' 'www.gyzq.com.cn' '蔡咏' '俞仕新' [3.3654e+05] '19970606' [] [ 3330] '主营业务:经纪业务,自营投资业务,投行业务,资产管理业务,基金管理业务,期货业务,境外业务国元黄山1号集合资产管理计划,国元黄山2号集合资产管理计划' '731686376' '91340000731686376P' '国海证券股份有限公司' '国海证券' '广西' '桂林市' '广西壮族自治区桂林市辅星路13号' '86-771-5569592,86-771-5539038,86-771-5532512' '广西壮族自治区南宁市滨湖路46号国海大厦' 'www.ghzq.com.cn' '何春梅' '刘世安' [4.2155e+05] '19881006' [] [ 1962] '主营业务:为客户提供证券代理买卖,证券发行与承销,收购兼并,资产重组,财务顾问,资产管理,投资咨询等综合金融服务' '198230687' '91450300198230687E' '广发证券股份有限公司' '广发证券' '广东' '广州市' '广东省广州市黄埔区中新广州知识城腾飞一街2号618室' '86-20-87555888,86-20-87550565,86-20-87550265' '广东省广州市天河区天河北路183-187号大都会广场40楼5楼,7楼,8楼,18楼,19楼,38-44楼' 'www.gf.com.cn' '孙树明' '林治海' [7.6211e+05] '19940121' [] [12103] '主营业务:证券经纪' '126335439' '91440000126335439C' 时间已过 2.602509 秒。
公募基金净值
tic; tData = api.query('fund_nav','ts_code','165509.SZ'); tData(1:gPara.len_demo,:) toc;
ans = 8×9 table ts_code ann_date end_date unit_nav accum_nav accum_div net_asset total_netasset adj_nav ___________ __________ __________ ________ _________ _________ _________ ______________ _______ '165509.SZ' '20181211' '20181210' 1.116 1.599 [] [] [] 1.7214 '165509.SZ' '20181207' '20181206' 1.116 1.599 [] [] [] 1.7214 '165509.SZ' '20181206' '20181205' 1.115 1.598 [] [] [] 1.7198 '165509.SZ' '20181205' '20181204' 1.114 1.597 [] [] [] 1.7183 '165509.SZ' '20181204' '20181203' 1.114 1.597 [] [] [] 1.7183 '165509.SZ' '20181201' '20181130' 1.113 1.596 [] [] [] 1.7167 '165509.SZ' '20181130' '20181129' 1.113 1.596 [] [] [] 1.7167 '165509.SZ' '20181129' '20181128' 1.113 1.596 [] [] [] 1.7167 时间已过 0.298360 秒。
公募基金分红
tic; tData = api.query('fund_div','ann_date','20181018'); tData(1:gPara.len_demo,:) toc;
ans = 8×16 table ts_code ann_date imp_anndate base_date div_proc record_date ex_date pay_date earpay_date net_ex_date div_cash base_unit ear_distr ear_amount account_date base_year ___________ __________ ___________ __________ ________ ___________ __________ __________ ___________ ___________ ________ __________ __________ ____________ ____________ __________ '161618.OF' '20181018' '20181018' '20180928' '实施' '20181022' '20181022' '20181024' [] [] 0.017 14982 5.0189e+06 [] '20181023' '20181022' '161619.OF' '20181018' '20181018' '20180928' '实施' '20181022' '20181022' '20181024' [] [] 0.015 2894.7 8.238e+05 [] '20181023' '20181022' '005485.OF' '20181018' '20181018' '20181015' '实施' '20181022' '20181022' '20181024' [] [] 0.018 1.01e+05 1.8689e+07 [] '20181023' '20181022' '519330.OF' '20181018' '20181018' '20181012' '实施' '20181022' '20181022' '20181024' [] [] 0.006 2.1974e+05 6.5923e+07 [1.3185e+07] [] '20181022' '519331.OF' '20181018' '20181018' '20181012' '实施' '20181022' '20181022' '20181024' [] [] 0.005 4.8656 1216.4 [ 243.2800] [] '20181022' '164702.SZ' '20181018' '20181018' '20180930' '实施' '20181022' '20181023' '20181024' [] [] 0.015 41287 8.0583e+06 [4.0291e+06] [] '20181022' '005068.OF' '20181018' '20181018' '20181016' '实施' '20181022' '20181022' '20181024' [] [] 0.0237 4953.9 1.1748e+06 [1.1748e+06] '20181023' '20181022' '519953.OF' '20181018' '20181018' '20181016' '实施' '20181022' '20181022' '20181024' [] [] 0.0191 23038 4.4087e+06 [4.4087e+06] '20181023' '20181022' 时间已过 0.122842 秒。
公募基金持仓数据
tic; tData = api.query('fund_portfolio','ts_code','001753.OF'); tData(1:gPara.len_demo,:) toc;
ans = 8×8 table ts_code ann_date end_date symbol mkv amount stk_mkv_ratio stk_float_ratio ___________ __________ __________ ___________ __________ __________ _____________ _______________ '001753.OF' '20181026' '20180930' '002024.SZ' 7.139e+06 5.296e+05 11.14 0.01 '001753.OF' '20181026' '20180930' '300577.SZ' 5.5805e+06 1.6911e+05 8.71 0.26 '001753.OF' '20181026' '20180930' '300383.SZ' 4.6045e+06 3.202e+05 7.19 0.02 '001753.OF' '20181026' '20180930' '300122.SZ' 4.3281e+06 88400 6.76 0.01 '001753.OF' '20181026' '20180930' '002384.SZ' 3.686e+06 3.009e+05 5.75 0.03 '001753.OF' '20181026' '20180930' '002368.SZ' 3.5997e+06 1.176e+05 5.62 0.03 '001753.OF' '20181026' '20180930' '600845.SH' 3.5956e+06 1.467e+05 5.61 0.02 '001753.OF' '20181026' '20180930' '600271.SH' 3.4342e+06 1.234e+05 5.36 0.01 时间已过 0.212737 秒。
场内基金日线行情
tic; tData = api.query('fund_daily','ts_code','510050.SH','start_date','20180101','end_date','20181201'); tData(1:gPara.len_demo,:) toc;
ans = 8×11 table ts_code trade_date pre_close open high low close change pct_chg vol amount ___________ __________ _________ _____ _____ _____ _____ ______ _______ __________ __________ '510050.SH' '20180102' 2.858 2.864 2.909 2.862 2.907 0.049 1.7145 4.777e+06 1.3835e+06 '510050.SH' '20180103' 2.907 2.909 2.945 2.906 2.912 0.005 0.172 5.7087e+06 1.6688e+06 '510050.SH' '20180104' 2.912 2.913 2.932 2.909 2.919 0.007 0.2404 3.0841e+06 9.0034e+05 '510050.SH' '20180105' 2.919 2.921 2.938 2.916 2.933 0.014 0.4796 3.2201e+06 9.4253e+05 '510050.SH' '20180108' 2.933 2.927 2.951 2.925 2.944 0.011 0.375 3.1255e+06 9.1849e+05 '510050.SH' '20180109' 2.944 2.942 2.97 2.941 2.97 0.026 0.8832 3.0971e+06 9.1668e+05 '510050.SH' '20180110' 2.97 2.967 2.996 2.96 2.994 0.024 0.8081 4.7791e+06 1.424e+06 '510050.SH' '20180111' 2.994 2.988 3.005 2.979 2.991 -0.003 -0.1002 3.2274e+06 9.6522e+05 时间已过 0.667262 秒。
ETC
over = 1;
Record Time
toc; displayEndOfDemoMessage(mfilename);
时间已过 0.674327 秒。