How to Use Forex Functions in MarketXLS
Access real-time foreign exchange rates and perform currency conversions directly in Excel with MarketXLS's Forex functions.
Function Parameter Order
All currency functions in MarketXLS require a Source currency symbol and a Target currency symbol. The first symbol is always the source, and the second is the target.
Available Forex Functions
Fx_Ask() - Get Ask Price
Returns the current ask price for a currency pair:
=Fx_Ask("USD", "GBP")Gets the ask price for converting USD to GBP
Fx_Bid() - Get Bid Price
Returns the current bid price for a currency pair:
=Fx_Bid("USD", "GBP")Gets the bid price for converting USD to GBP
Fx_Convert() - Currency Conversion
Converts an amount from one currency to another:
=Fx_Convert(100, "USD", "GBP")Converts 100 USD to GBP at the current exchange rate
Parameter Order
For the Fx_Convert function, provide the value to convert first, then the source currency, and finally the target currency symbol.
Common Currency Codes
Americas
- USD - US Dollar
- CAD - Canadian Dollar
- MXN - Mexican Peso
- BRL - Brazilian Real
Europe
- EUR - Euro
- GBP - British Pound
- CHF - Swiss Franc
- SEK - Swedish Krona
Asia-Pacific
- JPY - Japanese Yen
- CNY - Chinese Yuan
- INR - Indian Rupee
- AUD - Australian Dollar
Example Use Cases
Portfolio Currency Conversion
Convert international holdings to your base currency:
=Fx_Convert(A2, "EUR", "USD")Where A2 contains the EUR amount to convert
Real-Time Exchange Rates
Monitor exchange rates for currency pairs:
=Fx_Bid("EUR", "USD")Track EUR/USD exchange rate in real-time
Cross-Currency Analysis
Calculate spreads between bid and ask:
=Fx_Ask("USD", "JPY") - Fx_Bid("USD", "JPY")Determine the bid-ask spread for USD/JPY
Real-Time Forex Data
All Forex functions provide real-time exchange rates, perfect for international portfolio management, currency hedging analysis, and global investment tracking. Data updates automatically when you refresh MarketXLS.
Tips for Using Forex Functions
- Always use standard 3-letter ISO currency codes (USD, EUR, GBP, etc.)
- The order of currency symbols matters - source first, target second
- Use Fx_Convert for actual conversions, Fx_Bid/Fx_Ask for rate monitoring
- Combine with other MarketXLS functions for comprehensive international analysis
- Rates update when you refresh your MarketXLS data