Exchange rate in Excel

Exchange rate in Excel

Last Updated on 28/08/2023
Reading time: 2 minutes

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

Add Exchange Rate

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

  1. With this tool, you just have to fill in geographic data or financial data in your cells and Excel connects to a database
  2. 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?

  1. Once the icon is added to your cells
  2. Put your cursor on the icon
  3. Then, you visualize all the information related to the exchange rate between the 2 currencies
List of the data linked to a connection with Data Type

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?

  1. Click on the little rectangle in the upper right corner of the cell
  2. Select the property Price
Display all the options linked to one Data Type

As an alternative method, you can also write a formula

  1. Start with the equal sign
  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

3 Comments

  1. 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?

    Reply

  2. adopcion gato las palmas
    12/11/2021 @ 12:13

    ¡Información muy interesante! ¡Perfecto justo lo que estaba buscando!

    Reply

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

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Exchange rate in Excel

Reading time: 2 minutes
Last Updated on 28/08/2023

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

Add Exchange Rate

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

  1. With this tool, you just have to fill in geographic data or financial data in your cells and Excel connects to a database
  2. 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?

  1. Once the icon is added to your cells
  2. Put your cursor on the icon
  3. Then, you visualize all the information related to the exchange rate between the 2 currencies
List of the data linked to a connection with Data Type

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?

  1. Click on the little rectangle in the upper right corner of the cell
  2. Select the property Price
Display all the options linked to one Data Type

As an alternative method, you can also write a formula

  1. Start with the equal sign
  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

3 Comments

  1. 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?

    Reply

  2. adopcion gato las palmas
    12/11/2021 @ 12:13

    ¡Información muy interesante! ¡Perfecto justo lo que estaba buscando!

    Reply

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

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *