Forex Currency Correlation Calculation
Here is the correlation calculation process reviewed step-by step:
1. Get the pricing data of two currency pairs.For example the EUR / USD and USD / CHF.
2. Make two columns, each labeled with one of these pairs. Then, fill the columns with the latest prices that occurred a day for each pair during the period under forex review.
3. At the bottom of a column in an empty space, type = Correl (
4. Highlight all the data in a column of prices, you must obtain a range of cells in the formula box.
5. Add a comma.
6. Repeat steps 3-5 for the other currency
7. Close the formula so that it looks a = Correl (A1: A40, B1: B40)
8. The number represents the correlation occurs between the two currency pairs.
Although the correlations change, no need to update your numbers every day, updating once every week or at least once a month is usually a good idea.
See part 1: Forex Currency Pair Correlations
Saturday, July 10, 2010
Forex Currency Pair Correlations
Forex Correlation Strategy
One possible strategy would be the investment of 2 currency pairs based on the correlation of the reversal. You can track the correlation of 2 pairs of currencies over time and if it escapes from the norm can reverse direction to grip to fit the correlation again.
For example, if the EUR / USD and USD / CHF has a correlation of -. 90 and the EUR / USD has high volatility, while the USD / CHF is not moving much, you can go short on EUR / USD and USD / CHF and for the correlation to retake following the fall of the EUR / USD and USD / CHF to reverse correlation to the historical average. Of course, we must take into account that the correlation is not stagnant and there is no guarantee that will always return.
Assuming you already have an open forex account.
Forex Correlations
It is evident that the correlations change, which makes following the change of the correlations are equally important to global economic changes, as they are very dynamic and can change even from day to day.
Strong basic correlations might not be consistent with the longer-term correlation between two currencies. This is the reason why it should be noted the six-month correlation.
This is the advantage of an automatic system. Also very important is the proportion of a clearer perspective of the average six-month relationship between the two pairs of currencies, which tends to be more accurate. The correlation changes for a variety of reasons. The most common discrepancies are monetary, sensitivity to commodity prices and the economic and political factors.
See part 2: Calculating Forex Correlation
One possible strategy would be the investment of 2 currency pairs based on the correlation of the reversal. You can track the correlation of 2 pairs of currencies over time and if it escapes from the norm can reverse direction to grip to fit the correlation again.
For example, if the EUR / USD and USD / CHF has a correlation of -. 90 and the EUR / USD has high volatility, while the USD / CHF is not moving much, you can go short on EUR / USD and USD / CHF and for the correlation to retake following the fall of the EUR / USD and USD / CHF to reverse correlation to the historical average. Of course, we must take into account that the correlation is not stagnant and there is no guarantee that will always return.
Assuming you already have an open forex account.
Forex Correlations
It is evident that the correlations change, which makes following the change of the correlations are equally important to global economic changes, as they are very dynamic and can change even from day to day.
Strong basic correlations might not be consistent with the longer-term correlation between two currencies. This is the reason why it should be noted the six-month correlation.
This is the advantage of an automatic system. Also very important is the proportion of a clearer perspective of the average six-month relationship between the two pairs of currencies, which tends to be more accurate. The correlation changes for a variety of reasons. The most common discrepancies are monetary, sensitivity to commodity prices and the economic and political factors.
See part 2: Calculating Forex Correlation
Subscribe to:
Posts (Atom)