def test_dataview_universe(): ds = RemoteDataService() ds.init_from_config(data_config) dv = DataView() props = { 'start_date': 20170227, 'end_date': 20170327, 'universe': '000016.SH', # 'symbol': 'rb1710.SHF,rb1801.SHF', 'fields': ('open,high,low,close,vwap,volume,turnover,' + 'sw1,zz2,' + 'roe,net_assets,' + 'total_oper_rev,oper_exp,tot_profit,int_income'), 'freq': 1 } dv.init_from_config(props, ds) dv.prepare_data() data_bench = dv.data_benchmark.copy() dv.data_benchmark = data_bench try: dv.data_benchmark = data_bench.iloc[3:] except ValueError: pass dv.remove_field('roe,net_assets') dv.remove_field('close')
def test_dataview_universe(): ds = RemoteDataService() ds.init_from_config(data_config) dv = DataView() props = {'start_date': 20170227, 'end_date': 20170327, 'universe': '000016.SH', # 'symbol': 'rb1710.SHF,rb1801.SHF', 'fields': ('open,high,low,close,vwap,volume,turnover,' + 'sw1,zz2,' + 'roe,net_assets,' + 'total_oper_rev,oper_exp,tot_profit,int_income' ), 'freq': 1} dv.init_from_config(props, ds) dv.prepare_data() data_bench = dv.data_benchmark.copy() dv.data_benchmark = data_bench try: dv.data_benchmark = data_bench.iloc[3:] except ValueError: pass dv.remove_field('roe,net_assets') dv.remove_field('close')
print(dv.get_ts('roe_pb').head()) #这里用get_ts的方法输入新的名称即可 #5_从数据服务添加新数据至本地 #先设置Config data_config = { "remote.data.address": "tcp://data.tushare.org:8910", #地址统一,暂不做修改 "remote.data.username": "******", #quantos账号(手机号码) #quantos账号的API令牌号码 "remote.data.password": "******" } ds = RemoteDataService() #DataService启动 ds.init_from_config(data_config) #data_config启动 dv.add_field('eps_basic', ds) #添加新数据(eps_basic)至本地(ds) print(dv.get_ts('eps_basic').head()) A = dv.get_ts('eps_basic').head() #get_ts为数据获取 dv.remove_field('eps_basic') #删除数据(eps_basic) dv.add_field('volume', ds) #添加新数据至本地(ds) A = dv.get_ts('volume').head() dv.save_dataview('G:/data/hs300') #保存 dv.save_dataview('G:/data/hs300_1') #这相当于另存为 print(dv.fields) #查看dv中取得的数据 dv.add_field('roe', ds) #添加新数据至本地(ds)