Get a currency exchange rate (2024)

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

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.

Get a currency exchange rate (1)

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

    Get a currency exchange rate (2)

    in the cell.

    Note:If you see   Get a currency exchange rate (3) 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.

  4. To extract more information from the Currenciesdata type, select one or more converted cells and select the Insert Data button Get a currency exchange rate (4) 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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Get a currency exchange rate (2024)

FAQs

Get a currency exchange rate? ›

Local banks and credit unions usually offer the best rates. Major banks, such as Chase or Bank of America, often offer the added benefit of having ATMs overseas. Online peer-to-peer foreign currency exchanges. Online bureaus or currency converters, such as Travelex, provide convenient foreign exchange services.

How do I get the best exchange rate for currency? ›

Local banks and credit unions usually offer the best rates. Major banks, such as Chase or Bank of America, often offer the added benefit of having ATMs overseas. Online peer-to-peer foreign currency exchanges. Online bureaus or currency converters, such as Travelex, provide convenient foreign exchange services.

Who gives the best currency exchange rate? ›

Travel credit cards - i.e. the ones with no foreign transaction fees - offer two key advantages over travel money: Great exchange rates - when you spend on a travel credit card you get the Mastercard or Visa exchange rate, which is about the best you can find as a regular consumer.

Which US banks offer foreign currency exchange? ›

Financial institutions that allow you to exchange foreign currency
  • America First Credit Union: Credit union members may visit select branches to exchange up to $5,000. ...
  • Bank of America: Bank of America customers may exchange up to $10,000 online. ...
  • Citi: You can call or visit a branch to exchange over 50 types of currency.
May 8, 2024

Where do you find currency exchange rates? ›

OANDA's Currency Converter allows you to check the latest foreign exchange average bid/ask rates and convert all major world currencies. OANDA Rates™ are foreign exchange rates compiled from leading market data contributors.

Should I exchange money before I travel? ›

Before your trip, it's best to do a currency exchange at your bank or credit union, which likely offers better rates and fewer and/or lower fees. Your bank or credit union may buy back leftover foreign currency in exchange for dollars when you return.

Is it better to exchange money at bank or currency exchange? ›

Key Takeaways. Currency exchange shops and kiosks in airports are not the best places to exchange money. For the best rates, try a local bank or a bank ATM to make your currency exchanges.

Which bank gives the best exchange rate? ›

Comparing Our Rates With the Big Five Banks
RetailerUSDEuro
Scotiabank1.28921.5415
BMO1.28971.5601
CIBC1.30201.5601
Ultimate Currency Exchange1.27381.5260
3 more rows

Is it better to exchange currency at home or abroad? ›

If you don't have time to get cash at the bank before your trip, it can be tempting to get foreign currency at an airport kiosk or currency exchange counter. These merchants offer convenience, but their exchange rates are typically much less favorable than your bank at home.

What is the best day to exchange currency? ›

Mondays often experience the lowest number of trading in foreign exchange market. Therefore, you may expect the least fluctuation in price. Friday has a definite effect which is called the summary effect. There are many traders who close their positions at the end of the week.

Is it cheaper to get euros in the US or in Europe? ›

With time at your disposal, you'll be able to see exactly what the fee and rate is, and how many euros you'll get for your dollars. It's possible of course that you might get a better deal when you land in Europe. It may well be the case that fees are lower and exchange rates better.

Can I walk into Bank of America and get euros? ›

Any Bank of America customer can exchange foreign currency at any financial center.

Should you get euros before traveling? ›

Consider ordering euros before you leave

Check with your bank to see what options they offer, or use another organization such as AAA. Keep in mind that this step is up to you and doesn't always get you the best exchange rate—it's not necessary to obtain euros before traveling to most European countries.

Where can I get the best foreign exchange rate? ›

Head to your bank or credit union before you leave to avoid paying ATM transaction costs. You may even receive a better exchange rate. Credit unions and banks will exchange your dollars into a foreign currency before and after your trip when you have a checking or savings account with them.

Where can I get best exchange rate for US dollars? ›

What is the best US dollar exchange rate? The best US dollar exchange rate right now is 1.2559 from Travel FX. This is based on a comparison of 16 currency suppliers and assumes you were buying £750 worth of US dollars for home delivery.

What is the best way for exchange rate? ›

Where to exchange currency before you leave
  • Avoid changing money at the airport. ...
  • High street banks are unlikely to be competitive on exchange rates. ...
  • Look at online currency specialists. ...
  • Consider a specific account for currency exchange. ...
  • Use low or no fee credit and debit cards. ...
  • Pay in the local currency.
May 16, 2024

How can I get better exchange rates? ›

Our top foreign exchange rate tips
  1. Compare before you buy. We all know it's sensible to shop around for things such as car, home and travel insurance to get the best deal. ...
  2. It's not always better to exchange before you fly. ...
  3. You may not need to take cash. ...
  4. Look for a buy-back guarantee. ...
  5. Don't leave it until the last minute.
Jun 11, 2024

Where to get best USD exchange rate? ›

Exchanges- Currency-exchange services tend to offer a slightly better deal than the banks, such as the Vancouver Bullion & Currency Exchange (VBCE), and usually have best-rate guarantees. So, if a bank offers you a rate, you can show the VBCE and get a better rate.

How can I avoid currency conversion fees? ›

To avoid dynamic currency conversion fees when traveling internationally, choose to pay credit card transactions in the local currency rather than in US dollars. Some merchants will attempt to make this decision for you, so confirm which currency you're transacting in before you pay.

Top Articles
Latest Posts
Article information

Author: Terrell Hackett

Last Updated:

Views: 6326

Rating: 4.1 / 5 (52 voted)

Reviews: 91% of readers found this page helpful

Author information

Name: Terrell Hackett

Birthday: 1992-03-17

Address: Suite 453 459 Gibson Squares, East Adriane, AK 71925-5692

Phone: +21811810803470

Job: Chief Representative

Hobby: Board games, Rock climbing, Ghost hunting, Origami, Kabaddi, Mushroom hunting, Gaming

Introduction: My name is Terrell Hackett, I am a gleaming, brainy, courageous, helpful, healthy, cooperative, graceful person who loves writing and wants to share my knowledge and understanding with you.