python实现基于基本面和当天交易信息的选股模型

# 写入excel
def write_excel(data_list):
    full_excel = openpyxl.Workbook()
    full_sheet = full_excel.active
    for i in range(0, len(data_list)):
        full_sheet.append(data_list[i])
    file_name = "D:\\dev\\python\\download\\quantumMethod.xls"
    full_excel.save(file_name)
    full_excel.close()

# 莫伦模型
# 指标1：过去5年平均净资产收益率大于14%
# 指标2：0<市盈率<30
# 指标3：经营现金流为正
# 指标4：新期净利润大于前5年净利润
# stock_financial_analysis_indicator_df = ak.stock_financial_analysis_indicator(symbol="600571", start_year="20223")
# print(stock_financial_analysis_indicator_df)
stock_zh_a_spot_df = ak.stock_zh_a_spot_em()
# print(stock_zh_a_spot_df.head(100)) .isin('sh603960','002085','')
df_stock = stock_zh_a_spot_df[['代码', '名称', '最新价', '成交量', '换手率', '60日涨跌幅', '年初至今涨跌幅']]
anyData = {'stock': '00', 'name': &#