FT4Web by Investors FastTrack
What is Exporting and Why use It
FastTrack's exports dividend-adjusted data into formats readable by other programs. There is NO provision to export unadjusted data. However, the spreadsheet tab may compute it's results without dividends and this sheet may be exported.
The data exported is the data of ticker symbols in the Issue List. Exports can be performed automatically on startup without having to interact with Ft4Web manually.
The Date range of the data exported is from the date you type in to the current date. This is the "Export Period." There is no provision for exporting to an ending date other than the last date in the FT database.
In the case of existing "MetaStock (6.0 - 11.0) files". The export adds new data starting at the last day in the existing MetaStock data. Earlier FT data will not be prefixed to the MetaStock data. If you wish to extend the early data, then select the "Delete all files" Export Option, below. Exception, when FT4WEB rewrites MetaStock data to to adjust for distributions, the data is rewritten from the start of the Export Period.
Add New Update Existing . . .This can be selected only for MetaStock files.
Delete all files then Export . . .
Export all data to a single file . . .
Note: On the FastTrack Export Tab, when you select "Export all list issues to a single file" then the export goes to to a file shown at the top of the Issue List as the "Issue List Name". This allows you to export (step 8 above) multiple families of issues each to a separate export name.Date Format
When allowed, you fill this field in yourself. There are many options. This governs how the date is displayed. For some export types, the date format is predetermined and cannot be changed.
Paths for Export
This folder list shows where the exported files will go. You must know where your other programs expect their data files to exist.
FastTrack can remember where to export. Whenever you load a saved export, the path associated with that export displays in the folder list.
Remember: Exported files go to the currently highlighted path.
Note: You can export Metastock data to any path for Metastock to use. However you must tell Metastock what path to use to find the data.
New Folder Button
Delete Folder Button
Load Export Button
The hot key for this function is "L".
Save Export Button
Adjusting for Distributions
Using the Export
Comma Delimited Export Type - Export data in comma-delimited format.
DATE, JJJJJJ, CCCC.CC, DDDD.DDD, N
The lines of text are only as long as necessary to contain the values. The spacing of the fields and commas will vary according to the data. The lines of data are not all the same length although they always have the same number of fields. Values are rounded to the third decimal place.
This format is suitable for import as a CSV into spreadsheets and for input to a variety of PC programs.
Fixed Length - Export data in fixed length format.
This is an ASCII text format without any carriage returns at the end of each line. The data values occur at fixed length intervals. Short number fields are padded with blanks or zeros. This is often the best way to export data that will subsequently be processed by a mainframe or database program that is unable to accept comma-delimited formats. Data is exported to a text file named SYMBOL.EXP where SYMBOL is replaced by the fund's 5-letter NASDAQ symbol. The file is placed in the FastTrack directory. Data is exported in the following format:
Note: If you set the date format to something other than MM/DD/YYYY, then the above line will be different. For field definitions click here or see above
FastTrack Format (FNU) - Export into the FastTrack Import Format (FNU)
This exports data into a FastTrack ASCII text file with the extension FNU. See Importing Data for more information on this format.
The benefit of using this type of export is that you could export an issue, change the data (perhaps the most recent distribution is missing), and the display it with corrections. By default symbols exported will end in a $ so that the FNU file name does not duplicate a name already in the database. In prior versions of the export, we appended an "A" to the name, but this assumed that we were dealing with mutual funds whose symbols all end in X. Now that the database also includes stocks, simply appending an A may make an unintended valid symbol.
This export creates individual files in any folder you specify. The file named is the Symbol.PRN. The file contains lines of ASCII text in the form. Fund Master was a popular DOS program in the 1980's and many current analysis programs can still import FundMaster format data.
Spreadsheet - Export in a multi-row/multi-column comma-delimited text file.
This format is for importing FastTrack data into spreadsheets. The data is in ASCII, comma delimited, text in columns.
MetaStock Format (PRN) - Export an ASCII text for import by MetaStock's MSU or Downloader utility.
In addition to exporting FastTrack data via New MetaStock export type, FastTrack can export an ASCII text file that is compatible with MetaStock pre-Version 6. The MetaStock MSU data import utility and Downloader (Newer MS versions). Other programs like FundMaster can read this file format as well. Contact Equis for details on how to use MetaStock.
When FastTrack starts it will automatically perform a saved export if you wish. Here are the steps.
In the instructions below use saved file names that are simple. That is, no spaces, no punctuation except for the a period, no network path names
When the export completes, you may use FT normally or just shut it down. Using the task manager you can also cause additional tasks to run after the export.