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.
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.
It you click on the price option excel will add another cell to your sheet with the live price in.
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.
When you click on this question mark a data selector box will appear on the right side of your sheet.
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.
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.