Business surveys - NACE Rev. 2 activity - Retail sale - monthly data - ei_bsrt_m_r2

Data - Eurostat

Structure

Retail Confidence Indicator

France, Germany, Italy, Spain

Code
ei_bsrt_m_r2 |>
  filter(geo %in% c("FR", "DE", "IT", "ES"),
         indic == "BS-RCI",
         s_adj == "SA") |>
  month_to_date() |>
  add_flag_color("Geo") |>
  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(1980, 2100, 5), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("Retail confidence indicator (balance, SA)") +
  geom_hline(yintercept = 0, linetype = "dashed", color = "black")

France: Retail Business Survey

Key Indicators

Code
ei_bsrt_m_r2 |>
  filter(geo == "FR",
         indic %in% c("BS-RCI", "BS-REBS", "BS-ROP", "BS-REM"),
         s_adj == "SA") |>
  month_to_date() |>
  ggplot() + geom_line(aes(x = date, y = values, color = Indic)) +
  theme_minimal() +
  scale_x_date(breaks = as.Date(paste0(seq(1980, 2100, 5), "-01-01")),
               labels = date_format("%Y")) +
  theme(legend.position = "right", legend.title = element_blank()) +
  xlab("") + ylab("Balance (SA)") +
  geom_hline(yintercept = 0, linetype = "dashed", color = "black")

Latest Month: Retail Confidence Indicator

Code
latest_m <- ei_bsrt_m_r2 |>
  filter(indic == "BS-RCI",
         s_adj == "SA",
         !is.na(values)) |>
  summarise(m = max(time)) |>
  pull(m)

ei_bsrt_m_r2 |>
  filter(indic == "BS-RCI",
         s_adj == "SA",
         time == latest_m) |>
  select(Geo, values) |>
  arrange(-values) |>
  print_table_conditional()
Geo values
Sweden 26.6
Denmark 20.2
Greece 20.0
Czechia 18.8
Slovenia 14.4
Türkiye 13.9
North Macedonia 13.2
Albania 12.8
Finland 11.8
Italy 11.8
Ireland 11.1
Bulgaria 8.9
Serbia 8.4
Slovakia 6.0
Croatia 5.8
Lithuania 4.4
Portugal 3.9
Netherlands 3.6
Romania 2.7
Latvia 2.5
Montenegro 1.8
Poland -1.3
European Union - 27 countries (from 2020) -4.0
Belgium -4.4
Austria -4.8
Cyprus -5.3
Euro area – 21 countries (from 2026) -6.4
France -11.9
Hungary -13.8
Germany -24.9