Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

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])
Parameter Description Required Example
Symbol The stock or security symbol. Can be an equity (e.g., "MSFT"), index (e.g., "^SPX"), option (e.g., "@MSFT 110122C00020000"), or crypto (e.g., "BTCUSD:DEFAULT"). Yes "MSFT"
Year The specific year or special string indicators like "lq" (last quarter), "ly" (last year), "lt" (last 12 months), and their offsets (e.g., "ly-1"). Yes 2022, "lq", "ly-1"
Quarter The calendar quarter number (1 to 4) or empty. Defaults to "1" if omitted. No 2
TTM Use "TTM" for trailing 12 months or leave empty. No "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.