Skip to main content

METRICS

Get fundamental metrics for a given company.

Syntax

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

Examples

=OBB.EQUITY.FUNDAMENTAL.METRICS("AAPL")
=OBB.EQUITY.FUNDAMENTAL.METRICS("AAPL","annual",100)

Parameters

NameTypeDescriptionRequired
symbolTextSymbol to get data for. Multiple comma separated items allowed.True
periodTextTime period of the data to return.False
limitNumberThe number of data entries to return.False
with_ttmBooleanInclude trailing twelve months (TTM) data.False

Data

NameDescription
symbolSymbol representing the entity requested in the data.
market_capMarket capitalization
pe_ratioPrice-to-earnings ratio (P/E ratio)
period_endingPeriod ending date.
fiscal_periodPeriod of the data.
fiscal_yearCalendar year for the fiscal period.
revenue_per_shareRevenue per share
capex_per_shareCapital expenditures per share
net_income_per_shareNet income per share
operating_cash_flow_per_shareOperating cash flow per share
free_cash_flow_per_shareFree cash flow per share
cash_per_shareCash per share
book_value_per_shareBook value per share
tangible_book_value_per_shareTangible book value per share
shareholders_equity_per_shareShareholders equity per share
interest_debt_per_shareInterest debt per share
price_to_salesPrice-to-sales ratio
price_to_operating_cash_flowPrice-to-operating cash flow ratio
price_to_free_cash_flowPrice-to-free cash flow ratio
price_to_bookPrice-to-book ratio
price_to_tangible_bookPrice-to-tangible book ratio
ev_to_salesEnterprise value-to-sales ratio
ev_to_ebitdaEnterprise value-to-EBITDA ratio
ev_to_operating_cash_flowEnterprise value-to-operating cash flow ratio
ev_to_free_cash_flowEnterprise value-to-free cash flow ratio
earnings_yieldEarnings yield
free_cash_flow_yieldFree cash flow yield
debt_to_market_capDebt-to-market capitalization ratio
debt_to_equityDebt-to-equity ratio
debt_to_assetsDebt-to-assets ratio
net_debt_to_ebitdaNet debt-to-EBITDA ratio
current_ratioCurrent ratio
interest_coverageInterest coverage
income_qualityIncome quality
payout_ratioPayout ratio
sales_general_and_administrative_to_revenueSales general and administrative expenses-to-revenue ratio
research_and_development_to_revenueResearch and development expenses-to-revenue ratio
intangibles_to_total_assetsIntangibles-to-total assets ratio
capex_to_operating_cash_flowCapital expenditures-to-operating cash flow ratio
capex_to_revenueCapital expenditures-to-revenue ratio
capex_to_depreciationCapital expenditures-to-depreciation ratio
stock_based_compensation_to_revenueStock-based compensation-to-revenue ratio
working_capitalWorking capital
tangible_asset_valueTangible asset value
net_current_asset_valueNet current asset value
enterprise_valueEnterprise value
invested_capitalInvested capital
average_receivablesAverage receivables
average_payablesAverage payables
average_inventoryAverage inventory
days_sales_outstandingDays sales outstanding
days_payables_outstandingDays payables outstanding
days_of_inventory_on_handDays of inventory on hand
receivables_turnoverReceivables turnover
payables_turnoverPayables turnover
inventory_turnoverInventory turnover
return_on_equityReturn on equity
return_on_invested_capitalReturn on invested capital
return_on_tangible_assetsReturn on tangible assets
dividend_yieldDividend yield, as a normalized percent.
graham_numberGraham number
graham_net_netGraham net-net working capital