MarketXLS

Weighted Average Share Growth (Historical)

Returns the historical growth rate of weighted average shares outstanding. This measures share dilution or buyback activity.

Formula

Share Growth = (Current Shares - Prior Shares) / Prior Shares

Parameters

Parameter Required Description
Symbol Yes Stock ticker symbol
Year Yes Fiscal year or period code
Quarter No Quarter 1-4
TTM No "TTM" for trailing twelve months

Interpretation

  • Negative values indicate share buybacks (shareholder-friendly)
  • Positive values indicate dilution
  • Important for EPS growth analysis

Syntax

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

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Share growth rate as decimal

Examples

=hf_Weighted_Average_Share_Growth("AAPL", 2023, 4)
Q4 2023 (buybacks)
=hf_Weighted_Average_Share_Growth("TSLA", "ly")
Last year growth
=hf_Weighted_Average_Share_Growth("GOOGL", 2023, , "TTM")
TTM share growth

When to Use

  • Analyzing dilution impact
  • Tracking buyback programs
  • Understanding EPS drivers
  • Shareholder value assessment

When NOT to Use

Scenario Use Instead
Current shares Shares_Outstanding()
Basic shares hf_Shares_Basic()
Float shares FloatShares()

Common Issues & FAQ

Why is share growth negative?

Negative growth indicates share buybacks reducing outstanding shares.

How does this affect EPS?

Fewer shares means higher EPS even with flat earnings.

Related Formulas

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

Market data in your Excel sheets

1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.

See plans
MarketXLS Excel Add-in Tutorial - How to Use Weighted Average Share Growth (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions