Note: this article is meant for users with a working knowledge of the Windows command line, file system, application arguments and so on. If you are not familiar with these, it would be a good idea to read some material about them before proceeding.
Starting with v2.2.41, the Tick Data Suite permits exporting tick data using the command line.
If you have tick data export tasks that you find yourself performing frequently it is quite easy to create batch files or shortcuts that perform the required exports automatically.
In order to do that, you must first configure the export format. You can do that by opening the Symbol operations dialog in Tick Data Manager, navigating to the Export ticks tab, configuring the export as desired and finally clicking the Save configuration button. Make a note of the saved file name and location – you will need that for the command line parameters.
Once you have the export format file, the following command line options are available for exporting data:
- /eformat:file_path_and_name – used to specify the export format file. Examples:
/eformat:C:\export\custom_tick_export.tcf/eformat:"D:\export files\custom_tick_export.tcf"– if there’s a space in the file name or path, be sure to quote it. - /output:folder_path – used to specify the output folder. The exported files will be automatically named based on the source, the symbol and the exported period. Any existing files will be overwritten. The folder specified must already exist. Examples:
/output:C:\export\out/output:"D:\export folder"– if your path has spaces in it you need to quote it. Be sure not to add a trailing backslash in this case because it would get interpreted by the shell as an escape character for the following quotation mark. - /export:source:symbol[,symbol2,symbol3,…]:[start_date-end_date] – exports the tick data for the specified symbols from the specified tick data source. If a time period is specified, the export is limited to that time period. The dates specified must use the format YYYY.MM.DD. Examples:
/export:Dukascopy:EURUSD– will export the all the EURUSD tick data downloaded from Dukascopy./export:TrueFx:GBPUSD,USDJPY:2010.01.01-2011.12.31– will export the GBPUSD and USDJPY tick data downloaded from TrueFx for the 2010-2011 period./export:FxOpen:*– will export all the data for all FxOpen symbols that have any downloaded data.
Complete example:
"C:\Program Files (x86)\eareview.net\Tick Data Suite\Tick Data Manager.exe" /export:Dukascopy:EURUSD,GBPUSD:2019.01.01-2019.12.31 /eformat:C:\export\format.tcf /output:C:\export
These options can be added to the target part of a shortcut or alternatively a .bat file can be created.
Finally, it’s important to note that attempting this procedure will fail if you already have an instance of the Tick Data Manager running.