Diluted EPS Total (Historical)
Total diluted earnings per share.
Syntax
=hf_Diluted_EPS_total(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
yearstringRequired
quarterstring
TTMstring
Returns
number
Total diluted EPS
Examples
=hf_Diluted_EPS_total("AAPL", 2023, 4)When to Use
- Per-share analysis
- Diluted shares valuation
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Basic EPS | hf_Basic_EPS_total() |
Common Issues & FAQ
Most conservative EPS metric.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Dividend Yield (Historical)
- Dividends Paid Per Share Year To Date (Historical)
- Dividends Per Basic Common Share (Historical)
- Domestic Sales (Historical)
- Earnings Before Interest and Taxes - EBIT in USD (Historical)
- Earnings Before Tax (Historical)
- Earnings from Equity Interest (Historical)
- Earnings Indicator (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?