Get the last exchange between 2 currencies in Excel in a few steps
- Write your 2 currencies in a cell
You must write the 2 currency codes in the same cell
- Activate Data Type
You only need to click on this toll to be connected to the exchange rate market
- Select the Price property
Among all the properties, the Price gives you the last quotation
Add Exchange Rate
The Office 365 version provides a great new feature; Data Type.
- With this tool, you just have to fill in geographic data or financial data in your cells and Excel connects to a database
- Once you are connected, you can return any information in relationship with your cell's value
For instance, if you want to have the exchange rates between 2 currencies, here are the steps
- Write in your cells Currency1/Currency2
- Go to ribbon Data > Stocks
- The / is not compulsory. you can use any separator; like space, -, | , ...
And when you see the stock icon, you are connected 😀👍

What are the details behind the link?
- Once the icon is added to your cells
- Put your cursor on the icon
- Then, you visualize all the information related to the exchange rate between the 2 currencies

You can notice that many information could be returned 😯😎
Return the last Exchange rate
Now, how to return the last Exchange rate between 2 currencies?
- Click on the little rectangle in the upper right corner of the cell
- Select the property Price

As an alternative method, you can also write a formula
- Start with the equal sign
- Select the cell with the currencies
- Add a period. This opens the list of properties
- Double-click on the property you want to add and that's it.

In both situations, the formula is
=E2.Price
Copy the formula for the other currencies
When you copy the formula for the other exchange rate between 2 currencies, you could have a problem.
Not only do you copy the formula, but also the format, on the currency unit 😯 To avoid any mistakes
- Select a cell with the triangle in the upper left corner
- Click on the option Update Format

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е.