Getting data from Lipper fund using Eikon API

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.
Best Answer
-
Hi @Jiaman.Xu ,
I'm really sorry for the issue you're facing, this is more like a question about the content, hence, I already inform the support team in ticket number 11870276 to provide the resolution (show you how to retrieve it using =@TR formula in Eikon Excel, then the moderators on this forum can help you translate it into get_data method in Eikon Data API call. ) as the moderators on this forum do not have deep expertise in every type of content available through Refinitiv products. Such expertise is available through Refinitiv Helpdesk.
Hope this helps and the support team is going to contact you soon.
0
Answers
-
@Jiaman.Xu , The current Eikon API (same API used by Eikon Excel) only covers a small sub-set of Lipper contents. Hence, if you do not see the fields (all fields with name starts with "TR.Fund") in Eikon API's DIB (or in Excel's Formula Builder), it is likely the data is simply not in the Eikon API. The Eikon/Workspace desktop applications is not using the Eikon API. The newer RDP Funds API should cover most of the Lipper contents.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 685 Datastream
- 1.4K DSS
- 616 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 252 ETA
- 556 WebSocket API
- 38 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 652 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 228 TRKD
- 917 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛