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

Syntax

=hf_Earnings_per_Diluted_Share(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Examples

=hf_Earnings_per_Diluted_Share("AAPL", 2023, 4)
Q4 2023 diluted EPS
=hf_Earnings_per_Diluted_Share("MSFT", "ly")
Last fiscal year
=hf_Earnings_per_Diluted_Share("NVDA", 2023, , "TTM")
Trailing 12 months
=hf_Earnings_per_Diluted_Share(A1, B1, C1)
From cell references
=hf_Earnings_per_Diluted_Share("TSLA", "lq-2")
Two quarters ago

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

Scenario Use Instead
Need basic EPS hf_Earnings_per_Basic_Share()
Need current TTM EPS EarningsPerShare()
Need EPS in USD hf_Earnings_per_Basic_Share_USD()
Need shares outstanding hf_Weighted_Average_Shares_Diluted()

Common Issues & FAQ

Why is diluted EPS the same as basic EPS?

Either the company has no dilutive securities, or including them would be antidilutive (increase EPS), so they're excluded.

Which EPS should I use for P/E ratios?

Diluted EPS is standard for P/E calculations as it's more conservative.

How is diluted share count calculated?

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
MarketXLS Excel Add-in Tutorial - How to Use Earnings Per Diluted Share (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions