Basic EPS From Discontinued Operations (Historical) Formula in Excel

Basic EPS From Discontinued Operations (Historical) is a powerful Excel formula available with MarketXLS. It helps you quickly retrieve the earnings per share from discontinued operations for a given ticker symbol over specified periods, allowing you to analyze trends and make informed investment decisions. This function leverages historical fundamentals data to provide accurate, up-to-date information.

Understanding Basic EPS From Discontinued Operations (Historical)

• Purpose: Calculates earnings per share generated from discontinued operations for a chosen stock (or other security types) over a specific period.
• Key Benefits:
  • Instant access to historical EPS data related to discontinued operations.
  • Supports a wide range of symbols, including equities, indices, options, and cryptocurrencies.
  • Integrates seamlessly into your Excel workflows.
• When to Use:
  • When you need to evaluate how discontinuing a major business segment or product line has impacted a company’s earnings per share.
  • If you want to compare historical EPS from discontinued operations across multiple symbols.

Syntax and Parameters

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

?? Note: If the symbol is invalid or your MarketXLS license is not valid for this function, it will return "NA".

? Pro Tip: You can reference cells or use date functions to dynamically construct the Year parameter if you want to automate your spreadsheet. For example:
=hf_Basic_EPS_from_Discontinued_Operations("MSFT", TEXT(A1,"yyyy"), 1, "")

Return Value

• Returns a numeric value representing the EPS from discontinued operations for the specified period.
• If no data is available or an error occurs, it will return "NA".

Error Handling and Special Cases

• Invalid Symbol: Returns "NA".
• License Restriction: Returns a message or "NA" if the function is not supported under your current license.
• Non-numeric Results: If the response from the data source is not numeric, the function returns the exact response (often "NA").

Examples and Usage

Below are practical ways to use hf_Basic_EPS_from_Discontinued_Operations in your Excel worksheets:

1. Basic Usage (Year Only)

   =hf_Basic_EPS_from_Discontinued_Operations("MSFT", 2022)

   Retrieves Basic EPS from discontinued operations for Microsoft in 2022 (default quarter: 1).

2. Specifying Quarter

   =hf_Basic_EPS_from_Discontinued_Operations("MSFT", 2022, 2)

   Retrieves the same metric for Microsoft in Q2 of 2022.

3. Trailing Twelve Months

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

   Retrieves Basic EPS from discontinued operations for 2022 (Q3) trailing twelve months.

4. Last Quarter or Last Year

   • Last Quarter:

     =hf_Basic_EPS_from_Discontinued_Operations("MSFT", "lq")

   • Last Quarter Minus One:

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

   • Last Year:

     =hf_Basic_EPS_from_Discontinued_Operations("MSFT", "ly")

   • Last Year Minus One:

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

   • Last 12 Months:

     =hf_Basic_EPS_from_Discontinued_Operations("MSFT", "lt")

   • Previous Last 12 Months:

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

? Pro Tip: Combine cell references for dynamic inputs. For instance, if cell A1 has a year value:
=hf_Basic_EPS_from_Discontinued_Operations("MSFT", A1, 2)

Common Questions

1. What if I want to analyze multiple symbols at once?

   • Create a list of symbols in Excel and reference each cell in your formula. For example:
     =hf_Basic_EPS_from_Discontinued_Operations(A2, B2)
   • Use one row per symbol to compare results quickly.

2. Does this function update automatically?

   • Yes, MarketXLS formulas refresh with your Excel recalculations. You can also force a data refresh by pressing F9.

3. Why am I getting "NA" when I know data should exist?

   • Ensure your license supports historical fundamental data. Also verify the syntax and the validity of the symbol. Double-check that the year and quarter are entered correctly.

4. How can I get a more complete picture of a company’s performance?

   • Consider using related historical fundamental functions from MarketXLS, such as:
     • Revenue (Historical)
     • Cost Of Revenue (Historical)
     • Gross Profit (Historical)
     • R & D Expenses (Historical)
     • Selling General and Administrative Expense (Historical)

By using the Basic EPS From Discontinued Operations (Historical) formula in Excel with MarketXLS, you can easily track and analyze a key financial metric that reflects the impact of discontinuing certain operations on a company’s earnings.