generating_a_file_export
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
generating_a_file_export [2016/12/18 20:22] tickstory |
generating_a_file_export [2018/09/14 11:40] tickstory |
||
|---|---|---|---|
| Line 12: | Line 12: | ||
| 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. | 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. | + | 3. Select the timezone for which all time-stamps will be adjusted to. By default, the time-zone shift is set to 'None' which means that the time will remain in the instrument's native time-zone. The native time-zone can vary for each symbol. For Forex pairs, the native time-zone is usually UTC. |
| - | + | By selecting a specific time-zone, you will convert all the time-stamps to that timezone including any daylight-savings (DST) shifts that may be applicable. For example, if you select "EST +7:00 - New York Trading time", then the all bid/ask/OHLC time-stamps will be in that time-zone, automatically accounting for any daylight savings changes. | |
| {{:pasted:20161210-174243.png}} | {{:pasted:20161210-174243.png}} | ||
| Line 33: | Line 33: | ||
| 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). | 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. | See the section on 'Special tokens' for more information on how to tailor your output filename. | ||
| - | <note important>Ensure you specify the **full path name** to in your file specification such as: //C:\Users\Username\Documents\{Symbol}.csv//. If you do not do this, the file will be written to the current working directory and you may get an "access denied" error if this folder is write-protected by Windows.</note> | + | <note important>Ensure you specify the **full path name** to in your file specification such as: //C:\Users\Username\Documents\{Symbol}.csv//. If you do not do this, the file will be written to the **current working directory** and you may get an "access denied" error if this folder is write-protected by Windows.</note> |
| 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. | 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. | ||
generating_a_file_export.txt · Last modified: 2020/04/29 06:36 (external edit)
Page Tools
