Data Files: Merge Tool

We’ve created a small tool that allow you to merge any of our HistData.com CSV files into a unique file. This tool merges only CSV files.

For more information about the HistData.com file formats, please, go to:

http://www.histdata.com/f-a-q/data-files-detailed-specification/

So, you may merge the several files you’ll be able to download at www.histdata.com into one unique .CSV file by following the next instructions.

What do you need to have to run the tool?

You need to have Java 8 working on your machine and download the tool clicking here: histdata-filesmerger-0.3.jar

To check if you have Java 8 installed, open a command line tool and type:

java -version

It will return the Java version if Java is correctly installed.

How to get the tool?

Simply download the tool clicking here: histdata-filesmerger-0.3.jar

How to execute the tool?

You’ll need to have a folder where you’ll write the new and merged file.
Then, you’ll need to have one folder where you’ll have all the .Zip files downloaded from HistData.com and those files should belong to the same format.

Example:
1) you cannot have, in the same folder, M1 ASCII .Zip files for EUR/USD mixed with other forex pair files.
2) you cannot have, in the same folder, M1 ASCII .Zip files for EUR/USD mixed with Tick Data ASCII .Zip files for EUR/USD.

But, you can have several other folders, separated, each for its correspondent format/pair.
So, after having the folder with your files, you may execute the tool.
If all is ready, let’s move on.

Unzip the histdata-filesmerger-0.3.jar from the downloaded histdata-filesmerger-0.3.jar_.zip file. This is the tool file that you’ll need.

Then, to execute the tool:

1) Open a command line tool

2) Execute the tool:

Usage:

java -jar histdata-filesmerger-0.3.jar "[Original Zip Files Folder]" "[Destination Csv File Folder]" "[Destination Csv FileName]"

Execution example:

java -jar histdata-filesmerger-0.3.jar "C:/work/my/files/data/EURUSD/M1" "C:/work/my/files" "FILE_DUMP_EURUSD_M1.csv"

Then, you’ll get the file C:/work/my/files/FILE_DUMP_EURUSD_M1.csv with the contents of the .csv files from the .zip’s that may be in: C:/work/my/files/data/EURUSD/M1

That’s it. Enjoy!

Comments are closed.