Introduction to Eikon Excel

Introduction to Eikon Excel

Document History

Version

Date

1.

15 July 2016

Authors

Chua Rui Ting Vincent Chia

Changes First Issue for Eikon version 4.x

Contents

Introduction to Eikon Excel .............................................................................................. 1 Document History....................................................................................................... 2 1. Basics to Eikon Excel................................................................................................ 5 Overview .............................................................................................................. 5 Key Functions Available in Eikon Excel .......................................................................... 5 How to Generate a Basic Table and ............................................................. 6 How to use the function on Excel ........................................................................ 7 How to use Eikon Answers on Excel .................................................................... 8 Real-Time Data with Formula Builder ............................................................................ 8 2. Formula Builder...................................................................................................... 9 Method 1: Formula Builder manually ............................................................................. 9 Method 2: Formula Builder through Cell Referencing ....................................................... 10 3. Screener............................................................................................................. 12 4. Charting ............................................................................................................. 13 5. ISIN to RIC .......................................................................................................... 14

? Copyright Thomson Reuters 2016 Except as permitted by law, no part of this document may be reproduced or transmitted by any process or means without the prior consent of Thomson Reuters.

Thomson Reuters, by publishing this document, does not guarantee that any information contained herein is and will remain accurate or that use of the information

will ensure correct and faultless operation of the relevant service or equipment.

Thomson Reuters, its agents and employees shall not be held liable to or through any user for any loss or damage whatsoever resulting from reliance on the information contained herein.

Page 2 of 15

Introduction to Eikon Excel Page 3 of 15

Introduction to Eikon Excel Page 4 of 15

Introduction to Eikon Excel

Basics to Eikon Excel

1. Basics to Eikon Excel

Overview

In order to access Eikon Excel, one should open the Thomson Reuters ? Microsoft Excel application and do the following.

In the Thomson Reuters tab, press on the before proceeding.

button to log in. Ensure that the button now shows

Despite the many capabilities of the application, we will only focus on the core functions required for you to utilize.

On the Thomson Reuters Tab, the following can be seen

Key Functions Available in Eikon Excel

1. Data Retrieval The data retrieval function could be used to retrieve real-time data and to generate tables containing a list of instruments and data items. (E.g. EPS of Apple)

2. How to build your own formula Using the "Build Formula" button in the toolbar, one can use the application to customize their own formulas with different instruments, data items and specific parameters. Here, both real-time and historical figures can be retrieved.

3. How to screen for stocks Similar to the SCREENER application in Eikon, one can use this application to generate a list of equities based on their filter preferences.

4. How to plot charts Real-time charts with the ability to reflect real-time changes can be plotted with this function

5. How to use templates to generate more complex spreadsheets Using the sample templates available in Eikon Excel, users who wish to prepare more sophisticated spreadsheets can now do so with ease.

Page 5 of 15

Introduction to Eikon Excel

Basics to Eikon Excel

How to Generate a Basic Table and

Note that the positioning of where the information is entered is important. Hence, we would provide example cell numbers in order to illustrate the following.

Assuming you have a new spreadsheet open in Excel, the following steps could be observed in order to generate a list or table of data and instruments.

1. In Cell A2, (A3, A4 etc), enter the list of RICs (Reuters Instrument Code) you require.

Type "=RIC(" to pull up the following function and type in the instruments. Note that you can only enter one instrument per row. The code will also be hard coded and is not part of a formula.

2. In Cell B1 (C1, D1 etc), enter the list of Data Items you require. Type "=DI(" to pull up the following function and type in the data items (e.g. EPS, Dividend). Note that you can only enter one Data item per row.

3. After keying in all your required instruments and data items, right-click in cell B2 and select for the results to appear as follows.

4. To "refresh" the table to make new figures appear for every RIC or DI entered, there are two ways to do so: A: Right Click in B2 and repeat Step 3 to make the figures appear again B: Press F2 after selecting B2 and drag the formula box to include the new RICs and DI Please refer to the next page for another method to create the list.

Page 6 of 15

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download