I'm attaching a spreadsheet with April correlations for all pairs I had access to (31 pairs on Alpari) with corresponding scatterplots.
If you didn't know how to calculate your own correlations, take a look at my spreadsheet and you will be able to do it as well.
I plan to calculate 6 month and 1 year correlations as well, when I'm finished, I'll post the spreadsheets here as well.
Anybody has any other ideas on how we can further explore these besides scatterplots?
edit: I updated the spreadsheet, I included a few extra days from this month into the previous month's calculations by mistake.The new spreadsheet has the error corrected.
If you didn't know how to calculate your own correlations, take a look at my spreadsheet and you will be able to do it as well.
I plan to calculate 6 month and 1 year correlations as well, when I'm finished, I'll post the spreadsheets here as well.
Anybody has any other ideas on how we can further explore these besides scatterplots?
edit: I updated the spreadsheet, I included a few extra days from this month into the previous month's calculations by mistake.The new spreadsheet has the error corrected.
Attached File(s)
1monthcorrel.xls
271 KB
|
327 downloads