BALANCE

Get the balance sheet for a given company.

Syntax

=OBB.EQUITY.FUNDAMENTAL.BALANCE(symbol,[period],[limit])

Examples

=OBB.EQUITY.FUNDAMENTAL.BALANCE("AAPL")

=OBB.EQUITY.FUNDAMENTAL.BALANCE("AAPL","annual",5)

---

Parameters

Name	Type	Description	Required
symbol	Text	Symbol to get data for.	True
period	Text	Time period of the data to return.	False
limit	Number	The number of data entries to return.	False

---

Data

• fmp

Name	Description
period_ending	The end date of the reporting period.
fiscal_period	The fiscal period of the report.
fiscal_year	The fiscal year of the fiscal period.
filing_date	The date when the filing was made.
accepted_date	The date and time when the filing was accepted.
reported_currency	The currency in which the balance sheet was reported.
cash_and_cash_equivalents	Cash and cash equivalents.
short_term_investments	Short term investments.
cash_and_short_term_investments	Cash and short term investments.
net_receivables	Net receivables.
inventory	Inventory.
other_current_assets	Other current assets.
total_current_assets	Total current assets.
plant_property_equipment_net	Plant property equipment net.
goodwill	Goodwill.
intangible_assets	Intangible assets.
goodwill_and_intangible_assets	Goodwill and intangible assets.
long_term_investments	Long term investments.
tax_assets	Tax assets.
other_non_current_assets	Other non current assets.
non_current_assets	Total non current assets.
other_assets	Other assets.
total_assets	Total assets.
accounts_payable	Accounts payable.
short_term_debt	Short term debt.
tax_payables	Tax payables.
current_deferred_revenue	Current deferred revenue.
other_current_liabilities	Other current liabilities.
total_current_liabilities	Total current liabilities.
long_term_debt	Long term debt.
deferred_revenue_non_current	Non current deferred revenue.
deferred_tax_liabilities_non_current	Deferred tax liabilities non current.
other_non_current_liabilities	Other non current liabilities.
total_non_current_liabilities	Total non current liabilities.
other_liabilities	Other liabilities.
capital_lease_obligations	Capital lease obligations.
total_liabilities	Total liabilities.
preferred_stock	Preferred stock.
common_stock	Common stock.
retained_earnings	Retained earnings.
accumulated_other_comprehensive_income	Accumulated other comprehensive income (loss).
other_shareholders_equity	Other shareholders equity.
other_total_shareholders_equity	Other total shareholders equity.
total_common_equity	Total common equity.
total_equity_non_controlling_interests	Total equity non controlling interests.
total_liabilities_and_shareholders_equity	Total liabilities and shareholders equity.
minority_interest	Minority interest.
total_liabilities_and_total_equity	Total liabilities and total equity.
total_investments	Total investments.
total_debt	Total debt.
net_debt	Net debt.
link	Link to the filing.
final_link	Link to the filing document.