Weathering the Storm

Covid-19 began battering the financial markets in 2020 Which sectors are faring best?

I’ll compare each sector in the S&P 500 with the overall market. Baselining each at 100% as of February 19th, we’ll see which were the first to recover lost ground.

library(tidyverse)
library(wesanderson)
library(kableExtra)
library(scales, exclude = "date_format")
library(glue)
library(tidyquant)
library(clock)

theme_set(theme_bw())

(cols <- wes_palette("Moonrise2"))

symbols <-
  c(
    "SPY",
    "XLV",
    "XLK",
    "XLE",
    "XLF",
    "XLC",
    "XLI",
    "XLY",
    "XLP",
    "XLRE",
    "XLU",
    "XLB"
  )

from <- "2020-02-19"

from_formatted <- date_parse(from, format = "%Y-%m-%d") |> 
  date_format(format = "%b %d, %Y")

Note this patch if having prob lems with tq_get

eod_sectors <-
  tq_get(symbols, from = from) |>
  group_by(symbol) |>
  mutate(
    norm_close = adjusted / first(adjusted),
    type = if_else(symbol == "SPY", "Market", "Sector"),
    sector = case_when(
      symbol == "SPY"  ~ "S&P 500",
      symbol == "XLB"  ~ "Materials",
      symbol == "XLE"  ~ "Energy",
      symbol == "XLU"  ~ "Utilities",
      symbol == "XLI"  ~ "Industrical",
      symbol == "XLRE" ~ "Real Estate",
      symbol == "XLV"  ~ "Health",
      symbol == "XLK"  ~ "Technology",
      symbol == "XLF"  ~ "Financial",
      symbol == "XLC"  ~ "Communication",
      symbol == "XLY"  ~ "Consumer Discretionary",
      symbol == "XLP"  ~ "Consumer Staples",
      TRUE             ~ "Other"
    )
  ) |>
  ungroup() |> 
  drop_na()

Perhaps not too surprising to see that Tech led the way back. Energy has proven the most volatile, falling further and then recovering faster. And Comms, with all that home-working, benefited during the lockdown, but has faded since.

eod_sectors |>
  mutate(
    sector = str_wrap(sector, 12),
    sector = fct_reorder(sector, norm_close, last, .desc = TRUE)
  ) |>
  ggplot(aes(date, norm_close, colour = type)) +
  geom_rect(aes(xmin = min(date), xmax = max(date), ymin = -Inf, ymax = Inf),
    fill = if_else(eod_sectors$type == "Market", cols[1], NULL), colour = "white"
  ) +
  geom_hline(yintercept = 1, linetype = "dashed", colour = "grey80") +
  geom_line(key_glyph = "timeseries") +
  facet_wrap(~sector) +
  scale_colour_manual(values = cols[c(3, 4)]) +
  scale_y_continuous(labels = label_percent()) +
  labs(
    title = "S&P 500 Sector Impact of Covid-19",
    subtitle = glue("Relative to {from_formatted}"),
    x = NULL, y = NULL, colour = NULL
  ) +
  theme(axis.text.x = element_text(angle = 45, hjust = 1))

R Toolbox < svg class="anchor-symbol" aria-hidden="true" height="26" width="26" viewBox="0 0 22 22" xmlns="http://www.w3.org/2000/svg"> < path d="M0 0h24v24H0z" fill="currentColor"> < path d="M3.9 12c0-1.71 1.39-3.1 3.1-3.1h4V7H7c-2.76.0-5 2.24-5 5s2.24 5 5 5h4v-1.9H7c-1.71.0-3.1-1.39-3.1-3.1zM8 13h8v-2H8v2zm9-6h-4v1.9h4c1.71.0 3.1 1.39 3.1 3.1s-1.39 3.1-3.1 3.1h-4V17h4c2.76.0 5-2.24 5-5s-2.24-5-5-5z">

Summarising below the packages and functions used in this post enables me to separately create a toolbox visualisation summarising the usage of packages and functions across all posts.