The ECB daily rates currency month reader is connected to the ECB data portal exchange reference rates and returns the set of exchange rates for the defined single currency code and the month based on the provided date.
The connector expects the input of:
-
single currency code (ISO format 4217) and
-
date (format yyyy-mm-ddThh:mm:ss.sss or yyyymmddThh:mm:ss.sss based on ISO 8601). The connector will parse the date and use the year and month part of it.
The currency code is mandatory, the date is optional, and if not provided, the default date value is set to: NOW. Please mind, that if the date is set to the current day date or default value NOW, the exchange rates will be returned for all relevant days of the month except the current date.
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
ECB daily rates currency month input (ver. 1.0.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Currency | string | No | Currency code in ISO 4217 format |
| DateMonth | DateTime | Yes | Date - the month and year value will be taken to obtain the exchange rate. If the date is empty (null), actual date is taken. |
Output
ECB daily rates currency month output (ver. 1.0.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ValidFor | DateTime | No | Day in month (entire date) |
| CurrencyCode | string | No | Currency code in ISO 4217 format (CZK, EUR, USD, ...) |
| Amount | integer | No | Decimal place factor |
| Rate | double | No | Exchange rate for the currency using the decimal place factor |
Release notes
3.0.0
- First release