Stock portfolio

These demos showcase different components of RStudio Connect. Each folder contains a piece of R content. More details on each are below. If you have an Internet connect, you can pull live data using the tidyquant and quantmod packages. If you want encapsolated external dependencies, there are two SQLite databases with sample data: stock.db and portfolio.db.

Stocks Report

  • Stocks report [login]. Summarize a specific stock ticker symbol. The R Markdown report is parameterized, making it easy to schedule different versions of the report in RStudio Connect. The report also generates an email that includes a custom subject line, embeds a plot and table in the body of the email, and attaches a summary of the data in a csv file. RStudio Connect stores the history of the report and makes it easy to compare versions of the report over time.

Stocks Portfolio

  • ETL [login]. Schedule an ETL task that updates a database. The ETL document provides a quick visualization to validate the model over time and RStudio Connect sends an email if the ETL task fails. The output data from this ETL is used for the following app, report, and API.

  • Shiny app [login]. Use shiny to allow users to explore portfolio returns based on different tolerances for risk.

  • Portfolio report [login]. Explore the same portfolio returns as the Shiny application above. The report generates a customized email for remote review by stakeholders and RStudio Connect stores the report history for review over time.

  • API [login]. Surface a function that computes the volatiltiy of a stock price as a RESTful API. RStudio Connect automatically scales the number of R processes based on the volume of incoming API requests. RStudio Connect also contains a record of deployments, making it easy to roll back to a prior version of the API.