Get a currency exchange rate (2024)

With the Currenciesdata type you can easily get and compare exchange rates from around the world. In this article, you'll learn how to enter currency pairs, convert them into a data type, and extract more information for robust data.

Note:Currency pairsareonly available to Microsoft 365 accounts (Worldwide Multi-Tenant clients.)

Use the Currenciesdata type to calculate exchange rates

1. Enter the currency pair in a cell using this format: From Currency / To Currencywith the ISO currency codes.

   For example, enter "USD/EUR" to get the exchange rate fromoneUnited States Dollar toEuros.

2. Select the cellsand then select Insert > Table.Although creating a table isn't required, it'll make inserting data from the data type much easier later.

3. With the cells still selected, go to the Data tab and select the Currenciesdata type.

   If Excel finds a match between thecurrency pair and our data provider, your text will convert to a data type and you'll see the Currenciesicon

   

   in the cell.

   Note:If you see   in the cell insteadof the Currenciesicon, then Excel is having difficulty matching the text with data. Correct any mistakes and press Enter to try again. Or, select the icon to open the Data Selector where you can search for a currency pair or specify the data you need.

   See Also

   What is 90% rule in Forex?Learn the Easiest Way to Calculate an FX RateWhat is the spread in forex and how do you calculate it?Forex Market Participants: Who Controls the Forex Market? / Axi

4. To extract more information from the Currenciesdata type, select one or more converted cells and select the Insert Data button that appears or press Ctrl/Cmd+Shift+F5.

5. You'll see a list of all the fields available to choose from. Select the fields to add a new column of data.

   For example,Pricerepresents the exchange rate for the currency pair,Last Trade Timerepresents the time the exchange rate was quoted.

6. Once you have all the currency data that you want, you can use it in formulasor calculations. To ensure your data is up to date, you can go to Data > Refresh All to get an updated quote.

   Caution:Currencyinformation is provided "as-is" and may be delayed. Therefore, this data should not be used for trading purposes or advice. See About our data sourcesfor more information.

Seealso

Stocks and geography data types

How to write formulas that reference data types

FIELDVALUE function

#FIELD! error