使用R的雅虎季度财务数据

Question

我正在尝试通过网络抓取雅虎的财务数据。我已经找到了一个适用于某些数据的解决方案...但我不知道如何实现季度数据的飞跃。我想知道我是不是走错了路。这里有一个对我有效的解决方案，但我不知道如何从年度数据跃升到季度数据：R: web scraping yahoo.finance after 2019 change

Answer 1

抓取该页面的问题之一是它默认为年度数据。用户单击“季度”按钮后，将在浏览器中加载季度数据。虽然这不利于抓取，但对于截取API请求却很有好处。如果您在浏览器中打开您的开发人员控制台，转到Network选项卡，然后选择"Quarterly“按钮，您将看到一个请求(我将URL放在底部，因为它非常长)。请求将返回JSON数据。

免责声明:我对R了解不多，但是，在做了一些研究之后，我发现R有几个包可以让你读取JSON数据，你可以这样做：

# using rjson
url = "<get from down below>"
data = rjson::readJSON(file=url)

# using jsonlite
library(jsonlite)

url = "<get from down below>"
data <- readJSON(url)

以下是URL：

https://query1.finance.yahoo.com/ws/fundamentals-timeseries/v1/finance/premium/timeseries/AAPL?lang=en-US®ion=US&symbol=AAPL&padTimeSeries=true&type=annualEbitda%2CtrailingEbitda%2CannualDilutedAverageShares%2CtrailingDilutedAverageShares%2CannualBasicAverageShares%2CtrailingBasicAverageShares%2CannualDilutedEPS%2CtrailingDilutedEPS%2CannualBasicEPS%2CtrailingBasicEPS%2CannualNetIncomeCommonStockholders%2CtrailingNetIncomeCommonStockholders%2CannualNetIncome%2CtrailingNetIncome%2CannualNetIncomeContinuousOperations%2CtrailingNetIncomeContinuousOperations%2CannualTaxProvision%2CtrailingTaxProvision%2CannualPretaxIncome%2CtrailingPretaxIncome%2CannualOtherIncomeExpense%2CtrailingOtherIncomeExpense%2CannualInterestExpense%2CtrailingInterestExpense%2CannualOperatingIncome%2CtrailingOperatingIncome%2CannualOperatingExpense%2CtrailingOperatingExpense%2CannualSellingGeneralAndAdministration%2CtrailingSellingGeneralAndAdministration%2CannualResearchAndDevelopment%2CtrailingResearchAndDevelopment%2CannualGrossProfit%2CtrailingGrossProfit%2CannualCostOfRevenue%2CtrailingCostOfRevenue%2CannualTotalRevenue%2CtrailingTotalRevenue&merge=false&period1=493590046&period2=1596836602&corsDomain=finance.yahoo.com

你还可以使用另一个URL来获取季度损益表数据，但在使用美国以外的公司时似乎有点不稳定：

https://query2.finance.yahoo.com/v10/finance/quoteSummary/aapl?modules=incomeStatementHistoryQuarterly