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
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
Q: Why is EPS negative? A: Negative EPS indicates the company had a net loss for the period. This is common for growth companies reinvesting heavily.
Q: Is this basic or diluted EPS? A: This typically returns basic EPS. For diluted EPS that accounts for stock options and convertibles, check for dedicated diluted EPS functions.
Q: What time period does this cover? A: 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
▶
How does MarketXLS work?