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

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

Q: Why is share growth negative? A: Negative growth indicates share buybacks reducing outstanding shares.

Q: How does this affect EPS? A: Fewer shares means higher EPS even with flat earnings.

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

Related Functions