-
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?
-
Does RDP Fund API provide a capability to retrieve time series daily TNA data?
Does RDP Fund API provide a capability to retrieve time series daily TNA data? I confirmed that I can retrieve daily NAV via the API as follows but couldn't find out the way to retrieve TNA daily data.. REQUEST import requests url =…
-
Screening for Article 6, 8 and 9 funds
Hello folks, I would like to know how to screen for UCITs and AIFMD funds and whether these funds are Article 6, 8 or 9 under SFDR regulation using python API. Your help would be muh appreciated! Ebtehal
-
Inconsistent lipper classifications
I have noticed inconsistencies in the global lipper classifications between the refinitiv documentation and the datascope select rest api. Documentation In the documentation https://www.refinitiv.com/content/dam/marketing/en_us/documents/methodology/lipper-global-fund-classification-methodology.pdf I see on page 11 that…
-
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 =…
-
In Refinitiv Data Platform, is collected allocations endpoint limited to top 10 elements? Can I chan
This endpoint for example https://api.refinitiv.com/data/funds/v1/assets/ISIN:IE00B03HD209?properties=CollectedAllocations retrieves top 10 results for each allocation. My client needs more than 10. Are we limited for some reason? Is there a way to change that?
-
issue when requesting holdings for the fund LU0855227368. Internal Server Error Occured
I have issue only when requesting this particular fund LU0855227368 its related to lipper api https://api.refinitiv.com/data/funds/v1/assets {'request': '80005475-0000-f400-b63f-84710c7967bb#PRD2-205', 'date': '2022-10-10T15:00', 'code': '500', 'status': 'Internal Server Error Occured', 'message': 'Invalid currency:…
-
Are there any ways to retrieve fund data using its Japan ITA code or retrieve Lipper ID from its Jap
Are there any ways to retrieve fund data using its Japan ITA code or retrieve Lipper ID from its Japan ITA code via RDP Lipper Fund API? If its's the case, can you please give me a sample code for that?
-
For Equity funds in Lipper Funds API: Is it possible to extract the percentages of Style: Growth, Va
For Equity funds in Lipper Funds API: Is it possible to extract the percentages of Style: Growth, Value and Core; and the percentages of Market Cap: Giant, Large, Mid and Micro? If yes, kindly provide sample syntax/endpoint.
-
DSS REST API - Lipper Fund - TNC.Total Net Assets - truncated value
Hi, Is there a way when performing a Scheduled Extraction getting the extracted data back in JSON rather than as a text (csv stream), either through some sort of 'coercing' or if there's an endpoint specifically to get the same output from the extraction in a JSON format, if DSS supports either of these 2 options? For…
-
Lipper API - Token Errors
Hi, we receive different token errors when we want to extract data via API from Lipper: Token Error 400, Token Error 401, Token Error 403 Could you please explain what these errors mean? In all cases we get no data.
-
Gathering information from Refinitiv API - Lipper ID problem
Hello, I’m writing this since I have a problem with the Refinitiv Workspace API regarding the Lipper RIC and the Lipper ID. Let me explain step by step what I’m trying to do. NOTE: I would like to use Python since is the easiest way to do this and I have a PDF file with all the codes - provided by a friend of mine - to…
-
Lipper info via DSS rest api
Hi, I can query fundallocation for funds via dss api but I could not find any way for getting Lipper Global Classification, further lipper information, benchmarks etc via DSS rest api. Any example or links to the references would be really helpful. Thanks! Irem
-
How to download multiple funds data in excel (lipper code)
Hello, I'm currently using the "build formula" option with the refinitv excel addin because I'm trying to download data from different funds. Is there a method, having all the Lipper code, to download everything I need (Rolling performance) just in a single excel file from ALL the funds? My specific aim is to download the…
-
400:"User has multiple PO identifying region, asset type and subscription" error message
I received the 400 error with the message "User has multiple PO identifying region, asset type and subscription" when I send a request for 62901149 via RDP Lipper Fund API. Can you please let me know how to resolve this error?
-
Extract historical Lipper fund performance data
I'm trying to extract monthly performance data for a list of Belgian Lipper funds. However, the result I obtain only shows the most recent year-to-date performance. My API request (in R, so forgive me for the slight difference in syntax with the Python syntax) for a single specific Lipper fund (LP60022034) is the…
-
problem about accessing the fund properties
I noticed another problem about accessing the fund properties... e.g. when I am calling https://api.refinitiv.com/data/funds/v1/assets/ISIN:LU1744756369?properties=DerivedAllocations,Holdings I don't have access to derivedAllocations and holdings anymore.
-
generate several usable tokens
Client experimented with an extra device Id param, and it seems that they could sign in multiple devices (generate several usable tokens) with the same account. Could you please confirm this is the way to operate with multiple instances under the same account?
-
Time_Horizon MiFID FIeld not being returned in RDP Lipper API
This field is obligatory for EMT 1.0 reporting standard and is currently available via LGDF. LIpperID examples: 68533325, 60033972. thank you,
-
Is Lipper API via RDP support EMT 3.0?
We see that almost all fields required under EMT 1.0 (European MiFID Template) is supported. Is there any confirmation 3.0 will be supported, if so by when? thank you.
-
Lipper API error message code": "insufficient_scope
Please note request on behalf of user jcarpio@imantia.com "error": { "id": "13dd5468-6ce8-4859-b235-08f1a6d185a4", "code": "insufficient_scope", "message": "access denied. Scopes required to access the resource [trapi.data.funds.assets.read]", "status": "Forbidden"
-
Pull Fund Management Company RIC for a given fund LipperID
Is it possible to retrieve the RIC of the fund management company of a given fund using the Eikon Data API get_data (or any other) function? I've managed to retrieve the fund management company name as follows: get_data('40061133','TR.FundCompany'). However, I'd now like to get further information on the fund management…
-
For a given Mutual Fund I would like to retrieve the LipperCode as well as the Benchmarks and the Se
E.g. df_in, err = ek.get_data('LU0056508442',['TR.ISIN', 'TR.CommonName', 'CF_CURR', 'TR.Fund3YearPerf', 'TR.Fund5YearPerf','TR.FundTotalReturnLipperRating', 'TR.FundConsistentReturnLipperRating', 'TR.FundPreservationLipperRating', 'TR.FundExpenseLipperRating']) For any Mutual Fund, e.g. LU0056508442, I would like to…
-
Go from lipperID to RIC or ISIN
Hello! I am trying to convert a LipperID into ISIN using the following formula: df,err = ek.get_symbology("LP60000008", from_symbol_type="lipperID", to_symbol_type="ISIN") df And get a following error message: Can not process metadata for request: SymbologySearch.from - value doesn't fall in valid range: [RIC ISIN CUSIP…
-
Pull all holdings of a fund using Lipper ID or eMAXX ID
Hello! I am wondering whether it is possible to pull data using Lipper ID or eMAXX ID for funds? If yes, what syntax should I use? The data that I am looking for is bond holdings and fund data (e.g. fund location, investor contacts). Many thanks!
-
Hi, I can't find the Lipper field for the SRRI (Synthetic Risk and Reward Indicator) !! I didn' find
Hi, I can't find the Lipper field for the SRRI (Synthetic Risk and Reward Indicator) !! I didn' find this indicator in fund overview screen. Do you know if it exists?
-
How to get lipper permID about the mutual fund in Germany?
I want to collect the data of the mutual fund in Germany from the Datastream, and I need Lipper PermID, but I do not know how to get lipper permID for the website?
-
Can I get decent hedge fund data via Eikon?
Hello everyone, I am using the Fund Screener app to get the hedge funds meeting certain criteria. However, it seems that there are not all funds listed because the research that I am aware of mentions the bigger numbers. Also, in Liquidated funds category, there are very few that contain NAV history. (e.g. out of ~1100…
-
time series funds
I'm searching a way to collect a time series of mutual funds. I need historical data of fees charged (quarterly or yearly) and of performance (monthly and quarterly). I could get data for TNA, rolling performance, initial date but I'm still missing these databases.
-
lipperftp.thomsonreuters.com feed: Future updates and any suggestion on best process
Hello, We are trying to map Long Only Data in our tool, which is received via this FTP lipperftp.thomsonreuters.com Is there a way I can check any forthcoming changes in the file and folder structure to ensure our tool adapts to these changes? Also, do you have any suggestions for developers working on this data…
-
How to use get_symbology method using Lipper ID
I tried to use the following call to search for different fund symbols. It was working using RIC, ISIN, but always got an error when using LipperID: ek.get_symbology(["LP60000008"], from_symbol_type="RIC", to_symbol_type="LipperID") It will fail using "from" or "to". I tried "lipperID", "LipperID", "Lipper ID",…