Where To Get Live Exchange Rate Data

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web More...Less

With the Currencies data type you can easily get and compare exchange rates from around the world. In this article, y'all'll acquire how to enter currency pairs, catechumen them into a information type, and excerpt more than information for robust data.

Image showing a converted Currency table with exchange rates.

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

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.

For example, enter "USD/EUR" to go the exchange charge per unit from one United States Dollar to Euros.
Select the cells so select Insert > Table. Although creating a tabular array isn't required, it'll make inserting information from the data type much easier afterward.
With the cells even so selected, go to the Information tab and select the Currencies data type.

If Excel finds a match between the currency pair and our information provider, your text will convert to a information type and you'll see the Currencies icon in the cell.

Annotation:If yous 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 tin search for a currency pair or specify the data you lot demand.
To excerpt more than data from the Currencies information type, select one or more than converted cells and select the Insert Data button that appears or press Ctrl/Cmd+Shift+F5.
Y'all'll run into a list of all the fields available to choose from. Select the fields to add together a new column of information.

For example,Price represents the substitution rate for the currency pair,Terminal Trade Timerepresents the time the exchange rate was quoted.
In one case y'all accept all the currency information that you want, you tin utilise it in formulas or calculations. To ensure your information is up to appointment, y'all can go to Data > Refresh All to get an updated quote.

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