Refinitiv Data Python Cookbook

Fetching quarterly results

Show code cell content Hide code cell content

import refinitiv.data as rd

rd.open_session()

/home/runner/.local/share/virtualenvs/refinitiv-data-python-cookbook-I-HIyNf4/lib/python3.10/site-packages/refinitiv/data/_access_layer/session.py:71:FutureWarning: 
You open a platform session using the default value of the signon_control parameter (signon_control=True).
In future library version v2.0, this default will be changed to False.
If you want to keep the same behavior as today, you will need to set the signon_control parameter to True either in the library configuration file
({'sessions':{'platform':{'your_session_name':{'signon_control':true}}}}) or in your code where you create the Platform Session.
These alternative options are already supported in the current version of the library.

[Error 400] - {'error': 'access_denied', 'error_description': 'Account locked out due to provide incorrect password.'}

<refinitiv.data.session.Definition object at 0x7fa6c85cd510 {name='rdp'}>

You can use the Refinitiv Data Library for Python to retrieve quarterly results that company’s post each earnings season.

To do so, pass the company’s Refinitiv Instrument Code to the get_data submodule. In addition to the code, you must provide custom parameters that specify the metric, time interval and number of periods to retrieve.

Earnings per share

Here’s how to retrieve earnings per share for the last eight fiscal quarters for Thomson Reuters.

First define the metric you want to retrieve, followed by the time interval and number of periods in parenthesis.

expression = "TR.EPSFRActValue(SDate=0,EDate=-8,Period=FQ0,Frq=FQ)"

Then query the data for the company, asking for the metric as well as the date it was released and the last fiscal quarter’s end date.

rd.get_data(
    "TRI.TO",
    fields=[
        f"{expression}.Date",
        f"{expression}.periodenddate",
        expression,
    ],
)

Session is not opened. Can't send any request

---------------------------------------------------------------------------
ValueError                                Traceback (most recent call last)
Cell In[3], line 1
----> 1 rd.get_data(
      2     "TRI.TO",
      3     fields=[
      4         f"{expression}.Date",
      5         f"{expression}.periodenddate",
      6         expression,
      7     ],
      8 )

File ~/.local/share/virtualenvs/refinitiv-data-python-cookbook-I-HIyNf4/lib/python3.10/site-packages/refinitiv/data/_access_layer/get_data_func.py:63, in get_data(universe, fields, parameters, use_field_names_in_headers)
     57     warnings.warn(
     58         "Parameter 'use_field_names_in_headers' is deprecated and will be removed in future library version v2.0.",
     59         FutureWarning,
     60     )
     62 session = get_default()
---> 63 raise_if_closed(session)
     65 logger = session.logger()
     67 # Library usage logging

File ~/.local/share/virtualenvs/refinitiv-data-python-cookbook-I-HIyNf4/lib/python3.10/site-packages/refinitiv/data/_core/session/tools.py:37, in raise_if_closed(session)
     35 error_message = "Session is not opened. Can't send any request"
     36 session.error(error_message)
---> 37 raise ValueError(error_message)

ValueError: Session is not opened. Can't send any request

Revenue

The same logic can be used to query revenue, which is provided by the “TR.RevenueActValue” field.

expression = "TR.RevenueActValue(SDate=0,EDate=-8,Period=FQ0,Frq=FQ)"

rd.get_data(
    "TRI.TO",
    fields=[
        f"{expression}.Date",
        f"{expression}.periodenddate",
        expression,
    ],
)

Show code cell content Hide code cell content

rd.close_session()