Treasury Shares (Historical)
Returns the historical number of treasury shares for a company. Treasury shares are previously issued shares that have been repurchased by the company and are held in its treasury. These shares do not receive dividends and have no voting rights.
Supported 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 |
Treasury Shares Impact
| Aspect | Impact |
|---|---|
| EPS | Increases (fewer shares outstanding) |
| Book Value/Share | Increases |
| Voting Power | Concentrates among remaining shareholders |
| Cash | Decreases when shares repurchased |
Notes
- Some companies retire treasury shares immediately (Apple)
- Others hold them for employee compensation plans
- Treasury shares reduce shareholders' equity on balance sheet
Examples
=hf_Treasury_shares("HD", 2023)=hf_Treasury_shares("IBM", 2023, 2)=hf_Treasury_shares("JPM", "ly")=hf_Treasury_shares("AAPL", 2023, , "TTM")=hf_Treasury_shares(A1, B1, C1)When to Use
- Analyzing share buyback programs
- Understanding capital return to shareholders
- Calculating true shares outstanding
- Evaluating treasury share trends
- Capital allocation analysis
When NOT to Use
Common Issues & FAQ
Q: Why does Apple show zero treasury shares? A: Apple retires repurchased shares immediately rather than holding them as treasury stock. The buybacks still reduce shares outstanding.
Q: Why do treasury shares matter? A: Treasury shares represent capital deployed in buybacks. They can be reissued for acquisitions or employee compensation without diluting shareholders.
Q: Why am I getting "NA"? A: Some companies don't hold treasury shares or may not report them separately.
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?