Revenue per Country in excel -> for specific list of ISINs and specific countries

MyScreenName

Hi !

Hope this find you all well.

What about looking for a specific list of countries and multiple ISINs.

My code should work but in fact doesnt.

Could someone kindly help me.

import refinitiv.data as rd
import pandas as pd
rd.open_session()

countries = pd.read_excel("List_Of_Countries.xlsx")
isin= pd.read_excel("List_Of_ISIN.xlsx")
display(countries)
display(isin)

isin_list = isin['Unnamed: 0'].iloc[1:].tolist()
countries_list = countries.iloc[0, :].tolist()

GeoRaw = rd.get_data(
universe = isin_list,
fields = ['TR.CoRRevenueFraction'],
parameters = countries_list
)

display(GeoRaw)




Jirapongse

@MyScreenName

Thank you for reaching out to us.

The code could be like this:

rd.get_data(

    universe = ['IBM.N'],

    fields  = ['TR.CoRRevenueFraction','TR.CoRRevenueFraction.ISO2Code'],

    parameters = {'CountryCode':'US,GB,FR'})