Skip to main content

INCOME

Get the income statement for a given company.

Syntax

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

Examples

=OBB.EQUITY.FUNDAMENTAL.INCOME("AAPL")
=OBB.EQUITY.FUNDAMENTAL.INCOME("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 when the filing was made.
accepted_dateThe date and time when the filing was accepted.
reported_currencyThe currency in which the balance sheet was reported.
revenueTotal revenue.
cost_of_revenueCost of revenue.
gross_profitGross profit.
gross_profit_marginGross profit margin.
general_and_admin_expenseGeneral and administrative expenses.
research_and_development_expenseResearch and development expenses.
selling_and_marketing_expenseSelling and marketing expenses.
selling_general_and_admin_expenseSelling, general and administrative expenses.
other_expensesOther expenses.
total_operating_expensesTotal operating expenses.
cost_and_expensesCost and expenses.
interest_incomeInterest income.
total_interest_expenseTotal interest expenses.
depreciation_and_amortizationDepreciation and amortization.
ebitdaEBITDA.
ebitda_marginEBITDA margin.
total_operating_incomeTotal operating income.
operating_income_marginOperating income margin.
total_other_income_expensesTotal other income and expenses.
total_pre_tax_incomeTotal pre-tax income.
pre_tax_income_marginPre-tax income margin.
income_tax_expenseIncome tax expense.
consolidated_net_incomeConsolidated net income.
net_income_marginNet income margin.
basic_earnings_per_shareBasic earnings per share.
diluted_earnings_per_shareDiluted earnings per share.
weighted_average_basic_shares_outstandingWeighted average basic shares outstanding.
weighted_average_diluted_shares_outstandingWeighted average diluted shares outstanding.
linkLink to the filing.
final_linkLink to the filing document.