Average of field in Eikon data API.

Balagouda
Balagouda LSEG
edited January 2 in Eikon Data APIs

User running below script and she would like to add average of these 3 companies as output. We did try CODECR group analytics average but nothing really helped,

import eikon as ek
import pandas as pd

 

# Set up your Eikon API key

 

# List of company RICs (Reuters Instrument Codes)
companies = ['AAPL.O', 'MSFT.O', 'GOOGL.O']

 

# Fields to retrieve
fields = ['TR.EVToEBITDA']
date = '2024-06-30'

 

data, err = ek.get_data(companies, fields, {'SDate': date, 'EDate': date})

 

df = pd.DataFrame(data)
print(df)

has context menu

So, user want average EV to ebitda of all these 3 companies values.

Tagged:

Best Answer

  • [Deleted User]
    [Deleted User] Newcomer
    edited December 2024 Answer ✓

    Hi @Balagouda

    Does this code provide what you're after?



    import lseg.data as ld # pip install lseg.data

    ld.open_session()

    companies = ['AAPL.O', 'MSFT.O', 'GOOGL.O']

    fields = ['TR.EVToEBITDA']
    date = '2024-06-30'

    df = ld.get_data(companies, fields, {'SDate': date, 'EDate': date}).T

    df['Mean'] = ['Universe', df.T.mean().values[0]]

    df

Answers

Categories