The whole process took two weeks on my system and I had to upgrade my hard drive to store these CSV files. So you will basically save two weeks, maybe a hard drive and if you help to keep this torrent alive for everyone -> win-win situation...!
If you want it, fire up your BitTorrent client (qTorrent is a decent one without adware) and get it. You should be selective about what you download. Not many will want to backtest with a variable spread on T1 data and hack Zorro to do this, so maybe deselect this file: T1_Forex_History_2006-2017_Bid_hack.7z
All data adds up to around 50 GB (compressed by 70%!)
If you find any mistakes in the dataset, please post your findings here!
Readme:
All credits to statsmage.com!
Do yourself a favor and enable NTFS compression for your Zorro History folder! It will save you 40% disk space!
This data comes in different packages:
Dukascopy started recording Tick Data between January 2003 and the December 2005, depending on the currency pair. The datatypes are M1, Tick Data Ask (Zorro default) and Tick Data Bid. The later can empower you to backtest on Tick Data with variable Spread. Details on statsmage.com or in the attached PDF "Zorro on Steroids III - Backtesting with Variable Spread.pdf"
The different torrent packages are:
-Tick Data Ask and Bid from January 2003 to December 2005 (some currencies records start in 2003 and some in 2005 -Tick Data Ask from January 2006 to December 2017 -Tick Data Bid from January 2006 to December 2017 -Tick Data Ask and Bid from January 2018 to June 2018 (will be replaced in January 2019 by the dataset of the complete year) -M1 Data from January 2003 to December 2017 -M1 Data from January 2018 to June 2018 (will be replaced in January 2019 by the dataset of the complete year)
Included are all Major Forex Pairs and all Crosses (all possible combinations of AUD, CAD, CHF, EUR, GBP, JPY, NZD, USD)
If you can afford the disk space and bandwidth, please don't delete the torrent and help to upload. I'm not willing to lever a potential several hundred gigabytes of upload from my private internet connection. -> Don't be a Leecher - become a Seeder and be awesome! ;-)
If you want to create these files, install python 2 from within the Cygwin setup. It didn't work for me when I installed it directly!
The original script published on http://statsmage.com/ works only with Zorro S. I edited the original script a little so you can use Zorro free in a two - steps process (or rather 3 steps if you count Tickdownloader in)
Set the time zone to (UTC) Coordinated Universal Time. Tickdownloader will export two identical CSV files (for example EURUSD_tick.csv and EURUSD_tick_UTC+0_00.csv). If you forgot this - the first file will contain the UTC time without daylight savings. You can easily delete the second file to save space during the process. Check "Automatic export to CSV" and only export tick data. The conversion to M1 will be done by the Zorro script.
Call the python script by opening the Cygwin Terminal. Enter "cd /cygdrive/d/zorro/strategy/dataconversion" if the python script is in D:ZorroStrategyDataconversion (without the quotes!) and press Enter.
Enter "python convert_all_assets.py /cygdrive/e/tickdata/" if your CSV files are in E:tickdata
Don't press any keys while the Cygwin terminal is active and a script is running. It might break the whole process!
If you want to optimally use your computer's resources, distribute the CSV files on different folders (as many as you have physical CPU Cores) and if possible on different physical hard drives as well, as the reversion step is limited by your hard drive's speed. An SSD really rocks here.
Edit the the ConvertData_all_assets.c script according to your needs (first couple of lines)
Re: Dukascopy T1&T6 files for all Forex Pairs and Crosses - get it!
[Re: Smon]
#473315 06/28/1811:5406/28/1811:54
I am interesed in the M1 data for forex crosses. Maybe I have missed something obvious (sorry if I have) but how to you update the assets.fix file with correct spread, price, etc?
Thanks!
Re: Dukascopy T1&T6 files for all Forex Pairs and Crosses - get it!
[Re: j45p41]
#476446 02/26/1918:5702/26/1918:57
My broker is FXChoice (MT4). I just created the attached AssetsFix.csv with this script:
Code:
// connect to your broker and click the "Trade" button.
// this script creates this file: /zorro/log/assets.csv
// replace your assetsfix.csv in /zorro/history/ with this file!
// (better make a backup of the old one, jsut in case you need it again!)
function run()
{
StartDate = 20180101;
EndDate = 20181231;
LookBack = 1;
BarPeriod = 1440;
while(asset(loop("AUD/CAD","AUD/CHF","AUD/JPY","AUD/NZD","AUD/USD","CAD/CHF","CAD/JPY","CHF/JPY","EUR/AUD","EUR/CAD","EUR/CHF","EUR/GBP","EUR/JPY","EUR/NZD","EUR/USD","GBP/AUD","GBP/CAD","GBP/CHF","GBP/JPY","GBP/NZD","GBP/USD","NZD/CAD","NZD/CHF","NZD/JPY","NZD/USD","USD/CAD","USD/CHF","USD/JPY")))
{
vars Price = series(price());
}
}
Last edited by sdh309795gaas; 02/26/1919:00.
Re: Dukascopy T1&T6 files for all Forex Pairs and Crosses - get it!
[Re: Smon]
#476450 02/27/1913:5002/27/1913:50
I just found out that the dataset has some gaps. AUD/CAD is really bad in 2008. Use the script below to detect gaps. I commented it out to check for other gaps:
Code:
function run()
{
StartDate = 20080101;
EndDate = 20120101;
BarPeriod = 15;
//"AUD/CAD",
while(asset(loop("AUD/CHF","AUD/JPY","AUD/NZD","AUD/USD","CAD/CHF","CAD/JPY",
"CHF/JPY","EUR/AUD","EUR/CAD","EUR/CHF","EUR/GBP","EUR/JPY","EUR/NZD",
"EUR/USD","GBP/AUD","GBP/CAD","GBP/CHF","GBP/JPY","GBP/NZD","GBP/USD",
"NZD/CAD","NZD/CHF","NZD/JPY","NZD/USD","USD/CAD","USD/CHF","USD/JPY")))
{
var tdiff = (wdate() - wdate(1)); //time difference in days of the last consecutive bars
//search for time differences at 1.5 times longer than BarPeriod:
if(tdiff > (BarPeriod/1440)*1.5 && tdiff < 1) //1 day = 1440 minutes....
{
printf("n%d-%02d-%02d %02d:%02d %s gap: %.0f minutes missing",
year(), month(), day(), hour(), minute(), Asset, (wdate() - wdate(1))*1440);
}
}
}
Re: Dukascopy T1&T6 files for all Forex Pairs and Crosses - get it!
[Re: Smon]
#476907 04/22/1913:1804/22/1913:18
I will start with the T6 data since the last release and then add all previous T6 data later. I will stop seeding the old torrents in a couple of weeks.
At the moment, something isn't working with the conversion from tickdata to T1. I couldn't find the error at a quick glance and I don't plan to fix it any time soon, as I don't need tickdata. If somebody will fix it, I will release tickdata. The scripts for exporting are included in the shared folder.
Strategyquants QuantDataManager which I'm using to get the tick data from Dukascopy isn't able to export the (average?) spread anymore. This is why the dynamic live spread isn't available anymore for all T6 files after 2018.
Thank you Smon! I can't get Resilio to work though.. windows firewall permissions, etc. I can't find any good guide to resolve or fix the firewall issues.
Last edited by OptimusPrime; 11/06/2011:09.
Thanks so much,
OptimusPrime
Re: Dukascopy T1&T6 files for all Forex Pairs and Crosses - get it!
[Re: Smon]
#481833 11/06/2015:4811/06/2015:48
Hi Smon, I read your post regarding Dukascopy data. Thanks for the effort you put into this issue. One question: do you still have t1 data from Dukascopy?
I would like to backtest Broker arbitrage, therefor I need a second brokers tick data (I already have FXCM t1 history from the major pairs). Would appreciate that.
Thanks in advance for your answer.
Simon
Re: Dukascopy T1&T6 files for all Forex Pairs and Crosses - get it!
[Re: Smon]
#483081 05/01/2118:1005/01/2118:10
Thank you, you are so generous to share your data with all of us, Smon - I also think similar to you: When having done a long task, why not share it with others? If more people would be like you, the world would be a better place !
The only problem now is that I did download the torrents and a client and that torrent seems to be dead now - 5years after it started. So if anyone knows about other sources of such data, please revive this thread and share yours. Thank you.
Re: Dukascopy T1&T6 files for all Forex Pairs and Crosses - get it!
[Re: Smon]
#487710 08/07/2312:0108/07/2312:01
@YesNotes, you are right! I stopped the torrent on my side and didn't provide the link to the ResilioSync folder. Sorry for that! I must have assumed, that nobody is really interested in the TickData. So here ist the ResilioSync link. Please note that I stopped releasing Tickdata after 2018, as I don't need it for myself.
Thank you, you are so generous to share your data with all of us, Smon - I also think similar to you: When having done a long task, why not share it with others? If more people would be like you, the world would be a better place !
The only problem now is that I did download the torrents and a client and that torrent seems to be dead now - 5years after it started. So if anyone knows about other sources of such data, please revive this thread and share yours. Thank you.