# Quantitative trading strategies in r part 1 of 3

The code below will save the data in the following directory: There is a non-parametric statistical test that does exactly this: Note that I added an output file updateLog.

The join argument does the magic! In everything that follows, I assume that data is coming from Yahoo. In the next sections I present the prerequisite to developed such an approach and a step by step guide that explains how BERT could be used for simply passing data from R to Excel with minimal VBA code.

The process is summarized in the chart below. R any other name is fine in a directory of your choice. Analyzing the statistical properties of individual stocks vs. Formal significance tests can be evaluated but this is beyond the scope of this article. You can refer to the Examples section on QuantTools website.

This is a very first version of the project so do not expect perfection but hopefully it will get better over time. Multivariate Time Series What to do if you have to deal with multivariate time series? Obviously there is a survival ship bias: A factor can have a good IC but its predictive power might be limited to a small number of stocks. I have one csv file per instrument and each file is named after the instrument it contains.

Therefore there are greater chances to beat the index by overweighting the stocks falling into Q5 and underweighting those falling into Q1 relative to the benchmark. I found the Wikipedia definition pretty good. Univariate Time Series Univariate plots are designed to learn as much as possible about the distribution, central tendency and spread of the data at hand. Any comments comments welcome! Overall I find the package extremely useful and well documented.

Then save and close the file functions. Extract index values of a given xts object corresponding to the last observations given a period specified by on. You just setup storage parameters and you are ready to go. Obviously ICs must be as high as possible in absolute terms.

The Rise of the Robots Advisorsâ€¦ August 15,9: Machine Learning Modelling in R: Once the installation has completed you should have a new Add-Ins menu in Excel with the buttons as shown below.