Financial transactions - nasa_10_f_tr

Data - Eurostat

Info

Last observation: Annual: 2025 (N = 326,287)

First observation: Annual: 1990 (N = 6,900)

Last data update: 13 aoû 2026, 01:50. Last compile: 13 aoû 2026, 04:53

Structure

Net Acquisition of Loans (F4), Total Economy

France, Germany, Italy, Spain

Code
nasa_10_f_tr |>
  filter(geo %in% c("FR", "DE", "IT", "ES"),
         sector == "S1",
         finpos == "ASS",
         unit == "PC_GDP",
         na_item == "F4") |>
  year_to_date() |>
  left_join(colors, by = c("Geo" = "country")) |>
  mutate(values = values/100) |>
  ggplot() + geom_line(aes(x = date, y = values, color = color)) +
  theme_minimal() + scale_color_identity() + add_flags +
  scale_x_date(breaks = as.Date(paste0(seq(1990, 2100, 5), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("Net acquisition of loans (% of GDP)") +
  scale_y_continuous(labels = scales::percent_format(accuracy = 1)) +
  geom_hline(yintercept = 0, linetype = "dashed", color = "black")

France: Financial Transactions by Instrument, Total Economy

Currency & Deposits, Debt Securities, Loans, Equity

Code
nasa_10_f_tr |>
  filter(geo == "FR",
         sector == "S1",
         finpos == "ASS",
         unit == "PC_GDP",
         na_item %in% c("F2", "F3", "F4", "F5")) |>
  year_to_date() |>
  mutate(values = values/100) |>
  ggplot() + geom_line(aes(x = date, y = values, color = Na_item)) +
  theme_minimal() +
  scale_x_date(breaks = as.Date(paste0(seq(1990, 2100, 5), "-01-01")),
               labels = date_format("%Y")) +
  theme(legend.position = "right", legend.title = element_blank()) +
  xlab("") + ylab("Net acquisition of financial assets (% of GDP)") +
  scale_y_continuous(labels = scales::percent_format(accuracy = 1)) +
  geom_hline(yintercept = 0, linetype = "dashed", color = "black")

Latest Year by Instrument and Country

Code
latest_y <- nasa_10_f_tr |>
  filter(geo %in% c("FR", "DE", "IT", "ES"),
         sector == "S1",
         finpos == "ASS",
         unit == "PC_GDP",
         na_item == "F4",
         co_nco == "CO",
         !is.na(values)) |>
  summarise(m = max(time)) |>
  pull(m)

nasa_10_f_tr |>
  filter(geo %in% c("FR", "DE", "IT", "ES"),
         sector == "S1",
         finpos == "ASS",
         unit == "PC_GDP",
         na_item %in% c("F2", "F3", "F4", "F5", "F6"),
         co_nco == "CO",
         time == latest_y) |>
  mutate(values = values/100) |>
  select(Na_item, Geo, values) |>
  spread(Geo, values) |>
  print_table_conditional()
Na_item France Germany Italy Spain
Currency and deposits 0.068 0.059 0.032 0.046
Debt securities 0.077 0.039 0.037 0.057
Equity and investment fund shares 0.052 0.049 0.028 0.050
Insurance, pensions and standardised guarantees 0.004 0.000 0.000 0.001
Loans 0.036 0.028 0.006 0.017

na_item

Code
na_item <- read_parquet("na_item.parquet")
nasa_10_f_tr |>
  
  group_by(na_item, Na_item) |>
  summarise(Nobs = n()) |>
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}