Export Symbol Data

Description

The Export Symbol Data module is used to export intraday and historical data into text files for usage in external applications such as Microsoft Excel, Tradestation or MetaStock. This feature supports intraday export in the resolutions from 1 second, 1 minute, 5 minutes, 15 minutes and 1 hour. In addition the history export now supports the resolutions 1 day, 1 week and 1 month (previously only 1 day was supported).

Formats

It is possible to export data to Text/asci files;

•Comma separated

•Tab separated

•XML files

•Metastock

Step by step guide

1.Define a symbol list in the Composite Window. Save the list with a name (e.g. ”MyTest”)

2.Click on the "Export Symbol Data" Icon or select List|Export Symbol data on the right-click menu.

3.Select destination folder (e.g. C:\). Tick off  ”All in one file” if necessary, if not it will create one file per symbol.

4. Select type of dataset; Intraday, Historical or Tick by Tick

5.Select data range. It is possible to Include ”header” and ”ticker”

6.Select file format (Comma, Tab or XML)

7.Select date format (thus depending on your computer settings under Control Panel | Regional Settings | Regional Options | Customize | Date)

8.Click the start button

9.In a few seconds the files will be created in the destination folder above

10.Import the same files to the other program

Export to Metastock

Metastock is a popular charting package from Equis International. The exported symbol data can converted to a Metastock  file format in "The Downloader". The Downloader is a product which is shipped along with Metastock. After the symbol data is exported to a file, start The Downloader, select "Tools" in the main menu and select "Convert" in the drop down menu. Make sure the file type is set to "Ascii Text" and then enter the filename of the exported file (click on the "Browse" button). Click on "Ok" and then type in the ticker symbol in the next dialog. After the file is converted it can be opened in the Metastock chart application by selecting "File" and then "Open".