Setup ASCII Data Export

Last modified 10:27, 11 Feb 2015

Creating and Maintaining ASCII Data Files

Once Your SOFTWARE has downloaded data, it can distribute the data to any of a number of databases and data files in a wide range of formats.

Due to its popularity, a special tool is included in Your SOFTWARE to create and maintain MetaStock™ databases. This tool is covered separately in the Creating MetaStock Databases topic.

This topic is divided into two sections:

  • Creating Ascii Files
  • Updating the Files

ASCII and other Data File Formats

This topic will discuss how to export Your SOFTWARE price data in ASCII formatted files for use by third party applications.

The American Standard Code for Information Interchange (ASCII) scheme was developed in 1968 to standardize data transmission among different hardware and software systems.

ASCII format is essentially a text-only file, having no formatting information and being composed only of the 256 ASCII characters including letters, numerals, punctuation marks, control characters, and other symbols.

The ASCII Export Specification Wizard is used to set up ASCII files.

It can also be used to make custom specifications or select a number of common third-party formats in which to create and maintain data files.

Updating the Files

There are two methods of updating the ASCII type data files:

Automatic Update

After the files have been created, they can be set to be automatically updated each time the Update Manager has completed its download and distribution of Daily Data Pack files.

In order for this function to work, check the Export Ascii data at Completion of Distribution check-box on the Ascii Export tabbed page of the Application Settings dialog:

asciexpatupdtmngr.gif

The files in the list will be automatically updated with price data immediately after the Update Manager file distribution is completed.

For more information on this process and other settings relating to automatic data distribution, go to the Automatic Data Distribution section of this topic, below.

Manual Update

While the distribution is normally performed automatically after Update Manager file downloads, users may prefer to manually initiate distribution using the Distribute Downloaded Files command in the Tools/Maintenance sub-menu.

For more information on using this feature, go to the Manual Data Distribution section of this topic, below.

Automatic Data Distribution

The default setting is to distribute all data files received whenever the Update Manager is run.

This setting is found in the Modify Existing Database dialog box of the Databases tabbed page of the Application Settings:

datadistrbnautosetngs.gifhttp://hubb-trial.mindtouch.us/@api/deki/files/3532/datadistrbnautosetngs.gif?size=thumb

To open the dialog, select a Database from the list and click the Modify button.

If the box in front of the Data Type in the Include Data of Type list is checked, the data for that type will be automatically distributed.

By default, all boxes are un-checked "off" for Hubb data when Your SOFTWARE is installed.

When users establish an end-of-day Daily Data Account, historical data will first be installed onto their PC from a Data Pack. The Data Pack installation uses the Historical Data Wizard, the Wizard will set these boxed checked "on" so that the historical data in the databases can be updated at every Update Manager session.

Un-checking a Data Type will result in the user having to manually distribute the data using the Distribute Downloaded Files command, see the following section of this topic.

Note - Data Types' download settings can also be set when you create a database using the Add button.

Manual Data distribution

The second method is to select each databases data type to be manually distributed.

Select Data Types for Manual Distribution

Select the data types for manual distribution using the Modify Existing Database dialog box described in the previous section of this help topic.

Distribute Downloaded Files dialog

Select the Distribute Downloaded Files command from the Maintenance sub-menu of the Tools menu.

The Distribute Downloaded Files dialog will open:

datadistmandistribute.gif

Select Folder Location

Select the Download folder to which the downloaded files have been saved.

The folder named Download is the automatically created during the download phase and is located in the first tier of Your SOFTWARE's Program directory (the default location is C:\Integrated Investor\Download).

Click on the folder to display all the downloaded files in the File(s) panel on the right.

Select File Type

The downloaded files can be filtered using the Files of Type drop down list:

datadistmanselcttype.gif

The four selection options can narrow or expand the number of files displayed in the File(s) panel on the right.

Today's Downloaded Files

The default is Today's Downloaded Files. This will be adequate if you remember to distribute the files each day.

Yesterday's Downloaded Files

The selector is calendar based, no files will be shown the day after markets are closed e.g. a holiday or weekend.

All Downloaded Files

This shows all files in the Download folder.

To recreate the database from a backup of your downloaded files you should select All Downloaded Files.

All Files

This includes all files, including files that are not Hubb data files.

Normally there will not be any other files in the Download folder, unless you have added them or set the folder's location to be different than the default.

Select Files for Distribution

The files available to be distributed from the Download folder will be displayed the File(s) panel on the right.

As you change the Files of Type selector, the list will be dynamically repopulated.

Select the files to be downloaded.

Select One

Move the mouse cursor over the file to be distributed. Single left mouse-click to select the file.

Select Some

To select multiple files from non-contiguous parts of the list, hold down your Ctrl key and select individual files with your mouse.

Select All

To select all the files, select the first one in the list, then scroll to the bottom of the list, hold down your Shift key, and select the last one in the list. This will select all the files between those two.

Distribute Selected Files

Click Distribute to copy the data contained in those files to your pricing databases.

The Database Selection dialog box will open:

datadistmanselctdb.gif

Un-check any databases that you do not want data to be distributed to.

If a Database does not appear, check the settings in the Modify Existing Database dialog box of the Databases tabbed page of the Application Settings.

Distribution Progress

While the distribution takes place, a distribution progress dialog will display:

datadistrbnprogress.gif

Distribution Status

The Distribution Status dialog is displayed once data has been distributed to your databases. It should look similar to the screen below.

datadistmandiststatus.gif

Files Received

This shows the number of files that were received (or distributed),

Individual files can be of the following types:

  • System Data files including additional symbols, exchange rates, interest rates, etc.
  • Corporate Action files used to adjust data for companies that have had stock splits, etc.
  • Market Price data for those users who have set up a Daily Download Data Pack account with Hubb.

Records Processed

The number of total records from all files that were processed.

Usually there is one record for each symbol processed.

New Securities

The number of new securities that were added to your databases.

Topics
About Data
The About Data section aims to provide you with an understanding of the types of Data you may access through the Hubb Software and the different methods that may be used to access and maintain them.
Data Setup
Your SOFTWARE analyzes markets to help you trade better and provides both Price Data for technical analysis and Fundamental Data for fundamental analysis as well as news and market reports. In order to do this it needs up-to-date, reliable data from a wide range of exchanges, countries and information providers, in a format compatible with Your SOFTWARE.
Data Maintenance
This section contains information and guides on all aspects of maintaining your Hubb Software's Database.
Troubleshooting
Other
Page statistics
744 view(s) and 7 edit(s)
Social share
Share this page?

Tags

This page has no classifications.

Comments

You must to post a comment.

Attachments