REUTERS3000XTRAPPPRO—NEW.docVIP

Reuters 3000Xtra - PP Pro What is PowerPlus Pro? It enables you to use Reuters data in the Microsoft Excel environment. You could create sophisticated spreadsheet displays that can include different types of financial data, such as real-time prices, historic prices, analytics, reference data, and even news and graphs. Using Reuters Powerplus Pro in Microsoft Excel Go to the Windows Start and use the menus to select Programs/ Reuters 3000Xtra/Reuters PowerPlus Pro. Reuters Pull-down Menu Overview Real-time Quotes Real-Time Chain Security Instruments Security History Treasury Instrument Treasury History Treasury RICs, Ids and Agencies Treasury Schedule Time Series Data 1 Downloading Data in PPPro Drag Drop from Kobra To insert a single price into an Excel worksheet, simply drag the item from a Kobra display and drop it in the relevant cell in the worksheet. E.g. in Kobra press F4 for a pop-up quote window. In the command line of this window type EUR= and press Enter. You can now go back to Excel (the pop-up window remains on top) and drag a Bid price (for example) for this pop-up and drop it in a cell in your worksheet. Speed Lists If you know the exact names of the fields that you want to display in a quote list, you can create the list very quickly. In the worksheet, type the RICs of the instruments in a column of cells. Type the names of the fields in a row immediately above the column. In any cell directly below a column heading, right-click and select Real-time Speed List in the pop-up menu. This displays the data that you have specified. Assistants The Assistants give you step-by-step processes for creating different types of table. One advantage is that you can scroll through all the available fields to find the ones you want. So start creating a table of data, click on the cell that will be the top left corner of the table in the worksheet. Then select the relevant Assistant (as described below). Quote Lists To create a quote list where the d