Investments Current (Historical)
Returns historical current investments for a company. These are short-term investments that can be liquidated within one year, including marketable securities and other liquid financial instruments.
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 |
Current Investment Types
| Type | Description |
|---|---|
| Marketable Securities | Liquid stocks and bonds |
| Short-term Bonds | Bonds maturing within 1 year |
| Commercial Paper | Short-term corporate debt |
| Money Market Funds | Highly liquid fund investments |
Notes
- Current investments are part of current assets
- These are highly liquid and can be converted to cash quickly
- Important for assessing short-term liquidity
Syntax
=hf_Investments_Current(Symbol, Year, [Quarter], [TTM])Examples
=hf_Investments_Current("AAPL", 2023)=hf_Investments_Current("MSFT", 2023, 2)=hf_Investments_Current("GOOGL", "ly")=hf_Investments_Current("AMZN", 2023, , "TTM")=hf_Investments_Current(A1, B1, C1)When to Use
- Analyzing short-term liquidity position
- Calculating quick ratio with detailed assets
- Understanding working capital composition
- Evaluating cash management strategy
- Assessing near-term financial flexibility
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need total investments | hf_Investments() |
| Need long-term investments | hf_Investments_NonCurrent() |
| Need cash only | hf_Cash_and_Equivalents() |
| Need total current assets | hf_Total_Current_Assets() |
Common Issues & FAQ
What's the difference between current investments and cash?
Cash is immediately available; current investments are securities that can be liquidated quickly but are not cash.
Why might this be zero?
Some companies keep minimal short-term investments, preferring cash or long-term holdings.
Why am I getting "NA"?
Check that the symbol is valid. Not all companies report current investments separately.
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?