Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Transfer Exchange Rates by the ECB

1 Transfer Exchange Rates from ECB

The exchange rates published by the European Central Bank (ECB) per working day can be transferred directly from the network via the action Acquisition of exchange rates by the ECB or by transfer from the previously saved XML file. The ECB table contains closing prices of all currently valid prices per working day, which can be imported either jointly or selectively.

Basically, only those exchange rates can be imported which are created in the application 'FXCDE' (currency codes). Currencies that were not provided by the ECB must be entered manually in the relevant period. Via context menu you can click on Tablecells editable, where the exchange rates can be added manually in existing lines.

1.1 How to Transfer from ECB

In the application 'Exchange rates' (FXRTE) the following fields must be filled out in the Selection area:

Fact Specification of the fact on which the currency conversion takes place.

Reporting Date of exchange rate Specification of the cut-off date, for the exchange rate to be imported.

Exchange rate type Specification of the exchange rate type D.

Period relation Selection of the time reference (PAV, CR, or MAV)

You can choose the menu item via right click:

1.2 Calculation of the respective Exchange Rates

  • CR (Day) closing rate: when entering 'CR', the price of the respective working day is taken from the list. If the specified deadline is not a working day, it is not included in the ECB list. The system then automatically searches for the last working day before the specified key date and imports these values. This is documented in a message in the transfer protocol (application IE JOB Controls - Import Protocol).
  • PAV (Period) period average rate as the average of all CR (Day) at the end of the month: The reference is always made to the beginning of the respective fiscal year. The first period of the year marked 'J' in the application 'CLSDTE' is authoritative. The period average rate is calculated by adding together the rates of the last working day of the month and then dividing by the number of months.
  • PAV (Period) period average rate as the average of all MAV (Month): This is the average of all day closing date exchange rates of the specified time interval.
  • PAV (Period) period average rate as the average of all CR (Day): The calculation of average exchange rates is alternatively possible using the procedure applied by the ECB itself for calculation of annual average rates. This procedure calculates the average of all single daily exchange rates.
  • MAV (Month) Monthly average rate: is the arithmetic average of all closing rates from the first day of the month (working day) to the deadline (working day).

The import of the exchange rates is documented in the 'IE job controls' application under 'Import log' (see context menu of the respective job).

2 Transfer Exchange Rates from SNB

Similar to the functionality for the ECB you can automatically download exchange rates from the website of the Swiss National Bank (SNB) and import them into IDL Konsis. This function can only be used if the group currency is CHF, otherwise the new menu is not active. Vice versa the menu for the transfer of exchange rates from ECB now is disabled if the group currency is not EUR.

However, a difference exists in the way of publication of the exchange rates by the banks: While the ECB offers all exchange rates within one big file, the SNB releases files with exchange rates for every day. Even though these files are significantly smaller, a big number of files has to be downloaded for the determination of average exchange rates per year. Therefore, the offline mode (download of the exchange rate files independent from IDL Konsis and storage in the file system) is not provided for the SNB data.
Published:

Transfer Exchange Rates by the ECB

1 Transfer Exchange Rates from ECB

The exchange rates published by the European Central Bank (ECB) per working day can be transferred directly from the network via the action Acquisition of exchange rates by the ECB or by transfer from the previously saved XML file. The ECB table contains closing prices of all currently valid prices per working day, which can be imported either jointly or selectively.

Basically, only those exchange rates can be imported which are created in the application 'FXCDE' (currency codes). Currencies that were not provided by the ECB must be entered manually in the relevant period. Via context menu you can click on Tablecells editable, where the exchange rates can be added manually in existing lines.

1.1 How to Transfer from ECB

In the application 'Exchange rates' (FXRTE) the following fields must be filled out in the Selection area:

Fact Specification of the fact on which the currency conversion takes place.

Reporting Date of exchange rate Specification of the cut-off date, for the exchange rate to be imported.

Exchange rate type Specification of the exchange rate type D.

Period relation Selection of the time reference (PAV, CR, or MAV)

You can choose the menu item via right click:

1.2 Calculation of the respective Exchange Rates

  • CR (Day) closing rate: when entering 'CR', the price of the respective working day is taken from the list. If the specified deadline is not a working day, it is not included in the ECB list. The system then automatically searches for the last working day before the specified key date and imports these values. This is documented in a message in the transfer protocol (application IE JOB Controls - Import Protocol).
  • PAV (Period) period average rate as the average of all CR (Day) at the end of the month: The reference is always made to the beginning of the respective fiscal year. The first period of the year marked 'J' in the application 'CLSDTE' is authoritative. The period average rate is calculated by adding together the rates of the last working day of the month and then dividing by the number of months.
  • PAV (Period) period average rate as the average of all MAV (Month): This is the average of all day closing date exchange rates of the specified time interval.
  • PAV (Period) period average rate as the average of all CR (Day): The calculation of average exchange rates is alternatively possible using the procedure applied by the ECB itself for calculation of annual average rates. This procedure calculates the average of all single daily exchange rates.
  • MAV (Month) Monthly average rate: is the arithmetic average of all closing rates from the first day of the month (working day) to the deadline (working day).

The import of the exchange rates is documented in the 'IE job controls' application under 'Import log' (see context menu of the respective job).

2 Transfer Exchange Rates from SNB

Similar to the functionality for the ECB you can automatically download exchange rates from the website of the Swiss National Bank (SNB) and import them into IDL Konsis. This function can only be used if the group currency is CHF, otherwise the new menu is not active. Vice versa the menu for the transfer of exchange rates from ECB now is disabled if the group currency is not EUR.

However, a difference exists in the way of publication of the exchange rates by the banks: While the ECB offers all exchange rates within one big file, the SNB releases files with exchange rates for every day. Even though these files are significantly smaller, a big number of files has to be downloaded for the determination of average exchange rates per year. Therefore, the offline mode (download of the exchange rate files independent from IDL Konsis and storage in the file system) is not provided for the SNB data.
For an optimal Community experience, Please view on Desktop
Powered by Zendesk