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
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
Q: What is the difference between basic and diluted EPS? A: Diluted EPS includes the impact of all potential shares from options, warrants, and convertible securities.
Q: Why might YTD EPS differ from sum of quarterly EPS? A: Due to share count changes and weighted average calculations throughout the year.
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?