-
Lipper Fund Distribution/Dividend Data
Hi, my client is using WS API through the codebook. they have advised that they are unable to extract funds distributions data using the sample RICS and datatypes below. Is Lipper Data available in Codebook? LP68378190 LP68037657 VAS.AX IOZ.AX…
-
is there any chance of getting this data for specific years, such as 2022, 2023, and so on? I have a
Client query: is there any chance of getting this data for specific years, such as 2022, 2023, and so on? I have access to the API via Python, and I do a lot of my work that way, as it’s easier for certain tasks. Do you know if it might be possible to do it from Python? And resolution provided was: I have reached out to…
-
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",…
-
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…
-
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…
-
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…
-
Historical RICs on Mutual fund holdings
Hello everyone, I’m attempting to retrieve historical mutual fund holdings using the following code: However, the table appears as follows: As you can see, the code returns only the RICs from the most recent holdings, not those from earlier dates. I have two questions: How can I retrieve historical RICs for my mutual fund…
-
How can I use API to authomatically download funds' holdings informations?
Hi everyone, I am a researcher at the Catholic University of Milan, currently working on a project that involves historical holdings data for U.S. actively managed mutual funds. Specifically, I require the full holdings information (not just the top 3 holdings) for all such mutual funds, on a quarterly basis over the past…
-
Is there any way to create dynamic Fund screening (from FSCREEN app) by using Eikon/WS API ? Image a
Is there any way to create dynamic Fund screening (from FSCREEN app) by using Eikon/WS API ? Image attached(Indian Mutual funds screening)
-
Return RICs based on their return and Lipper Category
Hello, is there a way to return all lipper RICs with fund objective based on their Lipper category and return. For example I would like to get all Lipper RICs that are under "Money Market USD" Lipper category that had price return from 0 to 5% from 31/12/2022 to 31/12/2023 and 2 to 10% return from 31/12/2023 and 31/7/2024.…
-
Lipper for Investment Management - Mutual funds with missing Asset Universe
Hi, I have downloaded data from around 30 countries and noticed that many funds (more than 30,000) are missing their Asset Universe information Here are the Lipper IDs of some of these funds: 402350604023506140209231402092394020924240209238402092494020925640209257402092514003959940039600 Is there an alternative way to…
-
APIで取得するデータ定義の確認
平素より大変お世話になっております。 Refinitiv Lipper Funds APIを利用してデータを取得させて頂いているのですが、下記内容についてご回答お願いできますでしょうか。 お手数おかけしますが、よろしくお願いします。 Q1 ・騰落率（1・3年） ・シャープレシオ（1・3年） について、期限（始点～終点）の基準となる営業日（終点）は正確にはいつか？ Q2 ・騰落率（1・3年） ・シャープレシオ（1・3年） について、期間は営業日数ベースではなくカレンダーベースという理解で良いか？ Q3 ・騰落率（1・3年） ・シャープレシオ（1・3年）…
-
Pulling Lipper fund holdings for a large list of RIC instruments using Eikon API (python)
Hello, I need to pull Lipper fud holdings for a list of more than 4000 RIC Instrument. I am using the code copied below, but i get Expected timeout error. Is it possible to pull these data with only one code? df0, err = ek.get_data(RIC_list0, ['TR.FundHoldingRIC','TR.FundHoldingName',…
-
How to link Lipper API to Power BI using Python?
What we do is get the output from the API, save as csv files, then use those files in Power BI. It is taking a bit of time to load though. Can you recommend a better approach to link the API to Power BI?
