Other Current Assets (Historical)
Returns other current assets from historical balance sheets that don't fit into standard categories.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol |
| Year | Yes | Fiscal year or period code |
| Quarter | No | Calendar quarter 1-4 |
| TTM | No | Set to "TTM" for trailing twelve months |
Notes
- Catch-all category for current assets
- May include derivative assets, restricted cash, etc.
- Part of total current assets
Examples
=hf_Other_current_assets("AAPL", 2023, 4)=hf_Other_current_assets("MSFT", "ly", 2)=hf_Other_current_assets(A1, B1, C1)When to Use
- Detailed balance sheet analysis
- Understanding asset composition
- Reconciling total current assets
- Identifying unusual current assets
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need total current assets | hf_Total_current_assets() |
| Need cash | hf_Cash_and_equivalents() |
| Need receivables | hf_Accounts_receivable() |
Common Issues & FAQ
Q: What's typically in other current assets? A: Varies by company but may include derivative assets, assets held for sale, restricted cash, and other short-term items.
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?