EPS (On Demand)

Returns the earnings per share (EPS) for a stock using QuoteMedia's on-demand data service.

What is EPS?

Earnings Per Share (EPS) is calculated as:

EPS = Net Income / Shares Outstanding

It represents the portion of a company's profit allocated to each outstanding share of common stock.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT

Parameters

Parameter Type Required Description
Symbol String Yes Stock ticker symbol

Notes

  • Typically returns trailing twelve months (TTM) EPS
  • Negative EPS indicates a loss
  • Used to calculate P/E ratio

Syntax

=QM_EPS(Symbol)
Excel Desktop (Windows)

Examples

=QM_EPS("AAPL")
Apple EPS
=QM_EPS("MSFT")
Microsoft EPS
=QM_EPS("TSLA")
Tesla EPS
=QM_Last("AAPL")/QM_EPS("AAPL")
Calculate P/E ratio
=QM_EPS(A1)
Symbol from cell reference

When to Use

  • Fundamental analysis
  • Calculate P/E ratio
  • Compare earnings across companies
  • Valuation analysis

When NOT to Use

Scenario Use Instead
Need historical EPS hf_EPS() or historical functions
Need forward estimates Analyst estimate functions
Need diluted EPS Check for diluted EPS function

Common Issues & FAQ

Why is EPS negative?

Negative EPS indicates the company had a net loss for the period. This is common for growth companies reinvesting heavily.

Is this basic or diluted EPS?

This typically returns basic EPS. For diluted EPS that accounts for stock options and convertibles, check for dedicated diluted EPS functions.

What time period does this cover?

This usually returns trailing twelve months (TTM) EPS.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use EPS (On Demand) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions