Reproducible Finance With R

Reproducible Finance With R: Code Flows And Shiny Apps For Portfolio Analysis

R is a programming language that owes it’s lineage to S, a language designed in it’s own developers words, “to turn ideas into software,  quickly and faithfully.”(1) Shiny is an “interactive web technology” that makes it easy to take R models and publish them to the web.

Q4 hedge fund letters, conference, scoops etc

Jonathan L. Regenstein, Jr., the director of financial services at RStudio (an integrated development environment for R), walks us through both technologies in a portfolio analysis setting.

Reproducible Finance With R

What do I like about the book?

When I first joined Alpha Architect many of our financial models were exclusively in Excel and augmented with VBA code. Coming from Amazon, I was overwhelmed with VBA code and my eyes (and heart) started to bleed. Excel makes it very easy to write one-off simple programs and very difficult to write reproducible, maintainable programs.

R and Shiny fill this niche effectively. The book starts off with a crash course in a few common R packages. From there it dives into using those packages in a financial context. There are examples using the common data table libraries including xts, tidyverse, tidyquant, and tibbletime.

The book moves quickly from pulling down, cleaning, and producing returns data from the web to computing common statistical measures (standard deviation, skewness, kurtosis). The remainder of the book focuses on Portfolio theory including calculating Sharpe ratios, the CAPM, the Fama-French 3-factor model (including code that works verbatim for downloading data from the Fama French website), component contributions to standard deviation, and culminates in a full-blown web app running monte-carlo simulations.

We found the book compelling enough that we are planning on migrating many of our internal and external tools to R and the Shiny framework.

Constructive Criticism

This is a book for practitioners; if you have not programmed in another language before this book will be very difficult. The book also moves through the Financial material very quickly.

In the author’s own words:

The book seeks to be a resource for R coders interested in finance, or financiers who are interested in R or quantitative work generally.

The book also “prioritizes code that is understandable over code that is theoretically brilliant”. The code does have quite a bit of copy-paste and there are areas where adding a function or module would have cleaned up the code. Those who have an obsession for elegance, you have been warned.

Summary

This book achieves it’s mission to teach finance professionals and programmers how to use R in a financial setting. While I’m still a far-cry from mastering R, the book did give me enough knowledge that we will be using it for modelling purposes going forward.


  • The views and opinions expressed herein are those of the author and do not necessarily reflect the views of Alpha Architect, its affiliates or its employees. Our full disclosures are available here. Definitions of common statistics used in our analysis are available here (towards the bottom).
  • Join thousands of other readers and subscribe to our blog.
  • This site provides NO information on our value ETFs or our momentum ETFs. Please refer to this site.

References

Chambers, John M (1998). Programming with Data: A Guide to the S Language. Springer. ISBN978-0-387-98503-9.

The post “Reproducible Finance With R: Code Flows And Shiny Apps For Portfolio Analysis” appeared first on Alpha Architect.


Saved Articles
X
TextTExtLInkTextTExtLInk

The Life and Career of Charlie Munger

Charlie is more than just Warren Buffett’s friend and Berkshire Hathaway’s Vice Chairman – Buffett has actually credited him with redefining how he looks at investing. Now you can learn from Charlie firsthand via this incredible ebook and over a dozen other famous investor studies by signing up below:

  • Learn from the best and forever change your investing perspective
  • One incredible tidbit of knowledge after another in the page-turning masterpiece of a book
  • Discover the secrets to Charlie’s success and how to apply it to your investing
Never Miss A Story!
Subscribe to ValueWalk Newsletter. We respect your privacy.

Congrats! Are you a smart person?

We have an exclusive targeted for being a sophisticated and loyal reader.

Sign up for ValueWalkPremium today and get our exclusive content for 35% off.

Use coupon code vip19 or click on the button below

Limited time offer only ENDS 12/31/2019 or after next 25 subscribers take advantage whichever comes first – please do not share this discount with others

 

0