Returns ECB data for a given flow and key
Usage
ecb_data(
flow,
key = NULL,
start_period = NULL,
end_period = NULL,
first_n = NULL,
last_n = NULL
)Arguments
- flow
(
character(1)) flow to query.- key
(
character(1)) key to query.- start_period
(
character(1)) start date of the data. Supported formats:YYYY for annual data (e.g., "2019")
YYYY-S[1-2] for semi-annual data (e.g., "2019-S1")
YYYY-Q[1-4] for quarterly data (e.g., "2019-Q1")
YYYY-MM for monthly data (e.g., "2019-01")
YYYY-W[01-53] for weekly data (e.g., "2019-W01")
YYYY-MM-DD for daily and business data (e.g., "2019-01-01") If
NULL, no start date restriction is applied (data retrieved from the earliest available date). DefaultNULL.
- end_period
(
character(1)) end date of the data, in the same format as start_period. IfNULL, no end date restriction is applied (data retrieved up to the most recent available date). DefaultNULL.- first_n
(
numeric(1)) number of observations to retrieve from the start of the series. IfNULL, no restriction is applied. DefaultNULL.- last_n
(
numeric(1)) number of observations to retrieve from the end of the series. IfNULL, no restriction is applied. DefaultNULL.
See also
Other data:
bbk_data(),
bbk_series(),
snb_data()
Examples
# \donttest{
# fetch US dollar/Euro exchange rate
ecb_data("EXR", "D.USD.EUR.SP00.A")
#> date key value title
#> <Date> <char> <num> <char>
#> 1: 1999-01-04 D.USD.EUR.SP00.A 1.1789 Euro/US dollar
#> 2: 1999-01-05 D.USD.EUR.SP00.A 1.1790 Euro/US dollar
#> 3: 1999-01-06 D.USD.EUR.SP00.A 1.1743 Euro/US dollar
#> 4: 1999-01-07 D.USD.EUR.SP00.A 1.1632 Euro/US dollar
#> 5: 1999-01-08 D.USD.EUR.SP00.A 1.1659 Euro/US dollar
#> ---
#> 6794: 2025-04-15 D.USD.EUR.SP00.A 1.1324 Euro/US dollar
#> 6795: 2025-04-16 D.USD.EUR.SP00.A 1.1355 Euro/US dollar
#> 6796: 2025-04-17 D.USD.EUR.SP00.A 1.1360 Euro/US dollar
#> 6797: 2025-04-22 D.USD.EUR.SP00.A 1.1476 Euro/US dollar
#> 6798: 2025-04-23 D.USD.EUR.SP00.A 1.1415 Euro/US dollar
#> description freq
#> <char> <char>
#> 1: ECB reference exchange rate, Euro/US dollar, 2:15 pm (C.E.T.) daily
#> 2: ECB reference exchange rate, Euro/US dollar, 2:15 pm (C.E.T.) daily
#> 3: ECB reference exchange rate, Euro/US dollar, 2:15 pm (C.E.T.) daily
#> 4: ECB reference exchange rate, Euro/US dollar, 2:15 pm (C.E.T.) daily
#> 5: ECB reference exchange rate, Euro/US dollar, 2:15 pm (C.E.T.) daily
#> ---
#> 6794: ECB reference exchange rate, Euro/US dollar, 2:15 pm (C.E.T.) daily
#> 6795: ECB reference exchange rate, Euro/US dollar, 2:15 pm (C.E.T.) daily
#> 6796: ECB reference exchange rate, Euro/US dollar, 2:15 pm (C.E.T.) daily
#> 6797: ECB reference exchange rate, Euro/US dollar, 2:15 pm (C.E.T.) daily
#> 6798: ECB reference exchange rate, Euro/US dollar, 2:15 pm (C.E.T.) daily
#> currency currency_denom exr_type exr_suffix source_agency collection
#> <char> <char> <char> <char> <char> <char>
#> 1: USD EUR SP00 A 4F0 A
#> 2: USD EUR SP00 A 4F0 A
#> 3: USD EUR SP00 A 4F0 A
#> 4: USD EUR SP00 A 4F0 A
#> 5: USD EUR SP00 A 4F0 A
#> ---
#> 6794: USD EUR SP00 A 4F0 A
#> 6795: USD EUR SP00 A 4F0 A
#> 6796: USD EUR SP00 A 4F0 A
#> 6797: USD EUR SP00 A 4F0 A
#> 6798: USD EUR SP00 A 4F0 A
#> unit_mult decimals unit time_format
#> <char> <char> <char> <char>
#> 1: 0 4 USD P1D
#> 2: 0 4 USD P1D
#> 3: 0 4 USD P1D
#> 4: 0 4 USD P1D
#> 5: 0 4 USD P1D
#> ---
#> 6794: 0 4 USD P1D
#> 6795: 0 4 USD P1D
#> 6796: 0 4 USD P1D
#> 6797: 0 4 USD P1D
#> 6798: 0 4 USD P1D
# fetch data for multiple keys
ecb_data("EXR", c("D.USD", "JPY.EUR.SP00.A"))
#> date key value title
#> <Date> <char> <num> <char>
#> 1: 1999-01-04 D.JPY.EUR.SP00.A 133.7300 Euro/Japanese yen
#> 2: 1999-01-05 D.JPY.EUR.SP00.A 130.9600 Euro/Japanese yen
#> 3: 1999-01-06 D.JPY.EUR.SP00.A 131.4200 Euro/Japanese yen
#> 4: 1999-01-07 D.JPY.EUR.SP00.A 129.4300 Euro/Japanese yen
#> 5: 1999-01-08 D.JPY.EUR.SP00.A 130.0900 Euro/Japanese yen
#> ---
#> 13592: 2025-04-15 D.USD.EUR.SP00.A 1.1324 Euro/US dollar
#> 13593: 2025-04-16 D.USD.EUR.SP00.A 1.1355 Euro/US dollar
#> 13594: 2025-04-17 D.USD.EUR.SP00.A 1.1360 Euro/US dollar
#> 13595: 2025-04-22 D.USD.EUR.SP00.A 1.1476 Euro/US dollar
#> 13596: 2025-04-23 D.USD.EUR.SP00.A 1.1415 Euro/US dollar
#> description freq
#> <char> <char>
#> 1: ECB reference exchange rate, Euro/Japanese yen, 2:15 pm (C.E.T.) daily
#> 2: ECB reference exchange rate, Euro/Japanese yen, 2:15 pm (C.E.T.) daily
#> 3: ECB reference exchange rate, Euro/Japanese yen, 2:15 pm (C.E.T.) daily
#> 4: ECB reference exchange rate, Euro/Japanese yen, 2:15 pm (C.E.T.) daily
#> 5: ECB reference exchange rate, Euro/Japanese yen, 2:15 pm (C.E.T.) daily
#> ---
#> 13592: ECB reference exchange rate, Euro/US dollar, 2:15 pm (C.E.T.) daily
#> 13593: ECB reference exchange rate, Euro/US dollar, 2:15 pm (C.E.T.) daily
#> 13594: ECB reference exchange rate, Euro/US dollar, 2:15 pm (C.E.T.) daily
#> 13595: ECB reference exchange rate, Euro/US dollar, 2:15 pm (C.E.T.) daily
#> 13596: ECB reference exchange rate, Euro/US dollar, 2:15 pm (C.E.T.) daily
#> currency currency_denom exr_type exr_suffix time_format unit
#> <char> <char> <char> <char> <char> <char>
#> 1: JPY EUR SP00 A P1D JPY
#> 2: JPY EUR SP00 A P1D JPY
#> 3: JPY EUR SP00 A P1D JPY
#> 4: JPY EUR SP00 A P1D JPY
#> 5: JPY EUR SP00 A P1D JPY
#> ---
#> 13592: USD EUR SP00 A P1D USD
#> 13593: USD EUR SP00 A P1D USD
#> 13594: USD EUR SP00 A P1D USD
#> 13595: USD EUR SP00 A P1D USD
#> 13596: USD EUR SP00 A P1D USD
#> source_agency collection decimals unit_mult
#> <char> <char> <char> <char>
#> 1: 4F0 A 2 0
#> 2: 4F0 A 2 0
#> 3: 4F0 A 2 0
#> 4: 4F0 A 2 0
#> 5: 4F0 A 2 0
#> ---
#> 13592: 4F0 A 4 0
#> 13593: 4F0 A 4 0
#> 13594: 4F0 A 4 0
#> 13595: 4F0 A 4 0
#> 13596: 4F0 A 4 0
# }