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
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛