U.S Dollar Index
Returns the US Dollar Index from FRED. This measures the dollar's value against a basket of major currencies.
What This Measures
- Trade-weighted average of USD vs major currencies
- Indicator of dollar strength/weakness
- Similar concept to DXY
Data Source
Data is sourced from FRED (Federal Reserve Economic Data).
Notes
- May differ from real-time DXY futures
- Useful for economic research
- Base period = 100
Syntax
=USDollarWeightedAverage()Returns
number
US Dollar Index value
Examples
Dollar index from FRED
When to Use
- Dollar strength analysis
- International trade research
- Currency macro analysis
- Economic research
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Specific EUR rate | USdollarToEuro() |
| Specific GBP rate | USdollarToPound() |
| Real-time DXY | Last("DX-Y.NYB") |
Common Issues & FAQ
Is this the same as DXY?
Similar concept but may use different currency weights.
How is this calculated?
Trade-weighted average of USD against major trading partner currencies.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
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?