Total Ordinary Shares (Historical) Formula in Excel

Understanding Total Ordinary Shares (Historical)

The Total Ordinary Shares (Historical) formula in Excel with MarketXLS helps you quickly retrieve the total amount of funds a company has raised through the issuance of its common (ordinary) shares over various historical periods. This data is particularly useful for:

• Evaluating a company’s ownership structure over time
• Performing in-depth fundamental analysis on equity issuance trends
• Comparing share issuance across multiple companies and timeframes

? Pro Tip: Use this formula with other MarketXLS historical fundamental functions (e.g., Revenue (Historical), Cost Of Revenue (Historical)) to build comprehensive fundamental models.

Syntax and Parameters

Use the hf_Total_Ordinary_Shares function to retrieve historical ordinary shares data by specifying the ticker symbol, year, and other optional parameters.

=hf_Total_Ordinary_Shares(Symbol, Year, [Quarter], [TTM])

?? Note: The function returns a numeric value representing the total ordinary shares historically. If the symbol is invalid or your MarketXLS license is not valid for this data, "NA" will be returned.

Examples and Usage

Below are common use cases and best practices when working with this function in Excel:

1. Basic retrieval by year:

   =hf_Total_Ordinary_Shares("MSFT", 2022)

   This fetches the total ordinary shares for Microsoft in 2022.

2. Specifying a quarter:

   =hf_Total_Ordinary_Shares("MSFT", 2022, 2)

   This fetches the total ordinary shares during the second quarter of 2022.

3. Using Trailing Twelve Months (TTM):

   =hf_Total_Ordinary_Shares("MSFT", 2022, 3, "TTM")

   This fetches the TTM total ordinary shares, starting from the third quarter in 2022.

4. Leveraging special year parameters:

   • Last Quarter:

     =hf_Total_Ordinary_Shares("MSFT", "lq")

   • Last Quarter minus one:

     =hf_Total_Ordinary_Shares("MSFT", "lq-1")

   • Last Year:

     =hf_Total_Ordinary_Shares("MSFT", "ly")

   • Last Year minus one:

     =hf_Total_Ordinary_Shares("MSFT", "ly-1")

   • Last 12 months:

     =hf_Total_Ordinary_Shares("MSFT", "lt")

   • Previous last 12 months:

     =hf_Total_Ordinary_Shares("MSFT", "lt-1")

5. Using different symbol formats:

   • Indices:

     =hf_Total_Ordinary_Shares("^SPX", 2022)

   • Options:

     =hf_Total_Ordinary_Shares("@MSFT 110122C00020000", "ly")

   • Crypto:

     =hf_Total_Ordinary_Shares("BTCUSD:DEFAULT", 2022)

? Pro Tip: Combine this function with Excel cell references or date functions to manage dynamic date inputs. For example:
• Cell references ? =hf_Total_Ordinary_Shares(A1, B1) where A1 has the symbol and B1 has the year
• Direct dates (useful if you store year as text) ? =hf_Total_Ordinary_Shares("MSFT", "2022")
• Excel date functions ? =hf_Total_Ordinary_Shares("MSFT", TEXT(A1,"yyyy"))

Common Questions

1. What does "NA" mean when returned by the function?
   If hf_Total_Ordinary_Shares returns "NA", it could mean:

   • Invalid or unsupported symbol
   • A license-type restriction in MarketXLS
   • Data not available for the requested period

2. How can I improve performance if I have many formulas?

   • Use MarketXLS’s caching and avoid frequent recalculations on unchanged cells.
   • Organize your data retrieval to minimize the repeated pulling of identical values.

3. Can I use this function for non-equity symbols (e.g., indices, crypto)?
   Yes, as long as the underlying data is available. Otherwise, you may see "NA".

4. Are there any limitations?

   • This function retrieves historical data only for periods supported by MarketXLS.
   • Some advanced or international symbols may require upgraded MarketXLS plans.

5. How do special functions like "lq", "ly", "lt" work?

   • "lq" fetches data for the most recent quarter. "lq-1" goes a quarter back from the most recent.
   • "ly" fetches data for the most recent year. "ly-1" goes a year back from the most recent.
   • "lt" fetches data for the last 12 months counting back from the most recent quarter.

?? Note: Ensure your MarketXLS add-in is updated to the latest version for the most accurate and expansive dataset.

By integrating the Total Ordinary Shares (Historical) formula into your financial models, you gain valuable insights into how a company's equity structure evolves over time, helping you make more informed investment decisions.