Get the latest exchange rate between 2 currencies in Excel in a few steps.
- Write your two currencies in one cell - Enter both currency codes in the same cell.
- Activate Data Type - Click on Data Type to connect to the exchange rate market.
- Select the Price property - Choose "Price" to get the latest exchange rate.
Add Exchange Rate
The Office 365 version offers a new feature: Data Type.
- This tool fills cells with financial data, connecting Excel to a live database.
- Once connected, get information about your ticker or currencies.
To view exchange rates between two currencies, follow these steps:
- Enter Currency1/Currency2 in your cell.
- Go to the ribbon: Data > Stocks.
- Any separator (/, space, -, |) works.
- When the stock icon appears, you are connected. 😀👍
What Are the Details Behind the Link?
- Once the icon is in your cell, hover over it.
- View information about the exchange rate between the two currencies.
You can access information like the last trade time, % change, and more.
Return the Last Exchange Rate
Here’s how to return the latest exchange rate between two currencies:
- Click the small square in the top right of the cell.
- Select the Price property.
Or, you can use a formula:
- Start with an equal sign.
- Select the cell with the currency codes.
- Type a period to see a list of properties.
- Double-click the desired property to add it.
In both cases, the formula is:
=E2.Price
- Use the STOCKHISTORY function with the "EUR/USD" ticker for historical rates.
- =STOCKHISTORY("EUR/USD", ......)
Copy the Formula for Other Currencies
Copying the formula for other currencies might bring formatting issues. To prevent errors:
- Select a cell with a triangle in the top left corner.
- Click Update Format.
19/02/2024 @ 08:28
This was helpful, Thank you 🙂
16/04/2023 @ 14:53
I was wondering if there was a way to detect the most recent highs or lows within a certain number of bars. Do you work with clients who have objectives? Not sure whether I have to subscribe to a service and whether what i am looking for requires me to spend a crazy amount of monthly subscription to get data on different time frames 1,5,15,30, hr, 4hr, daily---OHLC) or if there is a recommendable site that has those time frames available.
Do you contract your as a service?
12/11/2021 @ 12:13
¡Información muy interesante! ¡Perfecto justo lo que estaba buscando!
13/01/2021 @ 13:57
There is certainly a lⲟt to know about this topic. I really like all of the points you have madе.