ASCII Export Wizard

Last modified

ASCII Export Wizard

Use the ASCII Export Specification Wizard to create file specification templates that will format exported data to the exact specifications of third party applications.

You can then open the resulting file in the third party application and work with the data.

Note - You will need to identify the exact data and formatting requirements of the third party application prior to running this wizard.

The Wizard will create a file specification/template with the following parameters defined:

When the Wizard has created a specification/template, it will be available for selection from the ASCII Export Specifications list.

Opening the Wizard

To run the Wizard, go to the go to the ASCII Export tabbed dialog box of the Applications Settings dialog and check the Export Ascii data at Completion of Distribution.

Next click the Add button to open the Ascii Export Specifications dialog box:

asciexp_addwizard.gif

Click the Add button to open the Ascii Export Specification Wizard, see next section of this topic.

Alternatively, select an existing Available Specification and click Edit to alter its settings. The edit will also take place in the Wizard, but the existing settings will populate some of the Wizard's entry fields.

Ascii Export Specification Wizard

The Ascii Export Wizard will lead you through the 8 steps needed to specify an output format that can be used by a third party application:

Step 1 - Introduction

The Ascii Export Specification Wizard will open at its Introduction page.

The text advises that the wizard will take you through the steps need to set up and output format that can be used by a 3rd party application.

Click the Next button.

Step 2 - Name and Output Location

asciexpviz2_clip.gif

Specification Name - This is the name you give to the specification.

Output Location - This is the location on your computer where the ASCII file will be placed at the end of each download.

Enter a name for the new specification and select the folder where the files will be created.

Click the Next button.

Step 3 - Filename Format

You can either format a new file each time you download using the current data date, or allow the same file to be updated each time you download.

asciexpviz3_clip.gif

If you select Format Data File using the Current Data Date, enter the required Prefix and select a Date Format and file Extension.

 

Prefix This will be added to the beginning of the filenames and could consist of a letter or numeral.
Date Format This determines the order and number of numerals used to define days, months, years in the date; e.g., if ddmmyy were selected for New Year's day 2000, the date would read 01010
Extension This is the extension on the filenames; e.g., .txt, .csv etc

 

The Prefix and Extension will appear on all filenames.

If you select Use the Same file for each Output, click on either Append to Existing File or Overwrite Existing File, depending on whether you wish to add to or overwrite the existing file.

 

Append to Existing File

Data will be added to a file already created. If the file is not yet created, it will create it.

Overwrite Existing File

A new file will be created and written over the old file after each download. Old data will be deleted and replaced by this process after each download.

 

Once you have made all selections and completed the required entries click the Next button.

Step 4 - Field Selection and File Layout and Format

Now select which of the available fields you wish to export. Available Fields are on the left, fields that will be exported are on the right, in descending order:

asciexpviz4_clip.gif

The single right and left arrows allow you to move a selected field from one side to the other; e.g. if you select Instrument and then click the single right arrow it will move to the right box. The double arrows allow you to move all of the fields, whether selected or not, from one side to the other; e.g., if you click on the right double arrow all of the fields will move into the right box.

Should you wish to change the order of any of the Fields to Export, select the field and move it either up or down by clicking on the up or down arrows adjacent to the box. Once you have selected a field these arrows will change color.

The following is a brief description of the available fields:

SymbolId

Symbol for selected items; e.g., BHP

Instrument

Type of security selected; e.g., share, option, warrant, future, FX

DataDate

Data of the data being exported

OpenPrice

The first traded price for a security on the day specified (DataDate)

HighPrice

The highest traded price for a security on the day specified (DataDate)

LowPrice

The lowest traded price for a security on the day specified (DataDate)

ClosePrice

The closing traded price for a security on the day specified (DataDate)

BidPrice

The bid price for a security on the day specified

AskPrice

The asking price for a security on the day specified

Volume

The total number of units of a security traded on the day specified

OpenInterest

The number of OPEN contracts held in the market for a security. This is not relevant to shares. If this is selected for shares a 0 will be placed in this field.

Select the fields you wish to export and shift them to the Fields to Export box. If this option is selected, a list of the Fields To Export immediately preceded by Symbol ID, DataDate etc, will appear at the top of every file created.

Select the required Field Delimiter and Text Delimiter. The field delimiter determines how you wish to separate days, months and years in the date; and the text delimiter determines how you wish to separate text.

Select the required Date Format.

Select whether you wish to include Headings on First Line. The headings are the selected fields.

Once you have made all selections and completed the required entries click the Next button.

Step 5 - Instruments to Export

Select which instruments types you wish to export.

asciexpviz5_clip.gif

Select the instruments you wish to export and click the Next button.

Step 6 - Data Modification

Select which data, if any, you wish to mathematically modify during the export process.

asciexpviz6_clip.gif

For each data item listed in the Price Field you can add, subtract, multiply or divide, as selected in the corresponding Operator field; by an amount or factor entered in the Value field.

If you make a change in the Open, High, Low or Close fields the software will ask if you wish to apply the same changes to the remaining fields. Volume and Open Interest are adjusted separately.

Select any items of data in the Price Field you wish to modify, select the required Operator, enter the required Value and select whether or not you wish to apply the same changes to the remaining fields.

When you are satisfied with all selections and entries, click the Next button.

Step 7 - Wizard Complete

Click the Finish button to complete the Wizard sequence.

Select the Specification to Run

The new Specification is now listed in the ASCII Export Specifications dialog.

Click the Select button to add it to the Specification list in the ASCII Export tabbed page of the Application Settings.

Provided the Export Ascii data at Completion of Distribution checkbox is checked, the Ascii database defined in the new Specification will be created the next time the Update Manager is run.

Refer to the ASCII Export Application Settings help topic for details on running Ascii exports and maintaining the list of specifications.

Page statistics
715 view(s) and 13 edit(s)
Social share
Share this page?

Tags

This page has no classifications.

Comments

You must to post a comment.

Attachments