User guide

Using Excel with Datastream Advance for Office
Page 31 of 38
Request Table options. This feature is primarily intended to provide compatibility with earlier versions of the
Request Table. If the Always Include Currency option is selected, any format options selected will have the
currency symbol ($) appended to the worksheet code; for example RC$.
5. Select series or lists (i.e. Local Lists, Datastream mainframe lists and constituent lists) using the Series
Lookup buttons. If the Request Type you selected is S or TS, click the Series Navigation button to display
the Series Selection screen (see Selecting Series). You can select any number of series. If the Request
Type you selected is TSL, click the List Picker button to display the List Picker (see Selecting lists).
6. Select a datatype, expression, company accounts format or search format (created in the Datastream
interface) by clicking the appropriate button. If you have selected Request Type S, you can select
datatypes (see Selecting Datatypes) and expressions (see Selecting Expressions). If you have selected
Request Types TS and TSL you can only select datatypes. If you have selected Request Type CAF, you
can select company account formats (see Creating company accounts data requests). If you have
selected Request Type SCH, you can select the search format (see Datastream Getting Started Guide).
7. Place the cell cursor in the next adjacent cell, e.g., G7, and enter either a fixed start date in the form
dd/mm/yy, a relative start date in the form -nY (that is n years ago from the End Date), or -nYE to retrieve
accounts data for n year ends. For static data requests, this field is used to specify the date for which the
data is to be requested. When requesting latest values for static data for company accounts items (i.e.
104) and economic codes, you must enter a space in the Start Date field.
8. Place the cell cursor in the next adjacent cell, e.g., H7, and specify an End Date in either a fixed date or
relative end date format. This date is only needed for time series and company accounts requests and
can be left blank to specify previous day values.
9. Place the cell cursor in the next adjacent cell, e.g., I7, and select a data frequency from the dropdown list.
The options are:
○ Daily
○ Weekly
○ Monthly
○ Quarterly
○ Yearly
10. Place the cursor in the next adjacent cell, e.g., J7. The next step is to specify where the result of the data
request is to be inserted. This can be a specific cell location in any new worksheet within the same
workbook, or a specific cell location in a different workbook. To specify a cell location in a worksheet
within the same workbook:
○ Insert a new worksheet from the Insert menu.
○ Click on the Request Table tab
○ With the cell cursor at J7, click the Data Destination button. The Create Destination Reference screen
is displayed. Click on the required worksheet tab and then click on the required cell location to
automatically paste the cell reference into the dialog, for example:
○ Click OK to insert the cell reference into the request table.
If you want to specify a cell reference in another workbook, simply click the Data Destination button, open
the required workbook, activate the required cell and click OK on the Create Destination Reference screen.
11. You must now choose whether you want the data destination cell location to be displayed as either plain
text reference or as a dynamic Excel formula. If you select the Display Destination as Excel Formula
option, this enables the position of the data results to be moved in the worksheet (e.g. after inserting a