Other Inventories (Historical)
Returns other inventories 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
- May include supplies, spare parts, packaging materials
- Category varies by company
- Part of total inventory breakdown
Examples
=hf_Other_inventories("WMT", 2023, 4)=hf_Other_inventories("TGT", "ly", 2)=hf_Other_inventories(A1, B1, C1)When to Use
- Detailed inventory analysis
- Understanding inventory composition
- Complete balance sheet breakdown
- Operational expense analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need total inventory | hf_Total_inventory() |
| Need raw materials | hf_Raw_materials() |
| Need finished goods | hf_Finished_goods() |
Common Issues & FAQ
Q: What's typically included in other inventories? A: Usually includes supplies, spare parts, packaging, and other items not in main inventory categories.
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?