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

Name	Type	Description	Required
symbol	Text	Symbol to get data for. Multiple comma separated items allowed.	True
period	Text	Time period of the data to return.	False
limit	Number	The number of data entries to return.	False
with_ttm	Boolean	Include trailing twelve months (TTM) data.	False

---

Data

• fmp

Name	Description
symbol	Symbol representing the entity requested in the data.
market_cap	Market capitalization
pe_ratio	Price-to-earnings ratio (P/E ratio)
price_to_book	Price to book ratio.
price_to_tangible_book	Price to tangible book ratio.
price_to_revenue	Price to revenue ratio.
quick_ratio	Quick ratio.
gross_margin	Gross margin, as a normalized percent.
ebit_margin	EBIT margin, as a normalized percent.
profit_margin	Profit margin, as a normalized percent.
eps	Basic earnings per share.
eps_growth	EPS growth, as a normalized percent.
revenue_growth	Revenue growth, as a normalized percent.
ebitda_growth	EBITDA growth, as a normalized percent.
ebit_growth	EBIT growth, as a normalized percent.
net_income_growth	Net income growth, as a normalized percent.
free_cash_flow_to_firm_growth	Free cash flow to firm growth, as a normalized percent.
invested_capital_growth	Invested capital growth, as a normalized percent.
return_on_assets	Return on assets, as a normalized percent.
return_on_equity	Return on equity, as a normalized percent.
return_on_invested_capital	Return on invested capital, as a normalized percent.
ebitda	Earnings before interest, taxes, depreciation, and amortization.
ebit	Earnings before interest and taxes.
long_term_debt	Long-term debt.
total_debt	Total debt.
total_capital	The sum of long-term debt and total shareholder equity.
enterprise_value	Enterprise value.
free_cash_flow_to_firm	Free cash flow to firm.
altman_z_score	Altman Z-score.
beta	Beta relative to the broad market (rolling three-year).
dividend_yield	Dividend yield, as a normalized percent.
earnings_yield	Earnings yield, as a normalized percent.
last_price	Last price of the stock.
year_high	52 week high
year_low	52 week low
volume_avg	Average daily volume.
short_interest	Number of shares reported as sold short.
shares_outstanding	Weighted average shares outstanding (TTM).
days_to_cover	Days to cover short interest, based on average daily volume.