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)Returns
Earnings per share
Examples
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.
Related Formulas
More MarketXLS Estimates formulas you can use in the same worksheet:
- EPS Estimate
- EPS Estimate Current Quarter
- EPS Estimate Current Year
- EPS Estimate Next Quarter
- EPS Estimate Next Year
- EPS Surprise
- EPS Surprise Percentage
- EPSEstimate Current Quarter
See QM_EPS used in a complete workbook: Earnings Surprise Screener Excel: Track Q1 2026 Earnings Beats and Misses in Real Time
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today