We recently put together a fairly interesting Inference in Excel example that uses a collection of novel R packages to easily perform advanced financial stock analysis using minimal R code. Specifically, the Inference in Excel document:
- downloads timely stock data
- displays this stock data in a way that enables decision making
- and performs customized analyses
To do this, the document leverages three R packages:
…and then performs a series of charted analyses, including trading volume, moving average, convergence/divergence indicators, and custom volatility calculations. I was really impressed by the degree of analysis depth and sophistication that could be accomplished using very little R code.
To better illustrate the example, we've assembled a four-minute screencast that goes through the process of creating and running the Inference in Excel document. The screencast also provides a sneak peek at the upcoming Run-In-Place and Inference in PowerPoint features coming in the next Inference for R release (due out this June!).
You can view the screencast on our Screencasts page, or by clicking on the screenshot below:
