-
Is it possible to retrieve FSCREEN including the added columns data in API?
I need to retrieve the following ETF attributes: Management Approach (Actively Managed or Passively Managed) Index Replication Strategy It was confirmed that there are currently no dedicated data fields or API fields available for these attributes. However, the information is available within the Fund Screener (FSCREEN)…
-
how can I pull in python the historical holding of an etf? for example the holding of XLK.P as of 31
how can I pull in python the historical holding of an etf? for example the holding of XLK.P as of 31-12-2019
-
Using LSEG APIs.
The client is able to access via Excel but not via our LSEG Data Library for Python. why ? ' TR.EUTaxTSC', 'TR.FundRIPosScnTheme', 'TR.FundRIPosScnPsTlt', 'TR.FundRIPosScnBIC', 'TR.FundRINegScnXWep', 'TR.FundRINegScnXTbc', 'TR.FundRINegScnXOth', 'TR.FundRINegScnXNuc', 'TR.FundRINegScnXGMO', 'TR.FundRINegScnXFsEn',…
-
Regarding Mutual Fund Data
I understand that Excel functions cannot retrieve historical holdings of mutual funds within a given universe. Is it possible to obtain this data through the API? If so, could you please explain the specific method for retrieving it, including any relevant API requests or examples?
-
Fund holdings
I would like to get fund holdings (LP40215045) by ISIN code using the API df = ld.get_data( universe = ['LP40215045'], fields = [ 'TR.FundName', 'TR.FundHoldingName(StartNum=1,EndNum=200)', 'TR.FundHoldingRIC(StartNum=1,EndNum=200)','TR.FdInvestorPctPortfolio(SDate=2021-12-31,EDate=2024-12-31,StartNum=1,EndNum=200,Frq=Q)'…
-
Retrieve historical fund holdings data via RDP API
Hello, I'm trying to retrieve historical Lipper fund holdings data via RDP API (which has been activated under my account) using Python. My python codes are as follows: import refinitiv.data as rd import pandas as pd rd.open_session() fund_ric = "LP60014953" fields = [ "TR.FundHoldingRIC", "TR.FundHoldingName",…
-
API | Is it possible to pull all tickers at once using the excel API feature?
Case 15650660 hi team, Is it possible to pull the Cryptocurrency and Blockchain attributes for the specified fund into Excel using the excel API feature? Also is it possible to extract data directly from FSCREEN into API excel?
-
Fund data points not pulling in through Python
Hello, It seems fund data points such as 'TR.FundCompany' or 'TR.FundType' or 'TR.Fund1YearPerf' are not pulling in through Python (I use Jupyter Notebook). Here is an example code: import lseg.data as ld ld.open_session() df = ld.get_data(universe = ['LP65011527'], fields = […
-
How to get hedge funds data?
Hi! I am trying to analyse hedge funds risk-adjusted performance as my final thesis topic for my master degree in finance. In particular, I would like to analyse the impact of lockup periods and high-watermark performance fee structure on the overall risk profile. Using the FSCREEN and ADVANCED SEARCH functions in LSEG…
-
Getting Fund's Constituents is not working
Hi, I am currently using the funds\v1\assets endpoint of the RDP API to retrieve all constituents of a fund via the “Holdings” property. However, I keep getting an empty result, as shown below: { "assets": [], "totalRecords": 0, "fromIndex": 0, "toIndex": 0, "pageNumber": 0} Does anyone know if I am using the correct…
-
How to download DHOLD with python for inactive funds? Details are attached.
I and my co-authors are trying to download the details of holdings portfolios of mutual funds. We can download the fund holdings for active funds (like LP40004027-AMG Boston Common Global Impact) by using the python code given below. This code gives the Fund Security Owned Name, Fund Security Owned RIC, Fund Investor…
-
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…
