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.
reported_currencyThe currency in which the balance sheet is reported.
revenueTotal revenue
operating_revenueTotal operating revenue
cost_of_revenueTotal cost of revenue
operating_cost_of_revenueTotal operating cost of revenue
gross_profitTotal gross profit
gross_profit_marginGross margin ratio.
provision_for_credit_lossesProvision for credit losses
research_and_development_expenseResearch and development expense
selling_general_and_admin_expenseSelling, general, and admin expense
salaries_and_employee_benefitsSalaries and employee benefits
marketing_expenseMarketing expense
net_occupancy_and_equipment_expenseNet occupancy and equipment expense
other_operating_expensesOther operating expenses
depreciation_expenseDepreciation expense
amortization_expenseAmortization expense
amortization_of_deferred_policy_acquisition_costsAmortization of deferred policy acquisition costs
exploration_expenseExploration expense
depletion_expenseDepletion expense
total_operating_expensesTotal operating expenses
total_operating_incomeTotal operating income
deposits_and_money_market_investments_interest_incomeDeposits and money market investments interest income
federal_funds_sold_and_securities_borrowed_interest_incomeFederal funds sold and securities borrowed interest income
investment_securities_interest_incomeInvestment securities interest income
loans_and_leases_interest_incomeLoans and leases interest income
trading_account_interest_incomeTrading account interest income
other_interest_incomeOther interest income
total_non_interest_incomeTotal non-interest income
interest_and_investment_incomeInterest and investment income
short_term_borrowings_interest_expenseShort-term borrowings interest expense
long_term_debt_interest_expenseLong-term debt interest expense
capitalized_lease_obligations_interest_expenseCapitalized lease obligations interest expense
deposits_interest_expenseDeposits interest expense
federal_funds_purchased_and_securities_sold_interest_expenseFederal funds purchased and securities sold interest expense
other_interest_expenseOther interest expense
total_interest_expenseTotal interest expense
net_interest_incomeNet interest income
other_non_interest_incomeOther non-interest income
investment_banking_incomeInvestment banking income
trust_fees_by_commissionsTrust fees by commissions
premiums_earnedPremiums earned
insurance_policy_acquisition_costsInsurance policy acquisition costs
current_and_future_benefitsCurrent and future benefits
property_and_liability_insurance_claimsProperty and liability insurance claims
total_non_interest_expenseTotal non-interest expense
net_realized_and_unrealized_capital_gains_on_investmentsNet realized and unrealized capital gains on investments
other_gainsOther gains
non_operating_incomeNon-operating income
other_incomeOther income
other_revenueOther revenue
extraordinary_incomeExtraordinary income
total_other_incomeTotal other income
ebitdaEarnings Before Interest, Taxes, Depreciation and Amortization.
ebitda_marginMargin on Earnings Before Interest, Taxes, Depreciation and Amortization.
total_pre_tax_incomeTotal pre-tax income
ebitEarnings Before Interest and Taxes.
pre_tax_income_marginPre-Tax Income Margin.
income_tax_expenseIncome tax expense
impairment_chargeImpairment charge
restructuring_chargeRestructuring charge
service_charges_on_deposit_accountsService charges on deposit accounts
other_service_chargesOther service charges
other_special_chargesOther special charges
other_cost_of_revenueOther cost of revenue
net_income_continuing_operationsNet income (continuing operations)
net_income_discontinued_operationsNet income (discontinued operations)
consolidated_net_incomeConsolidated net income
other_adjustments_to_consolidated_net_incomeOther adjustments to consolidated net income
other_adjustment_to_net_income_attributable_to_common_shareholdersOther adjustment to net income attributable to common shareholders
net_income_attributable_to_noncontrolling_interestNet income attributable to noncontrolling interest
net_income_attributable_to_common_shareholdersNet income attributable to common shareholders
basic_earnings_per_shareBasic earnings per share
diluted_earnings_per_shareDiluted earnings per share
basic_and_diluted_earnings_per_shareBasic and diluted earnings per share
cash_dividends_to_common_per_shareCash dividends to common per share
preferred_stock_dividends_declaredPreferred stock dividends declared
weighted_average_basic_shares_outstandingWeighted average basic shares outstanding
weighted_average_diluted_shares_outstandingWeighted average diluted shares outstanding
weighted_average_basic_and_diluted_shares_outstandingWeighted average basic and diluted shares outstanding