Calculating Correlations Yourself

The best way to keep current on the direction and strength of your correlation pairings is to calculate them yourself. This may sound difficult, but it's actually quite simple.

To calculate a simple correlation, just use a spreadsheet, like Microsoft Excel. Many charting packages (even some free ones) allow you to download historical daily currency prices, which you can then transport into Excel. In Excel, just use the correlation function, which is =CORREL(range 1, range 2). The one-year, six-, three- and one-month trailing readings give the most comprehensive view of the similarities and differences in correlation over time; however, you can decide for yourself which or how many of these readings you want to analyze.

Here is the correlation-calculation process reviewed step by step:

1. Get the pricing data for your two currency pairs; say they are GBP/USD and USD/JPY
2. Make two individual columns, each labeled with one of these pairs. Then fill in the columns with the past daily prices that occurred for each pair over the time period you are analyzing
3. At the bottom of the one of the columns, in an empty slot, type in =CORREL(
4. Highlight all of the data in one of the pricing columns; you should get a range of cells in the formula box.
5. Type in comma
6. Repeat steps 3-5 for the other currency
7. Close the formula so that it looks like =CORREL(A1:A50,B1:B50)
8. The number that is produced represents the correlation between the two currency pairs.

* source - http://www.investopedia.com/articles/forex/05/051905.asp


Learn More, Watch Video - Get 15-day Free Trial
Join FreedomRocks - Earn More, be a Representative

.