一、python安装wind接口
二、案例
from WindPy import w
# 导入wind模块
import xlwings as xw
#导入xlwings实现与excel联动
app = xw.App(visible=False, add_book=False)
excel = app.books
xw.App.display_alerts = False
xw.App.screen_updating = False
#启动wind
w.start()
#wind是否接连
w.isconnected()
class Stock_match(object):
def __init__(self, code):
self.code = code
def indus_wind(self):
'获取行业信息:股票、债券,债券发行机构'
indus_tab = []
indus = w.wss(self.code, "industry_csrc12_n", "industryType=3;tradeDate=20220507").Data
for induss in indus[0]:
indus_tab.append(acc_corsp.range(find_myvalue(acc_corsp.range("o1:o96"), induss, 1)).value)
return indus_tab
def stock_name(self):
'获取股票、债券、基金、期货简称'
stock_name = w.wss(self.code, "sec_name").Data
return stock_name[0]
def company_size(self):
'企业规模:股票,债券'
company_size_tab = []
company_size = w.wss(self.code, "corpscale", "tradeDate=20220506").Data
for com_size in company_size[0]:
if com_size == "大型":
company_size_tab.append("02 大型企业")
elif com_size == "中型" or com_size == "小型":
company_size_tab.append("01 中小微企业")
else:
company_size_tab.append("99 其他")
return company_size_tab
def exchange_cn(self):
'交易地点:股票,基金,债券,期货'
exchange_place = []
exchange_cn = w.wss(self.code, "exchange_cn").Data
# print("交易地点:",exchange_cn)
for exchang_place in exchange_cn[0]:
if exchang_place == "上海证券交易所":
exchange_place.append("03 上海证券交易所")
elif exchang_place == "深圳证券交易所":
exchange_place.append("04 深圳证券交易所")
elif exchang_place == "全国银行间同业拆借中心":
exchange_place.append("01 银行间债券市场")
elif