User guide

Using Excel with Datastream Advance for Office
Page 30 of 38
CREATING A SET OF REQUESTS
To create a set of requests in a Request Table:
Note: You can insert the resulting data, using Data Destination, into several worksheets within the same or
different workbooks.
1. Select the New Request Table option from the Datastream >Request Table menu.
2. You are now prompted to save the request table under a new name. Click Yes, supply the Request Table
name and directory location, and click Save.
Note It is important that you do not overwrite the default Request Table template (Adv_xl.xlt) as this
will form the basis for all your Request Table generation. We recommend that you make a back
up of the template which is installed with Datastream in the location: C:\Program
Files\Datastream\Datastream Advance.
The next stage in creating a set of data or chart requests is to enter the request parameters as a single row in
the worksheet labelled Request Table. To create other rows (i.e. data requests), repeat the following steps for
each request you wish to add.
1. Click on the worksheet tab labelled Request Table. An empty Request Table is displayed.
2. Click the Y, Y/N or N button to select the YES option - that is, refresh this request. This option can be turned
off by clicking the Y/N button again, where the cell contents will change to NO.
3. Select a Request Type by clicking the appropriate button. The buttons are:
○ S = Static data request
○ TS = Time series data request
○ TSL = Time series list data request
○ CAF = Company accounts data request
○ CH = Chart request
○ SCH = Search list format
4. Select a Format layout type from the dropdown list. You can select:
Format options
Worksheet codes
No headings
X
Row and column headings
RC
Titles with row and column headings
RCH
Titles with row headings
RH
Row and column data transposed with no
headings
T
Row and column data transposed with row
headings
TR
Row and column data transposed with
column headings
TC
Row and column data transposed with row
and column headings
TRC
Data annualised for company accounts data
items
A
In addition to the above formats, you can display the currency of the series selected in your request table. This
format option is selected by clicking the Always Include Currency check box on the Options dialog. See