This is an old revision of the document!
In order to produce a file export, follow the steps described below:
1. Select the begin and end date range for which you wish to generate data for. You can choose the “quick pick” buttons such as “Last 1 year” to quickly select a date range. NOTE: If you specify a date range for which you have not downloaded data for, the system will automatically download the data for you. There is no need to explicitly download data first.
2. Select the time-frame of the data export. If 'Tick' is selected, then you will be outputting detailed tick data. If you select '15-minutes', then you will produce an extract with 15-minute candle data.
3. Select the time-zone for the time-stamp that will be output. If you select GMT time, then all the timestamps will be in that timezone. If you select “UTC 6:00 - Central time (US & Canada)”, then the time-stamp will be in that time-zone, automatically accounting for any daylight savings shifts.
4. Define your output format. This allows you to specify the format of the file, including what format time will be output, the fields (bid, ask) etc, that will be output as part of the extract. For convenience, Tickstory provides a selection box of predefined formats including:
5. Define your output filename. When exporting multiple symbols, you can use a special token {Symbol} so that each file will be named according to it's symbol. For example, specifying:
{Symbol}.csv
will create a separate file such as EURUSD.csv, USDJPY.csv and so forth for each exported instrument. Unless otherwise specified, the files will reside in the current working directory (i.e. where the application is installed). See the section on 'Special tokens' for more information on how to tailor your output filename.
6) Press the OK button. Once you do this, the status bar next to the symbol(s) you are generating extracts for will display their percentage complete. Once it's done, your export file is ready for use in Excel or your trading platform of choice.