# Load packages
# Core
library(tidyverse)
library(tidyquant)
library(timetk)
Visualize and compare skewness of your portfolio and its assets.
Choose your stocks.
from 2012-12-31 to 2017-12-31
symbols <- c("META", "TSLA", "NKE", "VOO")
prices <- tq_get(x = symbols,
get = "stock.prices",
from = "2012-12-31",
to = "2017-12-31")
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"))
# 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
# ?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
# 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
# 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.