macrotrends金融数据抓取

redstoneleo

于 2021-07-17 21:55:09 发布

阅读量684

点赞数

本文链接：https://blog.csdn.net/redstoneleo/article/details/118863292

版权

Python 专栏收录该内容

48 篇文章

订阅专栏


def createLIBOR_Rate_CSV():
    for LIBOR_Rate_Date_Period, DataId in LIBOR_Rate_Date_Period2DataId.items():
        webpageSourceCode = getWebResponseText(f'https://www.macrotrends.net/assets/php/chart_iframe_comp.php?id={DataId}&url=1-month-libor-rate-historical-chart')
        originalDataStr = originalDataPtn.search(webpageSourceCode, pos=8000).group(1)

        rowDataList = []
        for tableRowData in eval(originalDataStr):
            rowDataList.append([tableRowData['date'], tableRowData.get('close')])  # 后面这个数据最近几天没有值
        # print(rowDataList)
        with open(f'./FinancialCharts/static/FinancialCharts/FinancialData/{LIBOR_Rate_Date_Period}.csv', 'w', newline='') as csvfile:  # If csvfile is a file object, it should be opened with newline=''
            writer = csv.writer(csvfile)  # , quoting=csv.QUOTE_NONNUMERIC
            writer.writerow(['date', 'close'])
            writer.writerows(rowDataList)