Exchange rate in Excel

Last Updated on 11/06/2024

Get the last exchange between 2 currencies in Excel in a few steps

1. Write your 2 currencies in a cell

You must write the 2 currency codes in the same cell

2. Activate Data Type

You only need to click on this toll to be connected to the exchange rate market

3. Select the Price property

Among all the properties, the Price gives you the last quotation

The Office 365 version provides a great new feature: Data Type.

• With this tool, you must fill in financial data in your cells, and Excel connects to a database.
• Once connected, you can return any information related to your ticker or currencies.

For instance, if you want to have the exchange rates between 2 currencies, here are the steps

1. Write in your cells Currency1/Currency2
2. Go to ribbon Data > Stocks
3. The / is not compulsory. you can use any separator; like space, -, | , ...
4. And when you see the stock icon, you are connected 😀👍
2. Put your cursor on the icon
3. Then, you visualize all the information related to the exchange rate between the 2 currencies

You can notice that many information could be returned: last trade time, % change, ...

Return the last Exchange rate

Now, how to return the last Exchange rate between 2 currencies?

1. Click on the little rectangle in the upper right corner of the cell
2. Select the property Price

As an alternative method, you can also write a formula

2. Select the cell with the currencies
3. Add a period. This opens the list of properties
4. 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

1. Select a cell with the triangle in the upper left corner
2. Click on the option Update Format

Frédéric LE GUEN

1. Raveena
19/02/2024 @ 08:28

This was helpful, Thank you 🙂

2. Len
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!

4. game
13/01/2021 @ 13:57

Exchange rate in Excel

Last Updated on 11/06/2024

Get the last exchange between 2 currencies in Excel in a few steps

1. Write your 2 currencies in a cell

You must write the 2 currency codes in the same cell

2. Activate Data Type

You only need to click on this toll to be connected to the exchange rate market

3. Select the Price property

Among all the properties, the Price gives you the last quotation

The Office 365 version provides a great new feature: Data Type.

• With this tool, you must fill in financial data in your cells, and Excel connects to a database.
• Once connected, you can return any information related to your ticker or currencies.

For instance, if you want to have the exchange rates between 2 currencies, here are the steps

1. Write in your cells Currency1/Currency2
2. Go to ribbon Data > Stocks
3. The / is not compulsory. you can use any separator; like space, -, | , ...
4. And when you see the stock icon, you are connected 😀👍
2. Put your cursor on the icon
3. Then, you visualize all the information related to the exchange rate between the 2 currencies

You can notice that many information could be returned: last trade time, % change, ...

Return the last Exchange rate

Now, how to return the last Exchange rate between 2 currencies?

1. Click on the little rectangle in the upper right corner of the cell
2. Select the property Price

As an alternative method, you can also write a formula

2. Select the cell with the currencies
3. Add a period. This opens the list of properties
4. 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

1. Select a cell with the triangle in the upper left corner
2. Click on the option Update Format

1. Raveena
19/02/2024 @ 08:28

This was helpful, Thank you 🙂

2. Len
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?