Foreign Currency to USD Exchange Rate (Historical)
Returns the exchange rate used to convert the company's reporting currency to USD for a specific period.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol |
| Year | Yes | Fiscal year or period code |
| Quarter | No | Quarter 1-4 |
| TTM | No | "TTM" for trailing twelve months |
Notes
- For US companies, this typically returns 1.0
- For foreign companies, shows the conversion rate used
- Useful for understanding currency impact on financials
Examples
=hf_Foreign_Currency_to_USD_Exchange_Rate("AAPL", 2023, 4)=hf_Foreign_Currency_to_USD_Exchange_Rate("SAP", "ly")=hf_Foreign_Currency_to_USD_Exchange_Rate("TSM", 2023)When to Use
- Understanding currency impact on financials
- Normalizing international comparisons
- Historical FX analysis for companies
- Currency risk assessment
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Current forex rates | Forex functions |
| Real-time FX | Streaming forex functions |
| Spot rates | Currency pair functions |
Common Issues & FAQ
Q: Why is the rate always 1.0? A: US-based companies report in USD, so the rate is 1.0.
Q: What currency is being converted? A: The company's reporting currency is converted to USD.
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?