Retrieve time series data from the Bank of Japan Statistics API.
Arguments
- db
(
character(1))
The database code to query (e.g.,"FM08"for foreign exchange rates). See the API manual for available databases.- code
(
character())
One or more series codes to query (e.g.,"FXERD01"for USD/JPY spot rate). Maximum 250 codes per request. All codes must have the same frequency. Useboj_metadata()to find available codes.- start_date
(
NULL|character(1)|integer(1))
Start date of the data. Format depends on frequency:"YYYYMMDD"orYYYYfor daily,"YYYYMM"for monthly,"YYYYQQ"for quarterly (where QQ is 01-04),"YYYY"for annual. IfNULL, all available data is returned. DefaultNULL.- end_date
(
NULL|character(1)|integer(1))
End date of the data, in the same format as start_date. IfNULL, data up to the latest available date is returned. DefaultNULL.- lang
(
character(1))
Language for series names, either"en"or"jp". Default"en".
Value
A data.table::data.table() with the requested data.
Examples
# \donttest{
# fetch USD/JPY exchange rate
boj_data("FM08", "FXERD01", start_date = "202401")
#> date key value freq
#> <Date> <char> <num> <char>
#> 1: 2024-01-04 FXERD01 142.98 daily
#> 2: 2024-01-05 FXERD01 144.77 daily
#> 3: 2024-01-09 FXERD01 144.22 daily
#> 4: 2024-01-10 FXERD01 144.43 daily
#> 5: 2024-01-11 FXERD01 145.73 daily
#> ---
#> 574: 2026-05-14 FXERD01 157.86 daily
#> 575: 2026-05-15 FXERD01 158.39 daily
#> 576: 2026-05-18 FXERD01 158.85 daily
#> 577: 2026-05-19 FXERD01 158.88 daily
#> 578: 2026-05-20 FXERD01 159.05 daily
#> name unit
#> <char> <char>
#> 1: US.Dollar/Yen Spot Rate at 9:00 in JST, Tokyo Market Yen per U.S. Dollar
#> 2: US.Dollar/Yen Spot Rate at 9:00 in JST, Tokyo Market Yen per U.S. Dollar
#> 3: US.Dollar/Yen Spot Rate at 9:00 in JST, Tokyo Market Yen per U.S. Dollar
#> 4: US.Dollar/Yen Spot Rate at 9:00 in JST, Tokyo Market Yen per U.S. Dollar
#> 5: US.Dollar/Yen Spot Rate at 9:00 in JST, Tokyo Market Yen per U.S. Dollar
#> ---
#> 574: US.Dollar/Yen Spot Rate at 9:00 in JST, Tokyo Market Yen per U.S. Dollar
#> 575: US.Dollar/Yen Spot Rate at 9:00 in JST, Tokyo Market Yen per U.S. Dollar
#> 576: US.Dollar/Yen Spot Rate at 9:00 in JST, Tokyo Market Yen per U.S. Dollar
#> 577: US.Dollar/Yen Spot Rate at 9:00 in JST, Tokyo Market Yen per U.S. Dollar
#> 578: US.Dollar/Yen Spot Rate at 9:00 in JST, Tokyo Market Yen per U.S. Dollar
# fetch multiple exchange rates
boj_data("FM08", c("FXERD01", "FXERD02"), start_date = "202401")
#> date key value freq
#> <Date> <char> <num> <char>
#> 1: 2024-01-04 FXERD01 142.98 daily
#> 2: 2024-01-05 FXERD01 144.77 daily
#> 3: 2024-01-09 FXERD01 144.22 daily
#> 4: 2024-01-10 FXERD01 144.43 daily
#> 5: 2024-01-11 FXERD01 145.73 daily
#> ---
#> 1152: 2026-05-14 FXERD02 157.99 daily
#> 1153: 2026-05-15 FXERD02 158.66 daily
#> 1154: 2026-05-18 FXERD02 159.08 daily
#> 1155: 2026-05-19 FXERD02 159.13 daily
#> 1156: 2026-05-20 FXERD02 159.09 daily
#> name unit
#> <char> <char>
#> 1: US.Dollar/Yen Spot Rate at 9:00 in JST, Tokyo Market Yen per U.S. Dollar
#> 2: US.Dollar/Yen Spot Rate at 9:00 in JST, Tokyo Market Yen per U.S. Dollar
#> 3: US.Dollar/Yen Spot Rate at 9:00 in JST, Tokyo Market Yen per U.S. Dollar
#> 4: US.Dollar/Yen Spot Rate at 9:00 in JST, Tokyo Market Yen per U.S. Dollar
#> 5: US.Dollar/Yen Spot Rate at 9:00 in JST, Tokyo Market Yen per U.S. Dollar
#> ---
#> 1152: US.Dollar/Yen Highest, Tokyo Market Yen per U.S. Dollar
#> 1153: US.Dollar/Yen Highest, Tokyo Market Yen per U.S. Dollar
#> 1154: US.Dollar/Yen Highest, Tokyo Market Yen per U.S. Dollar
#> 1155: US.Dollar/Yen Highest, Tokyo Market Yen per U.S. Dollar
#> 1156: US.Dollar/Yen Highest, Tokyo Market Yen per U.S. Dollar
# }