Earnings Per Diluted Share (Historical)
Returns the historical diluted earnings per share (EPS) for a company. Diluted EPS includes the impact of all dilutive securities such as stock options, warrants, convertible bonds, and preferred stock.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol (e.g., AAPL, MSFT) |
| Year | Yes | Fiscal year (2023) or period code (lq, ly) |
| Quarter | No | Quarter number 1-4 (default: 1) |
| TTM | No | Set to "TTM" for trailing twelve months |
Period Codes
| Code | Description |
|---|---|
lq |
Last reported quarter |
lq-1 |
One quarter ago |
ly |
Last fiscal year |
ly-1 |
Previous fiscal year |
lt |
Last twelve months (TTM) |
Notes
- More conservative than basic EPS
- Includes dilutive effect of options, warrants, convertibles
- Commonly used for P/E ratio calculations
- May equal basic EPS if no dilutive securities or if dilution is antidilutive
Examples
=hf_Earnings_per_Diluted_Share("AAPL", 2023, 4)=hf_Earnings_per_Diluted_Share("MSFT", "ly")=hf_Earnings_per_Diluted_Share("NVDA", 2023, , "TTM")=hf_Earnings_per_Diluted_Share(A1, B1, C1)=hf_Earnings_per_Diluted_Share("TSLA", "lq-2")When to Use
- Calculating P/E ratios (most common approach)
- Conservative earnings analysis
- Companies with significant stock-based compensation
- Analyzing tech companies with many stock options
- Professional financial analysis
When NOT to Use
Common Issues & FAQ
Q: Why is diluted EPS the same as basic EPS? A: Either the company has no dilutive securities, or including them would be antidilutive (increase EPS), so they're excluded.
Q: Which EPS should I use for P/E ratios? A: Diluted EPS is standard for P/E calculations as it's more conservative.
Q: How is diluted share count calculated? A: It uses the treasury stock method for options/warrants and the if-converted method for convertible securities.
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?