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:
-
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).
-
Specifying Quarter
=hf_Basic_EPS_from_Discontinued_Operations("MSFT", 2022, 2)
Retrieves the same metric for Microsoft in Q2 of 2022.
-
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.
-
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")
- Last Quarter:
? 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
-
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.
- Create a list of symbols in Excel and reference each cell in your formula. For example:
-
Does this function update automatically?
- Yes, MarketXLS formulas refresh with your Excel recalculations. You can also force a data refresh by pressing F9.
-
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.
-
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)
- Consider using related historical fundamental functions from MarketXLS, such as:
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.