获取所有股票基本信息

qh0526wy

于 2024-07-13 20:13:13 发布

阅读量64

点赞数 1

文章标签： python

本文链接：https://blog.csdn.net/qh0526wy/article/details/140405449

版权

@QhStarEndTime
def QhBasicXinXiDf(QhIsCsv=True,QhPs=2000):
    """
    股票基本信息 F10
    作者：阙辉
    """
    QhUrl = QHDFDBJSON["QhBasicXinXiDf"]["url"]           # 默认URL
    qh_params=QHDFDBJSON["QhBasicXinXiDf"]["params"]    # 请求参数

    QhUniqueValue = QHDFDBJSON["QhBasicXinXiDf"]["QhUniqueValue"]  # 唯一值参数获取
    QhCsvPath0 = QHDFDBJSON["QhBasicXinXiDf"]["QhCsvPath"]
    QhCsvPath0 = QhDbPathJieXiIsMkdir(QhCsvPath0,QHJSPATH)
    QhCsvName = copy.deepcopy(QHDFDBJSON["QhBasicXinXiDf"]["QhCsvName"])
    # QhCsvName = QhCsvName0.format(QhCode)
    QhCsvPath = "{}\{}".format(QhCsvPath0,QhCsvName)

    QhDateM = str(QhTimestamp()).replace("-","").replace(" ","").replace(":","")[:6]
    QhCsvNameM0 = copy.deepcopy(QHDFDBJSON["QhBasicXinXiDf"]["QhCsvNameM"])
    QhCsvNameM = QhCsvNameM0.format(QhDateM)
    QhCsvPathM = "{}\{}".format(QhCsvPath0,QhCsvNameM)
    # 基本信息
    qh_params["reportName"] = "RPT_F10_BASIC_ORGINFO"
    fielddic01 = QHDFDBJSON["QhBasicXinXiDf"]["fielddic"]["RPT_F10_BASIC_ORGINFO"]
    fielddic_keys01 = list(fielddic01.keys())        # 原key
    fielddic_values01 = list(fielddic01.values())   # 中文字段名
    QhJieGuoList01 = _QhRequestDataFor(QhUrl,qh_params,fielddic_keys01,QhPageC="pageNumber",QhType="C1",QhType0="C0",QhPs=QhPs,QhPageSize="pageSize")
    QhJieGuoDf01 = pd.DataFrame(QhJieGuoList01,columns = fielddic_values01)
    print(QhJieGuoDf01)
    # 发行信息
    qh_params["reportName"] = "RPT_PCF10_ORG_ISSUEINFO"
    qh_params["pageNumber"] = 1
    fielddic02 = QHDFDBJSON["QhBasicXinXiDf"]["fielddic"]["RPT_PCF10_ORG_ISSUEINFO"]
    fielddic_keys02 = list(fielddic02.keys())        # 原key
    fielddic_values02 = list(fielddic02.values())   # 中文字段名
    QhJieGuoList02 = _QhRequestDataFor(QhUrl,qh_params,fielddic_keys02,QhPageC="pageNumber",QhType="C1",QhType0="C0",QhPs=QhPs,QhPageSize="pageSize")
    QhJieGuoDf02 = pd.DataFrame(QhJieGuoList02,columns = fielddic_values02)
    print(QhJieGuoDf02)

    QhJieGuoDf = pd.merge(QhJieGuoDf01,QhJieGuoDf02,how = 'left',left_on=["JBXX股票代码"],right_on=["JBXX股票代码"])
    QhJieGuoDf.replace(to_replace=[None], value=np.nan, inplace=True)
    QhJieGuoDf["JBXX获取月份"] = QhDateM
    # QhJieGuoDf.replace(',', '，', inplace=True, regex=True)  # 使用其他字符
    print(QhJieGuoDf)

    # 存储数据 最新
    _QhDBToCsv(QhCsvPath,QhUniqueValue,QhJieGuoDf=QhJieGuoDf,QhDateSort="",QhIsCsv=QhIsCsv)  # 存储数据到CSV,如果请求报错以前存过则直接获取以前数据
    # 存储数据 按月 
    _QhDBToCsv(QhCsvPathM,QhUniqueValue,QhJieGuoDf=QhJieGuoDf,QhDateSort="",QhIsCsv=QhIsCsv)