Introduction to Eikon financial statements

How to find company financial and price data in the Eikon database

Specialist Library Support
Specialist Library Support
7 min readFeb 27, 2020

--

Downloading financial statements from Eikon

Contents

  1. Financial statements
  2. Price charts
  3. Price history
  4. Advanced search for companies

Introduction

Refinitiv Eikon includes many different functions which allow you to study individual quoted companies across the world. This post will outline some of the key company data apps in Eikon and how to use them. It will focus on features which will allow you to access reports and view data regarding company fundamentals.

Eikon home screen
App menu
Eikon starts with the Home app. Use the top-most search bar of the Eikon logo menu for finding apps. (Click to enlarge.)

1. Financial statements

The Eikon database contains more than ten years of historic data of financial statements of quoted companies from a choice of two sources. These financial reports can be downloaded as Excel documents. In this post we will work through an example, downloading the annual income statements of the French company ‘Accor S.A.’ for the 2008 fiscal year.

How to do a simple search for a company

After you search for a specific company in Eikon the app or function you choose (such as Company Fundamentals, Chart, Share Ownership and Filings) will be applied to that company.

  1. The simplest way to start is to click in the search box at the top-left and type the name of the company, for example, company name ‘ACCOR’, and select the best match (it will show ‘EQ’ for ‘Equity’).
  2. You can also type its ticker ‘symbol’ if you know it. The default page is ‘SUMMARY’ with code ‘SOV’.
Search for company
Company summary
Simple search for company ‘Accor’. The ‘SUMMARY’ app for company ‘Accor’.

How to select source of financial statements

There are two sources of financial statements or ‘fundamentals’:

  1. Refinitiv Financials (formerly Reuters Fundamentals)
  2. Refinitiv Company Fundamentals (RCF)

Refinitiv Company Fundamentals is arguable better. You should be consistent with whichever source you choose.

Steps to change the source of financial statements:

  1. On any page, at the top-right, click the ‘My Eikon’ head icon then ‘Settings’.
  2. In the Settings menu, click the ‘Web’ button.
  3. Select your preferred ‘Fundamentals Source’ then click ‘Apply’.
Settings icon
Settings Web button
Set the Fundamentals Source choice.
Go to ‘Settings’, ‘Web’ then select the ‘Fundamentals Source’.

How to access financial summary and income statement (Refinitiv Company Fundamentals)

Steps to view a company’s financial statements and financial summary:

  1. On the ‘SUMMARY’ page, go to the ‘Financials’ menu and click on ‘Income Statement’.

2. Use the Excel icon on the right to export the current statement.

Financials menu for Refinitiv Company Fundamentals
Load ‘Financials’ and ‘Income Statement’ with Refinitiv Company Fundamentals

How to access financial history (Refinitiv Company Fundamentals)

Steps to view a company’s financial history:

  1. Use the filters on the left-hand side and above the table..
  2. If you want to view more data, change ‘Number of Periods’ to ‘All Periods’.
  3. Notice which currency and units are being used!
  4. Click the ‘Update View’ button to proceed.
  5. Scroll to the right to see more years.

How to access financial summary and income statement (Refinitiv Financials)

Steps to view a company’s financial statements and financial summary:

  1. On the ‘SUMMARY’ page, go to the ‘Financials’ menu and click on ‘Income Statement’.

2. Use the Excel icon on the right to export the current statement.

Financials menu with Refinitiv Financials
Income Statement with Refinitiv Financials
Load ‘Financials’ and ‘Income Statement’ with Refinitiv Financials

How to access financial history (Refinitiv Financials)

You can view a company’s own accounts as they were reported, or access standardised reports which make it easier to compare data across a selection of different companies.

Steps to view a company’s financial history:

  1. Use the ‘View’ drop-down menu to switch between ‘As Reported’ and ‘Standardised’ as required.
  2. Click on the cog icon to reveal more options to change currency or periods. (If you are viewing data ‘As Reported’, you cannot change currency.)
  3. Click the ‘Update View’ button to apply changes.

^ Back to contents

2. Price charts

You can view the history of the company’s share price on a chart, overlay other information, then download the image.

How to view a price chart

Eikon price chart for Accor
View Price Charts, for example for last five years.

Steps to view a company’s historical price chart in the ‘CHART’ page:

  1. Hover over the ‘Price & Charts’ menu then click on ‘Chart’.
  2. Click on the ‘5Y’ button at the bottom of the screen.

Compare companies on one price chart

We can compare the price history of Accor with another hotel group, Expedia.

Add instrument to chart
Compare two companies’ price history in one chart.

Steps to compare a company’s price chart to that of a competitor:

  1. Click on the ‘|->’ icon at the top left of the chart, left of ‘Templates’.
  2. Click in the ‘Add Instrument’ box to type names of other companies or series in.
  3. Type the name or symbol of the second company and select the best match, e.g. ‘Expedia Group’, and click ‘Update Chart’.
  4. Both company’s prices will appear in the resulting chart.

^ Back to contents

Export chart to Excel
Export the chart to Excel, to an Image file or copy the image to the clipboard.

3. Price history

Price charts are created from price history data. You can download the raw table of price history data to Excel icon to create your own charts or perform your own calculations. You can access ‘intraday’ data (intervals of 1, 5 or 30 minutes) for the last three months, or daily data going back decades.

How to find price history data

Price History in the menu
Price History table and choices
Price History download to Excel button
View the Price History for a company, change the interval, period or currency, then download to Excel.

Steps to view a company’s price history:

  1. On any company page, go to the ‘Price & Charts’ menu and click on ‘Price History’.
  2. You will be taken to the ‘Price History’ page (with code ‘QH’) for the currently selected company. You will see columns for date and close price. You will see some drop-down menus to change ‘Interval’, ‘History Period’ and ‘Currency Conversion’. Change these as you wish and click the ‘Update View’ button.
  3. Use the cog icon on the right to access ‘Settings’ so you can select which additional columns to include, such as volume and turnover.
  4. Use the green ‘Download to Excel’ icon on the right when you are ready to download the data.

^ Back to contents

4. Advanced search for companies

It can be difficult to select the correct company when it has a name that is similar to or the same as that of other companies, or if the company is no longer trading. In these cases you may need to do an advanced search.

Search for the search function
Search Tools
Advanced search for companies or other entities

Steps to do an advanced search:

  1. Click in the search box at the top-left and type ‘search’. Select the ‘Search’ app with code ‘SRCH’.
  2. On this Search Tools page, click ‘Companies/Issuers’ in the first column.
  3. Use the filters on the left to update the list of results in the middle of the screen. For example, click on ‘Company Name: Add’ and type part of all of the company name, then ‘Country of Domicile: Add’ and select the country or region. You may need to use the small triangle icons to select individual countries.
  4. You can export any list you create to Excel using the green Excel icon at the top-right of the results.
Advanced search (reset)
Search for all companies named ‘Apple’ in the US
Search for all companies named ‘Apple’ in the United States

Further support

- Getting help in Eikon.

--

--