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
#> ---
#> 540: 2026-03-23 FXERD01 159.15 daily
#> 541: 2026-03-24 FXERD01 158.49 daily
#> 542: 2026-03-25 FXERD01 158.70 daily
#> 543: 2026-03-26 FXERD01 159.40 daily
#> 544: 2026-03-27 FXERD01 159.73 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
#> ---
#> 540: US.Dollar/Yen Spot Rate at 9:00 in JST, Tokyo Market Yen per U.S. Dollar
#> 541: US.Dollar/Yen Spot Rate at 9:00 in JST, Tokyo Market Yen per U.S. Dollar
#> 542: US.Dollar/Yen Spot Rate at 9:00 in JST, Tokyo Market Yen per U.S. Dollar
#> 543: US.Dollar/Yen Spot Rate at 9:00 in JST, Tokyo Market Yen per U.S. Dollar
#> 544: 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
#> ---
#> 1084: 2026-03-23 FXERD02 159.65 daily
#> 1085: 2026-03-24 FXERD02 158.79 daily
#> 1086: 2026-03-25 FXERD02 159.16 daily
#> 1087: 2026-03-26 FXERD02 159.53 daily
#> 1088: 2026-03-27 FXERD02 159.98 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
#> ---
#> 1084: US.Dollar/Yen Highest, Tokyo Market Yen per U.S. Dollar
#> 1085: US.Dollar/Yen Highest, Tokyo Market Yen per U.S. Dollar
#> 1086: US.Dollar/Yen Highest, Tokyo Market Yen per U.S. Dollar
#> 1087: US.Dollar/Yen Highest, Tokyo Market Yen per U.S. Dollar
#> 1088: US.Dollar/Yen Highest, Tokyo Market Yen per U.S. Dollar
# }