tidyquant

Bringing financial and business analysis to the tidyverse

Features of Tidyquant

Bringing Excel to R in tidyquant 1.0.0

NEW: Tidyquant 1.0.0 is the “R for Excel Users” release. My aim is to build functionality that helps users coming from an Excel Background (background I came from). It’s important to have these users feel at home. I have a full suite of functionality to accomplish your Excel-to-R transition.

-Matt

Details on the Excel integrations are covered in the blog article, “Excel in R - Pivot Tables, VLOOKUPs, and more”.

Bringing Financial Analysis to the tidyverse

tidyquant integrates the best resources for collecting and analyzing financial data, zoo, xts, quantmod, TTR, and PerformanceAnalytics, with the tidy data infrastructure of the tidyverse allowing for seamless interaction between each. You can now perform complete financial analyses in the tidyverse.

2-Minutes To Tidyquant

Our short introduction to tidyquant on YouTube.

Check out our entire Software Intro Series on YouTube!

Benefits

• A few core functions with a lot of power
• Integrates the quantitative analysis functionality of zoo, xts, quantmod, TTR, and now PerformanceAnalytics
• Designed for modeling and scaling analyses using the the tidyverse tools in R for Data Science
• Implements ggplot2 functionality for beautiful and meaningful financial visualizations
• User-friendly documentation to get you up to speed quickly!

One-Stop Shop for Serious Financial Analysis

With tidyquant all the benefits add up to one thing: a one-stop shop for serious financial analysis!

Core Functions

• Getting Financial Data from the web: tq_get(). This is a one-stop shop for getting web-based financial data in a “tidy” data frame format. Get data for daily stock prices (historical), key statistics (real-time), key ratios (historical), financial statements, dividends, splits, economic data from the FRED, FOREX rates from Oanda.

• Manipulating Financial Data: tq_transmute() and tq_mutate(). Integration for many financial functions from xts, zoo, quantmod,TTR and PerformanceAnalytics packages. tq_mutate() is used to add a column to the data frame, and tq_transmute() is used to return a new data frame which is necessary for periodicity changes.

• Performance Analysis and Portfolio Analysis: tq_performance() and tq_portfolio(). The newest additions to the tidyquant family integrate PerformanceAnalytics functions. tq_performance() converts investment returns into performance metrics. tq_portfolio() aggregates a group (or multiple groups) of asset returns into one or more portfolios.

Comparing Stock Prices

Visualizing the stock price volatility of four stocks side-by-side is quick and easy…

Evaluating Stock Performance

What about stock performance? Quickly visualize how a $10,000 investment in various stocks would perform.

Evaluating Portfolio Performance

Ok, stocks are too easy. What about portfolios? With the PerformanceAnalytics integration, visualizing blended portfolios are easy too!

• Portfolio 1: 50% FB, 25% AMZN, 25% NFLX, 0% GOOG
• Portfolio 2: 0% FB, 50% AMZN, 25% NFLX, 25% GOOG
• Portfolio 3: 25% FB, 0% AMZN, 50% NFLX, 25% GOOG
• Portfolio 4: 25% FB, 25% AMZN, 0% NFLX, 50% GOOG

This just scratches the surface of tidyquant. Here’s how to install to get started.

Installation

Development Version with Latest Features:

# install.packages("devtools")
devtools::install_github("business-science/tidyquant")

CRAN Approved Version:

install.packages("tidyquant")

Further Information

The tidyquant package includes several vignettes to help users get up to speed quickly:

• TQ00 - Introduction to tidyquant
• TQ01 - Core Functions in tidyquant
• TQ02 - R Quantitative Analysis Package Integrations in tidyquant
• TQ03 - Scaling and Modeling with tidyquant
• TQ04 - Charting with tidyquant
• TQ05 - Performance Analysis with tidyquant
• Blog Article: Excel in R - Pivot Tables, VLOOKUPs, and more!

See the tidyquant vignettes for further details on the package.

Want to Learn tidyquant?

• Learning Lab #9:

  • Performance Analysis & Portfolio Optimization with tidyquant - A 1-hour course on tidyquant in Learning Labs PRO

• Learning Lab #10:

  • Building an API with plumber - Build a stock optimization API with plumber and tidyquant

• Learning Lab #16:

  • Stock Portfolio Optimization and Nonlinear Programming - Use the ROI package with tidyquant to calculate optimal minimum variance portfolios and develop an efficient frontier.