Canada - U.S. Foreign Exchange Rate
Returns the Canadian dollar to U.S. dollar exchange rate, sourced from the Federal Reserve.
Data Source
Federal Reserve Statistical Release H.10 - Foreign Exchange Rates.
Usage Notes
- No parameters required
- Returns CAD per 1 USD (or USD per 1 CAD depending on FRED series)
- Data updated daily
- Useful for tracking North American trade dynamics
Exchange Rate Interpretation
| CAD/USD | USD Interpretation |
|---|---|
| Rising | USD strengthening vs CAD |
| Falling | USD weakening vs CAD |
Examples
Current CAD/USD exchange rate
When to Use
- Tracking Canadian dollar movements
- North American trade analysis
- Cross-border investment valuation
- Building forex dashboards
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need real-time forex quotes | Last("CADUSD=X") |
| Need CNY/USD rate | YuanToUSdollar() |
| Need JPY/USD rate | YenToUSdollar() |
Common Issues & FAQ
Q: Is this CAD per USD or USD per CAD? A: Check the returned value - if around 0.70-0.80, it's USD per 1 CAD. If around 1.25-1.40, it's CAD per 1 USD.
Q: How do I get real-time forex rates?
A: Use =Last("CADUSD=X") for real-time currency quotes.
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?