Average of field in Eikon data API.

Balagouda

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.

jonathan.legrand

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