Advanced GET EOD - Using Other Data Vendors – eSignal Knowledge Base

Advanced GET - Using Other Data Vendors

Using Other Data Vendors with Advanced GET
Advanced GET allows you to use data from several third party data vendors. They are currently:

TC2000 V. 4.x Stocks
ASCII
Metastock File Library
Computrac / Metastock 6.x
Future Source
CSI

You can add any of these vendors to your issue list by doing: Left click on the File menu and then select Data Paths. Next left click on the Add button.

The Format dialog box will appear to select the desired data format. Click OK.

The next screen will now display all of the formats that you have chosen. Once you have added one to this list, it is recommended that you change the properties of the format, so Advanced GET can locate the folder where the data is stored. To do this, select the format that you would like to edit, and then click on the Properties button.

Once you have set all of the formats and properties of each format, Click OK to save the settings. You will notice that the next time you load a chart, Advanced GET will automatically scan the locations you setup and add the symbols to the issue list.

You can change the setting of the data paths any time you would like to modify the issue list. You can go into the Data Path menu by either selecting the menu option from the File menu, or by clicking the Data Paths button from the Issue Dialog Box.

How do I enable the Advanced GET End of Day program to read Metastock (Reuters) data files?
Please follow these steps:

1. Call (801) 265-9998 or email (support@equis.com) Equis Technical Support and request the following DLL's be emailed to you: MSFL651.DLL, MSFL70.DLL, and MSFL72.DLL if you have MetaStock 8.0. If you have MetaStock 9.0, you will also need MSFL80.DLL.
2. When you receive the files, save or copy the files into the System32 folder located in the Windows or WINNT folder if using a 32-bit Windows operating system(C:\Windows\System32). If using a 64-bit Windows operating system, the files will need to be be copied to the SysWOW64 folder in the Windows directory(C:\Windows\SysWOW64).
3. Start Advanced GET and click on File, then Data Paths.
4. In the Data Paths window, click the Add button, select the MetaStock File Library and then click OK.
5. Highlight the Metastock File Library selection and click the Properties button.
6. Verify that the path to the MetaStock data directory is correct.
7. Check the Futures, Stocks and Indexes boxes (they must all be checked).
8. Click OK and then click OK in the Data Paths window.
9. GET will scan the Data Path and you should now be able to access the data.

TC2000 Data
The latest version of TC2000 data that works with Advanced GET is Version 6.000.66 (aka TC2007). As of March of 2011, this version is still available from Worden Brothers. Version 11, the latest version, does NOT work with Advanced GET EOD.

ASCII Format
If your data vendor uses ASCII data format, add the ASCII data path by by left-clicking on File, then Data Path. In the Data Path window, click on Add, select ASCII, click OK. Select the ASCII format and click on Properties. Under the ASCII properties window, click on the Browse button and select the directory where your data files are located.

In the Ext: field, enter the extension that your ASCII files are using. The extension of a file is the three letters that appear after the period "." in the file name. For example, if your file is named SP99Z.AHD, the extension would be AHD. The extension listed in the Ext: field must match your ASCII data files or no files will be found. If you do not know the extension your ASCII data files are using, you should contact your data vendor. If your ASCII data files do not have an extension, you must rename them and give them an extension. GET cannot locate and ASCII data file that does not have an extension.

The Format: field displays the order the data fields with the ASCII data files are arranged. If your data is not in the order shown, find the corresponding column that is not in the correct order and move your mouse cursor to that column. Next, right click your mouse to select from a list of alternate headings.

The Skip column heading tells GET to skip the data in that particular column. Please note that the Format: column must be in the exact same order as your ASCII files or they will not be read by GET. If you do not know the correct order of how your data is arranged, you should contact your data vendor for assistance. If your ASCII data contains a header as the first line in the file, the header will not be used and will be skipped. You must duplicate the settings of the header in the Format: column.

The Date Format: field indicates the order of the date field in your ASCII file.

YY	=	2 Digit Year	--	ex. 99
YYYY	=	4 Digit Year	--	ex. 1999
MM	=	2 Digit Month	--	ex. 05
DD	=	2 Digit Day	--	ex. 21

For example, if your ASCII data file contains the year format of 12/31/1999, you should set your Date Format: to MM DD YYYY. Please note that the month cannot be simply the month code, it must be the number of the month.

The Packed check box indicates that the date field in the ASCII data file is not separated by a character. When this box is checked, GET assumes the date in the ASCII file would look like 012868 for January 28, 1968. If this box is not checked, GET assumes the date in the ASCII file would look like 01/28/68, 01-28-68, or 01 28 68.

The Futures check box indicates that GET should search for futures data in the directory and format indicated. GET attempts to differentiate stocks from futures by looking for a recognized contract symbol, expiration year, and expiration month. If you check the Stocks check box, then GET will search for stock data in the directory and format indicated. Note, if GET is not detecting your futures, they may be named in a way which leads GET to believe they are stocks. In that case, try checking the Stocks check box. And finally, check the Indices check box to indicate that GET should search for index data in the directory and format indicated.

The Current Only check box indicates that GET will not show expired contracts in the symbol list. If you would like to view these at a later time, simply uncheck this box and they will reappear in the symbol list.

If you want to use the ASCII data path only in accessing your data files, uncheck all other data path entries and place a check mark on ASCII only. Click OK. From here on, when you open a new chart, all the data will be accessed from the ASCII folder where your ASCII data files are located.