MarketXLS

EPS Diluted Growth (Historical)

Returns historical diluted earnings per share growth rate for a company. This measures the year-over-year percentage change in diluted EPS, accounting for all potentially dilutive securities.

Formula

EPS Diluted Growth = ((Current Diluted EPS - Prior Diluted EPS) / Prior Diluted EPS) x 100

Supported Symbols

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ
International SYMBOL SHOP, TSM

Parameters

Parameter Description
Symbol Stock ticker symbol
Year Fiscal year (2020, 2021) or period code (lq, ly, lt)
Quarter Optional: 1, 2, 3, or 4 for quarterly data
TTM Optional: Set to "TTM" for trailing twelve months

Interpretation

Growth Interpretation
> 25% Strong growth
10-25% Good growth
0-10% Modest growth
< 0% Declining earnings

Notes

  • Diluted EPS includes impact of stock options and convertibles
  • Large percentage changes can occur from small base numbers
  • Negative prior EPS can result in unusual growth calculations

Syntax

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

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code (lq, ly, etc.)

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Diluted EPS growth rate as a percentage

Examples

=hf_EPS_Diluted_Growth("AAPL", 2023)
Apple EPS growth
=hf_EPS_Diluted_Growth("NVDA", 2023, 2)
Nvidia Q2 2023
=hf_EPS_Diluted_Growth("MSFT", "ly")
Microsoft last fiscal year
=hf_EPS_Diluted_Growth("GOOGL", 2023, , "TTM")
Alphabet TTM
=hf_EPS_Diluted_Growth(A1, B1, C1)
Cell references

When to Use

  • Analyzing earnings growth trends
  • Growth investing research
  • Comparing earnings momentum across companies
  • Identifying accelerating or decelerating growth
  • Valuation analysis (PEG ratio context)

When NOT to Use

Scenario Use Instead
Need basic EPS growth hf_EPS_Growth()
Need absolute EPS hf_EPS_Diluted()
Need current EPS EarningsPerShare()
Need revenue growth hf_Revenue_Growth()

Common Issues & FAQ

Why is NVDA growth so high?

When a company has rapid earnings expansion (like Nvidia in AI boom), growth rates can be very high. Small prior-year EPS amplifies percentage changes.

Why is growth negative despite higher EPS?

This shouldn't happen mathematically. Check if you're comparing correct periods.

Why am I getting "NA" or unusual values?

This occurs when prior EPS is zero, negative, or unavailable. Growth percentages are undefined in these cases.

Related Formulas

More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:

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 Diluted Growth (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions