Extraordinary Gains Losses (Historical)
Returns historical extraordinary gains or losses for a company. These are unusual, infrequent items that are both unusual in nature and infrequent in occurrence, reported separately from regular operations.
Supported Symbols
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| International | SYMBOL | SHOP, TSM |
Parameters
| Parameter | Description |
|---|---|
| Symbol | Stock ticker symbol |
| Year | Fiscal year (2020, 2021) or period code (lq, ly, lt) |
| Quarter | Optional: 1, 2, 3, or 4 for quarterly data |
| TTM | Optional: Set to "TTM" for trailing twelve months |
Types of Extraordinary Items
| Type | Examples |
|---|---|
| Natural Disasters | Hurricane, earthquake damage |
| Expropriation | Government seizure of assets |
| Legal | Large lawsuit settlements |
| Tax | Major tax law changes |
Notes
- Under current GAAP, extraordinary item classification is rarely used
- Most "unusual" items now reported in continuing operations
- Positive values are gains, negative are losses
Examples
=hf_Extraordinary_gains_losses("BA", 2020)=hf_Extraordinary_gains_losses("GE", 2023, 2)=hf_Extraordinary_gains_losses("XOM", "ly")=hf_Extraordinary_gains_losses("AAPL", 2023, , "TTM")=hf_Extraordinary_gains_losses(A1, B1, C1)When to Use
- Identifying true one-time items
- Adjusting earnings for unusual events
- Understanding earnings quality
- Comparing normalized earnings
- Historical event impact analysis
When NOT to Use
Common Issues & FAQ
Q: Why is this usually zero? A: Under current accounting rules, true "extraordinary items" are rare. Most unusual items are now included in operating results rather than reported separately.
Q: How do I find one-time items? A: Look at company disclosures, operating gains/losses, and restructuring charges. True extraordinary items as defined by GAAP are uncommon.
Q: Why am I getting "NA"? A: Most companies have no extraordinary items to report in most periods.
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?