Share Dilution Ratio (Historical)
Returns historical share dilution ratio for a company. This ratio measures the impact of potentially dilutive securities (stock options, convertible bonds, warrants) on the share count. It is calculated as Diluted Shares Outstanding divided by Basic Shares Outstanding.
Formula
Share Dilution Ratio = Diluted Shares Outstanding / Basic Shares OutstandingSupported 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
| Value | Interpretation |
|---|---|
| 1.00 | No dilution |
| 1.01 - 1.05 | Low dilution (1-5%) |
| 1.05 - 1.10 | Moderate dilution (5-10%) |
| > 1.10 | High dilution (>10%) |
Notes
- Higher ratios indicate more potential dilution from stock-based compensation
- Tech companies often have higher dilution due to stock options
- Watch for increasing dilution trends over time
Examples
=hf_Share_Dilution_Ratio("AAPL", 2023)=hf_Share_Dilution_Ratio("TSLA", 2023, 2)=hf_Share_Dilution_Ratio("NVDA", "ly")=hf_Share_Dilution_Ratio("META", 2023, , "TTM")=hf_Share_Dilution_Ratio(A1, B1, C1)When to Use
- Analyzing stock-based compensation impact
- Evaluating shareholder dilution trends
- Understanding EPS dilution
- Comparing dilution across companies
- Assessing management compensation practices
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need shares outstanding | hf_Total_common_shares_outstanding() |
| Need diluted EPS | hf_EPS_Diluted() |
| Need basic EPS | EarningsPerShare() |
| Need treasury shares | hf_Treasury_shares() |
Common Issues & FAQ
Q: Why do tech companies have higher dilution? A: Tech companies often use stock-based compensation heavily, resulting in more stock options and RSUs that increase diluted share count.
Q: Is 5% dilution bad? A: It depends on context. If accompanied by strong revenue and profit growth, moderate dilution may be acceptable. Watch for dilution outpacing growth.
Q: Why am I getting "NA"? A: Check that the symbol is valid and the company reports both basic and diluted share counts.
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?