-
Can you share a list of mutual fund data points and tell me which ones are available via API?
Case- 15312764 Query- I would like to request the following information: I would also like to know which data items can be used to retrieve the following information (as shown in the attached screenshot): Fund Administrator Fund Advisor Custodian Fund Management Company Promoter Furthermore, I would like to understand how…
-
If I want to populate a list in python with all the mutual funds existing, how do I do that ?
If you’re familiar with the process, would you be able to share the code or point me in the right direction? I have tried to use the material given but it does not really explain how to correctly write a query in the function. For now I have written this: rd.open_session() search = rdp.search( view =…
-
Pull historical Lipper derived holdings data using RDP API
Hi! I would like to pull historical derived holdings data for +1000 funds on LSEG Workspace (specifically Lipper) using the Python API. I saw a few posts that I might want to use the RDP API for such tasks. I have accessed RDP but can't figure out which functions I should use. Could you provide some instructions? Below is…
-
How to Retrieve ETF Split / Reverse Split Events (Including Cancellations)?
I am currently working on an ETF data integration project and need to track corporate actions such as forward splits, reverse splits (consolidations), and their scheduled dates for ETFs. Here’s what I have observed so far: • Using the RDP Lipper Funds API, I can retrieve historical data on ETF assets, pricing, and…
-
Is it possible to access a fund screener using R or Python
Is it possible to access a fund screener using R or Python in order to download a list of all available funds or ETFs based on selected filters? Raised on behalf of external client.
-
Fund holdings data as at different dates
Hi, I am trying to obtain the holdings for a set of funds as at different points in time, on a quarterly basis over a 10-year period. I have tried using both the EIKON API, as well as CodeBook to do this. However, I notice that even though I change the date in the parameters field, the Number of Shares and Percentage of…
-
Retrieving 10-Year Monthly Returns for Multiple Mutual Funds via LSEG Workspace API in Python
Hi, I'm using LSEG Workspace for Students and trying to retrieve monthly returns for a list of mutual funds over the past 10 years using the API in Python. However, I haven't been able to find a function or endpoint that provides this type of time-series return data. I've checked the documentation, but couldn't identify a…
-
Peer funds retrieval
Hi, is there any way to pull the peers under the same classification under "Lipper Global" using Python. While pulling, i want to pull their ISINs and Benchmark names? below you can see to understand what i want.
-
Hi, is it a way to pull all fund peers in Python from the Refinitive Workspace which follow the clas
I need to pull this using Python. Who can help me?
-
ETF Ownership of equity
Hi, I am currently looking for a way to retrieve the % of outstanding shares held by ETFs of a single equity. I know that I can do this manually by looking at the Fund Ownership of an individual equity, however, I am looking at 150 equities over the past 20 years on a monthly basis. Thus, doing it manually is not an…
-
Why is data not flowing in API while available in Excel for active funds?
Hi Team, We have use Code like this one: import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['LP68702800','LP68611492'], fields = ['TR.ISIN', 'TR.FundName','TR.FundObjective','TR.FundRIESGEnviron','TR.FundRIESGGov','TR.FundRIESGSoc'], ) display(df) These fund RICs are active so we are curious why it…
-
How to get historical holdings and allocation data for funds?
How to get monthly or quarterly changes in a fund holdings, sector and country allocations? With the below code I'm only able to get the recent holdings and not the historical holdings. Python column_fields = [ "TR.FundHoldingRIC", "TR.FundHoldingName", "TR.FundPercentageOfFundAssets", ] refinitiv_data, err =…
-
Retrieving RIC Code Using FundSearch Endpoint
I am performing a fund search using the following endpoint: https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/FundSearch Despite specifying "PreferredIdentifierType": "Ric" in my request, I am consistently receiving ISIN codes instead of the desired RIC code. How can I ensure that I get RIC codes?
-
How to get fund portfolio data
I use Eikon in Excel. 1. How can I get a list of all Korean mutual funds? Even though I used the code below, an error occurred and I was unable to obtain data. =TR("FDS_ALLFUNDS", "RIC,Name", "COUNTRY=South Korea;FUNDTYPE=Mutual Fund") 2. How can I get 10 years of quarterly fund ownership portfolio reports for all the…
-
Eikon box shows different fund constituents than EIKON Python API
@nick.zincone Hi, I am using EIKON API to retrieve Fund constituents using Python ("EAP" in sequel) script shown below. Upon comparing it with what I get from EIKON box (Derived Holding), I see a "slightly" different picture a. "EAP"result gives a total of weights equal to ~300% whereas EIKON box shows 100% ("ACCOUNTS…
