Cash and Equivalents USD (Historical)
Returns the historical cash and cash equivalents balance converted to US dollars. Essential for comparing cash positions across companies that report in different currencies.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol (e.g., AAPL, TSM) |
| Year | Yes | Fiscal year (2023) or period code (lq, ly) |
| Quarter | No | Quarter number 1-4 (default: 1) |
| TTM | No | Set to "TTM" for trailing twelve months |
Currency Conversion
- Uses period-end exchange rates
- For US companies, same as local currency version
- Enables apples-to-apples comparison globally
- Exchange rate fluctuations affect USD values
Notes
- Balance sheet item (point-in-time)
- USD-normalized for global comparison
- Same as local currency for US companies
- Useful for building global screeners
Examples
=hf_Cash_and_Equivalents_USD("AAPL", 2023, 4)=hf_Cash_and_Equivalents_USD("TSM", "ly")=hf_Cash_and_Equivalents_USD("SAP", 2023, , "TTM")=hf_Cash_and_Equivalents_USD(A1, B1, C1)When to Use
- Comparing cash across different currencies
- Global stock screening
- International portfolio analysis
- Currency-neutral liquidity comparison
- Cross-border company comparisons
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need local currency cash | hf_Cash_and_Equivalents() |
| Need total current assets | hf_Current_Assets() |
| Need operating cash flow | hf_Net_Cash_Flow_from_Operations() |
| Need net debt | Calculate: Total Debt - Cash |
Common Issues & FAQ
Q: Why is USD cash different from local currency? A: Exchange rate conversions. A company reporting in EUR will have different USD values depending on EUR/USD rate.
Q: How do I calculate net debt?
A: Net Debt = Total Debt - Cash: =hf_Total_Debt_USD("AAPL","lq") - hf_Cash_and_Equivalents_USD("AAPL","lq")
Q: Which version should I use for US companies? A: Either works - they're identical for US companies. Use USD version for consistency when comparing globally.
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?