You don't need to keep chasing that one perfect strategy...

See how you can use algos to systematise your trading, remove emotions and finally __make your capital grow__!

Grab your FREE Guide to Algo Trading PDF:

Posted on Mar 04, 2016 by

69 comments

18,879 Views

**Update 1: In response to a suggestion from a reader, I’ve added a section on feature selection using the Boruta package. **

**Update 2: Responding to another suggestion, I’ve added some equity curves of a simple trading system using the knowledge gained from this analysis.**

**Update 3: In response to a comment from Alon, I’ve added some Lite-C code that generates the training data used in this post and outputs it to a .csv file. You can have some serious fun with this and it enables you to greatly extend the research presented here. Enjoy!**

**Update 4: 30 March 2017: The analysis was extended the analysis to include data up to the end of 2016. Of course, I updated the post to reflect the changes.**

**The code for performing the analysis and generating the data I used in this post, as well the data file itself and another for a different instrument that you can experiment with, are all available for free by clicking here.**

One of the first books I read when I began studying the markets a few years ago was David Aronson’s *Evidence Based Technical Analysis*. The engineer in me was attracted to the ‘Evidence Based’ part of the title. This was soon after I had digested a trading book that claimed a basis in chaos theory, the link to which actually turned out to be non-existent. Apparently using complex-sounding terms in the title of a trading book lends some measure of credibility. Anyway, *Evidence Based Technical Analysis *is largely a justification of a scientific approach to trading, including a method for rigorous assessment of the presence of data mining bias in backtest results. There is also a compelling discussion based in cognitive psychology of the reasons that some traders turn away from objective methods and embrace subjective beliefs. I find this area fascinating.

Readers of this blog will know that I am very interested in using machine learning to profit from the markets. Imagine my delight when I discovered that David Aronson had co-authored a new book with Timothy Masters titled *Statistically Sound Machine Learning for Algorithmic Trading of Financial Instruments – *which I will herein refer to as SSML. I quickly devoured the book and have used it as a handy reference ever since. While it is intended as a companion to Aronson’s (free) software platform for strategy development, it contains numerous practical tips for any machine learning practitioner and I’ve implemented most of his ideas in R.

I used SSML to guide my early forays into machine learning for trading, and this series describes some of those early experiments. While a detailed review of everything I learned from SSML and all the research it inspired is a bit voluminous to relate in detail, what follows is an account of what I found to be some of the more significant and practical learnings that I encountered along the way.

This post will focus on feature engineering and also introduce the data mining approach. The next post will focus on algorithm selection and ensemble methods for combining the predictions of numerous learners.

Data mining is just one approach to extracting profits from the markets and is different to a model-based approach. Rather than constructing a mathematical representation of price, returns or volatility from first principles, data mining involves searching for patterns first and then fitting a model to those patterns after the fact. Both model-based and data mining approaches have pros and cons, and I contend that using both approaches can lead to a valuable source of portfolio diversity.

The Financial Hacker summed up the advantages and disadvantages of the data mining approach nicely:

The advantage of data mining is that you do not need to care about market hypotheses. The disadvantage: those methods usually find a vast amount of random patterns and thus generate a vast amount of worthless strategies. Since mere data mining is a blind approach, distinguishing real patterns – caused by real market inefficiencies – from random patterns is a challenging task. Even sophisticated reality checks can normally not eliminate all data mining bias. Not many successful trading systems generated by data mining methods are known today.

David Aronson himself cautions against putting blind faith in data mining methods:

Though data mining is a promising approach for finding predictive patterns in data produced by largely random complex processes such as financial markets, its findings are upwardly biased. This is the data mining bias. Thus, the profitability of methods discovered by data mining must be evaluated with specialized statistical tests designed to cope with the data mining bias.

I would add that the implicit assumption behind the data mining approach is that the patterns identified will continue to repeat in the future. Of course, the validity of this assumption is unlikely to ever be certain.

Data mining is a term that can mean different things to different people depending on the context. When I refer to a data mining approach to trading systems development, I am referring to the use of statistical learning algorithms to uncover relationships between feature variables and a target variable (in the regression context, these would be referred to as the independent and dependent variables, respectively). The feature variables are observations that are assumed to have some relationship to the target variable and could include, for example, historical returns, historical volatility, various transformations or derivatives of a price series, economic indicators, and sentiment barometers. The target variable is the object to be predicted from the feature variables and could be the future return (next day return, next month return etc), the sign of the next day’s return, or the actual price level (although the latter is not really recommended, for reasons that will be explained below).

Although I differentiate between the data mining approach and the model-based approach, the data mining approach can also be considered an exercise in predictive modelling. Interestingly, the model-based approaches that I have written about previously (for example ARIMA, GARCH, Random Walk etc) assume linear relationships between variables. Modelling non-linear relationships using these approaches is (apparently) complex and time consuming. On the other hand, some statistical learning algorithms can be considered ‘universal approximators’ in that they have the ability to model any linear or non-linear relationship. It was not my intention to get into a philosophical discussion about the differences between a model-based approach and a data mining approach, but clearly there is some overlap between the two. In the near future I am going to write about my efforts to create a hybrid approach that attempts a synergistic combination of classical linear time series modelling and non-linear statistical learning – trust me, it is actually much more interesting than it sounds. Watch this space.

The first and most obvious decision to be made is the choice of target variable. In other words, what are we trying to predict? For one-day ahead forecasting systems, profit is the usual target. I used the next day’s return normalized to the recent average true range, the implication being that in live trading, position sizes would be inversely proportionate to the recent volatility. In addition, by normalizing the target variable in this way, we may be able to train the model on multiple markets, as the target will be on the same scale for each.

In SSML, Aronson states that the golden rule of feature selection is that the predictive power should come primarily from the features and not from the model itself. My research corroborated this statement, with many (but not all) algorithm types returning correlated predictions for the same feature set. I found that the choice of features had a far greater impact on performance than choice of model. The implication is that spending considerable effort on feature selection and feature engineering is well and truly justified. I believe it is critical to achieving decent model performance.

Many variables will have little or no relationship with the target variable and including these will lead to overfitting or other forms of poor performance. Aronson recommends using chi-square tests and Cramer’s V to quantify the relationship between variables and the target. I actually didn’t use this approach, so I can’t comment on it. I used a number of other approaches, including ranking a list of candidate features according to their Maximal Information Coefficient (MIC) and selecting the highest ranked features, Recursive Feature Elimination (RFE) via the caret package in R, an exhaustive search of all linear models, and Principal Components Analysis (PCA). Each of these are discussed below.

Following is the list of features that I investigated as part of this research. Most were derived from SSML. This list is by no means exhaustive and only consists of derivatives and transformations of the price series. I haven’t yet tested exogenous variables, such as economic indicators, the price histories of other instruments and the like, but I think these are deserving of attention too. The following list is by no means exhaustive, but provides a decent starting point:

- 1-day log return
- Trend deviation: the logarithm of the closing price divided by the lowpass filtered price
- Momentum: the price today relative to the price
*x*days ago, normalized by the standard deviation of daily price changes. - ATR: the average true range of the price series
- Velocity: a one-step ahead linear regression forecast on closing prices
- Linear forecast deviation: the difference between the most recent closing price and the closing price predicted by a linear regression line
- Price variance ratio: the ratio of the variance of the log of closing prices over a short time period to that over a long time period.
- Delta price variance ratio: the difference between the current value of the price variance ratio and its value
*x*periods ago. - The Market Meanness Index: A measure of the likelihood of the market being in a state of mean reversion, created by the Financial Hacker.
- MMI deviation: The difference between the current value of the Market Meanness Index and its value
*x*periods ago. - The Hurst exponenet
- ATR ratio: the ratio of an ATR of a short (recent) price history to an ATR of a longer period.
- Delta ATR ratio: the difference between the current value of the ATR ratio and the value
*x*bars ago. - Bollinger width: the log ratio of the standard deviation of closing prices to the mean of closing prices, that is a moving standard deviation of closing prices relative to the moving average of closing prices.
- Delta bollinger width: the difference between the current value of the bollinger width and its value
*x*bars ago. - Absolute price change oscillator: the difference between a short and long lookback mean log price divided by a 100-period ATR of the log price.

Thus far I have only considered the most recent value of each variable. I suspect that the recent history of each variable would provide another useful dimension of data to mine. I left this out of the feature selection stage since it makes more sense to firstly identify features whose current values contain predictive information about the target variable before considering their recent histories. Incorporating this from the beginning of the feature selection stage would increase the complexity of the process by several orders of magnitude and would be unlikely to provide much additional value. I base that statement on a number of my own assumptions, not to mention the practicalities of the data mining approach, rather than any hard evidence.

In my experiments, the variables listed above were used with various cutoff periods (that is, the number of periods used in their calculation). Typically, I used values between 3 and 20 since Aronson states in SSML that lookback periods greater than about 20 will generally not contain information useful to the one period ahead forecast. Some variables (like the Market Meanness Index) benefit from a longer lookback. For these, I experimented with 50, 100, and 150 bars.

Additionally, it is important to enforce a degree of stationarity on the variables. Davind Aronson again:

Using stationary variables can have an enormous positive impact on a machine learning model. There are numerous adjustments that can be made in order to enforce stationarity such as centering, scaling, and normalization. So long as the historical lookback period of the adjustment is long relative to the frequency of trade signals, important information is almost never lost and the improvements to model performance are vast.

Aronson suggests the following approaches to enforcing stationarity:

- Scaling: divide the indicator by the interquartile range (note, not by the standard deviation, since the interquartile range is not as sensitive to extremely large or small values).
- Centering: subtract the historical median from the current value.
- Normalization: both of the above. Roughly equivalent to traditional z-score standardization, but uses the median and interquartile range rather than the mean and standard deviation in order to reduce the impact of outliers.
- Regular normalization: standardizes the data to the range -1 to +1 over the lookback period (x-min)/(max-min) and re-centered to the desired range.

In my experiments, I generally adopted regular normalization using the most recent 50 values of the features.

If you’re following along with the code and data provided (see **note in bold** above), I used the data for the GBP/USD exchange rate (sampled daily at midnight UTC, for the period 2009-2016), but I also provided data for EUR/USD (same sampling regime) for further experimentation.

Before you continue....

**Want to see how others trade for a living with algos — so maybe you can too?**

Learn where to start and see how systematic retail traders generate profit long-term:

It makes sense to remove variables that are highly correlated with other variables since they are unlikely to provide additional information that isn’t already contained elsewhere in the feature space. Keeping these variables will also add unnecessary computation time, increase the risk of overfitting and bias the final model towards the correlated variables.

Running
caret ‘s function for examining pairwise correlations between variables –
caret::findCorrelation() – with a cutoff of 0.3, these are the remaining variables and their pairwise correlations:

## Feature selection via Maximal Information

## Recursive feature elimination

## Models with in-built feature selection

The maximal information coefficient (MIC) is a non-parametric measure of two-variable dependence designed specifically for rapid exploration of many-dimensional data sets. While MIC is limited to univariate relationships (that is, it does not consider variable interactions), it does pick up non-linear relationships between dependent and independent variables. Read more about MIC here. I used the minerva package in R to rank my variables according to their MIC with the target variable (next day’s return normalized to the 100-period ATR). Here’s the code output:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
### MIC RESULTS # MMIFaster 0.09817869 # deltaPVR5 0.10107728 # bWidthSlow 0.10196236 # deltaATRrat10 0.10228334 # apc5 0.10346916 # deltaATRrat3 0.10473520 # mom10 0.10593616 # trend 0.10610100 # HurstMod 0.10703185 # HurstFast 0.10810217 # atrRatSlow 0.10818756 # deltaMMIFastest10 0.10863479 # bWdith3 0.11014629 # HurstFaster 0.11493763 # ATRSlow 0.12458435 |

These results show that none of the features have a particularly high MIC with respect to the target variable, which is what I would expect from noisy data such as daily exchange rates sampled at an arbitrary time. However, certain variables have a higher MIC than others. In particular, the long-term ATR and the 20-period Hurst exponent and the 3-period Bollinger width outperform the rest of the variables.

I also used recursive feature elimination (RFE) via the
caret package in R to isolate the most predictive features from my list of candidates. RFE is an iterative process that involves constructing a model from the entire set of features, retaining the best performing features, and then repeating the process until all the features are eliminated. The model with the best performance is identified and the feature set from that model declared the most useful.

I performed cross-validated RFE using a random forest model. Here are the results:

1 2 3 |
#### Results # The top 5 variables (out of 14): # ATRSlow, trend, HurstMod, deltaATRrat10, bWidthSlow |

In this case, the RFE process has emphasized variables that describe volatility and trend, but has decided that the best performance is obtained by incorporating 14 of 15 variables into the model. Here’s a plot of the cross validated performance of the best feature set for various numbers of features (noting that *k*-fold cross validation may not be the ideal cross-validation method for financial time series):

I am tempted to take the results of the RFE with a grain of salt. My reasons are:

- The RFE algorithm does not fully account for interactions between variables. For example, assume that two variables individually have no effect on model performance, but due to some relationship between them they improve performance when both are included in the feature set. RFE is likely to miss this predictive relationship.
- The performance of RFE is directly related to the ability of the specific algorithm (in this case random forest) to uncover relationships between the variables and the target. At this stage of the process, we have absolutely no evidence that the random forest model is applicable in this sense to our particular data set.
- Finally, the implementation of RFE that I used was the ‘out of the box’ caret version. This implementation uses root mean squared error (RMSE) as the objective function, however I don’t believe that RMSE is the best objective function for this data due to the significant influence of extreme values on model performance. It is possible to have a low RMSE but poor overall performance if the model is accurate across the middle regions of the target space (corresponding to small wins and losses), but inaccurate in the tails (corresponding to big wins and losses)

In order to address (3) above, I implemented a custom summary function so that the RFE was performed such that the cross-validated absolute return was maximized. I also applied the additional criterion that only predictions with an absolute value of greater than 5 would be considered under the assumption that in live trading we wouldn’t enter positions unless the prediction exceeded this value. The results are as follows:

1 2 |
# The top 5 variables (out of 15): # ATRSlow, trend, HurstMod, bWidthSlow, atrRatSlow |

The results are a little different to those obtained using RMSE as the objective function. The focus is still on the volatility and trend indicators, but in this case the best cross validated performance occurred when selecting only 2 out of the 15 candidate variables. Here’s a plot of the cross validated performance of the best feature set for various numbers of features:

The model clearly performs better in terms of absolute return for a smaller number of predictors. This is consistent with Aronson’s assertion that with this approach we should stick with at most 3-4 variables otherwise overfitting is almost unavoidable.

The performance profile of the model tuned on absolute return is very different to that of the model tuned on RMSE, which displays a consistent improvement as the number of predictors is increased. Using RMSE as the objective function (which seems to be the default in many applications I’ve come across) would result in a very sub-optimal final model in this case. This highlights the importance of ensuring that the objective function is a good proxy for the performance being sought in practice.

In the RFE example above, I used 5-fold cross validation, but I haven’t held out a test set of data or estimated performance with an inner cross validation loop. Note also that *k*-fold cross validation may not be ideal for financial time series thanks to the autocorrelations present.

A number of machine learning algorithms have feature selection in-built. Max Kuhn’s website for the caret package contains a list of such models that are accessible through the caret package. I’ll apply several and compare the features selected to those selected with other methods. For this experiment, I used a diverse range of algorithms that include various ensemble methods and both linear and non-linear interactions:

- Bagged multi-adaptive regressive splines (MARS)
- Boosted generalized additive model (bGAM)
- Lasso
- Spike and slab regression (SSR)
- Regression tree
- Stochastic gradient boosting (SGB)

For each model, I did only very basic (if any) hyperparameter tuning within caret using time series cross validation with a train window length of 200 days and a test window length of 20 days. Maximization of absolute return was used as the objective function. Following cross-validation, caret actually trains a model on the full data set with the best cross-validated hyperparameters – but this is not what we want if we are to mimic actual trading behaviour (we are more interested in the aggregated performance across each test window, which caret very neatly allows us to access – details on this below when we investigate a trading system).

The table below shows the top 5 variables for each algorithm:

Variable | Size (bytes) | Range | Step Size | Example Use |
---|---|---|---|---|

var | 8 | -1.8e308 to 1.8e308 | 2.2e−308 | Prices, technical indicators |

int | 4 | -2,147,483,648 to 2,147,483,647 | 1 | Counting |

char | 1 | 0 to 256 | 1 | Individual text characters |

string | Number of characters plus 1 | N/A | N/A | Text |

bool | 4 | true or false | N/A | Decisions |

vars or var* | 8*(Series length) | -1.8e308 to 1.8e308 | 2.2e−308 | Time series of prices, returns |

We can see that 10-day momentum is included in the top 5 predictors for every algorithm I investigated except one, and was the top feature every time it was selected. The change in the ratio of the ATR lookbacks featured 7 times in total. A responsive absolute price change oscillator was selected 4 times, and in one form or another (10- and 20-day variables once each and 100-day variable thrice). The 5-day change in the price variance ratio was a notable mention, being included in the top variables 3 times. The table below summarizes the frequency with which each variable was selected:

9 of the 15 variables that passed the correlation filter were selected in the top 5 by at least one algorithm.

The glmulti package fits all possible unique generalized linear models from the variables and returns the ‘best’ models as determined by an information criterion (Aikake in this case). The package is essentially a wrapper for the glm (generalized linear model) function that allows selection of the ‘best’ model or models, providing insight into the most predictive variables. By default, glmulti builds models from the main interactions, but there is an option to also include pairwise interactions between variables. This increases the computation time considerably, and I found that the resulting ‘best’ models were orders of magnitude more complex than those obtained using main interactions only, and results were on par.

1 2 3 4 5 6 7 8 9 10 11 |
### glmulti.analysis # Method: h / Fitting: glm / IC used: aicc # Level: 1 / Marginality: FALSE # From 100 models: # Best IC: 22669.8709723958 # Best model: # [1] "target ~ 1 + trend + atrRatSlow" # Evidence weight: 0.0323562049748589 # Worst IC: 22673.0396363133 # 23 models within 2 IC units. # 92 models to reach 95% of evidence weight. |

We retain the models whose AICs are less than two units from the ‘best’ model. Two units is a rule of thumb for models that, for all intents and purposes, are likely to be on par in terms of their performance:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
### model aicc weights # 1 target ~ 1 + trend + atrRatSlow 22669.87 0.03235620 # 2 target ~ 1 + apc5 + trend + atrRatSlow 22670.72 0.02111157 # 3 target ~ 1 + MMIFaster + trend + atrRatSlow 22670.73 0.02104022 # 4 target ~ 1 + bWdith3 + trend + atrRatSlow 22670.87 0.01961736 # 5 target ~ 1 + trend + atrRatSlow + bWidthSlow 22670.96 0.01878187 # 6 target ~ 1 + deltaMMIFastest10 + trend + atrRatSlow 22671.04 0.01799825 # 7 target ~ 1 + trend + atrRatSlow + ATRSlow 22671.20 0.01667710 # 8 target ~ 1 + atrRatSlow 22671.23 0.01644049 # 9 target ~ 1 + apc5 + MMIFaster + trend + atrRatSlow 22671.40 0.01504698 # 10 target ~ 1 + deltaPVR5 + trend + atrRatSlow 22671.44 0.01474030 # 11 target ~ 1 + MMIFaster + trend + atrRatSlow + bWidthSlow 22671.49 0.01439135 # 12 target ~ 1 + HurstFast + trend + atrRatSlow 22671.55 0.01396476 # 13 target ~ 1 + HurstMod + trend + atrRatSlow 22671.61 0.01357259 # 14 target ~ 1 + mom10 + trend + atrRatSlow 22671.64 0.01337186 # 15 target ~ 1 + apc5 + bWdith3 + trend + atrRatSlow 22671.65 0.01329943 # 16 target ~ 1 + MMIFaster + deltaMMIFastest10 + trend + atrRatSlow 22671.66 0.01325762 # 17 target ~ 1 + deltaATRrat3 + trend + atrRatSlow 22671.68 0.01309016 # 18 target ~ 1 + deltaATRrat10 + trend + atrRatSlow 22671.69 0.01303342 # 19 target ~ 1 + HurstFaster + trend + atrRatSlow 22671.70 0.01294480 # 20 target ~ 1 + bWdith3 + MMIFaster + trend + atrRatSlow 22671.72 0.01283320 # 21 target ~ 1 + apc5 + trend + atrRatSlow + bWidthSlow 22671.74 0.01268352 # 22 target ~ 1 + apc5 + deltaMMIFastest10 + trend + atrRatSlow 22671.83 0.01216110 # 23 target ~ 1 + bWdith3 + trend + atrRatSlow + bWidthSlow 22671.85 0.01205142 |

Notice any patterns here? many of the top models selected the ratio of the 20- day to 100-day ATRs, as well as the difference between a short-term and long-term trend indicator. Perhaps surprisingly sparse are the momentum variables. This is confirmed with this plot of the model averaged variable importance (averaged over the best 1,000 models):

Note that these models only considered the main, linear interactions between each variable and the target. Of course, there is no guarantee that any relationship is linear, if it exists at all. Further, there is the implicit assumption of stationary relationships amongst the variables which is unlikely to hold. Still, this method provides some useful insight.

One of the great things about
glmulti is that it facilitates model-averaged predictions – more on this when I delve into ensembles in part 2 of this series.

Finally, I used a generalized linear model with stepwise feature selection:

1 2 3 4 5 6 7 8 |
### GLM Stepwise Feature Selection Results # Coefficients: # (Intercept) trend atrRatSlow # -1.907 -3.632 -5.100 # # Degrees of Freedom: 2024 Total (i.e. Null); 2022 Residual # Null Deviance: 8625000 # Residual Deviance: 8593000 AIC: 22670 |

The final model selected 2 of the 15 variables: the ratio of the 20- to 100-day ATR, difference between a short-term and long-term trend indicator.

Boruta finds relevant features by comparing the importance of the original features with the importance of random variables. Random variables are obtained by permuting the order of values of the original features. Boruta finds a minimum, mean and maximum value of the importance of these permuted variables, and then compares these to the original features. Any original feature that is found to be more relevant than the maximum random permutation is retained.

Boruta does not measure the absolute importance of individual features, rather it compares each feature to random permutations of the original variables and determines the relative importance. This theory very much resonates with me and I intuit that it will find application in weeding out uninformative features from noisy financial data. The idea of adding randomness to the sample and then comparing performance is analogous to the approach I use to benchmark my systems against a random trader with a similar trade distribution.

The box plots in the figure below show the results obtained when I ran the Boruta algorithm for the 15 filtered variables for 1,000 iterations. The blue box plots show the permuted variables of minimum, mean and maximum importance, the green box plots indicate the original features that ranked higher than the maximum importance of the random permuted variables, and the variables represented by the red box plots are discarded.

1 2 3 4 5 6 |
### Boruta all relevant feature selection # Boruta performed 369 iterations in 5.385172 mins. # 8 attributes confirmed important: apc5, atrRatSlow, ATRSlow, bWidthSlow, # deltaMMIFastest10 and 3 more; # 7 attributes confirmed unimportant: bWdith3, deltaATRrat10, deltaATRrat3, deltaPVR5, # HurstFast and 2 more; |

These results are largely consistent with the results obtained through other methods, perhaps with the exception of the inclusion of the MMI and Hurst variables. Surprisingly, the long-term ATR was the clear winner.

Side note: The developers state that “Boruta” means “Slavic spirit of the forest.” As something of a slavophile myself, I did some googling and discovered that this description is quite a euphemism. Check out some of the items that pop up in a Google image search!

It is important to note that any feature selection process naturally invites a degree of selection bias. For example, from a large set of uninformative variables, a small number may randomly correlate with the target variable. The selection algorithm would then rank these variables highly. The error would only be (potentially) uncovered through cross validation of the selection algorithm or by using an unseen test or validation set. Feature selection is difficult and can often make predictive performance worse, since it is easy to over-fit the feature selection criterion. It is all to easy to end up with a subset of attributes that works really well on one particular sample of data, but not necessarily on any other. There is a fantastic discussion of this at the Statistics Stack Exchange community that I have linked here because it is just so useful.

It is critical to take steps to minimize selection bias at every opportunity. The results of any feature selection process should be cross validated or tested on an unseen hold out set. If the hold out set selects a vastly different set of predictors, something has obviously gone wrong – or the features are worthless. The approach I took in this post was to cross validate the results of each test that I performed, with the exception of the Maximal Information Criterion and
glmulti approaches. I’ve also selected features based on data for one market only. If the selected features are not robust, this will show up with poor performance when I attempt to build predictive models for other markets using these features.

I think that it is useful to apply a wide range of methods for feature selection, and then look for patterns and consistencies across these methods. This approach seems to intuitively be far more likely to yield useful information than drawing absolute conclusions from a single feature selection process. Applying this logic to the approach described above, we can conclude that the 10-day momentum, the ratio of the 10- to 20-day ATR, the trend deviation indicator, and the absolute price change oscillator are probably the most likely to yield useful information since they continually show up in most of the feature selection methods that I investigated. Other variables that may be worth considering include the long-term ATR and the change in a responsive MMI.

In part 2 of this article, I’ll describe how I built and combined various models based on these variables.

An alternative to feature selection is Principal Components Analysis (PCA), which attempts to reduce the dimensionality of the data while retaining the majority of the information. PCA is a linear technique: it transforms the data by linearly projecting it onto a lower dimension space while preserving as much of its variation as possible. Another way of saying this is that PCA attempts to transform the data so as to express it as a sum of uncorrelated components.

Again, note that PCA is limited to a linear transformation of the data, however there is no guarantee that non-linear transformations won’t be better suited. Another significant assumption when using PCA is that the principal components of future data will look those of the training data. It’s also possible that the smallest component, describing the least variance, is also the only one carrying information about the target variable, and would likely be lost when the major variance contributors are selected.

To investigate the effects of PCA on model performance, I cross validated 2 random forest models, the first using the principal components of the 15 variables, and the other using all 15 variables in their raw form. I chose the random forest model since it includes feature selection and thus may reveal some insights about how PCA stacks up in relation to other feature selection methods. For both models, I performed time series cross validation on a training window of 200 days and a testing window of 20 days.

In order to infer the difference in model performance, I collected the results from each resampling iteration of both final models and compared their distributions via a pair of box and whisker plots:

The model built on the raw data outperforms the model built on the data’s principal components in this case. The mean profit is higher and the distribution is shifted in the positive direction. Sadly however, both distributions look only sightly better than random and have wide distributions.

I will go into more detail about building a practical trading system using machine learning in the next post, but the following demonstrates a simple trading system based on some of the information gained from the analysis presented above. The system is based on three of the indicators that the feature selection analysis identified as being predictive of the target variable. The features used were long-term ATR, the change in the responsive MMI, and the trend deviance indicator. I trained a generalized boosted regression model using the
gbm package in R using these indicators as the independent variables predicting the next day return normalized to the recent ATR. The model was trained on a sliding window of 200 days and tested on the adjacent 20 days over the length of the entire data set. I also subtracted transaction costs of 2 pips per round turn lot traded.

The returns series of most financial instruments consists of a relatively large number of small positive and small negative values and a smaller number of large positive and large negative values. I hypothesize that the values whose magnitude is smaller are more random in nature than the values whose magnitude is large. On any given day, all things being equal, a small negative return could turn out to be a small positive return by the time the close rolls around, or vice versa, as a result of any number of random occurrences related to the fundamentals of the exchange rate. These same random occurrences are less likely to push a large positive return into negative territory and vice versa, purely on account of the size of the price swings involved. Following this logic, I hypothesize that my model is likely to be more accurate in its extreme predictions than in its ‘normal’ range. We can test this hypothesis on the simple trading strategy described above by entering positions only when the model predicts a return that is large in magnitude.

Here are the results, along with the buy and hold return from the testing data set:

While the strategy may look enticing, it is actually not overly robust to changing the random initialization or the hyperparameters of the GBM algorithm – more work is needed to turn this into a viable strategy. We can see that increasing the prediction threshold for entering a trade resulted in smoother equity curves, but a much reduced final equity. The model significantly outperformed the buy and hold strategy. The prediction threshold can be adjusted depending on the trader’s appetite for high returns (threshold = 0) as opposed to minimal drawdown (threshold = 100).

Following are the generalizations that will inform the next stage of model development:

- The MIC analysis and the Boruta algorithm agreed that the long-term ATR was the most important feature. They were also the only approaches that included the Hurst exponent in their most important features.
- The RFE analysis indicated that it may be prudent to focus on variables that measure long-term volatility or recent changes in volatility relative to the longer term.
- An exhaustive search of all possible generalized linear models that considered main interactions using glmulti implied that the 20- to 100-day ATR ratio and the trend deviance variables are most predictive.
- Stepwise feature selection using a generalized linear model returned similar results.
- Boruta identified 8 useful variables, with the long-term ATR the clear winner.
- Transforming the variables using PCA reduced the performance of a random forest model relative to using the raw variables.

The same features seem to be selected over and over again using the different methods. Is this just a fluke, or has this long and exhaustive data mining exercise revealed something of practical use to a trader? In part 2 of this series, I will investigate the performance of various machine learning algorithms based on this feature selection exercise. I’ll compare different algorithms and then investigate combining their predictions using ensemble methods with the objective of creating a useful trading system.

Before you continue....

**Want to see how others trade for a living with algos — so maybe you can too?**

Learn where to start and see how systematic retail traders generate profit long-term:

Aronson, D. 2006, *Evidence-Based Technical Analysis: Applying the Scientific Method and Statistical Inference to Trading Signals*.

Aronson, D. and Masters, T. 2014-, *Statistically Sound Machine Learning for Algorithmic Trading of Financial Instruments: Developing Predictive-Model-Based Trading Systems Using TSSB*

## (69) Comments

Great post! I’ll be sure to follow the next parts of the series. I’m just starting in the world of algo trading and based on what you wrote SSML looks like a good starting point. Would you recommend any other book?

Thanks! Glad you liked it.

My reading list for starting out with algo trading includes both of Ernie Chan’s books and Aronson’s first book, ‘Evidence Based Technical Analysis’. Jaekle and Tomasini is a handy reference too. If you don’t already have the background, an introductory statistics/probability text (sorry, can’t recommend one off the top of my head). If you want to delve into time series analysis, Ruey Tsay’s book on the topic is heavy going, but worth persisting with. In terms of machine learning, Lantz’s ‘Machine Learning with R’ will get you started. Depending on your stats background, Tibrishani et. al. released two works – ‘The Elements of Statistical Learning’ (more advanced) and ‘Introduction to Statistical Learning’ – these are the logical next steps for machine learning. Finally, I find the caret package in R to be immensely useful, and the author of the package also wrote a book called ‘Applied Predictive Modelling’ – definitely worth a read if you are interested in the machine learning side of things.

Brilliant post Kris, Thank you.

This has really helped me to get started in the area of using ML in trading. Was even part of the recommended reading I was given.

Will email you about adding your recommended books here to the Quantocracy book list.

I am really looking forward to the follow up post.

God speed

Jacques Joubert

Thanks for that feedback, Jaques. I am really glad you found it useful.

Best

Kris

Excellent Work !

I love Aronson’s books also. Did you implement a version of the MCPT ?

Best, Nick

Thanks Nick! I haven’t yet implemented MCPT in R, but I think the ‘coin’ package could be used. Do you know of any others? MCPT would be a good inclusion as an update to this post, or perhaps in the next.

I’m not familiar with ‘coin’ but thanks for mentioning that … I’ve implemented my own version of the MCPT.

BTW, you mention that you use Zorro. Have you used their R bridge for strategy development or live trading ?

Best, Nick

Hey Nick,

Yes I’ve used Zorro’s R bridge extensively for strategy development and am using it for live trading right now. Its an integral part of my workflow and I am much more efficient during the development stage compared with using either Zorro or R separately. Its a very useful piece of kit to have in your toolbox.

I ‘ll do a post in the near future on exactly how this works and why it is efficient.

Very interesting work. You might also be interested in the “Boruta” all relevant feature selection method, which can be found at https://m2.icm.edu.pl/boruta/

I look forward to your next few posts.

Thanks for pointing me to Boruta, Dekalog. I’ll update the post to include this method. I see that it is implemented as an R package – how convenient!

Dekalog,

I’ve updated the post with a paragraph on Boruta. Thanks for pointing me to this package – very easy to use and wonderfully intuitive logic behind it.

[…] Machine learning for financial prediction: experimentation with Aronson’s latest work – … […]

Hi and thanks for sharing your work. One suggestion and request I would make would be to plot equity curves of some of the more promising candidates against say a simple Buy and Hold model. For example, if your in sample training set found ATR and BB (with some parameter set) useful and you created a model built around those features, you could plot both the in and out of sample resulting equity curves of the results (you also need to determine how you want to translate those predictions to actions. e.g. Buy/Sell/Flat). I’ve found the equity curve can reveal a lot about the results that may not be evident from looking at standalone metrics. One test may show promising results around a certain set of variables, but depending on how the individual results are finally aggregated, a different set of features may have performed much better.

Hi IT, thanks for that comment. I take your point – equity curves certainly reveal a lot more useful information than the result of a feature selection test. And after all, this is a blog about trading. I had originally intended to leave all of the strategy development stuff until the next post where I will write about how I transform a model output into actionable intelligence, combining predictions from multiple learners and all that. But you’re right – an illustrative trading strategy and equity curve would fit nicely here. I’ll update the post accordingly.

Thanks again for your feedback – always much appreciated.

\nThat will be the common answer you will come across for every machine learning and knowledge discovery problem you face. There is no best learning system, classification system, or statistical method. You need to know your data-set well enough to realize where one approach might be better than others.

Couldn’t agree more, Deshawn. There is an important place for subject matter knowledge in nearly any machine learning task.

Hello and thank you for the great post. I discovered TSSB thanks to it and now I’m playing with the application. I see you also use ATR normalized return. I tried to compute it in R and compare the values to TSSB outputs but they differ. For example on D1 GBP/USD data from 2009-11-11 to 2016-03-01 mean value of my computed ATR 250 normalized return is -0.01237755 while TSSB values give mean of -0.01529271. Do you experience the same (which would probably mean that the implementations differ)? Or did I make a mistake?

Hello and thanks for commenting. Are you sampling your data at the same time in both applications? Since foreign exchange doesn’t have an official closing time, make sure that the one you use is consistent across both applications. Also, I believe TSSB calculates this variable using open prices, which in theory shouldn’t differ from the previous day’s closing price. Unless of course there is a price gap between one day’s close and the next’s open, which can happen due to weekends and holidays. Can those ideas account for the differences you are seeing?

I have not actually run anything in TSSB myself. I like using R too much!

Hey and sorry for the late reply, I was without my laptop for a while.

I completely understand, it’s easy to fall in love with R!:) I also wanted to rewrite the stuff into R but after reading the whole book I decided to give TSSB a go because I saw how much work had already been put into it.

Or maybe I will combine the approaches somehow. I noticed there is an automation framework for TSSB written in Python which could be modified to handle both: R and TSSB (unfortunately it’s Windows only solution).

About the problem – it turned out it was only because at the end of TSSB returns vector there was bunch of NA values while my computed one had all of them. I should have checked the end of the data frame more carefully, stupid mistake.

Hi pcz

Where is “here is an automation framework for TSSB “? Did I miss something?

Jeff

[…] Whatever signals we’re using for predictors, they will most likely contain much noise and little information, and will be nonstationary on top of it. Therefore financial prediction is one of the hardest tasks in machine learning. More complex algorithms do not necessarily achieve better results. The selection of the predictors is critical to the success. It is no good idea to use lots of predictors, since this simply causes overfitting and failure in out of sample operation. Therefore data mining strategies often apply a preselection algorithm that determines a small number of predictors out of a pool of many. The preselection can be based on correlation between predictors, on significance, on information content, or simply on prediction success with a test set. You can find some practical experiments with feature selection here. […]

[…] https://robotwealth.com/machine-learning-financial-prediction-david-aronson/ […]

… [Trackback][…] Find More Informations here: robotwealth.com/machine-learning-financial-prediction-david-aronson/ […]

Hi Robot Master, great post! I was wondering if you thought about potential implication of using ATR normalized returns in your target, especially for feature selection. What I mean with that is; by normalizing with ATR you are introducing a strong recent volatility component in your target variable. And as any quant would appreciate volatility clusters heavily and therefore recent volatility measures popping-up in your best features across the board. (Maybe not only the time you redefined your target metric as profit where you only observed 2 variables.) And of course you can estimate volatility pretty decently utilizing some recent vola information but when it come to making a directional bet you won’t have much of an edge. What do you think? I just had a quick read of the post, so apologies if I am missing something. Keep up the good work.

Hi Erk

Thanks for the comment. You raise a very good point – by normalizing the target variable to the current ATR, a strong volatility component is introduced. This was actually a recommendation that Aronson makes in the book on which the post is based, but may not be the best solution, particularly in relation to feature selection. I’ve done some recent work using the raw first difference of the time series and found that the feature selection algorithms tend towards slightly different features under this scenario.

This suggests to me that there may be merit in using a differenced time series as the target variable during the feature selection phase, and then during the model building phase normalizing the target variable to the ATR so as to ensure volatility is included at some level in the trading model.

Thanks for commenting, great suggestion!

[…] a test set. Practical experiments with feature selection can be found in a recent article on the Robot Wealth […]

Thank you for a very thorough writeup of your very interesting work. I’m looking forward to the next installment. The recommended reading list is appreciated as well. (I hope you will consider making a separate blog entry of Recommended Reading so the books are easy to find in one entry.)

Hi Mike

Thanks for commenting. Great idea regarding the recommended reading list! I will make that my next post.

Really Thanks for posting these machine learning contents!

I’m trying to follow up and apply your posting using R.

but now, I get in trouble with making data table using variables in “Some candidate features”. I can see Zorro code in second post to make selected variables.

Since I’ve never learned the Zorro, I don’t understand how you make the variables in

“Some candidate features” .

Could you explain how did you make variables in “Some candidate features” using R?

I know this is time-consuming but I really appreciate if you explain about making variables…

Hi Sung

I created those variables using Zorro and then exported them for use in R. You can reproduce them using the descriptions in the section that you are referring to, whether that be in R, C, or some other language. If you get really stuck, shoot me an email using the contact form and I’ll send you an R implementation.

Hello, I’m sung.

I’m wondering what kind of data, lev, model(input) should be put in to operate the absretSummary function?

absretSummary <- function (data, lev = NULL, model = NULL) {

positions 5, sign(data[, “pred”]), 0)

trades <- abs(c(1,diff(positions)))

profits <- positions*data[, "obs"]

profit <- sum(profits)

names(profit) <- 'profit'

return(profit)

}

[…] it is never that simple. We have features to engineer and transform (no trivial task – see here and here for an exploration with applications for finance), not to mention the vagaries of dealing […]

Great post however…

1) cross validation

its not allowed to use cross validation for time series as simple it introduces future leak and bias. See Rob Hydman page https://robjhyndman.com/hyndsight/crossvalidation/

2) From my experience every subset of financial data will give you different features. The method which I use to find the best features is based on bootstraping and its called Neyman – Pearson method. Different features will be selected for BUY and different for SELL side so perhaps its good to split the selection.

3) I read the paper about Boruta method. I’m using filter methods based on correlation (FCBF) and mutal information (MRMR, JMI etc). Than I bootstrap those selection by Neyman-Person method. Wrapper methods (like Boruta) take too much time to compute so you can’t bootstrap them specially if you use big and many datasets.

Krzysztof

Krzysztof

Krzysztof

Hi Krzysztof

Thanks for reading my blog. Regarding your points:

1) I wouldn’t say its not allowed. But I agree regular cross-validation (k-fold, bootstrap, leave-one-out etc) is not suitable for financial data. I now use and recommend the time series cross-validation approach that is mentioned at the bottom of the link you provided. See my post on selecting optimal data windows for more information.

2) Thanks for the heads up re the Neyman-Pearson method. I haven’t used this, but I will look into it. I agree that different models for long and short sides may be a good idea.

3) I find Boruta to be quite useful for my applications. I also like the intuition behind the algorithm. Its only one of many possible feature selection algoirthms though and I’m sure your methods are great too.

Thanks again for reading.

Hello again,

ad 3) None of the methods is great or the best, just combining with Nyman-Person give you better chance that you will not end up not relevant at all feature after selection. But its just better chance…All this analysis of financial data is very slippery, after more than 5 years of applying ML algos to it my only conclusion is than only very extensive backtest on multiple data sets from different instruments can give the answer if something works better or not. You can just try to repeat your steps on series from different instrument or the same instrument but from different period and I guess you will get different results. (e.g. different features are relevant or different technique is better)

Krzysztof

[…] A.S.Sisodiya, Reducing Dimensionality of Data (2) K.Longmore, Machine Learning for Financial Prediction (3) V.Perervenko, Selection of Variables for Machine Learning(4) D.Erhan et al, Why Does […]

hello,i am tom. can you tell me how to use the function absretSummary in rfeControl and rfe? Thank you. absretSummary <- function (data, lev = NULL, model = NULL) {

positions 5, sign(data[, “pred”]), 0)

trades <- abs(c(1,diff(positions)))

profits <- positions*data[, "obs"]

profit <- sum(profits)

names(profit) <- 'profit'

return(profit)

}

Hey Tom

This is just a custom Summary function for use with the caret

`train()`

function. The Summary function is simply the objective function for the training process; this one trains the learning algorithm towards maximizing the profit at the end of the training period. You can easily write your own for maximizing the Sharpe ratio or any other performance metric of interest.Max Kuhn (the author of the caret package) explains the use of the summary function here. In particular, scroll down to read about the

`trainControl()`

function and alternative performance metrics.Hope that helps.

Great article! really good research in all aspects

is it possible to post the code showing how you make the training file (gu_data)?

Thanks,

Thanks for reading! I’ve added the code showing how I created the training file as an appendix. I created this code a while ago and have since added to it, so there are a bunch of other indicators and transforms that will be output to a csv file. You can pick out the ones that I’ve used in this post, or experiment with the others, as you like. The output file is called “variables.csv” and this is what I read into my training data object “gu_data” in this post.

Also, you will need to manually exclude some rows from the output file where indicator values are unable to be calculated due to an insufficient lookback period.

This code is written in Lite-C and is compatible with the Zorro platform, which is an awesome tool for doing this sort of analysis. Some exciting things you can do to extend my research by tweaking this code include:

1. Try other bar periods (I used daily)

2. If using daily bars, try sampling at a more sensible time (ie not midnight, as I have done here)

3. Obtain the same data for any market for which you have data by changing the

`asset()`

call towards the start of the script4. Use Zorro’s recently added pre-processing tools for better scaling/compressing/normalizing of the data than I have used here (these tools were added to the platform after I wrote this post)

5. Add other indicators or data that you are interested in

6. Experiment with longer prediction horizons. By default, I used a one-day prediction horizon. Could predicting further into the future give better results?

7. Try using a classification approach by changing the target variable from a return (a numerical value) to a market direction (a binary value).

8. Plenty more that I haven’t even thought of…

Hope this is useful for you.

Great work! Very good tutorial for beginner like me!

A small question thought, why did you times 100 to the price change of the target?

Thanks.

Hi David

No reason other than aesthetics. I just find it nicer to look at figures on the left of the decimal point. You’ll get the same results if you don’t multiply by 100.

Cheers

Kris

Hi Kris,

Thanks for reply.

Another small question bothers me while reading your post.

In “Removing highly correlated variables” step, we remained variables having correlation less than 0.5 with others. Then, why did some high correlation pairs still remain and show on the map? (f.i. velocity10 v.s. atrRat10 ; atrRat10 v.s. atrRat10_20)

Is there something possibly wrong?

Thanks.

Hello David

You can answer your own question very easily by looking into the documentation of the relevant function,

`caret::findCorrelation()`

. I’ll do the leg-work for you so that we have a reference here on Robot Wealth. From the documentation:The absolute values of pair-wise correlations are considered. If two variables have a high correlation, the function looks at the mean absolute correlation of each variable and removes the variable with the largest mean absolute correlation.The key point is that the function considers

mean absolute correlationsof each variable when the pair-wise correlation between them is higher than the threshold. The function will then remove the variable that has the highest mean absolute correlation with all remaining variables. This is not the same as simply removing any variable that has a pair-wise correlation with another variable greater than the cutoff value.Hope that helps.

Hi Kris,

I think the point is whenever two variables have a high correlation, one of them will be removed. The mean absolute correlations is just a way to decide which one would be cut out.

So, your correlation map shouldn’t have the pair like velocity10 to atrRat10 with large circle/high correlation. Otherwise, what’s the point for using the findCorrelation() and setting the cutoff ?

Hi David

The point is that the pair-wise correlations reveal useful information about the data. As do the results of the

`findCorrelation()`

function. Further, if there were many variables from which to select, the function is an efficient first step in processing them. Its also interesting to see which variables the function identifies for removal in relation to their pair-wise correlations with the remaining variables.I don’t see any basis to your statement ‘your correlation map shouldn’t have the pair like velocity10 to atrRat10 with large circle/high correlation.’ Why not? Does it not reveal useful information? Have I misrepresented the pair-wise correlations? I think you might be confusing the roles of the correlation map and the

`findCorrelation()`

function by assuming they represent the same thing, or perhaps you see them as being somehow contradictory rather than complimentary. I’m struggling to see where you’re coming from here.Hi Kris,

I don’t think I’m confused with the function and the map, but still thanks for the reply. I’ll think it through again and check my code.

[…] Machine learning for financial prediction: experimentation with Aronson’s work – part 1 … […]

[…] trading that is currently undergoing a huge upsurge in interest. I am of course referring to machine learning and artificial intelligence, which seems to have captured the imagination of both technologists and […]

Hi,

I’m an R beginner and trying to reproduce the results.

I don’t understand where the “gu_data_filt” variable is filled with data in the first small code block of the article.

Any help appreciated.

Thanks

Vincenzo

Vincenzo, you found an error – nicely spotted. There was a missing line of code which has been added.

Hi Vincenzo,

I suggest adding “highCor <- highCor+1;" before "gu_data_filt <- gu_data[, -highCor];", for your reference.

David,

Can you explain that suggestion? Why do you need to increment the values in the

`highCor`

object?It’s because we use cor(gu_data[, -1]), making highCor contained the wrong column numbers(all are 1 smaller) of removed feature. Adding 1 back so that we can get the correct result.

Nicely spotted! You are absolutely correct. I’ve updated the code accordingly. Note that this would alter the features which get passed through to the next feature selection stage.

Hi Kris,

If you have time can you update the article with the correct resulting features ?

Just to compare my results with yours.

Thanks

Hey Vincenzo,

You mean the features that fall out of the correlation analysis? Or the entire post? Sure, I’ll update the figures and results, when I can find the time.

Note however that there aren’t any ‘correct’ features – a better way to approach the problem is to think in terms of which features or combination of features are most useful for the problem at hand.

Hi Kris,

I mean in your reply to David pasted below, the resulting features are incorrect because of the code issue he outlined. Would be nice if you could update the article feature selection results after this fix.

Thanks for setting up a great interesting web site.

“Note that this would alter the features which get passed through to the next feature selection stage”

Understood. Yes, updating the post is on my radar. Might take me a week or two to find the time, but I’ll make sure it happens.

Thanks for the kind words.

Hi Vincenzo

In case you are following this thread via email, I’ve updated the post following David’s observations about the correlation filter.

Glad it helped. Looking forward to the updated result. Thanks for the good work.

Hi David,

In case you are following this thread via email, I’ve updated the post following your observations about the correlation filter.

Great post. I am facing a couple of these problems.

Hi Kris, thanks for releasing all the R code unified (including the GBM model), it’s very helpful and adds a lot of insight to the whole experimentation process.

Hi Paul,

My pleasure! Glad to hear it is helpful.

Cheers

Kris

Hi, thanks for the great article, but where is the link to download the scripts? In two places you say the scripts are available for download, but I can’t find any links.

Jimmy.

You’re most welcome. There’s a link at the top of the article, under Update 4. But you have to give me your email address in return. I promise not to spam you.

Predicting a single bar is bound to be problematic because of the aliasing noise. John Ehlers often points out that if you sample the data at one bar per day then the simple fact of sampling introduces noise that is significant for signal wavelengths less than 10 bars long.

I find the use of the normalize and zscore functions to be philosophically problematic for some sorts of data. As an example, lets take a value for the trend. Obviously if this value is positive, we have an up-trend. The problem is that normalize and zscore recenter the values around their mean, so a positive value might be transformed into a negative value. I’d be interested to see any studies on whether non-shifted values give better results.

Its only bound to be problematic if you accept that Ehlers’ digital signal processing paradigm is applicable to financial time series. My personal opinion is that it can be, at times and under certain conditions. I’ve taken parts of Ehlers’ approach and used it in my own work, but I’d be careful of treating it as dogma. After all, many of the frequency decomposition techniques referenced in his work were intended for stationary, repeating signals, not the type of data we typically deal with. Of course they can be adapted to the markets, but a flexible and open minded approach is required.

Regarding the scaling and normalizing question: but the fact that such data, in its raw form, is of a certain sign is only applicable to our understanding and perception of what that means. A machine doesn’t care about the sign in the sense that we associate it with an ‘up’ trend. It cares about what that data point means in relation to the other variables, in particular the target. But still, experimentation is the best way to explore such questions, and it wouldn’t be difficult to come up with a way to scale your data while preserving the sign. I’d love to hear what you find out.