Preferred Securities Of Subsidiary Trust (Historical)
Syntax
=hf_Preferred_securities_of_subsidiary_trust(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
yearstringRequired
quarterstring
TTMstring
Returns
number
Preferred securities of subsidiary trust amount
Examples
=hf_Preferred_securities_of_subsidiary_trust("JPM", 2023, 4)When to Use
- Trust preferred analysis
- Capital structure analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need common equity | hf_Common_stock_equity() |
Common Issues & FAQ
What are trust preferreds?
Hybrid securities issued by bank holding companies that have characteristics of both debt and equity.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
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?