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.
accounts_receivable	Accounts receivable
marketable_securities	Marketable securities
prepaid_expenses	Prepaid expenses
other_current_assets	Other current assets
total_current_assets	Total current assets
property_plant_equipment_net	Property plant and equipment net
inventory	Inventory
other_non_current_assets	Other non-current assets
total_non_current_assets	Total non-current assets
intangible_assets	Intangible assets
total_assets	Total assets
accounts_payable	Accounts payable
employee_wages	Employee wages
other_current_liabilities	Other current liabilities
total_current_liabilities	Total current liabilities
other_non_current_liabilities	Other non-current liabilities
total_non_current_liabilities	Total non-current liabilities
long_term_debt	Long term debt
total_liabilities	Total liabilities
minority_interest	Minority interest
temporary_equity_attributable_to_parent	Temporary equity attributable to parent
equity_attributable_to_parent	Equity attributable to parent
temporary_equity	Temporary equity
preferred_stock	Preferred stock
redeemable_non_controlling_interest	Redeemable non-controlling interest
redeemable_non_controlling_interest_other	Redeemable non-controlling interest other
total_stock_holders_equity	Total stock holders equity
total_liabilities_and_stock_holders_equity	Total liabilities and stockholders equity
total_equity	Total equity