# Load packages

# Core
library(tidyverse)
library(tidyquant)

Goal

Collect individual returns into a portfolio by assigning a weight to each stock

five stocks: “BAC”, “NOK”, “F”, “T”, “NVDA”

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

1 Import stock prices

symbols <- c("BAC", "NOK", "F", "T", "NVDA")

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

2 Convert prices to returns

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"))

3 Assign a weight to each asset

symbols <- asset_returns_tbl %>% distinct(asset) %>% pull()
symbols
## [1] "BAC"  "F"    "NOK"  "NVDA" "T"
# 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 BAC        0.25
## 2 F          0.25
## 3 NOK        0.2 
## 4 NVDA       0.2 
## 5 T          0.1

4 Build a portfolio

# tq_portfolio

portfolio_returns_tbl <- asset_returns_tbl %>%
    
    tq_portfolio(assets_col = asset,
                 returns_col = returns,
                 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.00116
##  2 2013-02-28 -0.0119 
##  3 2013-03-28  0.0142 
##  4 2013-04-30  0.0369 
##  5 2013-05-31  0.0690 
##  6 2013-06-28 -0.00642
##  7 2013-07-31  0.0723 
##  8 2013-08-30 -0.0197 
##  9 2013-09-30  0.118  
## 10 2013-10-31  0.0435 
## # ℹ 50 more rows

5 Calculate Sharpe Ratio

# Define risk free rate
rfr <- 0.0003

portfolio_SharpeRatio_tbl <- portfolio_returns_tbl %>%
    
    tq_performance (Ra = returns,
                   performance_fun = SharpeRatio, 
                   Rf = rfr,
                   FUN = "StdDev")

portfolio_SharpeRatio_tbl
## # A tibble: 1 × 1
##   `SharpeRatio(Rf=0%,p=95%)`
##                        <dbl>
## 1                      0.379

6 Plot

Rolling Sharpe Ratio

# Create a custom function to calculate rolling SR
Calculate_rolling_SharpeRatio <- function(data) {
    
    rolling_SR <- SharpeRatio(R = data,
                              Rf = rfr,
                              FUN = "StdDev")
    
    return(rolling_SR)
}

# Define window
window <- 24

# Transform data: calculate rolling sharpe data
rolling_sr_tbl <- portfolio_returns_tbl %>%
    
    tq_mutate(select = returns,
              mutate_fun = rollapply,
              width = window,
              FUN = Calculate_rolling_SharpeRatio,
              col_rename = "rolling_sr") %>%

select(-returns) %>%
    na.omit()

rolling_sr_tbl
## # A tibble: 37 × 2
##    date       rolling_sr
##    <date>          <dbl>
##  1 2014-12-31      0.482
##  2 2015-01-30      0.371
##  3 2015-02-27      0.447
##  4 2015-03-31      0.384
##  5 2015-04-30      0.347
##  6 2015-05-29      0.315
##  7 2015-06-30      0.295
##  8 2015-07-31      0.252
##  9 2015-08-31      0.222
## 10 2015-09-30      0.146
## # ℹ 27 more rows
rolling_sr_tbl %>%
    
    ggplot(aes(x = date, y = rolling_sr)) +
    geom_line(color = "cornflowerblue") +
    
    # Labelling
    labs(x = NULL, y = "Rolling Sharpe Ratio") +
    
    annotate(geom = "text",
             x = as.Date("2016-06-01"), y = 0.5,
             label = "This portfolio has done quite well since 2016",
             color = "red", size = 4)

How has your portfolio performed overtime? Provide data of the structural breaks, if any. The code along assignment 9 had 1 structural break in November 2016.What do you think the reason is?

My portfolio performed modestly through 2015 and early 2016, with a low, flat rolling Sharpe ratio, since the 24-month window captured the 2015 selloff and the early 2016 dip. Around November 2016, the rolling Sharpe ratio jumps and stays elevated through 2017, which is the structural break. The most likely reason is the U.S. presidential election and the post-election rally, which lifted Bank of America on expectations of higher rates and deregulation, and also boosted Ford and AT&T, while NVIDIA’s surge added further gains and volatility stayed low.