Diluted EPS From Continuing Operations (Historical) Formula in Excel

In this guide, you will learn how to use the Diluted EPS From Continuing Operations (Historical) formula in Excel with MarketXLS to retrieve a company's diluted earnings per share from ongoing operational activities over a given time period. By leveraging this function, you can quickly gain insights into the company’s performance from continuing operations.

Understanding Diluted EPS From Continuing Operations (Historical)

• The Diluted EPS From Continuing Operations (Historical) measure shows the earnings per share generated by a company from its continuing activities, adjusted for the full impact of dilutive securities.
• It provides deeper insight into profitability trends by focusing on ongoing business segments, excluding any discontinued operations.
• Use this formula when you need precise historical EPS figures for advanced analysis, ratio calculations, or year-over-year comparisons.

? Pro Tip: Combine this function with other MarketXLS historical fundamentals (e.g., Revenue or Gross Profit) to build a comprehensive financial model.

Syntax and Parameters

=hf_Diluted_EPS_from_Continuing_Operations(Symbol, year, [quarter], [TTM])

Return Value

• Returns a numeric value representing diluted EPS from continuing operations for the specified period.
• Returns "NA" if the symbol is invalid, data is unavailable, or if the user’s MarketXLS license does not support this function.

?? Note: This function relies on data from MarketXLS servers. Response times can vary based on network performance and your subscription plan.

Examples and Usage

Below are a few ways to call hf_Diluted_EPS_from_Continuing_Operations in Excel:

1. Basic usage by specifying symbol and year:

   =hf_Diluted_EPS_from_Continuing_Operations("MSFT", 2022)

   Retrieves the diluted EPS from continuing operations for the year 2022.

2. Including a quarter:

   =hf_Diluted_EPS_from_Continuing_Operations("MSFT", 2022, 2)

   Retrieves the diluted EPS for Microsoft’s Q2 of 2022.

3. Using trailing twelve months (TTM):

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

   Returns the diluted EPS for the trailing twelve months ending in Q3 of 2022.

4. Last quarter or year shortcuts:

   =hf_Diluted_EPS_from_Continuing_Operations("MSFT", "lq")
   =hf_Diluted_EPS_from_Continuing_Operations("MSFT", "ly")

   • "lq" automatically retrieves the last quarter’s data.
   • "ly" automatically retrieves the last year’s data.

5. Using cell references and date functions for year input (if desired):

   =hf_Diluted_EPS_from_Continuing_Operations(A1, TEXT(A2,"yyyy"))

   Where cell A1 contains the symbol (e.g., "MSFT") and cell A2 contains an Excel date such as "1/1/2023". The TEXT function converts it to the "yyyy" format.

6. Symbol variants for indices, options, and crypto:

   =hf_Diluted_EPS_from_Continuing_Operations("^SPX", 2022)
   =hf_Diluted_EPS_from_Continuing_Operations("@MSFT 110122C00020000", "ly")
   =hf_Diluted_EPS_from_Continuing_Operations("BTCUSD:DEFAULT", "lq")

? Pro Tip: Combine this function with Excel’s referencing to build dynamic dashboards that update automatically.

Common Questions

1. What if the function returns "NA"?

   • This typically indicates invalid symbols, unavailable data, or insufficient user license permissions.

2. Can I apply this function to multiple cells at once?

   • Yes, simply reference different symbols or years in multiple cells to retrieve an array of EPS values.

3. How does TTM calculation work?

   • TTM combines the most recent four quarters of data (if available). It’s useful for measuring the latest 12-month performance rather than a single fiscal year.

4. Are there any performance considerations?

   • Because the function retrieves data from MarketXLS servers, performance depends on your internet connection and the MarketXLS API response. For large-scale operations, consider batching requests or using Excel’s refresh scheduling features.

5. Will the function work with any date format for the year?

   • The function is designed to work with simple year inputs (e.g., 2022) or relative period shortcuts ("ly", "lq", etc.). If you want to derive the year from a date cell, convert the date to a year string (for example, with TEXT(A1, "yyyy")).

?? Note: Double-check the function’s parameter order. Ensure each argument is placed in its correct position to avoid unexpected results.