Lots of zeros abnormally obtained when downloading companies' financials

[FV83]

Hello, I'm using the 'yahoofinancer' package to download quartely financials from yahoo. In the last few weeks, I have faced this issue: I get 0 values for many financial metrics for the last available quarter. For example, when loading the 'alphabet' quarterly financials, I get 0s for variables such as 'total revenues' or 'net income' for quarter ending '2023-03-31', although non-zero values are displayed on yahoo.finance.com (https://finance.yahoo.com/quote/GOOG/financials?p=GOOG).

alphabet.financials <- Ticker$new("GOOG")$get_income_statement('quarter') print(alphabet.financials[,c("end_date","total_revenue","ebit","net_income")])

A tibble: 4 × 4

end_date total_revenue ebit net_income

1 2023-03-31 0 17415000000 0 2 2022-12-31 76048000000 18160000000 13624000000 3 2022-09-30 69092000000 17135000000 13910000000 4 2022-06-30 69685000000 19453000000 16002000000

[aravindhebbali]

Hi.. The error seems to be in the Yahoo Finance API. As you rightly said, the data is available on the website but the API is not returning them. You can see the data returned by the API using the below link:

https://query1.finance.yahoo.com/v10/finance/quoteSummary/goog?modules=incomeStatementHistoryQuarterly&corsDomain=finance.yahoo.com

[charliestanislav]

I have this same problem, I have a bunch of companies that reported a couple weeks ago, but none of their Q1 results are showing up? Is there a cadence to when the API is refreshed, or is it a regular lag (like a month?) inbetween when the earnings are posted on Yahoo and when they are in the API?

[aravindhebbali]

Since there is no official documentation available for the API, I cannot say for sure when the API is refreshed or if there is a lag between data we see on the website and the data returned by the API.