Total Ordinary Shares (Historical)

Returns the historical total ordinary (common) shares issued by a company. This represents the total number of common shares that have been issued, including those held in treasury.

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

Share Count Hierarchy

Metric Definition
Authorized Maximum shares company can issue
Issued Shares actually issued
Outstanding Issued minus treasury shares
Float Outstanding minus restricted shares

Notes

  • Total ordinary shares includes treasury shares
  • Use hf_Total_common_shares_outstanding() for shares actually trading
  • Share count affects per-share metrics like EPS and book value

Examples

=hf_Total_ordinary_shares("AAPL", 2023)
Apple total shares
=hf_Total_ordinary_shares("MSFT", 2023, 2)
Microsoft Q2 2023
=hf_Total_ordinary_shares("GOOGL", "ly")
Alphabet last fiscal year
=hf_Total_ordinary_shares("AMZN", 2023, , "TTM")
Amazon TTM
=hf_Total_ordinary_shares(A1, B1, C1)
Cell references

When to Use

  • Understanding total equity share structure
  • Calculating equity dilution from issuances
  • Analyzing share issuance trends
  • Capital structure analysis
  • Comparing issued vs outstanding shares

When NOT to Use

Scenario Use Instead
Need shares actually trading hf_Total_common_shares_outstanding()
Need preferred shares hf_Preferred_shares()
Need treasury shares hf_Treasury_shares()
Need current shares Shares_Outstanding()

Common Issues & FAQ

Q: Why is this different from shares outstanding? A: Total ordinary shares includes treasury shares (shares the company has repurchased). Outstanding = Issued - Treasury.

Q: Why do shares increase over time? A: Companies issue shares for stock compensation, acquisitions, and capital raises. Some also have significant buybacks reducing outstanding shares.

Q: Why am I getting "NA"? A: Check that the symbol is valid and the company has reported share data for that period.

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

Related Functions