Basic EPS From Extraordinary Income (Historical) Formula in Excel

Understanding Basic EPS From Extraordinary Income (Historical)

The Basic EPS From Extraordinary Income (Historical) formula allows you to retrieve a company's earnings per share specifically tied to extraordinary items over a given historical period. This function is especially useful when analyzing how one-time or extraordinary events affect a company's earnings per share over time. By incorporating this formula from MarketXLS, you can:

• Quickly evaluate the impact of unusual gains or losses on reported EPS.
• Combine fundamental data with other financial metrics in Excel for deeper insights.
• Automate your financial modeling and analysis workflows.

? Pro Tip: Use this formula alongside other fundamental data, such as revenue and gross profit, to get a complete picture of a company's performance.

Syntax and Parameters

Below is the official syntax for using hf_Basic_EPS_from_Extraordinary_Income in Excel:

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

?? Note: The function returns a number representing Basic EPS from extraordinary items. If data is unavailable or the symbol is invalid, it returns "NA".

Examples and Usage

Below are some common ways to use the formula:

1. Retrieve the annual value for a specific year:

   =hf_Basic_EPS_from_Extraordinary_Income("MSFT", "2022")

2. Specify the year and quarter:

   =hf_Basic_EPS_from_Extraordinary_Income("MSFT", "2022", "2")

3. Return data for trailing twelve months:

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

4. Use special codes for quickly referencing past periods:
   • Last quarter:

     =hf_Basic_EPS_from_Extraordinary_Income("MSFT", "lq")

   • Last quarter minus one:

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

   • Last year:

     =hf_Basic_EPS_from_Extraordinary_Income("MSFT", "ly")

   • Last 12 months (rolling):

     =hf_Basic_EPS_from_Extraordinary_Income("MSFT", "lt")

? Pro Tip: Combine this historical EPS data with MarketXLS’s price functions for more robust equity analysis.

Performance Considerations

• This function queries external data in real-time. Repeated calculations across many cells can affect workbook performance.
• Consider caching or limiting recalculation frequency for larger datasets.

Common Questions

What does the function return if there is no extraordinary income data?

The function returns NA when there is no relevant data, if the symbol is invalid, or if the request fails.

Can I use actual date inputs for the year parameter?

The year argument is designed for text or numeric entries (e.g., "2022", "ly"). Date formats like "2024-03-15" are not directly supported for this particular function.

Do I need a subscription plan for this function?

Yes. A valid MarketXLS subscription is required to use this function. If your license doesn’t support this functionality, the function will return "NA".

Are there related functions to compare other fundamentals?

Yes. Some related historical fundamental functions from MarketXLS include:

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

?? Note: Always ensure your symbols and parameters are accurate to avoid unexpected results.