# Load packages

# Core
library(tidyverse)
library(tidyquant)
library(timetk)

Goal

Visualize and compare skewness of your portfolio and its assets.

Choose your stocks.

from 2012-12-31 to 2017-12-31

1 Import stock prices

symbols <- c("META", "TSLA", "NKE", "VOO")

prices <- tq_get(x    = symbols,
                 get  = "stock.prices",
                 from = "2012-12-31",
                 to   = "2017-12-31")

2 Convert prices to returns (monthly)

asset_returns_tbl <- prices %>%
    
    group_by(symbol) %>%
    
        tq_transmute(select     = adjusted,
                     mutate_fun = periodReturn,
                     period     ="monthly",
                     type       ="log") %>%
    
    slice(-1) %>%

    ungroup() %>%

set_names(c("asset", "date", "return"))

3 Assign a weight to each asset (change the weigting scheme)

# symbols
symbols <- asset_returns_tbl %>% distinct(asset) %>% pull()
symbols
## [1] "META" "NKE"  "TSLA" "VOO"
# weights
weights <- c(0.25, 0.25, 0.2, 0.2)
weights
## [1] 0.25 0.25 0.20 0.20
w_tbl <- tibble(symbols, weights)
w_tbl
## # A tibble: 4 × 2
##   symbols weights
##   <chr>     <dbl>
## 1 META       0.25
## 2 NKE        0.25
## 3 TSLA       0.2 
## 4 VOO        0.2

4 Build a portfolio

# ?tq_portfolio

portfolio_returns_tbl <- asset_returns_tbl %>%
    
    tq_portfolio(assets_col = asset, 
                returns_col = return, 
                weights     = w_tbl,
                rebalance_on = "months",
                col_rename  = "returns")

portfolio_returns_tbl
## # A tibble: 60 × 2
##    date       returns
##    <date>       <dbl>
##  1 2013-01-31  0.0800
##  2 2013-02-28 -0.0414
##  3 2013-03-28  0.0282
##  4 2013-04-30  0.114 
##  5 2013-05-31  0.0836
##  6 2013-06-28  0.0291
##  7 2013-07-31  0.150 
##  8 2013-08-30  0.0689
##  9 2013-09-30  0.119 
## 10 2013-10-31 -0.0188
## # ℹ 50 more rows

5 Compute Skewness

# Compute Skewness for the Portfolio
portfolio_skew_tbl <- portfolio_returns_tbl %>%
    tq_performance(Ra = returns, 
                   performance_fun = table.Stats) %>%
    select(Skewness)

portfolio_skew_tbl
## # A tibble: 1 × 1
##   Skewness
##      <dbl>
## 1    0.484

6 Plot: Skewness Comparison

# Calculate Rolling 24-Month Skewness
library(tibbletime)

window <- 24
skew_roll_24 <- tibbletime::rollify(skewness, window = window)

rolling_skewness_tbl <- portfolio_returns_tbl %>%
  mutate(rolling_skewness = skew_roll_24(returns)) %>%
  slice(-1:-(window - 1))

# Plot Rolling 24-Month Skewness
rolling_skewness_tbl %>%
  ggplot(aes(x = date, y = rolling_skewness)) +
  geom_line(color = "cornflowerblue", linewidth = 1) +
  geom_hline(yintercept = 0, linetype = "dotted", linewidth = 1.5) +
  annotate(
    geom = "text",
    x = as.Date("2016-07-01"),
    y = 0.8,
    color = "red",
    size = 4,
    label = "The 24-month rolling skewness is positive for about half of the life time,\neven though the overall skewness is negative"
  ) +
  labs(
    y = "Skewness",
    x = NULL,
    title = "Rolling 24-Month Skewness"
  ) +
  theme_minimal() +
  theme(plot.title = element_text(hjust = 0.5))

Is any asset in your portfolio more likely to return extreme positive returns than your portfolio collectively? Discuss in terms of skewness. You may also refer to the distribution of returns you plotted in Code along 4.
Based on the rolling 24-month skewness plot, the portfolio’s return distribution fluctuates over time, showing that the 24-month rolling skewness is positive for about half of its lifetime despite its overall negative skewness. This indicates that while the portfolio experiences periods of elevated asymmetry and negative tail risk, it also undergoes extended phases where positive returns are more frequent and dominant over rolling two-year windows.