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

Basic EPS From Continuing Operations (Historical) Formula in Excel

Understanding Basic EPS From Continuing Operations (Historical)

The Basic EPS From Continuing Operations (Historical) formula in Excel with MarketXLS helps you retrieve a company's historical earnings per share (EPS) from continuing operations. This calculation excludes any earnings from discontinued operations, extraordinary items, or accounting changes, giving you a clearer picture of the company’s ongoing profitability.

  • Purpose: Quickly gauge how profitable a company is, based on its core operations.
  • Key Benefits:
    • Provides accurate insight into a company's earnings.
    • Ideal for comparing historical trends in profitability.
    • Excludes non-recurring items for clearer analysis.
  • When to Use: Use this formula when you need to analyze a company’s core profitability over different reporting periods, like year-over-year or quarter-over-quarter comparisons.

Syntax and Parameters

Use the hf_Basic_EPS_from_Continuing_Operations function in Excel as follows:

=hf_Basic_EPS_from_continuing_operations(Symbol, year, [quarter], [TTM])
Parameter Description Required Example
Symbol The stock, index, option, or crypto symbol. Examples: "MSFT", "^SPX", "@MSFT 110122C00020000", "BTCUSD:DEFAULT". Yes "MSFT"
year The target fiscal year or special keywords like "lq" (last quarter), "ly" (last year), "lt" (last 12 months) with optional offsets. Yes 2023 or "ly-1"
quarter Fiscal quarter (1, 2, 3, or 4). Defaults to "1" if omitted. No 2
TTM Set to "TTM" to retrieve values for the trailing twelve months. Defaults to an empty string. No "TTM"

?? Note: If an invalid parameter is provided or if data is unavailable, the function may return "NA".

Return Value

The function returns a numeric value representing the basic EPS from continuing operations for the specified period. If data is not available or there is an error, the function returns "NA".

Date Input Formats

You can combine multiple ways to specify date inputs:

  1. Cell references, for example:
    =hf_Basic_EPS_from_continuing_operations(A1)
  2. Direct dates, for example:
    =hf_Basic_EPS_from_continuing_operations("2024-03-15")
  3. Excel date functions, for example:
    =hf_Basic_EPS_from_continuing_operations(TEXT(A1,"yyyy-mm-dd"))

Examples and Usage

Below are practical examples demonstrating how to use the formula:

  1. Basic usage by symbol and year:

    =hf_Basic_EPS_from_continuing_operations("MSFT", 2022)

    Retrieves the basic EPS from continuing operations for Microsoft in 2022.

  2. Specify a quarter:

    =hf_Basic_EPS_from_continuing_operations("MSFT", 2022, 2)

    Retrieves the value for Microsoft’s second quarter in 2022.

  3. Using trailing twelve months (TTM):

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

    Retrieves the trailing twelve months EPS as of the third quarter of 2022.

  4. Using special keywords for last quarter or last year:

    =hf_Basic_EPS_from_continuing_operations("MSFT","lq")
    =hf_Basic_EPS_from_continuing_operations("MSFT","ly")

    Returns values for the most recent quarter or year, respectively.

? Pro Tip: Combine offsets with keywords for more control:
=hf_Basic_EPS_from_continuing_operations("MSFT","lq-1")

Common Questions

1. What if the function returns "NA"?

  • "NA" can appear if the symbol is invalid, you do not have the required subscription plan, or data for the specified period is not available.

2. How do I ensure accuracy over multiple periods?

  • Use the quarter or TTM parameters to specify exact timeframes. Confirm that your symbol references and subscription plan include historical fundamentals data.

3. Does performance slow down with multiple calls?

  • MarketXLS is optimized for quick retrieval. However, for large datasets, consider batching requests or limiting recalculations to boost performance.

4. Are discontinued operations included in this EPS figure?

  • No. This formula excludes discontinued operations, extraordinary items, and accounting changes to focus on core continuing operations.

?? Note: This function is part of the “Historical Fundamentals” category. Make sure you have the correct MarketXLS add-on or license level to access these data points.


Related Functions:

  • Revenue (Historical): Returns the company's total revenue for a specified historical period.
  • Cost Of Revenue (Historical): Returns the company's total cost of revenue for a specified historical period.
  • Gross Profit (Historical): Returns the company's gross profit for a specified historical period.
  • R & D Expenses (Historical): Returns the company's research and development expenses for a specified historical period.
  • Selling General and Administrative Expense (Historical): Returns the company's SG&A expenses for a specified historical period.