Home      Site Map      Contact             

ANF Data Converter

To download zip file with Data Converter click here

After downloading zip file extract ccdconv.exe (executable file) and ccdconv.hlp (help file). Create new folder (name it as Converter for example) and save files into it. Data Converter will use this folder as a default folder to read source data files from and write destination files in.
To run Data Converter go to folder where Converter was saved and simply double click ccdconv.exe file name.

Data Converter creates new data file with a different format of the data using CC Data and Tick Data files (source files).

- ticker;
 - intra day mark ("I" symbol);
 - date (in yymmdd format);
 - time (in hh:mm format);
 - open;
 - high;
 - low;
 - close;
 - volume;
 - CC close;

Example:
ES01MIG,I,021212,07:34,00901.00,00903.75,00901.00,00903.00,290,899.75

Each price in the file must be in decimal format. 

Source Tick Data file is an ASCII text file with a comma separated values (csv format). This file contains intra day One minute tick data. The Converter uses this file with CC Data file together to create new one with a different tick data format. There are 8 fields in every line, the order of fields is: 

 - ticker contract symbol ( ES, NQ ... )
 - time frame (interval)
 - date 
 - time (from beginning of interval) 
 - Up Tick
 - Down Tick
 - Up Volume
 - Down Volume

Example: 
ES01,020307,08:37,64,51,532,406

All CC Data and Tick Data source files must have ".csv" extension.

Destination File is a file where new data is written after conversion. The common rule for destination file name is - "Source file name" + ". Where "time frame" is "01", "03", "05" … and so on, "session mark" is "R" (regular) for day session data and "G" (globex) for day + night sessions data.
If  "Compose tick data" option is chosen with "None (Volume/CCclose only)" value, there will be No any mark added to the destination file name. (ES0206_30R.CSV for instance)
In case you choose "Compose tick data" option with "Up/Dn Tick" value, there will be "T" mark added to the destination file name. (ES0206_30RT.CSV for instance)
In case you choose "Compose tick data" option with "Up/Dn Volume" value, there will be "V" mark added to the destination file name.(ES0206_30RV.CSV for instance)
In case you choose "Compose tick data" option with "Volume/ Ticks" value there will be "W" mark added to the destination file name.(ES0206_30RW.CSV  for instance)

All destination Data files have ".csv" extension.
 

Time Frame - is an option to check the time frame you wish convert data. There are 8 time frames - 01 minute, 03, 05, 10, 15, 20, 30 and 60 minutes. Every bar is constructed by trades from the beginning to the end of the time period. For example : the bar 15:45 of 15-min data includes trades between 15:45:00 and 15:59:59. The only bar 15:00 of 60-min data includes trades from 15:00:00 to 15:14:59 and only bar 16:00 of 60-min data includes trades from 15:30:00 to 15:59:59. The data in Source File usually is in the 1-min time frame.

Time Format is an option to check the time format for converted data. For intraday data, the time must be stored in 24-hour format. For example, 1:15pm would be entered as 1305 or 13:05, and 10:00am as 1000 or 10:00. You can choose format with or without colon. There are two formats: "hh:mm" (with colon) - for MetaStock software and "hhmm" (without colon) - for TradeStation software. The data in Source File must have time in "hh:mm" format only.

Date Format is an option to check the date format for data conversion. Dates are presented in Y2K compliant formats. Y2K Compliant Formats Examples MM/DD/YYYY 01/27/1998 YYYYMMDD 19981127 There are two formats in CC Data converter: "mm/dd/yyyy" and "yyyymmdd" . The data in Source File must have Date in "yymmdd" format only.

Trade Hours - is an option to check the time period you wish to include into converted data.  "Day / night session" marks 24 hours Globex session and others includes " data for day session only" with start time of 07:00, 07:20, 08:00 or 08:30 (all in CST).  Destination File name will include R or G char - "session mark" where "R" (regular) is for day session data and "G" (Globex) is for day + night sessions data. The data in Source File usually is "day and night sessions" (Globex Time Hours).

Continued Close (O/I field) without decimal point (example: 1036.25 ==>103625). This option allows you to convert CC Close into the value without decimal point. It useful as the O/I field must be an integer. To create real value of CC Close for usage in your functions you have to divide OI by 100 (CCClose=OI*0.01). The data in Source File must have Continued Close in "with decimal point" format only.

  © Copyright 2000-2006 ANFutures.com