15 DATA RETRIEVAL                                               Main Table of Contents

 

Data Retrieval Setup for Aspen Graphics 3.01

Data Retrieval Setup for Aspen Graphics Version 3.02

Retreiving Historical Data

 Data Retrieval Status

Data Retrieval Commands

    This chapter explains how to use the Data Retrieval feature in Aspen Graphics. Before data retrieval will work, your server or standalone unit must be equipped with a compatible modem.

    There are two methods of retrieving data, and the Data Retrieval Feature enables you to "refresh" or "update" your tick, bar, and daily data at any time.

Data Retrieval Setup for Aspen Graphics 3.01                      Top of Page

Data Retrieval Setup can only be performed on Aspen
network servers and Aspen standalone units.

Before you can retrieve data from the Aspen Graphics database, you must have the correct settings in the Data Retrieval Setup menu. To check or change these settings, follow these steps:
  1. Type .drset btnEnter.gif (1425 bytes). The 3.01 Data Retrieval Setup menu (see Figure 1) will appear.

Figure 1
  1. Under the heading of Serial, single left click on the word None. A drop down box with Com choices will appear.
  2. Select the correct Com port for your modem. The IRQ and BASE fields will automatically be filled with the appropriate information.
  3. Make sure that the IRQ and BASE fields have the correct parameters for your modem.
  4. Under the heading of Modem, single left click on the modem field. A Modem menu will appear.
  5. Select the proper script for your modem.
  6. Single left click in the Host Phone # field. An edit box will appear.
  7. If no phone number is present, type in the phone number for Aspen’s data retrieval servers, and tap the btnEnter.gif (1425 bytes) key one time. Please call Aspen Graphics Technical Support for the correct number. If you must dial 9 to get an outside line, type in a 9 followed by a period. Also, don’t forget the number 1 if you have to dial long distance.
  8. Single left click in the Dialing Mode field. A Mode menu will appear.
  9. Select the dialing mode you wish to use. Choosing Auto will make the modem automatically dial out when a request is made. The Manual selection makes the modem wait until a .dial command is issued. The At Time selection will dial the modem at a specific time.
  10. Single left click in the Update List field. A List menu will appear.
  11. Select the list mode you wish to use. When you choose Auto, the system will automatically insert an instrument in the update list when you bring up that instrument on a chart or quote page. When you choose Manual, you must enter each instrument that you want updated.

    12.  
  12. Single left click in the Update Length field. An edit box will appear.
  13. Enter the maximum number of symbols to appear in the update list (maximum of 999 symbols), and tap the btnEnter.gif (1425 bytes) key one time.
  14. Single left click in the Start Time field. An edit box will appear.
  15. Type in the starting date for data retrieval. If you want to update data back to the beginning of 1997, then type 1/1/97 btnEnter.gif (1425 bytes). The start date you entered will appear in that field.
  16. Single left click on Done. The Data Retrieval Setup menu will disappear.

 

Data Retrieval Setup for Aspen Graphics Version 3.02                      Top of Page

 

Data Retrieval Setup can only be performed on Aspen
network servers and Aspen standalone units.

Before you can retrieve data from the Aspen Graphics data base, you must have the correct settings in the Data Retrieval Setup menu.

To check or change these settings, follow these steps:

  1. Type .drset btnEnter.gif (1425 bytes). The 3.02 Data Retrieval Setup menu (see Figure 2) will appear.

Figure 2

 

  1. Double left click in the Area Code field.
  2. Type in the number 970 and tap the btnEnter.gif (1425 bytes) key one time.
  3. Double left click in the Phone Number field.
  4. Type in the number 9450752 and tap the btnEnter.gif (1425 bytes) key one time.
  5. In the How to Dial section, single left click on Dialing Properties. The Dialing Properties menu will appear (see Figure 3).

Figure 3
  1. Double left click in the The Area Code Is field.
  2. Type in your area code and tap thebtnEnter.gif (1425 bytes) key one time.
  3. If you need to dial a number to access an outside line, single left click in the To access an outside line, first dial field.
  4. Type in the access number and tap the btnEnter.gif (1425 bytes) key one time.
  5. Single left click in the for long distance field.
  6. Type the number 1 and tap the btnEnter.gif (1425 bytes) key one time.
  7. Single left click on OK.
  8. Under the Connect Using header, single left click on the down elevator button at the end of the TAPI Line field. Your modem should appear as a selection.
  9. Single left click on your modem. It will become the selected modem.
  10. Single left click on the down elevator button in the Dialing Mode field.
  11. Select the dialing mode you wish to use. Choosing Auto will make the modem automatically dial out when a request is made. The Manual selection makes the modem wait until a .dial command is issued. The At Time selection will dial the modem at a specific time.
  12. Single left click on the down elevator button in the Update Mode field.
  13. Select the list mode you wish to use. When you choose Auto, the system will automatically insert an instrument in the update list when you bring up that instrument on a chart or quote page. When you choose Manual, you must enter each instrument that you will want updated.
  14. Single left click in the Length field.
  15. Enter the maximum number of symbols to appear in the update list (maximum of 999 symbols), and tap the btnEnter.gif (1425 bytes) key one time.
  16. Single left click in the Start Time field.
  17. Enter the starting date for data retrieval. If you want to update data back to the beginning of 1997, then type 1/1/97 btnEnter.gif (1425 bytes). The start date you entered will appear in that field.
  18. Single left click on OK.

Retrieving Historical Data                      Top of Page

    This section will explain the differences between a refresh and an update. It will also step you through the data retrieval process.

Refresh

The refresh command retrieves only data displayed in a chart window. This command can only be entered on a Standalone unit or a Network Workstation. To refresh your charts, follow these steps:
  1. Bring up a chart with a symbol for which you would like to retrieve data.
  2. Make sure that the time scale of your chart draws the entire period of time for which you want to pull back data.
  3. Type .refresh btnEnter.gif (1425 bytes). If your dialing mode is set to auto, the system will automatically dial out and fill in the chart.
  4. If your dialing mode is set to manual, type .dial btnEnter.gif (1425 bytes). The modem will dial out and connect to the Aspen data retrieval system.

Update                   

The update command retrieves data for all symbols in the update list. This command retrieves the data from as far back as you have the start time set in the Data Retrieval Setup menu. If the start time is set to the current time and date, the system will only update the Master Table of symbols. To update your charts, follow these steps (The Update command can only be issued on a standalone system or a network server):
  1. Type .uplist btnEnter.gif (1425 bytes). The Edit Update list will appear.
  2. Check the list to make sure that all the symbols you want to update are included.
  3. Single left click on Done. The update list will disappear.
  4. Type .drset btnEnter.gif (1425 bytes). The Data Retrieval Setup menu will appear.
  5. Single left click on Start Time. An edit box will appear.
  6. Type in the starting date for data retrieval. If you want to update historical data back to the beginning of 1997, then type 1/1/97 btnEnter.gif (1425 bytes). The start date you entered will appear in that field.
  7. Single left click on Done.
  8. If your dialing mode is set to auto, the system will dial automatically. If your dialing mode is set to manual, type .dial btnEnter.gif (1425 bytes). The modem will then dial out and connect to the Aspen data retrieval system.

Data Retrieval Status                      Top of Page

    Type .drstat btnEnter.gif (1425 bytes). The Data Retrieval Status window will appear ( see Figure 4).

    Figure 4

    The Data Retrieval Status window shows the number of requests and the call status for the data retrieval function.

    The following fields are present in the data retrieval status window:

    Requests - Number of data retrieval requests to be processed.

    Status line - Shows what the modem is doing.

    DTE - Indicates the type of modem that you have selected in data retrieval.

    Offline - Indicates the status of the modem.

    r - Packets received.

    x - Packets transmitted.

     

Data Retrieval Commands                      Top of Page

Command Function
.dial Initiates a call to the host.
.drcancel Cancels all requests for data.
.drmenu Displays the Data Retrieval menu.
.drset Displays the Data Retrieval Setup menu.
.drstat Displays the Call Status window.
.hangup Causes the modem to hang up.
.refresh Refreshes the data displayed on a chart.
.update Updates all symbols in the Edit Update List.

Table 1