Skip to main content

CASH

Get the cash flow statement for a given company.

Syntax

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

Examples

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

Parameters

NameTypeDescriptionRequired
symbolTextSymbol to get data for.True
periodTextTime period of the data to return.False
limitNumberThe number of data entries to return.False

Data

NameDescription
period_endingThe end date of the reporting period.
fiscal_periodThe fiscal period of the report.
fiscal_yearThe fiscal year of the fiscal period.
reported_currencyThe currency in which the balance sheet is reported.
net_income_continuing_operationsNet Income (Continuing Operations)
net_income_discontinued_operationsNet Income (Discontinued Operations)
net_incomeConsolidated Net Income.
provision_for_loan_lossesProvision for Loan Losses
provision_for_credit_lossesProvision for credit losses
depreciation_expenseDepreciation Expense.
amortization_expenseAmortization Expense.
share_based_compensationShare-based compensation.
non_cash_adjustments_to_reconcile_net_incomeNon-Cash Adjustments to Reconcile Net Income.
changes_in_operating_assets_and_liabilitiesChanges in Operating Assets and Liabilities (Net)
net_cash_from_continuing_operating_activitiesNet Cash from Continuing Operating Activities
net_cash_from_discontinued_operating_activitiesNet Cash from Discontinued Operating Activities
net_cash_from_operating_activitiesNet Cash from Operating Activities
divestituresDivestitures
sale_of_property_plant_and_equipmentSale of Property, Plant, and Equipment
acquisitionsAcquisitions
purchase_of_investmentsPurchase of Investments
purchase_of_investment_securitiesPurchase of Investment Securities
sale_and_maturity_of_investmentsSale and Maturity of Investments
loans_held_for_saleLoans Held for Sale (Net)
purchase_of_property_plant_and_equipmentPurchase of Property, Plant, and Equipment
other_investing_activitiesOther Investing Activities (Net)
net_cash_from_continuing_investing_activitiesNet Cash from Continuing Investing Activities
net_cash_from_discontinued_investing_activitiesNet Cash from Discontinued Investing Activities
net_cash_from_investing_activitiesNet Cash from Investing Activities
payment_of_dividendsPayment of Dividends
repurchase_of_common_equityRepurchase of Common Equity
repurchase_of_preferred_equityRepurchase of Preferred Equity
issuance_of_common_equityIssuance of Common Equity
issuance_of_preferred_equityIssuance of Preferred Equity
issuance_of_debtIssuance of Debt
repayment_of_debtRepayment of Debt
other_financing_activitiesOther Financing Activities (Net)
cash_interest_receivedCash Interest Received
net_change_in_depositsNet Change in Deposits
net_increase_in_fed_funds_soldNet Increase in Fed Funds Sold
net_cash_from_continuing_financing_activitiesNet Cash from Continuing Financing Activities
net_cash_from_discontinued_financing_activitiesNet Cash from Discontinued Financing Activities
net_cash_from_financing_activitiesNet Cash from Financing Activities
effect_of_exchange_rate_changesEffect of Exchange Rate Changes
other_net_changes_in_cashOther Net Changes in Cash
net_change_in_cash_and_equivalentsNet Change in Cash and Equivalents
cash_income_taxes_paidCash Income Taxes Paid
cash_interest_paidCash Interest Paid