Shares Outstanding (1 Year - Growth)
Returns the 1-year percentage change in shares outstanding for a company.
Interpretation
- Negative values indicate share buybacks (shareholder-friendly)
- Positive values indicate dilution (new shares issued)
- Value is expressed as decimal (0.05 = 5% increase)
Data Source
Calculated from historical shares outstanding data.
Syntax
=SharesOutstandingOneYearChange(Symbol)Returns
number
1-year change in shares outstanding as decimal
Examples
=SharesOutstandingOneYearChange("AAPL")=SharesOutstandingOneYearChange("MSFT")From cell reference
When to Use
- Analyzing dilution risk
- Evaluating buyback programs
- Assessing shareholder value creation
- Stock-based compensation impact
When NOT to Use
| Scenario | Use Instead |
|---|---|
| 3-year trend | SharesOutstandingThreeYearChange() |
| Current share count | Shares_Outstanding() |
| Float shares | FloatShares() |
Common Issues & FAQ
What does a negative value mean?
The company has reduced shares outstanding (buybacks).
How is this calculated?
(Current shares - Shares 1 year ago) / Shares 1 year ago.
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?