Quote from NickBarings:
Anybody has any numbers oe an estimation on this correlation ?
Hey Nick,
Here is your answer. You want numbers? Why don't you do your own calculations? Even if somebody actually gave you figures here, why would you trust any other sources than your own research?
Just go into Excel and figure out correlations yourself. Do it with the "CORREL" function, look it up in help if you don't know how, any kid could do it. There's lots more statistical analysis functions, like covariance, anova, F-Test, cumulative frequency histograms, fourier analysis, regression analysis, sample-based standard deviation, you name it, more than you could ever need.
Here's an example correlation calculation I just did on the quick in Excel, testing the correlation between one month of the OHLC of 5 minute-bars on 5 indices (ES, ER2, NQ, YM, DAX). In order to do that, I set a chart (in eSignal) to one time template, selected only the OHLC average (via OHLC-1MA) in the export window, exported the data into excel, and crunched the columns.
Here are the top 10 results for correlation coefficients:
DAX/ES 0.9355
YM/ES 0.9279
ES/AB 0.9123
DAX/AB 0.9121
DAX/YM 0.7783
YM/AB 0.7607
AB/NQ 0.7283
DAX/NQ 0.6529
ES/NQ 0.4829
YM/NQ 0.1873
As you can see, the ES & DAX are extremely highly correlated (so what's new), followed by ES-YM, ES-ER2 etc. On the other end of the scale (surprise, surprise) the ES-NQ correlation is rather low, and the YM-NQ correlation is almost insignificant. Incidentally, the calculations for just the actual bar closes are almost identical.
Generally speaking, I would call anything >0.8 a high correlation, and >0.9 very high. 1.0 is identical and 0 is completely un-correlated. Negative values for negative correlations (i.e. crude oil price & airlines, prosperity & Bush, etc...)
For purposes of intraday index arbitrage, spreading, trading divergences, modelling options etc, I would look where correlations are >0.9.
This is not to say that any of this data is actually significant (it's up to you to find the good stuff yourself), but now you know how to actually test various issues of all kinds (indices, stocks, currencies, commodities etc) against each other for correlation, in various timeframes, with different parameters etc. Keep quantifying, and you'll find some amazing things. And you'll no longer be dependant on ET for answers (and flames).
Enjoy!
Scientist