Diluted EPS Preferred Securities (Historical)
Diluted EPS adjustment for preferred securities.
Syntax
=hf_Diluted_EPS_preferred_securities(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
yearstringRequired
quarterstring
TTMstring
Returns
number
Diluted EPS from preferred securities
Examples
=hf_Diluted_EPS_preferred_securities("BAC", 2023, 4)When to Use
- Capital structure analysis
- Preferred dividend impact
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Total EPS | hf_Diluted_EPS_total() |
Common Issues & FAQ
Adjustment for preferred dividends.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Diluted EPS Tax Loss Carryforward (Historical)
- 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)
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?