python调用通达信函数_python获取通达信基本数据源码

1、安装python,执行以下脚本

wget https://repo.anaconda.com/miniconda/Miniconda3-latest-Linux-x86_64.sh

chmod a+x Miniconda3-latest-Linux-x86_64.sh

./Miniconda3-latest-Linux-x86_64.sh

2、python安装quanaxis依赖，详情参照文档

案例1：获取板块数据

import QUANTAXIS as QA

import mysql.connector

import pandas as pd

import time

from retrying import retry

mydb = mysql.connector.connect(

host="", # 数据库主机地址

user="", # 数据库用户名

passwd="", # 数据库密码

database="" # 数据库

)

mycursor = mydb.cursor()

QA.QA_util_log_info('板块数据')

data=QA.QAFetch.QATdx.QA_fetch_get_stock_block()

data = pd.DataFrame(data.values,columns=data.columns)

sql = "INSERT INTO fa_stock_block (blockname, code, type, source, createtime, updatetime) VALUES (%s, %s, %s, %s,%s,%s)"

for i in range(len(data.index)):

intime = int(time.time())

val = (data['blockname'][i],data['code'][i],data['type'][i],data['source'][i],intime,intime)

mycursor.execute(sql, val)

print(val)

mydb.commit() # 数据表内容有更新，必须使用到该语句

print(mycursor.rowcount, "记录插入成功。")

案例2：获取股票列表

import QUANTAXIS as QA

import mysql.connector

import pandas as pd

import time

from retrying import retry

mydb = mysql.connector.connect(

host="", # 数据库主机地址

user="", # 数据库用户名

passwd="", # 数据库密码

database="" # 数据库

)

mycursor = mydb.cursor()

QA.QA_util_log_info