Special Income-Charges (Historical)
Returns special income items or charges that are non-recurring or unusual. These one-time items are often excluded when calculating normalized earnings.
Examples
| Type | Examples |
|---|---|
| Special Income | Asset sale gains, legal settlements received |
| Special Charges | Restructuring costs, impairments, legal settlements paid |
Notes
- Positive = income (gains)
- Negative = charges (losses)
- Excluded from normalized/adjusted earnings
- Important for understanding true ongoing profitability
Examples
=hf_Special_Income_Charges("AAPL", 2023)=hf_Special_Income_Charges("MSFT", 2023, 2)=hf_Special_Income_Charges("GOOGL", "lq")=hf_Special_Income_Charges("TSLA", "ly")=hf_Special_Income_Charges(A1, B1, C1)When to Use
Earnings quality analysis, normalized earnings calculation, identifying one-time items
When NOT to Use
| Need normalized income | hf_Normalized_income() |
| Need core operating income | hf_Operating_Income() |
Common Issues & FAQ
Q: What year formats are accepted? A: Use numeric years (2023) or period codes: lq (last quarter), ly (last year), lt (last twelve months), lq-1 (quarter before last).
Q: Why am I getting "NA"? A: The company may not report this metric, or data may not be available for the requested period.
Q: What's the difference between quarterly and TTM? A: Quarter shows one quarter's data. TTM (trailing twelve months) sums the last 4 quarters.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today