Skip to content
background-image background-image

ecb

ECB daily Rates Currency Month Reader

  • Version

    3.0

  • Agent restriction

    None

  • Processing type

    Row by row

  • Multi-input step

    Not Supported

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