Skip to content
background-image background-image

ecb

ECB Monthly Averages Reader

  • Version

    3.0

  • Agent restriction

    None

  • Processing type

    Row by row

  • Multi-input step

    Not Supported

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