Japan - U.S. Foreign Exchange Rate
Returns the Japanese Yen to U.S. Dollar exchange rate (how many Yen per 1 USD).
Data Details
| Attribute | Value |
|---|---|
| Source | Federal Reserve / FRED |
| Frequency | Daily |
| Unit | JPY per USD |
| Quote | How many Yen to buy 1 Dollar |
Notes
- Higher values mean a stronger Dollar (more Yen needed to buy a Dollar)
- Lower values mean a stronger Yen
- Commonly used for international trade and investment analysis
Syntax
=YenToUSdollar()Returns
number
Japanese Yen per U.S. Dollar exchange rate
Examples
Current JPY/USD rate
=1000/YenToUSdollar()=100*YenToUSdollar()When to Use
- Currency conversion calculations
- International trade analysis
- Forex market research
- Portfolio currency exposure analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need Chinese Yuan rate | YuanToUSdollar() |
| Need Canadian Dollar rate | CanadiandollarToUSdollar() |
| Need real-time forex | Last("USDJPY=X") |
Common Issues & FAQ
What does the value represent?
How many Japanese Yen are needed to buy 1 U.S. Dollar.
How often is it updated?
Daily, based on Federal Reserve data.
How do I convert USD to JPY?
Multiply USD amount by the rate: =100*YenToUSdollar() converts 100 USD to JPY.
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?