
Mathematical Relationship between Forex pairs 2 Attachment(s) I posted this in my Journal, but thought it would be useful for a broader audience. Attached is an Excel spreadsheet that shows the calculated price relationships between the 7 majors and 22 crosses....a snapshot of the spreadsheet is shown below. Basically, the spreadsheet shows how the rate for any given currency pair can be calculated from many different pair sets, i.e. the mathematical dependency between all pairs. The exchange rate data is from late October, but you can input current exchange rate data if you wish.. I posted this because when reading through the forums, it seems that some traders are under the impression that exchange rates are completely independent of one another...not true... Please note that in several calculations, you need to take the reciprocal of the rate data. For example, to calculate the following rate data for: EURJPY x CHFJPY = EURCHF You need to take the reciprocal of CHFJPY: EURJPY = 133.53 CHFJPY = 122.95 = 1/122.95 = 0.0081 133.53 x 0.0081 = 1.0861 = EURCHF At the time of the above calculation, the bid on EURCHF = 1.0860 Hope that some folks find this useful.... Dave Mathematical Relationship between Forex pairs.xlsx 
I personally could not agree more ,the intertwined relationships within a selected basket are far more revealing than the correlations show.they for the best part beat as one. One such example would be early indications of break outs,establishing range can be determined along with volatilityand momentum to name a few 
Hi Dave, Yep! In fact, if you write the symbols in the "standard" notation, i.e. using a slash (like this EUR/USD), then actually the math works out exactly as it would in algebra. Then, the times when you need to take the reciprocal are obvious. In fact, you just divide instead of multiply. In basic algebra, if you have A/B times B/C, then the Bs cancel out and you get A/C. Similarly: (EUR/USD)*(USD/JPY) = EUR/JPY Also, in basic algebra, if you have A/B divided by C/B, then the Bs cancel again to give you A/C. You could also think of (A/B)/(C/B) as (A/B)*(B/C), the normal rule of dividing fractions as multiplying by the reciprocal. Similarly: (EUR/JPY)/(CHF/JPY) = EUR/CHF or rather (EUR/JPY)*(JPY/CHF) = EUR/CHF ... note the reciprocal in the second version. Pure math! 
2 Attachment(s) Here are the basic rules in a more mathematicallyfriendly notation: In fact, it is because of these rules that currency pairs are written as little fractions, like GBP/USD. 
Something cool on this topic! Inserted Video 
1 Attachment(s) That is interesting, alphaomega. I don't see why he's plotting some things in the negative quadrants because all the exchange rates are positive, whether you take the reciprocal or not. But I do see why those points all have the same slope (when he drew the line throgh those three points). When the xvalue is the exchange rate with respect to the USD and the yvalue is the exchange rate with respect to the EUR, then the slope between any two points will equal the EUR/USD exchange rate. Here's a proof for the slope between the CHF point and the JPY point. (You could do the same for the slope between the CAD point and the CHF point or any two distinct points and you'd get the same thing.) Remember from high school math that the slope between two points is the change in yvaules over the change in xvalues. Also, to go from step two to step three, I just multiplied the numerator and the denominator by CHF and by JPY, (in other words, by CHF*JPY). Then I just factored out the EUR from the numerator and factored out the USD from the denominator. Finally, I cancelled the CHF  JPY. 
So, for example, if EUR/JPY makes a breakout on some small scale, and USD/JPY remains basically unchanged, that is not an early signal that EUR/USD will not make a breakout. In fact, EUR/USD would have made its breakout at the same time as the EUR/JPY did. Furthermore, even if EUR/JPY does shoot up before EUR/USD (again, assuming that USD/JPY is unchanged), does that mean that EUR/USD will have to shoot up soon to stay in line, or does that mean that EUR/JPY will have to drop back down to stay in line? So unless you want to get into the arbitrage game (and you'll need lots of money, expensive equipment, and a zerolag connection to the market), then I'm afraid these relationships won't help you much. I could be wrong, though. And if there's a relationship anyone would like to explore, I'd be happy to provide some mathematical insight, if I can. 
Hi Mathematician, Thanks for the clearer algebraic expressions...by convention I just leave out the "/ " sign, but nonetheless you are right that the relationships themselves don't give you an edge (other than stat arb). But for hedging purposes, it's useful to know what those relationships are in order to minimize swap costs..plus, as diceman555 pointed out, you can set up some interesting basket trades... Dave 
Dave and Diceman, Yeah, that's true: It's good to know the cheapest (lowest overall spread) way to trade the pairs you ultimately want to trade. For example, maybe some brokers have a higher spred on, say, AUD/CAD then the spread on AUD/USD and USD/CAD combined, so then it would be cheaper to "factor out" AUD/CAD and trade your position across AUD/USD and USD/CAD. That's true, Dman, you could get some intersting baskets going. Personally I find that it's helpful to look at basic correlations just so that you don't have too much redundancy the list of markets you watch. I don't even bother with doing an exact, numerical calculation of the correlation between all pairs. I just zoom out on a daily or weekly chart and compare the basic flow of price. If I see one pair making a huge uptrend across that time, another pair making a big 'V', and another just range bouncing all over the place, then I know these pairs move rather independently of each other, so I know I'm not overexposed in one currency or another if I happen to have trades in all of them going at the same time. 
for example (not actual value, some segment trend on the candle chart, with certain inclination : sometimes) ; usd/chf = ((dollar index(eur/usd)) x height) / sin(theta) + y where y is a constant. 
Likewise, some crosses like EUR/CHF (as long as SNB is not intervening!!), AUD/CAD and to a slightly lesser extent AUD/NZD are highly ranging unless one or both of the underlying USD counterparts are moving strongly. 
2 Attachment(s)
Are you familiar with calculus at all? Even just high school or firstyearuniversity calculus will do. It's all related to the product rule and quotient rule for derivatives. The Product Rule for Derivatives Let's start with the product rule, which is the rule we have to use when one pair is composed of a multiple of two other pairs. For example, EUR/JPY = (EUR/USD)*(USD/JPY). In general, we can just write it like this: C = A*B. So some currency pair, C, is the product of currency pair A times currency pair B. Now we will take the derivative with respect to time. (Remember that a derivative is basically a measure of how one variable changes with respect to another. So when you do a derivative with respect to time, you're looking at how that variable changes through time.) Below, I've first shown the derivative using the product rule for general currencies A, B, and C in calculus notation. Then I write a simplified version just using "Delta" to represent the change in some value. Finally, I wrote it out for the example of EUR/JPY = (EUR/USD)*(USD/JPY). What this means is this: The change in EUR/JPY (say the change between the open and close for a particular day) is equal to the closing price of EUR/USD on that day times the change in the USD/JPY over that day, plus the closing price of USD/JPY on that day times the change in the EUR/USD over that day. Remember that the change should be calculated as final price minus initial price, so Close  Open. For example, if we look at EUR/JPY, EUR/USD, and USD/JPY for November 9th, here's what I get: Inserted Code EUR/JPY: open 132.87 close 132.38 ∆EUR/JPY 0.49 EUR/USD: open 1.0769 close 1.0743 ∆EUR/USD 0.0026 USD/JPY: open 123.38 close 123.22 ∆USD/JPY 0.16 ∆EUR/JPY based on the product rule ∆EUR/JPY = (EUR/USD)*(∆USD/JPY) + (USD/JPY)(∆EUR/USD) = (1.0743)*(0.16) + (123.22)(0.0026) = 0.49226 As you can see, ∆EUR/JPY as calculated from the derivative is very close to the actual change between the high and low that happened over that day. There will be a slight discrepancy because we're looking at a large change over a long period of time (one day), but derivatives are supposed to represent instantaneous changes, therefore this is just an approximation. Normally to make your approximation more accurate, you could look at the change over a smaller period of time, so you could try looking at the change over just one minute. However, that will not really work with the market data we get because we don't really get a precise measurement of the change. The smallest unit we can get is usually one pip. In fact, calculus is designed to work with continuous values, but prices are actually discrete since they move in wholenumber multiples of pips (pipettes at best). We don't have the full richness of the real numbers. Nevertheless, it's pretty interesting to see how this approximation is pretty good. The Quotient Rule for Derivatives Now we have enough background to talk about GBP/NZD and why it seems to be affected more by changes in NZD/USD than by changes in GBP/USD. The key lies in the fact that GBP/NZD = GBP/USD divided by NZD/USD. It's not a product of the other two pairs; it's quotient, so we have to use the quotient rule for derivatives. In general, we can just write it like this: C = A/B. So some currency pair, C, is currency pair A divided by currency pair B. Again, we will take the derivative with respect to time, but the derivative of a quotient is quite different than the derivative of a product. As before, I've first shown the derivative using the quotient rule for general currencies A, B, and C in calculus notation. Then I write a simplified version just using "Delta" to represent the change in some value. Finally, I wrote it out for the example of GBP/NZD = (GBP/USD)(NZD/USD). I'm too lazy to find prices and write out a numerical example for this one, but notice how this formula is different from the product rule: In this case, the denominator of the whole fraction is the price of NZD/USD, and not only that, but it's squared in the denominator! So changes in the NZD/USD will have a bigger impact than changes in GBP/USD. 
Excellent posts Mathematician!!! As I said previously, we should be able to use this information to develop a balanced basket such that it earns a consistently modest profit with "mitigated" risk due to multiplepair hedging...and we can make the basket so that swap is in our favor, or at least that a net negative swap is minimized. A new project! Dave 
The problem is no exposure: equity won't change. Regards, EZ 
I don't think I understand what you mean by "swap" in this context. 
I find these relationships interesting, but I don't really use them because I don't think they can give me any sort of edge. In fact, this sort of overanalysis tends to get in the way. I think it was said best by Brian Monieson. A quote from Alexander Elder's Come Into My Trading Room:

Hi EZ, The few baskets I've been testing are not "net zero" exposure, albeit the number of units in each triangular hedge is volatilityadjusted (relative to the most volatile pair in the hedge) such that the high low equity swings of each triangular hedge is very minor. But I believe that's the advantage... you pool enough of these triangular baskets together and let them run (EURAUD(s)+AUDCAD(s)+EURCAD(b)), (GBPNZD(b) + GBPAUD(s) + AUDNZD(b)), (USDJPY(b)+USDCAD(s)+CADJPY(s)), etc...the equity sum of the total basket is generally net positive, with very low drawdown. Use 1% equity to open each pair and close the entire basket once the %gain is equal to ~0.51% of your equity. Not a "get rich quick" by any stretch of the imagination, but profitable nonetheless... 
So in the case of EUR/AUD  when AUD/USD was .9, that meant a square component in the denominator of .81 yielding a 1.23x multiplier effect from it. Now that we have AUD/USD at .7, the .49 square gives a 2.04x multiplier effect Similarly NZD/USD when it was .85 was giving 1.39x versus 2.37x at 0.65. Both currencies affecting twice as much now! 
Mathematician, Have you ever looked at cointegrated pairs and triplets? I did some work on it a while back, and will revisit after my current projects are finished and trading. Basically I did this: 1) Download 1 year of hourly closing data on 25 currency pairs. This is done daily. 2) Use R (an open source statistical analysis program) to merge all by Date / Hour 3) Remove missing data fields (4) and below are for 2 pairs X and Y, but if you do 3 pairs X, Y, and Z its similar ... just a bit more complicated 4) Run a linear regression of each pair against all other pairs to calculate the trading coefficient. Side note: For 2 pairs, I run principal component analysis so the coefficients are reciprocals of each other. So if I run linear regression of X on Y, when I do Y on X the coef. are inverse. For 3 pairs, I do X vs. Y and Z to get 2 coef. 5) Calculate the spread. For 2 pairs, spread = X  Coef * Y 6) Run the Augmented Dickey Fuller test to see if the spread is mean reverting (Pvalue < 0.05) 7) Calculate mean value of spread for past 1 year, and +/ 1 and 2 stdev lines 8) Save all of this to output (only mean reverting spreads), so I can sort in Excel 9) Look for cointegrated pairs below 2 stdev to buy, exit at mean. Viceversa for shorts. Ex: If I have AUDCAD  0.3EURCHF as the spread, and its at 2.1 stdev, I would buy AUDCAD and short 0.3 units of EURCHF (for every unit of AUDCAD). 10) Exit at the mean value of spread I want to improve this more by looking at short term trends on 5, 15 min charts to enter long AUDCAD, and short 0.3 units of EURCHF. My EA can do that. Anyway, just a project I have on the back burner. Have you ever done anything like this? Regards, EZ 

© Forex Factory