Retrieve time series data from the ECB SDMX Web Service.
Usage
ecb_data(
flow,
key = NULL,
start_period = NULL,
end_period = NULL,
first_n = NULL,
last_n = NULL,
updated_after = NULL
)Arguments
- flow
(
character(1))
Flow to query.- key
(
NULL|character())
The series keys to query.- start_period
(
NULL|character(1)|integer(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
(
NULL|character(1)|integer(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
(
NULL|numeric(1))
Number of observations to retrieve from the start of the series. IfNULL, no restriction is applied. DefaultNULL.- last_n
(
NULL|numeric(1))
Number of observations to retrieve from the end of the series. IfNULL, no restriction is applied. DefaultNULL.- updated_after
(
NULL|character(1)|Date(1)|POSIXct(1))
Retrieve only observations updated after the given timestamp (e.g.,"2024-06-01T00:00:00"). Useful for incremental retrieval. IfNULL, no restriction is applied. DefaultNULL.
Value
A data.table::data.table() with the requested data.
See also
Other data:
banxico_data(),
bbk_data(),
bbk_series(),
bcb_data(),
bcb_expectations(),
bcb_fx_rates(),
bcb_inflation(),
bcb_selic(),
bcb_top5(),
bde_data(),
bde_latest(),
bdf_codelist(),
bdf_data(),
bdf_dataset(),
bdp_data(),
bis_data(),
boc_data(),
boe_data(),
boi_data(),
boj_data(),
cnb_czeonia(),
cnb_data(),
cnb_fx_other_rates(),
cnb_fx_rates(),
cnb_pribor(),
nbp_fx_rates(),
nbp_gold(),
nob_data(),
onb_data(),
snb_data(),
srb_cross_rates(),
srb_data()
Examples
# \donttest{
# fetch US dollar/Euro exchange rate
ecb_data("EXR", "D.USD.EUR.SP00.A")
#> date key value freq
#> <Date> <char> <num> <char>
#> 1: 1999-01-04 D.USD.EUR.SP00.A 1.1789 daily
#> 2: 1999-01-05 D.USD.EUR.SP00.A 1.1790 daily
#> 3: 1999-01-06 D.USD.EUR.SP00.A 1.1743 daily
#> 4: 1999-01-07 D.USD.EUR.SP00.A 1.1632 daily
#> 5: 1999-01-08 D.USD.EUR.SP00.A 1.1659 daily
#> ---
#> 7149: 2026-09-07 D.USD.EUR.SP00.A 1.1622 daily
#> 7150: 2026-09-08 D.USD.EUR.SP00.A 1.1614 daily
#> 7151: 2026-09-09 D.USD.EUR.SP00.A 1.1652 daily
#> 7152: 2026-09-10 D.USD.EUR.SP00.A 1.1616 daily
#> 7153: 2026-09-11 D.USD.EUR.SP00.A 1.1592 daily
#> title
#> <char>
#> 1: US dollar/Euro ECB reference exchange rate
#> 2: US dollar/Euro ECB reference exchange rate
#> 3: US dollar/Euro ECB reference exchange rate
#> 4: US dollar/Euro ECB reference exchange rate
#> 5: US dollar/Euro ECB reference exchange rate
#> ---
#> 7149: US dollar/Euro ECB reference exchange rate
#> 7150: US dollar/Euro ECB reference exchange rate
#> 7151: US dollar/Euro ECB reference exchange rate
#> 7152: US dollar/Euro ECB reference exchange rate
#> 7153: US dollar/Euro ECB reference exchange rate
#> description currency
#> <char> <char>
#> 1: ECB reference exchange rate, US dollar/Euro, 2.15 pm (C.E.T.) USD
#> 2: ECB reference exchange rate, US dollar/Euro, 2.15 pm (C.E.T.) USD
#> 3: ECB reference exchange rate, US dollar/Euro, 2.15 pm (C.E.T.) USD
#> 4: ECB reference exchange rate, US dollar/Euro, 2.15 pm (C.E.T.) USD
#> 5: ECB reference exchange rate, US dollar/Euro, 2.15 pm (C.E.T.) USD
#> ---
#> 7149: ECB reference exchange rate, US dollar/Euro, 2.15 pm (C.E.T.) USD
#> 7150: ECB reference exchange rate, US dollar/Euro, 2.15 pm (C.E.T.) USD
#> 7151: ECB reference exchange rate, US dollar/Euro, 2.15 pm (C.E.T.) USD
#> 7152: ECB reference exchange rate, US dollar/Euro, 2.15 pm (C.E.T.) USD
#> 7153: ECB reference exchange rate, US dollar/Euro, 2.15 pm (C.E.T.) USD
#> currency_denom exr_type exr_suffix unit_index_base unit decimals
#> <char> <char> <char> <char> <char> <char>
#> 1: EUR SP00 A 99Q1=100 USD 4
#> 2: EUR SP00 A 99Q1=100 USD 4
#> 3: EUR SP00 A 99Q1=100 USD 4
#> 4: EUR SP00 A 99Q1=100 USD 4
#> 5: EUR SP00 A 99Q1=100 USD 4
#> ---
#> 7149: EUR SP00 A 99Q1=100 USD 4
#> 7150: EUR SP00 A 99Q1=100 USD 4
#> 7151: EUR SP00 A 99Q1=100 USD 4
#> 7152: EUR SP00 A 99Q1=100 USD 4
#> 7153: EUR SP00 A 99Q1=100 USD 4
#> source_agency time_format unit_mult collection
#> <char> <char> <char> <char>
#> 1: 4F0 P1D 0 A
#> 2: 4F0 P1D 0 A
#> 3: 4F0 P1D 0 A
#> 4: 4F0 P1D 0 A
#> 5: 4F0 P1D 0 A
#> ---
#> 7149: 4F0 P1D 0 A
#> 7150: 4F0 P1D 0 A
#> 7151: 4F0 P1D 0 A
#> 7152: 4F0 P1D 0 A
#> 7153: 4F0 P1D 0 A
# fetch data for multiple keys
ecb_data("EXR", c("D.USD", "JPY.EUR.SP00.A"))
#> date key value freq
#> <Date> <char> <num> <char>
#> 1: 1999-01-04 D.JPY.EUR.SP00.A 133.7300 daily
#> 2: 1999-01-05 D.JPY.EUR.SP00.A 130.9600 daily
#> 3: 1999-01-06 D.JPY.EUR.SP00.A 131.4200 daily
#> 4: 1999-01-07 D.JPY.EUR.SP00.A 129.4300 daily
#> 5: 1999-01-08 D.JPY.EUR.SP00.A 130.0900 daily
#> ---
#> 14302: 2026-09-07 D.USD.EUR.SP00.A 1.1622 daily
#> 14303: 2026-09-08 D.USD.EUR.SP00.A 1.1614 daily
#> 14304: 2026-09-09 D.USD.EUR.SP00.A 1.1652 daily
#> 14305: 2026-09-10 D.USD.EUR.SP00.A 1.1616 daily
#> 14306: 2026-09-11 D.USD.EUR.SP00.A 1.1592 daily
#> title
#> <char>
#> 1: Japanese yen/Euro ECB reference exchange rate
#> 2: Japanese yen/Euro ECB reference exchange rate
#> 3: Japanese yen/Euro ECB reference exchange rate
#> 4: Japanese yen/Euro ECB reference exchange rate
#> 5: Japanese yen/Euro ECB reference exchange rate
#> ---
#> 14302: US dollar/Euro ECB reference exchange rate
#> 14303: US dollar/Euro ECB reference exchange rate
#> 14304: US dollar/Euro ECB reference exchange rate
#> 14305: US dollar/Euro ECB reference exchange rate
#> 14306: US dollar/Euro ECB reference exchange rate
#> description
#> <char>
#> 1: ECB reference exchange rate, Japanese yen/Euro, 2.15 pm (C.E.T.)
#> 2: ECB reference exchange rate, Japanese yen/Euro, 2.15 pm (C.E.T.)
#> 3: ECB reference exchange rate, Japanese yen/Euro, 2.15 pm (C.E.T.)
#> 4: ECB reference exchange rate, Japanese yen/Euro, 2.15 pm (C.E.T.)
#> 5: ECB reference exchange rate, Japanese yen/Euro, 2.15 pm (C.E.T.)
#> ---
#> 14302: ECB reference exchange rate, US dollar/Euro, 2.15 pm (C.E.T.)
#> 14303: ECB reference exchange rate, US dollar/Euro, 2.15 pm (C.E.T.)
#> 14304: ECB reference exchange rate, US dollar/Euro, 2.15 pm (C.E.T.)
#> 14305: ECB reference exchange rate, US dollar/Euro, 2.15 pm (C.E.T.)
#> 14306: ECB reference exchange rate, US dollar/Euro, 2.15 pm (C.E.T.)
#> currency currency_denom exr_type exr_suffix unit_index_base
#> <char> <char> <char> <char> <char>
#> 1: JPY EUR SP00 A 99Q1=100
#> 2: JPY EUR SP00 A 99Q1=100
#> 3: JPY EUR SP00 A 99Q1=100
#> 4: JPY EUR SP00 A 99Q1=100
#> 5: JPY EUR SP00 A 99Q1=100
#> ---
#> 14302: USD EUR SP00 A 99Q1=100
#> 14303: USD EUR SP00 A 99Q1=100
#> 14304: USD EUR SP00 A 99Q1=100
#> 14305: USD EUR SP00 A 99Q1=100
#> 14306: USD EUR SP00 A 99Q1=100
#> source_agency time_format unit_mult decimals collection unit
#> <char> <char> <char> <char> <char> <char>
#> 1: 4F0 P1D 0 2 A JPY
#> 2: 4F0 P1D 0 2 A JPY
#> 3: 4F0 P1D 0 2 A JPY
#> 4: 4F0 P1D 0 2 A JPY
#> 5: 4F0 P1D 0 2 A JPY
#> ---
#> 14302: 4F0 P1D 0 4 A USD
#> 14303: 4F0 P1D 0 4 A USD
#> 14304: 4F0 P1D 0 4 A USD
#> 14305: 4F0 P1D 0 4 A USD
#> 14306: 4F0 P1D 0 4 A USD
# }