# Load packages
# Core
library(tidyverse)
library(tidyquant)
Visualize and compare skewness of your portfolio and its assets.
Choose your stocks.
from 2012-12-31 to 2017-12-31
symbols <- c("SOXX", "TKR", "VUG", "AMZN", "GOOG")
prices <- tq_get(x = symbols,
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", "returns"))
# symbols
symbols <- asset_returns_tbl %>% distinct (asset) %>% pull()
symbols
## [1] "AMZN" "GOOG" "SOXX" "TKR" "VUG"
# weights
weights <- c(0.25, 0.25, 0.2, 0.2, 0.1)
weights
## [1] 0.25 0.25 0.20 0.20 0.10
w_tbl <- tibble(symbols, weights)
w_tbl
## # A tibble: 5 × 2
## symbols weights
## <chr> <dbl>
## 1 AMZN 0.25
## 2 GOOG 0.25
## 3 SOXX 0.2
## 4 TKR 0.2
## 5 VUG 0.1
# ?tq_portfolio
portfolio_returns_tbl <- asset_returns_tbl %>%
tq_portfolio(assets_col = asset,
returns_col = returns,
weights = w_tbl,
rebalance_on = "months")
portfolio_returns_tbl
## # A tibble: 60 × 2
## date portfolio.returns
## <date> <dbl>
## 1 2013-01-31 0.0725
## 2 2013-02-28 0.0249
## 3 2013-03-28 0.0163
## 4 2013-04-30 -0.0124
## 5 2013-05-31 0.0574
## 6 2013-06-28 0.00642
## 7 2013-07-31 0.0398
## 8 2013-08-30 -0.0465
## 9 2013-09-30 0.0688
## 10 2013-10-31 0.0626
## # ℹ 50 more rows
portfolio_skew_tidyquant_builtin_percent <- portfolio_returns_tbl %>%
tq_performance(Ra = portfolio.returns,
performance_fun = table.Stats) %>%
select(Skewness)
portfolio_skew_tidyquant_builtin_percent
## # A tibble: 1 × 1
## Skewness
## <dbl>
## 1 0.183
# Data transformation: calculate skewness (named asset_skewness_tbl to match downstream code)
asset_skewness_tbl <- asset_returns_tbl %>%
group_by(asset) %>%
summarise(skew = skewness(returns)) %>%
ungroup() %>%
# Add portfolio skewness using the correct column name: portfolio.returns
add_row(tibble(asset = "Portfolio",
skew = skewness(portfolio_returns_tbl$portfolio.returns)))
asset_skewness_tbl
## # A tibble: 6 × 2
## asset skew
## <chr> <dbl>
## 1 AMZN 0.187
## 2 GOOG 0.784
## 3 SOXX -0.276
## 4 TKR -0.0190
## 5 VUG -0.236
## 6 Portfolio 0.183
# Plot skewness
asset_skewness_tbl %>%
ggplot(aes(x = asset, y = skew, color = asset)) +
geom_point() +
ggrepel::geom_text_repel(aes(label = asset),
data = asset_skewness_tbl %>%
filter(asset == "Portfolio")) +
labs(y = "skewness")
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.
Yes, GOOG is more likely to give big positive returns than the overall portfolio. While the portfolio has a moderate positive skewness near 0.2, GOOG’s skewness is significantly higher than any other asset at over 0.6, making it the most prone to extreme positive upside among all the assets. SOXX, TKR and VUG have a negative skew, which is dragging down the the portfolio’s skew as well.