Exchange-traded derivatives statistics - XTD

Data - BIS

load_data("bis/XTD.RData")

iso3c, iso2c, Borrowers’ country

XTD %>%
  arrange(iso3c, date) %>%
  group_by(iso3c, iso2c, `Location of trade (Exchange or country)`) %>%
  summarise(Nobs = n(),
            start = first(date),
            end = last(date)) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

FREQ, Frequency

XTD %>%
  group_by(FREQ, Frequency) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}

FREQ	Frequency	Nobs
M	Monthly	104976
Q	Quarterly	69984
A	Annual	14580

OD_TYPE, Measure

XTD %>%
  group_by(OD_TYPE, `Measure`) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}

OD_TYPE	Measure	Nobs
U	Turnover - notional amounts (daily average)	154548
A	Notional amounts outstanding	34992