Skip to content

Missing keys in quarterly balance sheet. #2605

@beetleb

Description

@beetleb

Describe bug

For some tickers, the quarterly balance sheet isn't returning all the fields.

As an example, https://finance.yahoo.com/quote/BRK-B/balance-sheet/ is not getting the following fields:

Fixed Maturity Investments
Equity Investments
Net Loan
Deferred Assets
Other Assets

Here is a simple reproducer.

Simple code that reproduces your problem

import yfinance as yf
from pprint import pprint

date = "2025-06-30"

TICKER = "BRK-B"
tickers = yf.Tickers(TICKER)
pprint(tickers.tickers[TICKER].quarterly_balancesheet[date].to_dict())

keys = list(tickers.tickers[TICKER].quarterly_balancesheet[date].to_dict().keys())
print(keys)

Debug log from yf.enable_debug_mode()

DEBUG    Entering _fetch_time_series()
DEBUG     Entering get()
DEBUG      Entering _make_request()
DEBUG       url=https://query2.finance.yahoo.com/ws/fundamentals-timeseries/v1/finance/timeseries/BRK-B?symbol=BRK-B&type=quarterlyTreasurySharesNumber,quarterlyPreferredSharesNumber,quarterlyOrdinarySharesNumber,qua...
DEBUG       params=None
DEBUG       Entering _get_cookie_and_crumb()
DEBUG        cookie_mode = 'basic'
DEBUG        Entering _get_cookie_and_crumb_basic()
DEBUG         Entering _get_cookie_basic()
DEBUG          Entering _load_cookie_curlCffi()
DEBUG          Exiting _load_cookie_curlCffi()
DEBUG          reusing persistent cookie
DEBUG         Exiting _get_cookie_basic()
DEBUG         Entering _get_crumb_basic()
DEBUG          Entering _get_cookie_basic()
DEBUG           reusing cookie
DEBUG          Exiting _get_cookie_basic()
DEBUG          crumb = 'ii3TA91FmHM'
DEBUG         Exiting _get_crumb_basic()
DEBUG        Exiting _get_cookie_and_crumb_basic()
DEBUG       Exiting _get_cookie_and_crumb()
DEBUG       response code=200
DEBUG      Exiting _make_request()
DEBUG     Exiting get()
DEBUG    Exiting _fetch_time_series()

Bad data proof

https://finance.yahoo.com/quote/BRK-B/balance-sheet/

yfinance version

0.2.66

Python version

3.12.9

Operating system

Linux

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions