Import of exchange rates from the ECB
When importing exchange rates from the ECB, the date shift of the exchange rate validity is ensured. The exchange rate table imports the exchange rate with the validity date moved forward by 1 day compared to the announcement date on the ECB website.
Settings for the date offset
- Choose the
icon, enter Curr. Exch. Rate Service and then choose the related link. - On the Currency Exchange Rate Services page for ECB-EXCHANGE-RATES open Data Exchange Definitions.
- On the Data Exchange Definition page, choose Field Mapping.
- In the SK Date Formula field enter 1D o ensure that the date offset works for import.
- Confirm with OK.