Treasury Stock (Historical)

Returns treasury stock (repurchased shares) from historical balance sheets.

Examples

=hf_Treasury_stock("AAPL", 2023, 4)

When to Use

  • Share buyback analysis
  • Understanding capital return to shareholders

When NOT to Use

Scenario Use Instead
Need shares count hf_Treasury_shares()

Common Issues & FAQ

Q: Why is treasury stock negative? A: Treasury stock reduces equity, so it's shown as a negative (contra-equity) account.

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 Stock (Historical) and Other Financial Formulas
How does MarketXLS work?