Skip to contents

Retrieve time series data from the Bank of Japan Statistics API.

Usage

boj_data(db, code, start_date = NULL, end_date = NULL, lang = "en")

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. Use boj_metadata() to find available codes.

start_date

(NULL | character(1) | integer(1))
Start date of the data. Format depends on frequency: "YYYYMMDD" or YYYY for daily, "YYYYMM" for monthly, "YYYYQQ" for quarterly (where QQ is 01-04), "YYYY" for annual. If NULL, all available data is returned. Default NULL.

end_date

(NULL | character(1) | integer(1))
End date of the data, in the same format as start_date. If NULL, data up to the latest available date is returned. Default NULL.

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
# }