I have a list of Lipper fund IDs and I'm trying to get data for those funds. Since it's a long list, I'm using Eikon API to get the data. The Python codes look like this:
import eikon as ek import os import pandas as pd ek.set_app_key('xxxxxxx') # import the fund list df = pd.read_csv('fund_list.csv') fund_list = df['Lipper Primary Fund Class ID'].tolist() # variables field= ['TR.FundName','TR.FundType','TR.FundGeographicFocus','TR.FundLegalStructure'] # call the function batchsize = 5000 df = pd.DataFrame() for i in range(0, len(fund_list), batchsize): batch = fund_list[i:i + batchsize] print(i) data, err = ek.get_data([*batch], field, {'SDate': '2021-12-31'}) df = df.append(data) filename = 'year' + str(2021) + '.csv' df.to_csv(filename)
The code works fine. My problem is that I can't get the correct variable names to put into the 'field' list for some data points.
I'll need the following data in the Lipper fund database:
Promoter Name; Investment Advisor Name; Sub-Advisor Name; Fund Management Company Name; Administrator Name; Countries Notified for Sale; Group Pension; Infrastructure Fund; Institutional Fund; Insurance Funds; Pension Trust; Investor Type Eligible Counterparty; Investor Type Professional Investor; Investor Type Retail; Asset Status
I can get the data on a fund if I use the "Screener" in the Refinitiv Workspace. I'm looking for advice on how to get those data items for a list of funds using the API. I have contacted the Customer Service team and have been advised that I should raise the question here.
I have checked the DIB (Data item browser) and couldn't find those items.