Diluted EPS From Total Operations Year To Date (Historical)
Returns the cumulative diluted earnings per share from total operations from the beginning of the fiscal year through the specified quarter.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol (e.g., AAPL, MSFT) |
| Year | Yes | Fiscal year (e.g., 2023) or period code (lq, ly) |
| Quarter | No | Calendar quarter 1-4, defaults to 1 |
| TTM | No | Set to "TTM" for trailing twelve months |
Notes
- Diluted EPS accounts for all potential share dilution from options, warrants, convertibles
- Includes all operations (continuing and discontinued)
- Values are per share
Syntax
=hf_Diluted_EPS_from_total_operations_year_to_date(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
Stock ticker symbol
yearstringRequired
Fiscal year or period code
quarterstring
Calendar quarter (1-4)
TTMstring
Set to 'TTM' for trailing twelve months
Returns
number
Diluted EPS from total operations YTD
Examples
=hf_Diluted_EPS_from_total_operations_year_to_date("AAPL", 2023, 4)=hf_Diluted_EPS_from_total_operations_year_to_date("MSFT", "ly", 2)=hf_Diluted_EPS_from_total_operations_year_to_date("GOOGL", 2022, 3, "TTM")=hf_Diluted_EPS_from_total_operations_year_to_date(A1, B1, C1)When to Use
- Tracking cumulative EPS progress through the year
- Year-over-year YTD EPS comparisons
- Valuation analysis with YTD earnings
- Comparing diluted vs basic EPS YTD
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need single quarter EPS | hf_Diluted_EPS() |
| Need basic EPS | hf_Basic_EPS_year_to_date() |
| Need current EPS | EPS() |
Common Issues & FAQ
What is the difference between basic and diluted EPS?
Diluted EPS includes the impact of all potential shares from options, warrants, and convertible securities.
Why might YTD EPS differ from sum of quarterly EPS?
Due to share count changes and weighted average calculations throughout the year.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Diluted EPS Other Gains/Losses (Historical)
- Diluted EPS Preferred Securities (Historical)
- Diluted EPS Tax Loss Carryforward (Historical)
- Diluted EPS Total (Historical)
- Dividend Yield (Historical)
- Dividends Paid Per Share Year To Date (Historical)
- Dividends Per Basic Common Share (Historical)
- Domestic Sales (Historical)
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?