User guide

Using Excel with Datastream Advance for Office
Page 7 of 38
CREATING STATIC DATA REQUESTS
Static data requests are created using the Datastream Static Request dialog to enter your request parameters.
Choose Static Request from the Datastream menu
The minimum you need to do to create a static data request is select a series, a datatype, and a start date on
the Datastream Static Request dialog. You can then Submit the request to Datastream. The results are
displayed directly in the spreadsheet with row and column headings (if selected). The Refresh button enables
you to edit and refresh the embedded request.
Example - Three series and static datatypes
Selecting series
The Datastream Navigator, displayed by clicking the Series Navigation button, enables you to
select individual series. When you select a series, the series mnemonic is copied to the Series field on the
Request dialog. Multiple selections are automatically separated by commas.