How to get currency prices automatically in excel
Investoroly - How to get currency prices automatically in excel - Convert to Stocks

How to get currency prices automatically in excel

This is a quick guide on how to automatically get currency prices in excel.  Getting live currently exchange rates into excel is quite simple now with a recent update to Microsoft excel. The way to pull live data is as follows

Adding the code

In an excel cell you need to add both of the currencies that you would like to convert from and the currency you would like to convert too separated by a forward slash. In this example we will convert United States Dollars into Great British Pound. We enter the following into excel USD/GBP

With this done we need to open the data ribbon. On the data ribbon there is a box called Data Types. Within this box is a button called Stocks. When we click on the Stocks buttons excel will attempt to create a link looking for United States Dollars to Great British Points. 

Investoroly - How to get currency prices automatically in excel - Convert to Stocks

If it is successful at finding it, excel will add a symbol of an exchange into the cell. With this cell now linked when you click it in an extra box will appear called insert data. When you click on Insert data a menu will appear will all of the data that can delivered.

Investoroly - Conversion data

It you click on the price option excel will add another cell to your sheet with the live price in.  

Investoroly - How to get currency prices automatically in excel - Live Prices

Problems that can occur

If excel is unable to match the conversion it will instead of an exchange symbol it will use a blue question mark in a circle.  

Investoroly - How to get currency prices automatically in excel - Input Error

When you click on this question mark a data selector box will appear on the right side of your sheet.

Investoroly - How to get currency prices automatically in excel Data selector

In here you can alter what you would like Excel to search for. It will list possibilities below the input box. Select the option you require.

Investoroly - Data Selector options

Currency Codes

Here are the codes for some of the popular currency’s

  • USD = United States Dollar
  • GBP = Great British Pound
  • EUR = Euro
  • AUD = Australia Dollar
  • CAD = Canadian Dollar
  • INR = Indian Rupee
  • CNY = Chinese Yuan

I hope that this quick guide on how to get currency prices automatically in excel was useful to you.

Close Menu