Correlation spreadsheet anyone?

Hi All,

I was wondering if anybody had a spreadsheet which could show the
correlation between markets fed to it through MT4, to update daily.
I'm reallly crappy at excel so if anyone would be kind enough to post one that would be bonza! I was hoping to include various markets aswell including grains, oil and gas, indexes etc. But if theres such a thing lying round for Forex markets I'm sure I'll figure out how to expand it from there.

Thanks,

Ed

I love correlation, check out these links:
http://www.mataf.net/en/analysis-cor...etVsMarket.htm
http://www.understandmarket.com/index.php?categoryid=55

Thanks Sidus,

I had seen those before, which was what piqued my interest in the use of correlation in the first place, do you have any specific plays relating to correlated pairs? I believe that many people use the CHF to hedge exposure to Euro?
Anyway any excel expert out there who could point me in the right direction would be greatly appreciated.

Ed

For MT4, why don't you just write an indicator that computes the correlation between two pairs directly?

You can plot the correlation and use it on any pair, timeframe, and period of your choosing.

I liked when they had the 5, 20, and 100 day correlations.. Any ideas how to view those on their site now? Seems they only offer 1H and Daily.

David

Is that indicator available for download?

Hi,

I was hoping to have this in an updateable spreadsheet form so as to be able to instantly see which instuments I should avoid holding simultaneously, the reason for not writing an indicator is firstly that I don't know how, but also I would like to keep the charts as clean as possible. If anybody can point me in the right direction, thanks in advance.