R/premia.R

In Reckziegel/aqrr: Datasets from the AQR Data Library

#' Premia From a Wide Array of Factors
#'
#' Downloads data with the  self-financing returns of equity, bonds, currencies and
#' commodities.
#'
#' @param .tidy A flag. Should the output be tidy? The default is \code{TRUE}.
#'
#' @return A \code{tibble}.
#' @export
#'
#' @references  Ilmanen, Israel, Lee, Moskowitz & Thapar (2021),
#' “How Do Factor Premia Vary Over Time? A Century of Evidence".
#'
#' @examples
#' if (FALSE) {
#'   aqr_factor_premia_monthly()
#' }
aqr_factor_premia_monthly <- function(.tidy = TRUE) {

  assertthat::assert_that(assertthat::is.flag(.tidy))

  url <- "https://www.aqr.com/-/media/AQR/Documents/Insights/Data-Sets/Century-of-Factor-Premia-Monthly.xlsx"
  destfile <- "Century_of_Factor_Premia_Monthly.xlsx"
  curl::curl_download(url, destfile)

  factor_premia_raw <- suppressMessages(
    readxl::read_excel(
      path      = destfile,
      sheet     = "Century of Factor Premia",
      range     = "A19:AS1183",
      col_types = c("guess", rep("numeric", 44))
    )
  )

  names(factor_premia_raw)[[1]] <- "date"

  factor_premia <- factor_premia_raw |>
    dplyr::mutate(date = lubridate::as_date(date))
    #dplyr::select(-dplyr::starts_with("Intl"))

  if (.tidy) {
    factor_premia <- factor_premia |>
      tidyr::pivot_longer(cols = -date)
  }

  factor_premia

}