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
Syntax
=hf_Total_ordinary_shares(Symbol, Year, [Quarter], [TTM])Parameters
Stock ticker symbol
Fiscal year or period code (lq, ly, etc.)
Calendar quarter (1-4)
Set to 'TTM' for trailing twelve months
Returns
Total ordinary (common) shares issued
Examples
=hf_Total_ordinary_shares("AAPL", 2023)=hf_Total_ordinary_shares("MSFT", 2023, 2)=hf_Total_ordinary_shares("GOOGL", "ly")=hf_Total_ordinary_shares("AMZN", 2023, , "TTM")=hf_Total_ordinary_shares(A1, B1, C1)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
Why is this different from shares outstanding?
Total ordinary shares includes treasury shares (shares the company has repurchased). Outstanding = Issued - Treasury.
Why do shares increase over time?
Companies issue shares for stock compensation, acquisitions, and capital raises. Some also have significant buybacks reducing outstanding shares.
Why am I getting "NA"?
Check that the symbol is valid and the company has reported share data for that period.
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