ViewZ RTDVR series Guia do Utilizador

USING EXCEL 2007 ISSUE 4 DATASTREAM ADVANCE FOR OFFICE 5

Using Excel with Datastream Advance for Office Page 10 of 38 CREATING TIME SERIES REQUESTS You can create time series requests for individual s

Using Excel with Datastream Advance for Office Page 11 of 38 USING FUNCTIONS AND EXPRESSIONS WITH TIME SERIES REQUESTS Selecting expressions Fo

Using Excel with Datastream Advance for Office Page 12 of 38 Selecting dates Dates can be typed as either a fixed date format, that is dd/mm/yy

Using Excel with Datastream Advance for Office Page 13 of 38 4. Click OK, the expression is displayed in Datatypes / Expression text field

Using Excel with Datastream Advance for Office Page 14 of 38 USING EXPRESSION EDITOR IN STATIC AND TIME SERIES DIALOGS The Expression Editor he

Using Excel with Datastream Advance for Office Page 15 of 38 When you click the Expression Picker button in the Edit Series/Lists (Time Ser

Using Excel with Datastream Advance for Office Page 16 of 38 CREATING COMPANY ACCOUNTS DATA REQUESTS In addition to static and time series data

Using Excel with Datastream Advance for Office Page 17 of 38 Select last request parameters You can re-insert the parameters for any of yo

Using Excel with Datastream Advance for Office Page 18 of 38 Select, or deselect, the required format options and click the Submit button. The

Using Excel with Datastream Advance for Office Page 19 of 38 Use the following options to edit the request: Cut Cuts the entire details of the

Datastream Advance for Office Page 2 of 38 CONTENTS 1 Using Ribbon based UI for AFO (in MS-Office 2007 and above) 3 2 Using Excel with DATAST

Using Excel with Datastream Advance for Office Page 20 of 38 To select these options: 1. Choose Options from the Datastream menu. The Options

Using Excel with Datastream Advance for Office Page 21 of 38 T1 code - displays Thomson ONE code for the requested series. It is available on

Using Excel with Datastream Advance for Office Page 22 of 38 Expression editing Select the Show out of date warning to warn you when expressi

Using Excel with Datastream Advance for Office Page 23 of 38 3 USING LISTS CREATING A LOCAL LIST FROM A SET OF CODES (DATASTREAM, ISINS, SEDO

Using Excel with Datastream Advance for Office Page 24 of 38 4 USING EXPRESSIONS THE EXPRESSION PICKER You use the Expression Picker to select

Using Excel with Datastream Advance for Office Page 25 of 38 Tools available in the Expression Builder Function The Select a Function dialog i

Using Excel with Datastream Advance for Office Page 26 of 38 5 USING THE REQUEST MANAGER You can create and embed any number and type of data

Using Excel with Datastream Advance for Office Page 27 of 38 3. To change the time period, click on Time Period button. To change display pr

Using Excel with Datastream Advance for Office Page 28 of 38 4. Right click on the chart and click Update Chart to transfer the updated char

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 involve

Using Excel with Datastream Advance for Office Page 3 of 38 1 USING RIBBON BASED UI FOR AFO (IN MS-OFFICE 2007 AND ABOVE) When you install Data

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: Y

Using Excel with Datastream Advance for Office Page 31 of 38 Request Table options. This feature is primarily intended to provide compatibility

Using Excel with Datastream Advance for Office Page 32 of 38 new row or column). If you select this option, any future processing of the Reques

Using Excel with Datastream Advance for Office Page 33 of 38 UPLOAD LIST BUTTON The Upload List button in the request table can be copied to a

Using Excel with Datastream Advance for Office Page 34 of 38 PROCESSING AND SCHEDULING REQUESTS You can choose to either process your Request

Using Excel with Datastream Advance for Office Page 35 of 38 USER CREATED TIME SERIES This workbook also includes a Request table to enable ser

Using Excel with Datastream Advance for Office Page 36 of 38 1st - Plot data from the beginning of the calendar period. Mid - Plot data from t

Using Excel with Datastream Advance for Office Page 37 of 38 12. Set the date range. Click the Date range button and type the start and end da

© 2009 Thomson Reuters. All rights reserved. Republication or redistribution of Thomson Reuters content, including by framing or similar means,

Using Excel with Datastream Advance for Office Page 4 of 38 Utilities: This group consists of six buttons. Find the series and datatype you r

Using Excel with Datastream Advance for Office Page 5 of 38 2 USING EXCEL WITH DATASTREAM ADVANCE FOR OFFICE CREATING DATA REQUESTS IN EXCEL Da

Using Excel with Datastream Advance for Office Page 6 of 38

Using Excel with Datastream Advance for Office Page 7 of 38 CREATING STATIC DATA REQUESTS Static data requests are created using the Datastream

Using Excel with Datastream Advance for Office Page 8 of 38 Selecting datatypes The Datatype Mnemonic Picker, displayed by clicking the Dataty

Using Excel with Datastream Advance for Office Page 9 of 38 Selecting lists You can use lists stored on your PC (i.e. Local Lists) or remote li