Last observation: Q: 2014-Q1 (N = 228) · A: 2014 (N = 31)
First observation: Q: 1989-Q4 (N = 24) · A: 1995 (N = 836)
Last data update: 02 aoû 2026, 08:56. Last compile: 17 aoû 2026, 21:52
Households’ financial and non-financial assets and liabilities - 7HA_A_Q
Data - OECD
Info
Structure
Pension plans managed by autonomous pension funds (Germany)
Code
`7HA_A_Q` |>
# AF6121: Pension plans managed by autonomous pension funds
# AF6122: Pension plans managed by non-autonomous pension funds
# AF6123: Insured pension plans
# AF6124: Other pension plans and unfunded pension plans
filter(TRANSACT %in% c("AF6121", "AF6122", "AF6123", "AF6124", "AF612"),
LOCATION == "DEU",
MEASURE == "C") |>
year_to_enddate() |>
left_join(`7HA_A_Q_var`$TRANSACT |>
setNames(c("TRANSACT", "Transact")), by = "TRANSACT") |>
ggplot() + xlab("") + ylab("Euros Managed") + theme_minimal() +
geom_line(aes(x = date, y = obsValue/1000, color = Transact, linetype = Transact)) +
scale_color_manual(values = viridis(4)[1:3]) +
scale_x_date(breaks = as.Date(paste0(seq(1960, 2020, 1), "-01-01")),
labels = date_format("%Y")) +
theme(legend.position = c(0.45, 0.9),
legend.title = element_blank()) +
scale_y_continuous(breaks = seq(0, 4000, 50),
labels = dollar_format(suffix = " Bn€", prefix = "", accuracy = 1))
Net equity of households in pension funds
Code
`7HA_A_Q` |>
filter(TRANSACT %in% c("AF612"),
LOCATION %in% c("DEU", "FRA"),
MEASURE == "C") |>
year_to_date() |>
left_join(`7HA_A_Q_var`$LOCATION, by = "LOCATION") |>
mutate(obsValue = obsValue / 1000) |>
left_join(colors, by = c("Location" = "country")) |>
ggplot() + theme_minimal() + xlab("") + ylab("") +
geom_line(aes(x = date, y = obsValue, color = color)) +
scale_color_identity() + add_2flags +
scale_x_date(breaks = as.Date(paste0(seq(1960, 2020, 1), "-01-01")),
labels = date_format("%Y")) +
theme(legend.position = c(0.45, 0.9),
legend.title = element_blank()) +
scale_y_continuous(breaks = seq(0, 20000, 100),
labels = dollar_format(suffix = " Bn€", prefix = "", accuracy = 1))