Mapping ASCII

From MultiCharts
Jump to: navigation, search

Sometimes importing data to the database is extremely complicated or outright impossible.

In such a case ASCII mapping is the solution; there are two principal reasons for using ASCII mapping:

  1. If one or several ASCII files constantly used are periodically updated. Even if there are just a few updates per day, re-importing hundreds of symbols is difficult or just not feasible;
  2. If tick/volume bars must be displayed on a chart.

When mapping, the file path and format is indicated once, and every time a chart is created the program finds the file automatically, converts it into the necessary format based on the preset configuration and displays the data.


How to map ASCII files

  1. Open QuoteManager window
  2. On the File menu, click Map ASCII.
  3. Click Browse to indicate the path containing the files to be mapped.
  4. In the Get Symbol From indicate File Name for the program to extract the symbol name from the filename. If along with quotes the file contains the symbol name as one of the columns, indicate File's Field.
  5. Use Get name from to characters, if a part of the word must be used.
  6. If the symbol name needs to be edited manually, click the corresponding cell.
  7. Make sure the program has correctly defined the Resolution for every file you intend to map. If you see an error, click the hyperlinked file name. In the window that appears check:
    • The Date field is not defined or not properly defined
      To set date:
      1. Click the Date column heading.
      2. Select Date and the corresponding template.
      3. Click Custom if there is no such template.
      4. Create a template. If the number of symbols in the date changes, use an asterisk * to replace the symbol, e.g. 9/9/2004 changed to 10/9/2004. The number of symbols changes from 6 to 7.
      5. Apply the created template by selecting it from the list.
    • The Time filed is not defined or not properly defined
      To set time:
      1. Click the Time column heading.
      2. Select Time and the corresponding template.
      3. If the template does not exist, click Custom.
      4. Create a template. If the number of symbols in the date changes, use an asterisk * to replace the symbol, e.g. 8:30 changes to 10:10. The number of symbols changes from 4 to 5.
      5. To set a time template, e.g. 5:22 PM, the template must look like H:MM tt@PM, where tt means the postfix placeholder and after @ the PM value stands.
      6. Apply the created template by selecting it from the list.
    • Wrong detection of the starting line of quotes
      To set Start at Row You should indicate how many lines to skip.
    • Wrong sequence of columns
      To change the sequence:
      1. Click the column heading.
      2. From the drop-down field select the correct file.
      3. Repeat for all improperly defined columns.
    After those parameters have been properly set, the program analyses the file again and sets the proper Resolution.
    The program will automatically apply the edited template for all files with the same structure, so the user does not have to edit every file manually.
  8. Indicate the Category, Exchange, Field, TimeZone, Price and Volume Multiplier for all symbols. If the same value is to be used in several cells, the program supports copying and multi-pasting.
  9. Make sure the check box is checked for files to be mapped. If all fields are filled, the program checks the check box on the left, indicating that the file is ready for mapping.
  10. Click OK to complete the procedure.