Create my own forex data?

Discussions about trading the Forex markets.
Post Reply
LeviF
Roundtable Knight
Roundtable Knight
Posts: 1436
Joined: Mon Dec 22, 2003 12:24 pm
Location: Des Moines, IA
Contact:

Create my own forex data?

Post by LeviF »

If I have historical data for USD/CAD and USD/JPY, isn't it just some simple math to generate CAD/JPY? Am i overlooking anything important here?
sluggo
Roundtable Knight
Roundtable Knight
Posts: 2987
Joined: Fri Jun 11, 2004 2:50 pm

Post by sluggo »

Since USD and CAD are nearly 1-to-1, your math might possibly have a mistake that wouldn't be obvious in this case. Therefore I suggest you test out your math on some example problems in which no two currencies are anywhere near 1-to-1. Perhaps, JPY-ZAR-USD ?? See below:
Attachments
JPYZAR.png
JPYZAR.png (22.2 KiB) Viewed 10768 times
LeviF
Roundtable Knight
Roundtable Knight
Posts: 1436
Joined: Mon Dec 22, 2003 12:24 pm
Location: Des Moines, IA
Contact:

Post by LeviF »

Its pretty close, about 0.1% difference.
sluggo
Roundtable Knight
Roundtable Knight
Posts: 2987
Joined: Fri Jun 11, 2004 2:50 pm

Post by sluggo »

levijean wrote:Its pretty close, about 0.1% difference.
How many pips is 0.1%? (I'm not a forex trader and don't have this kind of information at my fingertips....)
Tim Arnold
Site Admin
Site Admin
Posts: 9015
Joined: Tue Apr 06, 2004 1:41 pm
Location: Boston, MA
Contact:

Post by Tim Arnold »

Here's some data of each cross currency, the actual JPYCAD and a calculated JPYCAD. Looks close, but not exact. Room for arbitrage I suppose.

Code: Select all

Date	    USDJPY	USDCAD	  JPYCAD	  Calculated
20080401	101.96	1.021500	0.010017	0.010019
20080402	102.36	1.014100	0.009900	0.009907
20080403	102.32	1.004700	0.009816	0.009819
20080404	101.60	1.009300	0.009929	0.009934
20080407	102.46	1.013400	0.009888	0.009891
20080408	102.57	1.013200	0.009874	0.009878
LeviF
Roundtable Knight
Roundtable Knight
Posts: 1436
Joined: Mon Dec 22, 2003 12:24 pm
Location: Des Moines, IA
Contact:

Post by LeviF »

Assuming a pip on the ZAR/JPY is 0.0001, then its 130 pips.
LeviF
Roundtable Knight
Roundtable Knight
Posts: 1436
Joined: Mon Dec 22, 2003 12:24 pm
Location: Des Moines, IA
Contact:

Post by LeviF »

I'm trying to revisit this method. Doing the math works ok at fixed points in time like the open and close. The highs and lows are trickier because they wouldn't occur at the same point. I wonder if there is a "good enough" method?
Post Reply