Where Do I Get Forex Historical Data?

December 28, 2007 by Trader Rich 

I've had a bunch of inquiries on where I obtain my forex historical data so I figured it's best to address it right here.  

In my 2+ years of backtesting experience, I've found a variety of forex historical data providers.  Some have been good, some bad.  I have only paid for historical data once and it was cheap, $134.99 cheap.  The major issue with this data is that it's indicative and has holes.  For those of you that don't know what indicative data is, it's data compiled from multiple providers so the prices could reflect either the median or average price.  This is not a true reflection of what's going on when you're trading.  Indicative data in my opinion is useless.  Unfortunately, you'll find this mostly in Foreign Exchange since their is no centralized exchange.  If you're really interested in this data, you can find it at http://disktrading.is99.com.

The ultimate goal is to find forex data that is not indicative.  A decent source is at Gain Capital where you can download historical tic data from 2000-present.  It's a whole lot of data since it's tic but it's not indicative so it's useful.  The major issue is that it's going to take you a long time to download (Gain throttles bandwidth I believe) and clean it up.  This is from someone I received an email from today but his issues were the following:

  1. Some of the files were stored in 16bit unicode and not UTF8
  2. Spans of data overlaps
  3. 2005 is possibly missing chunks
  4. Somewhere in 2006, the CSV started using quotes at random which broke his parser

Like I said, it's going to take you a lot of time to get this data in a usable format but it's not bad.  You can find it at ratedata.gaincapital.com (Gain capital is forex.com)

Another decent provider of free forex historical data is at Forexite.  This data is also not indicative and spans back to 2001.  It's 1-minute OHLC data (Open, High, Low, Close.)  The only minor issue with this data is that it's in GMT +1.  Your backtesting has to take this into consideration.  All I did was write a script to convert the time to EST once it was imported into the database.  The time zone differences can get confusing sometimes and I didn't want this to get in the way of my actual backtesting logic.  Interested?  You can find this data at http://www.forexite.com/free_forex_quotes/forex_history_arhiv.html.

Another option is to export the data right out of Metatrader from whatever broker you connect to.  The only issue with this is that the intraday data doesn't go back more than 2 years at the most. 

Once I have all the forexite data imported into a database for the 17 different currency pairs, I'd think about offering it out to the public for download but this wouldn't be until after it's been checked for holes.  

Popularity: 5%

Comments

7 Responses to “Where Do I Get Forex Historical Data?”

  1. CCC on December 29th, 2007 2:22 am

    Minor comment - the ratedata.gaincapital.com link doesn’t work (although it’s quite easy to work out where to go). All in all a a very useful article though thanks ;-)

  2. Rich on December 29th, 2007 2:36 am

    Thanks For the heads up CCC. It’s fixed.

  3. Craig on December 29th, 2007 5:39 pm

    The intraday data on my IPFX account goes back to around 2000 for both EURUSD & GBPUSD.

  4. Rich on December 29th, 2007 5:50 pm

    Craig, what is IPFX?

  5. Craig on December 29th, 2007 6:55 pm

    Sorry, typo, IBFX.

  6. Rich on December 29th, 2007 9:06 pm

    I checked IBFX through Metatrader today and found the limitation exists for all intraday data. M1 has 65000 (2 months) M5 has 32000 (5 months), M15 has 16000 (8 months), M30 has 16000 (16 months), M60 has 16000 (32 months), and M240 has 10000 (81 months) ??

  7. Craig on December 29th, 2007 11:06 pm

    How are you establishing the above time frames? Looking in the ‘History Center’ can be misleading, for example when I look at my 1M data it only seems to go back about 2 months but when I run a test on 1M data the trades start in 1999.

Feel free to leave a comment...
and oh, if you want a pic to show with your comment, go get a gravatar!