U.S - UK Foreign Exchange Rate
Returns the US Dollar to British Pound exchange rate from FRED.
Data Source
Data is sourced from the Federal Reserve H.10 release via FRED.
Notes
- May be delayed vs. real-time forex
- For real-time, use
Last("GBPUSD=X") - Useful for economic research
Examples
USD/GBP from FRED
=Last("GBPUSD=X")When to Use
- Economic research with FRED data
- Historical forex analysis
- UK trade analysis
- Academic research
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Real-time forex | Last("GBPUSD=X") |
| EUR rate | USdollarToEuro() |
| Dollar index | USDollarWeightedAverage() |
Common Issues & FAQ
Q: Is this real-time?
A: No, FRED data may be delayed. Use Last("GBPUSD=X") for real-time.
Q: Is this USD per GBP or GBP per USD? A: Check FRED documentation for the exact quote convention.
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?