Excel Add-in: explanation of the EXCHANGE_RATE function

Introduction

With the [EXCHANGE_RATE (curr_code;co;which_rate)] function, you can include the exchange rate for a particular currency code in the worksheet.

Explanation of the fields

Company
Select the administration from which you want to retrieve the Exact data. If you select 'Default', the data will be taken from the default company. If you select a company, the data from the selected company will be displayed.

The advantage of not selecting a company is that the same report can be used for each company. You only need to change the default company to get the right data.

Function
Select the function you want to use. In this case 'EXCHANGE_RATE'.

Currency code
Enter the currency code for which you want to retrieve the exchange rate.

Date
Enter the date for which you want the exchange rate to be retrieved. This date is not so important for EMU currencies, because these have had a fixed exchange rate since 1 January 2002. This date is important for other currencies.

Example

EXCHANGE_RATE("USD";17;"31/12/2005")
The most recent exchange rate for the 'USD' on 31-12-2005 will be displayed on the worksheet.