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.
filing_dateThe date of the filing.
accepted_dateThe date the filing was accepted.
reported_currencyThe currency in which the cash flow statement was reported.
net_incomeNet income.
depreciation_and_amortizationDepreciation and amortization.
deferred_income_taxDeferred income tax.
stock_based_compensationStock-based compensation.
change_in_working_capitalChange in working capital.
change_in_account_receivablesChange in account receivables.
change_in_inventoryChange in inventory.
change_in_account_payableChange in account payable.
change_in_other_working_capitalChange in other working capital.
change_in_other_non_cash_itemsChange in other non-cash items.
net_cash_from_operating_activitiesNet cash from operating activities.
purchase_of_property_plant_and_equipmentPurchase of property, plant and equipment.
acquisitionsAcquisitions.
purchase_of_investment_securitiesPurchase of investment securities.
sale_and_maturity_of_investmentsSale and maturity of investments.
other_investing_activitiesOther investing activities.
net_cash_from_investing_activitiesNet cash from investing activities.
repayment_of_debtRepayment of debt.
issuance_of_common_equityIssuance of common equity.
repurchase_of_common_equityRepurchase of common equity.
payment_of_dividendsPayment of dividends.
other_financing_activitiesOther financing activities.
net_cash_from_financing_activitiesNet cash from financing activities.
effect_of_exchange_rate_changes_on_cashEffect of exchange rate changes on cash.
net_change_in_cash_and_equivalentsNet change in cash and equivalents.
cash_at_beginning_of_periodCash at beginning of period.
cash_at_end_of_periodCash at end of period.
operating_cash_flowOperating cash flow.
capital_expenditureCapital expenditure.
free_cash_flow
linkLink to the filing.
final_linkLink to the filing document.