富途牛牛API：https://www.futunn.com/openAPI

富途牛牛最新文档：https://futunnopen.github.io/futu-api-doc/api/Quote_API.html#id2

富途牛牛帮助：https://help.futu5.com/faq/category366/scid680

实践

安装anaconda就会附带将python3安装了： https://www.anaconda.com/download/

同时将vscode一并安装，设置settings的pythonpath搜索下的settings.json为如图配置

"python.pythonPath": "D:\\ProgramData\\Anaconda3"

安装参照视频：https://live.futunn.com/record/151?ch=0 但是视频已过时最新操作要使用pip install futu-API

首先要tuple处理，之后再在pandas中遍历DataFrame行得到最终数据：https://blog.csdn.net/ls13552912394/article/details/79349809

数据库实践案例：

插入数据

from futu import *
import pymssql
quote_ctx = OpenQuoteContext(host='127.0.0.1', port=11111)
quote_ctx.subscribe(['HK.00700'], [SubType.BROKER])
#print(quote_ctx.get_broker_queue('HK.00700'))
re=quote_ctx.get_broker_queue('HK.00700')
nlist=list(re)
#print(nlist)
nub=0
server="127.0.0.1"    # 连接服务器地址
user="sa"
password="123456"
conn=pymssql.connect(server, user, password, "test")  #获取连接
cursor = conn.cursor() # 获取光标
for new in nlist:
    if nub==2:
        print(new)
        for index,row in new.iterrows():
            print(row["code"],row["ask_broker_id"],row["ask_broker_name"],row["ask_broker_pos"])
            cursor.executemany("INSERT INTO T_PyFUTU VALUES (%s, %d, %s,%s)",[(row["code"],row["ask_broker_id"],row["ask_broker_name"], row["ask_broker_pos"])])
        #new.to_html('D:a.html')
    nub+=1
conn.commit()
conn.close()
quote_ctx.close()