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.
