With the Currencies data 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.
Use the Currencies data type to calculate exchange rates
Enter the currency pair in a cell using this format: From Currency / To Currency with the ISO currency codes.
You are watching: In this table, the reference currency is the
For example, enter “USD/EUR” to get the exchange rate from one United States Dollar to Euros.
Select the cells and then select Insert > Table. Although creating a table isn”t required, it”ll make inserting data from the data type much easier later.
With the cells still selected, go to the Data tab and select the Currencies data type.
If Excel finds a match between the currency pair and our data provider, your text will convert to a data type and you”ll see the Currencies icon
in the cell.
Note: If you see
in the cell instead of the Currencies icon, 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.
To extract more information from the Currencies data type, select one or more converted cells and select the Insert Data button
that appears or press Ctrl/Cmd+Shift+F5.
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, Price represents the exchange rate for the currency pair, Last Trade Time represents the time the exchange rate was quoted.
Stocks and geography data types
How to write formulas that reference data types
Thank you! Any more feedback? (The more you tell us the more we can help.) Can you help us improve? (The more you tell us the more we can help.)