URLS循环以获取金融数据

Question

我有一个代码，我试图获得财务状况，但我的问题是，我只收到在excel的第一个网址“年收入”，而不是四个标签。下面的代码如果有人知道我做错了什么，以及应该做什么更改以获得每个链接的四个选项卡：

import requests
from bs4 import BeautifulSoup
import pandas as pd

headers = {'user-agent' : 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0', 'Access-Control-Allow-Origin': '*',
    'Access-Control-Allow-Methods': 'GET',
    'Access-Control-Allow-Headers': 'Content-Type',
    'Access-Control-Max-Age': '3600'}

ticker = "BABA"

urls= {}
urls['income annually']= f"https://stockanalysis.com/stocks/{ticker}/financials/"
urls['balance sheet annually']= f"https://stockanalysis.com/stocks/{ticker}/financials/balance-sheet/"
urls['cash flow annually']= f"https://stockanalysis.com/stocks/{ticker}/financials/cash-flow-statement/"
urls['ratios annually']= f"https://stockanalysis.com/stocks/{ticker}/financials/ratios/"


xlwriter =pd.ExcelWriter(f'financial statements ({ticker}).xlsx', engine='xlsxwriter')

for key in urls.keys():
    response = requests.get(urls[key], headers=headers)
    soup = BeautifulSoup(response.content, 'html.parser')
    df = pd.read_html(str(soup), attrs={'id': 'financial-table'})[0]
    df.to_excel(xlwriter, sheet_name=key, index=False)

    xlwriter.save()

Answer 1

最后一行的缩进是错误的。它会关闭该文件。

更正：

for key in urls.keys():
    ...
    df.to_excel(xlwriter, sheet_name=key, index=False)

xlwriter.save()