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.

Where can I get the best exchange rate? ›

Online firms such as Revolut may offer a better exchange rate. Along with low-cost providers Monzo, Starling Bank and others, Revolut holders can expect fee-free cash withdrawals (usually subject to a monthly limit).

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.

Which Bank is best for currency exchange? ›

Top Banks That Exchange Foreign Currencies
  • TD Bank: TD Bank offers 55 different currencies. ...
  • Service Federal Credit Union: The number of currencies available for customers at Service Credit Union exceeds 60. ...
  • US Bank: Customers of US Bank can exchange money at a nearby branch.

Where is it cheapest to exchange currency? ›

Best place to exchange currency: Your bank or credit union

Many banks offer currency exchange to their customers. Though there may be a small fee if you exchange less than a certain amount, your bank or credit union will almost always be the cheapest place to exchange currency.

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

It's often more cost-effective to exchange a small amount of euros in America for initial expenses and then withdraw euros from ATMs in Europe for a better exchange rate and lower fees.

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

What is the best place to exchange foreign currency? The best place to exchange foreign currency in the U.S. is at your local bank or credit union before you leave for your trip.

Is it cheaper to get foreign currency abroad? ›

If possible, consider withdrawing cash abroad as needed from ATMs. Because they're owned by banks, ATMs usually offer the most current exchange rate and feature fees that are lower than an airport or currency exchange.

What is the best day to buy currency? ›

Typically, the least busy times of the week are Mondays, mid-week and the weekend (excluding Friday). These days have the lowest number of transfers in the week, so you might expect to see less fluctuation in the mid-market rate.

Where can I find official exchange rates? ›

Governmental resources
  • Treasury Department's currency exchange rate.
  • Federal Reserve Bank.
  • U.S. Department of Agriculture.

What is the exchange rate right now? ›

USDGBPCAD
10.797421.36807
1.2540411.71561
0.730960.582881
1.076240.858211.47236
1 more row

How much is $1 dollar in other countries? ›

US Dollar Exchange Rates Table Converter
US Dollar1.00 USDinv. 1.00 USD
Euro0.9288771.076569
British Pound0.7972461.254318
Indian Rupee83.4209160.011987
Australian Dollar1.5137090.660629
6 more rows

How can I get the best 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.

Do banks convert currency for free? ›

Many banks and credit unions allow you to exchange U.S. currency for a relatively minimal cost, or none at all, and in the manner that best suits your needs, including online, through a bank's mobile app, in a branch or over the phone.

Should I exchange money before I travel? ›

Ordering currency from your bank before you travel is almost always better than using the airport currency exchange. Sally French is a travel rewards expert who joined NerdWallet in 2020. She previously wrote about travel and credit cards for The New York Times and its sibling site, Wirecutter.

Where can I find the most accurate exchange rates? ›

The Treasury Reporting Rates of Exchange dataset provides the U.S. government's authoritative foreign currency exchange rates for federal agencies to consistently report U.S. dollar equivalents.

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

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. Check to see if your U.S. bank offers foreign ATM fee refunds for using a foreign ATM. Not all currency exchanges charge the same rate.

Which money exchange gives the best rate? ›

Orient Exchange is one of the best foreign currency exchange in India. The most expensive option is airport exchange which should only be used as a last resort.

Do you get a better exchange rate using a credit card? ›

And despite any differences, credit cards still give you a much better conversion rate than if you exchange money at an airport kiosk or at checkout.

Top Articles
Latest Posts
Article information

Author: Barbera Armstrong

Last Updated:

Views: 5995

Rating: 4.9 / 5 (79 voted)

Reviews: 86% of readers found this page helpful

Author information

Name: Barbera Armstrong

Birthday: 1992-09-12

Address: Suite 993 99852 Daugherty Causeway, Ritchiehaven, VT 49630

Phone: +5026838435397

Job: National Engineer

Hobby: Listening to music, Board games, Photography, Ice skating, LARPing, Kite flying, Rugby

Introduction: My name is Barbera Armstrong, I am a lovely, delightful, cooperative, funny, enchanting, vivacious, tender person who loves writing and wants to share my knowledge and understanding with you.