Diluted EPS From Extraordinary Income (Historical) Formula in Excel

Use the MarketXLS “Diluted EPS From Extraordinary Income (Historical)” formula in Excel to quickly retrieve a company's diluted earnings per share figure that excludes extraordinary income. This is especially helpful when analyzing financial statements to understand a company's core earnings performance.

Understanding Diluted EPS From Extraordinary Income (Historical)

• Purpose and Use Cases
  This formula returns the diluted EPS figure that excludes infrequent and unusual items (extraordinary gains or losses). Investors and analysts often use it to evaluate the underlying earning power of a business without one-off events.

• Key Benefits

  • Focuses on recurring earnings.
  • Filters out one-time, extraordinary situations.
  • Simplifies financial modeling and benchmarking.

• When to Use
  Use this formula when you need to conduct fundamental analysis focusing purely on operational profitability, free from extraordinary items.

Syntax and Parameters

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

Return Value
This formula returns a numeric value representing the diluted EPS excluding extraordinary income for the specified period. If the ticker symbol is invalid, the user is not licensed, or any error occurs, the function returns "NA".

?? Note: Performance depends on your internet connection and MarketXLS license validity.

Examples and Usage

Below are examples illustrating how to use the function with different symbol formats and date inputs:

1. Basic symbol and year:

   =hf_Diluted_EPS_from_Extraordinary_Income("MSFT", 2022)

   Retrieves the annual diluted EPS excluding extraordinary income for 2022.

2. Symbol with quarter and TTM:

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

   Returns the trailing twelve-month value from Q3 2022.

3. Using cell references for dates:

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

   If cell A1 contains a valid date or if you convert the cell to “yyyy-mm-dd” format.

4. Direct date input example:

   =hf_Diluted_EPS_from_Extraordinary_Income("2024-03-15")

   Though typically used with Year/Quarter inputs, you can also pass direct date strings.

5. Special period inputs:

   • Last Quarter:

     =hf_Diluted_EPS_from_Extraordinary_Income("MSFT", "lq")

   • Last Quarter minus one:

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

   • Last Year:

     =hf_Diluted_EPS_from_Extraordinary_Income("MSFT", "ly")

   • Last 12 months:

     =hf_Diluted_EPS_from_Extraordinary_Income("MSFT", "lt")

? Pro Tip: You can combine special period inputs with quarters and TTM arguments to get highly specific data ranges.

Common Questions

1. What happens if I use an invalid symbol?

If you use an invalid Symbol (or one not covered by your subscription plan), the function will return "NA".

2. Can I use this function for international securities?

Yes, as long as MarketXLS provides coverage. For specific symbols, refer to MarketXLS documentation or contact support.

3. Why am I getting “NA” for legitimate symbols?

Ensure your MarketXLS license is active and you have a stable internet connection. Try refreshing the workbook or contacting support if the issue persists.

4. Is there a performance issue with multiple calls?

Large spreadsheets with numerous formula calls might load slower. Consider using fewer calls or referencing results in helper cells for better performance.

5. Does the formula account for stock splits automatically?

MarketXLS data is generally adjusted for splits. The resulting EPS values should reflect split-adjusted figures, unless indicated otherwise.

For related data points, explore other MarketXLS Historical Fundamentals functions, such as:

• Revenue (Historical)
• Cost Of Revenue (Historical)
• Gross Profit (Historical)
• R & D Expenses (Historical)
• Selling General and Administrative Expense (Historical)

Use these together to get a comprehensive view of a company’s financial performance.