Shares Outstanding (3 Year - Growth)
Returns the 3-year percentage change in shares outstanding for a company.
Interpretation
- Negative values indicate net buybacks over 3 years
- Positive values indicate net dilution over 3 years
- Value is expressed as decimal (0.10 = 10% increase)
Data Source
Calculated from historical shares outstanding data.
Syntax
=SharesOutstandingThreeYearChange(Symbol)Returns
number
3-year change in shares outstanding as decimal
Examples
=SharesOutstandingThreeYearChange("AAPL")=SharesOutstandingThreeYearChange("MSFT")When to Use
- Long-term dilution analysis
- Evaluating capital allocation
- Multi-year buyback assessment
- Value creation analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| 1-year trend | SharesOutstandingOneYearChange() |
| Current share count | Shares_Outstanding() |
| Float shares | FloatShares() |
Common Issues & FAQ
Why use 3-year vs 1-year?
3-year shows long-term capital allocation patterns, smoothing annual volatility.
What causes share count changes?
Stock buybacks (reduce), stock compensation (increase), secondary offerings (increase).
Related Formulas
More MarketXLS Growth 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
▶
How does MarketXLS work?