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)
