Importing Exchange Rates
Last updated on 2025-07-09
Overview
Exchange rates for exchange rate tables can either be queried from the European Central Bank or imported from MS Excel.
This article contains the following sections:
Importing Exchange Rates from the ECB
Exchange rates can be queried online from the ECB and imported at the same time into one or more exchange rate tables. All the EURO exchange rates of these currencies, as well as all the exchange rates between these currencies, can be queried.
To call up the exchange rates from the ECB:
- Right-click the root folder Exchange rate tables or an individual exchange rate table.
- Choose Import | Import exchange rates from European Central Bank from the context menu. The Import Exchange Rate From European Central Bank dialog is displayed:
‘Import Exchange Rate From European Central Bank’ dialog - Specify the exchange rate table, data level, and period.
- Click Import.
- All of the exchange rates in the selected data levels and in the selected time period defined in Lucanet are updated on the basis of the exchange rates from the ECB.
- The most recently available exchange rate of the respective month is used as the closing exchange rate.
- The average exchange rate is determined in Lucanet by calculating the average using the daily closing exchange rates of the month. This means that the ECB calculation method is used.
Importing Exchange Rates from MS Excel
To import exchange rates from MS Excel:
- Right-click the Exchange rate tables root folder.
- Choose Import | Import exchange rates from MS Excel from the context menu.
- Navigate to the desired file and click its name.
- Click Import or press Enter to start the import.
The import can be carried out successfully only if the structure of the Excel file matches the structure of an exchange rate file export file (see Exporting Exchange Rates).