Diluted EPS From Discontinued Operations (Historical) Formula in Excel

This guide explains how to use the Diluted EPS From Discontinued Operations (Historical) formula in Excel with MarketXLS. This function returns the earnings per share figure related to discontinued operations, offering insights into a company’s historical performance for segments that are no longer active or have been sold.

Understanding Diluted EPS From Discontinued Operations (Historical)

• The Diluted EPS From Discontinued Operations figure focuses on profits (or losses) from operations that are no longer part of a company’s ongoing business.
• It’s highly useful for investors and analysts to isolate and evaluate one-time impacts on earnings.
• Use it to analyze historical performance while excluding discontinued segments that do not represent the company’s future operations.

? Pro Tip: Focusing on discontinued operations helps highlight the ongoing core business performance.

Syntax and Parameters

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

?? Note:

• The function returns a numeric value if data is found, or "NA" when invalid data or license restrictions apply.
• Make sure you have an active MarketXLS subscription that supports fundamental data.

Return Value

• Numeric value (Double) representing the discontinued operations diluted EPS.
• "NA" if data is unavailable, invalid, or if your MarketXLS plan doesn’t cover this data.

Special Cases and Limitations

• If the symbol is invalid or you’re not licensed for advanced fundamentals, the function returns "NA".
• Results may vary if the company did not report discontinued operations for the specified period.

Examples and Usage

Below are practical usage scenarios:

1. Basic Yearly Lookup:

   =hf_Diluted_EPS_from_Discontinued_Operations("MSFT", 2022)

   Returns the diluted EPS from discontinued operations for Microsoft in 2022.

2. Quarterly Lookup:

   =hf_Diluted_EPS_from_Discontinued_Operations("MSFT", 2022, 2)

   Returns values specifically for the second quarter of 2022.

3. Trailing Twelve Months:

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

   Fetches trailing twelve months data from the third quarter of 2022.

4. Relative References:

   =hf_Diluted_EPS_from_Discontinued_Operations("MSFT", "lq-1")
   =hf_Diluted_EPS_from_Discontinued_Operations("MSFT", "ly")
   =hf_Diluted_EPS_from_Discontinued_Operations("MSFT", "lt")

   Provides data for last quarter - 1, last year, or last 12 months, respectively.

5. Date Input Variations:

   • Via a cell reference:

     =hf_Diluted_EPS_from_Discontinued_Operations(A1)

   • Directly entering the date:

     =hf_Diluted_EPS_from_Discontinued_Operations("2024-03-15")

   • Using an Excel date function:

     =hf_Diluted_EPS_from_Discontinued_Operations(TEXT(A1,"yyyy-mm-dd"))

Common Questions

What if the function returns “NA”?

• Confirm the symbol is valid.
• Check if your MarketXLS license includes Historical Fundamental data.
• Verify you’ve entered a valid year, quarter, or TTM parameter.

Are discontinued operations always reported?

• Not all companies report discontinued operations every period. If none exist, you may see “NA”.

How often is the data updated?

• MarketXLS updates fundamental data regularly. Check MarketXLS documentation for the latest update schedules.

? Pro Tip: Combine this function with other MarketXLS formulas like “Revenue (Historical)” or “Gross Profit (Historical)” for a more comprehensive analysis of company performance.