Live and Historic Currency Exchange Rates in Excel

Excel Price Feed is ideal for populating your Excel spreadsheet with live currency exchange rates.


Excel live currency exchange rate example

Introduction

If you run an international business that deals in a variety of currencies or are simply trying to work out how much you spent on holiday then you have no doubt spent time updating a spreadsheet with the latest exchange rates.

This usually means looking up the rate on a website then copying/pasting the rate into a cell in your sheet. This process is repeated for each currency, and is repeated again whenever you want to update the fx rates (the fx market is open 24 hours a day).

There is an easier way, you can use the Excel Price Feed Add-in to automatically retrieve live exchange rates into Excel cells.

You set up the formula once and then each time you refresh your spreadsheet the latest live exchange rates are retrieved and the rate in the cell is updated. No more copying/pasting exchange rates.


Live Exchange Rates Example

After installing the Add-in you now have access to 80+ new Excel functions, including the one below which we will to retrieve the live exchange rate from Yahoo Finance:

=EPF.Yahoo.Price("EURUSD=X")

This formula uses currency code of the exchange rate you require, the convention for Yahoo Finance is the currency pair code followed by "=X".

If you don't know the currency code then you can use the search screen on the Configuration Pane, accessed from the button on the toolbar.

For this example we will start with a table of widgets that we are sourcing from 3 different countries which are priced in 3 different currencies:

Excel exchange rate example

To populate the USD price column we just need to provide the live exchange rate to the "Rate" column, for example here we can see the EPF.Yahoo.Price formula used for the Euro widget in the Rate cell:

Excel live EUR USD exchange rate formula

We repeat this formula for the next two rows, we now have the dollar price for each widget and can calculate a dollar total for all 3 widgets:

Excel live currency exchange rate example

Any time you wish to update the exchange rates, simply press the "Refresh Sheet" button on the Excel Price Feed toolbar, no more copying/pasting exchange rates!

Excel refresh exchange rates from Yahoo Finance

Historic Exchange Rates

Excel Price Feed also provides the ability to retrieve historic exchange rates into Excel cells. This is achieved using the EPF.Yahoo.Historic.Close formula.

For example, this formula will retrieve the Euro/US Dollar (EURUSD) exchange rate as it was on 1 January 2019:

=EPF.Yahoo.Historic.Close("EURUSD=X","1 Jan 2019")

Summary

We hope this tutorial really helps you save time building Excel spreadsheets that need live currency exchange rates.

Discover the power of Excel Price Feed with 80+ new Excel formulas for live, historic and fundamental data in your spreadsheet. Click the button below to request an Activation Code for your free 10 day trial:

Try it FREE for 10 days