User guide

Using Excel with Datastream Advance for Office
Page 29 of 38
6 USING THE REQUEST TABLE
WHAT IS THE REQUEST TABLE?
If your use of Excel involves building models using several requests for data from Datastream, you can use the
Request Table to administrate and edit these refreshable data requests. The request table is an Excel template
with additional facilities for entering request parameters as individual Excel rows.
These parameters include:
Creating and storing regularly used Datastream data or chart requests in the form of a table enables you to:
Enable/disable individual requests when they are required/not required.
View the details of all requests in one glance.
Reference request input parameters from other worksheets.
List requests in the table in the order they need to be processed (to use returned values as input
parameters in subsequent requests).
Specify different cell and worksheet references for individual requests.
Schedule the request table to be processed in the future and „out of hours‟.
Continue processing, even if a datatype within a list of datatypes is invalid.
Add a description against each row in the table.
Copy a code button onto work sheets to access the series/datatype lookup.
Link to charts and data.
YES or NO allow you to set request to YES or NO rather than toggle from Yes to No.
Functionality to update mainframe L# lists in the same way as Datastream Equity Screening.
Request Table and UCTS templates merged to allow existing RT sheets to be converted to merged
template.