THOMSON REUTERS SPREADSHEET LINK - Baker Library
THOMSON REUTERS SPREADSHEET LINK
USER GUIDE
MN-212 Date of issue: 13 July 2011
Legal Information
? Thomson Reuters 2011. All Rights Reserved. Thomson Reuters disclaims any and all liability arising from the use of this document and does not guarantee that any information contained herein is accurate or complete. This document contains information proprietary to Thomson Reuters and may not be reproduced, transmitted, or distributed in whole or part without the express written permission of Thomson Reuters.
Contents
Contents
About this Document ...................................................................................................................................... 1 Intended Readership .................................................................................................................................1 In this Document........................................................................................................................................1 Feedback ...................................................................................................................................................1
Chapter 1 Thomson Reuters Spreadsheet Link .......................................................................................... 2
Chapter 2 Template Library ........................................................................................................................ 3
View Templates (Template Library) ............................................................................................................................................... 3 Upload Templates (Template Library)............................................................................................................................................ 3
Chapter 3 Constituent Lookup .................................................................................................................... 5
Look Up Constituents (Constituent Lookup) ................................................................................................................................... 5 Customize Your Export (Constituent Lookup) ................................................................................................................................. 6
Chapter 4 Data Item Lookup....................................................................................................................... 7
Browse by Category (Data Item Lookup)......................................................................................................................................... 7 Search by Data Item Name (Data Item Lookup) .............................................................................................................................. 8 Set Parameters (Data Item Lookup) ............................................................................................................................................... 9 Learn About Creating a Time Series (Data Item Lookup) ............................................................................................................... 12 Apply an Identifier to a Data Item ................................................................................................................................................ 12 Customize Your Export (Data Item Lookup) .................................................................................................................................. 14 Parameter Definitions - Alphabetical List..................................................................................................................................... 15 Parameter Definitions - Categorized List...................................................................................................................................... 26
Chapter 5 Identifier Lookup ...................................................................................................................... 29
Look up a Company, Equity Index, or IBES Global Aggregate (Identifier Lookup) ........................................................................... 29 Look up Foreign Exchange Rates (Identifier Lookup) .................................................................................................................... 30 Advanced Options for Looking up a Public Company (Identifier Lookup)........................................................................................ 31 Advanced Options for Looking up a Private Company or Public and Private Companies (Identifier Lookup) ..................................... 32 Advanced Options for Looking up an Equity Index (Identifier Lookup)............................................................................................ 34 Advanced Options for Looking up IBES Global Aggregates (Identifier Lookup)............................................................................... 35 Advanced Options for Looking up Foreign Exchange Rates (Identifier Lookup)............................................................................... 37 Change the View of the Results (Identifier Lookup) ....................................................................................................................... 38 Customize Your Export (Identifier Lookup) ................................................................................................................................... 38 Datastream Country Identification Prefixes .................................................................................................................................. 39
Chapter 6 Aggregate Builder .................................................................................................................... 41
Create a Custom Aggregate (Aggregate Builder) .......................................................................................................................... 41 Save a Custom Aggregate (Aggregate Builder)............................................................................................................................. 42 Open a Saved Aggregate (Aggregate Builder) .............................................................................................................................. 43
Contents
Reference a Cell (Aggregate Builder) ........................................................................................................................................... 43 Customize Your Export (Aggregate Builder) ................................................................................................................................. 44 Aggregate Types (Aggregate Builder) .......................................................................................................................................... 44
Chapter 7 Chart Builder ............................................................................................................................ 46
Create a Single Equity Price Chart (Chart Builder)......................................................................................................................... 46 Create a Multiple Equity Price Chart (Chart Builder)...................................................................................................................... 47 Create a Custom Chart (Chart Builder) ......................................................................................................................................... 48 Create a Total Return Chart (Chart Builder).................................................................................................................................. 49 Create a Shares Traded Analysis Chart (Chart Builder).................................................................................................................. 50 View Chart Numeric Table Data (Chart Builder) ............................................................................................................................ 52 Customize Your Export................................................................................................................................................................ 52
Chapter 8 Expression Builder ................................................................................................................... 53
Build an Expression Starting with Data Items (Expression Builder) ................................................................................................ 53 Set Parameters for Data Items (Expression Builder)...................................................................................................................... 55 Build an Expression Starting with Analytical Functions (Expression Builder) .................................................................................. 56 Build an Expression by Typing in the Expression Box (Expression Builder) ..................................................................................... 58 Save an Expression (Expression Builder) ...................................................................................................................................... 59 Expression Area (Expression Builder) ........................................................................................................................................... 62 Customize Your Export (Expression Builder) ................................................................................................................................. 63 Analytical Functions ................................................................................................................................................................... 64 Mathematical Operators ........................................................................................................................................................... 112
Chapter 9 Funded Portfolio Builder........................................................................................................ 115
Create a Funded Portfolio ......................................................................................................................................................... 115 Import a Funded Portfolio ......................................................................................................................................................... 116 Save a Funded Portfolio or Watchlist ......................................................................................................................................... 117
Chapter 10 Watchlist Builder ............................................................................................................... 118
Create a Watchlist .................................................................................................................................................................... 118 Import a Watchlist .................................................................................................................................................................... 118
Chapter 11 Report Builder.................................................................................................................... 120
Custom Reports (Report Builder) ............................................................................................................................................... 120 Ownership Reports (Report Builder) .......................................................................................................................................... 123 Reuters As Reported Fundamental Data Reports (Report Builder) .............................................................................................. 130 Adjust and Apply Formats (Report Builder) ................................................................................................................................ 132 Customize Your Export (Report Builder) ..................................................................................................................................... 132
Chapter 12 Screen Builder .................................................................................................................... 134
Build a Screen (Screen Builder).................................................................................................................................................. 134 Save a Screen (Screen Builder) .................................................................................................................................................. 144 Open a Screen (Screen Builder) ................................................................................................................................................. 144 Run a Screen (Screen Builder) ................................................................................................................................................... 144
Contents
Delete a Screen (Screen Builder)................................................................................................................................................ 145 Work with Results (Screen Builder) ............................................................................................................................................ 145 Customize Your Export (Screen Builder) ..................................................................................................................................... 146
Chapter 13 Multi-Factor Ranking......................................................................................................... 147
Build a Multi-Factor Ranking .................................................................................................................................................... 147 Save a Ranking (Multi-Factor Ranking)...................................................................................................................................... 151 Open a Saved Ranking (Multi-Factor Ranking)........................................................................................................................... 152 Generate a Ranking (Multi-Factor Ranking) ............................................................................................................................... 152 Delete a Ranking (Multi-Factor Ranking) ................................................................................................................................... 153 Work with Results (Multi-Factor Ranking).................................................................................................................................. 153 Customize your Export (Multi-Factor Ranking) ........................................................................................................................... 154
Chapter 14 Proprietary Data Manager ................................................................................................. 156
Create Data Items (Proprietary Data Manager)........................................................................................................................... 156 Manage Proprietary Data Items (Proprietary Data Manager)....................................................................................................... 160 Export (Proprietary Data Manager) ............................................................................................................................................ 161
Chapter 15 Linking ............................................................................................................................... 162
Import and Export Content (Linking) .......................................................................................................................................... 162 Refresh Links (Linking) ............................................................................................................................................................. 168 Set Standardized Names (Linking)............................................................................................................................................. 169 Manage Links (Linking)............................................................................................................................................................. 169 Highlight All the Links in a Presentation or Document (Linking) .................................................................................................. 172 Edit Individual Links (Linking) ................................................................................................................................................... 173 Keyboard Shortcuts (Linking) .................................................................................................................................................... 173 Save a Source Workbooks and Target Presentation or Document to a Zip File (Linking)................................................................ 178
Chapter 16 My Workbench.................................................................................................................... 179
About My Workbench................................................................................................................................................................ 179 Manage Lists (My Workbench)................................................................................................................................................... 179 Manage Screens (My Workbench) .............................................................................................................................................. 180 Manage Expressions (My Workbench) ........................................................................................................................................ 181 Manage Custom Aggregates (My Workbench) ............................................................................................................................ 181 Manage Templates (My Workbench).......................................................................................................................................... 182 Manage Rankings (My Workbench) ........................................................................................................................................... 183 Use the Recycle Bin (My Workbench) ......................................................................................................................................... 184 Export to Excel (My Workbench) ................................................................................................................................................ 184
Chapter 17 Options ............................................................................................................................... 185
Change Connection Settings(Options) ....................................................................................................................................... 185 Change Null Tolerance Defaults (Options) ................................................................................................................................. 185 Change Reporting State Defaults (Options)................................................................................................................................ 185 Change Calendar Methodology Defaults (Options) ..................................................................................................................... 186
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- advanced formulas and functions in microsoft excel
- incident rate calculation worksheet
- how to estimate the long term growth rate in the
- commonly used excel functions
- how to make a run chart in excel
- thomson reuters spreadsheet link baker library
- how to run statistical tests in excel cbgs
- superelevation iowa department of transportation
Related searches
- thomson reuters impact factor list
- thomson reuters impact factor 2018
- thomson reuters journal impact factor
- thomson reuters list of journals
- thomson reuters impact factor
- thomson reuters journal rankings
- thomson reuters journal list
- thomson reuters indexed journal list
- thomson reuters journal check
- thomson reuters journal master list
- thomson reuters publications
- thomson reuters journal list 2018