The ECB monthly averages reader is connected to the ECB data portal exchange reference rates and returns the average exchange rates for the published set of currency codes and all completed months of the provided year.
The connector expects the input of:
- year (format yyyy)
Euro foreign exchange reference rates
The reference rates are usually updated at around 16:00 CET every working day, except on TARGET closing days.
They are based on the daily concertation procedure between central banks across Europe, which normally takes place around 14:10 CET. The reference rates are published for information purposes only. Using the rates for transaction purposes is strongly discouraged.
Configuration
This connector does not include any configuration.
Input & Output Schema
Input
CNB monthly averages rates input (ver. 1.0.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Year | integer | Yes | Year, for which the average rates are required |
Output
CNB monthly averages rates output (ver. 1.0.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Month | string | No | Month - 3 letter abbreviation (JAN, FEB, MAR, ...) |
| Year | integer | No | Year |
| Average | double | No | Average exchange rate for the period |
| CurrencyCode | string | No | Currency code in ISO 4217 format |
| Amount | integer | No | Exchange rate for the currency using the decimal place factor |
Release notes
3.0.0
- First release