python与wind和excel联动，调用wind接口【附源码】_from windpy import w

一、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()
1
2
3
4
5
6
7
8
9
10
11
12

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
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