MarketXLS

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

Syntax

=hf_Treasury_shares(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code (lq, ly, etc.)

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Number of treasury shares held by the company

Examples

=hf_Treasury_shares("HD", 2023)
Home Depot treasury shares
=hf_Treasury_shares("IBM", 2023, 2)
IBM Q2 2023
=hf_Treasury_shares("JPM", "ly")
JPMorgan last fiscal year
=hf_Treasury_shares("AAPL", 2023, , "TTM")
Apple TTM (likely zero)
=hf_Treasury_shares(A1, B1, C1)
Cell references

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

Scenario Use Instead
Need shares trading hf_Total_common_shares_outstanding()
Need total issued hf_Total_ordinary_shares()
Need float shares FloatShares()
Need current shares Shares_Outstanding()

Common Issues & FAQ

Why does Apple show zero treasury shares?

Apple retires repurchased shares immediately rather than holding them as treasury stock. The buybacks still reduce shares outstanding.

Why do treasury shares matter?

Treasury shares represent capital deployed in buybacks. They can be reissued for acquisitions or employee compensation without diluting shareholders.

Why am I getting "NA"?

Some companies don't hold treasury shares or may not report them separately.

Related Formulas

More MarketXLS Historical Fundamentals 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
MarketXLS Excel Add-in Tutorial - How to Use Treasury Shares (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions