ExRates for Excel

Embedded Official ExchangeRates as Add-In for Excel


Your daily business is related to Excel and you often need to know currency exchange rates? Well, take a look at this Add-In for Microsoft Excel. Based upon the historical official exhange rates, published by the ECB (European Central Bank), this Add-In adds four new formulas to Excel. These formulas make it easy to add the exchange rates of a currency combination for a specific date or as average of a month, week or even a free scalable timerange to your spreadsheet.

Reliable. Fast.

Historical data available - from 1999 until today

The ECB is publishing all exchange rates in the Internet. The idea behind this Add-In is very simple. Why not building a logic that gives a user the chance to combine currencies in all possible ways. ExRates for Excel will show the result immediately. Reliable and super fast. You only need Excel and an Internet Connection.

Easy to use

Download and start using it

The AddIn provides four new formulas with a self-explaining logic how to use them. All details on how to use these formulas and answers to a few issue that might occur are listed in the "Frequently Asked Questions" below.

FAQ - Frequently Asked Questions

Simply open the Archive File and double click the included *.xlam File. The AddIn asks for being installed and activated. Please allow the executions of Macros in Excel when the security prompt occurs. if you want to update a prior version this process will also update the AddIn. After the install, Excel exits and you have to restart it.

When the AddIn has been installed successfully you will see five new formulas, all starting with "ExRate ...". For further reference on how to use these formulas please see the sections to each formulas with examples below.

ExRate

This formula shows the Exchange rate from a source currency shortcut to a target current currency shortcut for a specific date.

General setup of the formula:

=ExRate([SOURCE_CURRENCY_SHORTCUT];[TARGET_CURRENCY_SHORTCUT];[DATE])

You can either give concrete parameters or reference to a cell with the parameters:

ExRate_AVG

This formula shows the average exchange rate from a source currency shortcut to a target currency shortcut for a self-defined timerange.

General setup of the formula:

=ExRate([SOURCE_CURRENCY_SHORTCUT],[TARGET_CURRENCY_SHORTCUT],[DATE_FROM],[DATE_TO])

You can either give concrete parameters or reference to a cell with the parameters:

Please note that it can take a while until you get a proper result. The bigger the timerange the more rates have to be added to calculate the average. Please be patient.

ExRate_AVG_Month

This formula shows the average exchange rate from a source currency shortcut to a target currency shortcut for a specifc month of a year.

General setup of the formula:

=ExRate([SOURCE_CURRENCY_SHORTCUT],[TARGET_CURRENCY_SHORTCUT],[YEAR],[MONTH])

You can either give concrete parameters or reference to a cell with the parameters. In this case we are looking for the average rate from EUR to USD for January 2019:

Please note that it can take a while until you get a proper result. The bigger the timerange the more rates have to be added to calculate the average. Please be patient.

ExRate_AVG_Week

This formula shows the average exchange rate from a source currency shortcut to a target currency shortcut for a specifc calendar week of a year.

General setup of the formula:

=ExRate([SOURCE_CURRENCY_SHORTCUT],[TARGET_CURRENCY_SHORTCUT],[YEAR],[WEEK])

You can either give concrete parameters or reference to a cell with the parameters. In this case we are looking for the average rate from EUR to USD for the 10th calendar week in 2019:

For a full list of all supported currency shortcuts please follow this link:

The AddIn relies on the data published by the ECB. If this currency is not published there it won´t be in this AddIn either.

Well you can use the AddIn 15 days for free. After 15 days you have to purchase a License.

If you don´t get a proper exchange rate and you receive "0" or "#NA" as a result one of the following items might the reason for this error.
- There is a typo in your date or you are referring to a cell that is not formatted as a date.
- You are referring to a Sunday or a Holiday. These days do not have exchange rates.
- You are referring to a date prior 1999 or a date higher than yesterday´s date. For these time ranges exchange rates do not exist.
- You are not connected to the Internet. An Internet connection is mandatory for the use of ExRatesForExcel.
- You may have found a bug in the software. Do not hesitate to send an E-Mail to support@code-is-poetry.de or report this issue in our support forum.

No. If you have seven weekdays and only five days with exhange rates the average is based upon five days (not on seven).

Simply because it´s no available. All rates are based upon the official rates published by the ECB. They publish actual rates alwas on the following day.

Well, I have no idea. As already stated - this AddIn takes the rates from the ECB. No other sources are included.

Please type "=ExRate_License()" in a cell in a spreadsheet. Follow the link, "Purchase a License" in the roip right corner. Click on "Purchase a Serial Number" on the now open webpage. Follow the instruction and buy a License. If everything works fine during the payment process you should receive a License right after the payment via E-Mail. Take the Name and the serial number and add to the License Screen you have opened with "=ExRate_License()"

One person is allowed to install this AddIn on three different machines as long as the same person is working with this License on all these machines. It´s not allowed to share the License with another person.

What?! You want to uninstall this masterpiece of Sofware?? :-) Ok. Open Excel -> File -> Options -> AddIns -> Manage: Excel Add-ins -> Go and remove the Addin "Exratesforexcel". Or you can download this script and execute it with a double click.