-
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…
-
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…
-
[RDP API's] How can I get access to Funds target return and available share classes?
[RDP API's] How can I get access to Funds target return and available share classes?
-
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…
-
Net Asset Value Jumps
Hi Team, I am referring to the picture attached, which shows the time series of the nat asset value (NAV) for ric EEM (iShares, Inc: iShares MSCI Emerging Markets ETF) along with the closing prices retrived using python get data function. The values for NAV seem very low before Jul 2008. In terms of returns both are pretty…
-
How can I obtain the Debtor Domicile from fixed-income funds using the Refinitiv Data API?
In the workspace, there is a section with the summary holding > debtor domicile, for fixed income funds, like TIP, it shows country and the allocation in percentage. How can I retrieve this data? I couldn't find any data item that links to this specific information: ```python df = rd.get_data( universe=['TIP'], fields=[ #…
-
Getting Mutual fund time series data
Hello, for my thesis I have to obtain times series return data for several mutual funds (at least monthly, but daily would be better) from 2000-today. However, the data is not available in Eikon (for example when I try it with the build formula tool in excel). Is it even possible to get return data for mutual funds in…
-
How to get investment trusts list in Eikon api?
Hi,I want to get a list of domestic investment trusts in Python using Eikon Data api. Q1.Could you teach me how to write python code when I get all columns? like ek.getdata([JPFUND],[XXXXXX]) Q2.Could you teach me how to write python code when I get selected columns? like ek.getdata([JPFUND],[Lipper RIC,AssetName,ISIN…
-
Fund Management Approach
Hello, Very short and simple problem: I am trying to find the "Management Approach" field in the Eikon API, but so far without success: The ISIN for the window in the picture is LU1009760643. Best, BQXQ
-
RDP api.refinitiv.com/auth/oauth2/v1/token scope error
I am using RDP API to get data from resource https://api.refinitiv.com/data/funds/v1/assets In the rquest, a Bearer type token obtained from https://api.refinitiv.com/auth/oauth2/v1/token is being sent. The problem is that I am getting the following error: ### Request POST https://api.refinitiv.com/data/funds/v1/assets…
-
Syntax Error
Hi, I have received a formula for retrieving fund information, however, in order to apply the formula to multiple funds I am trying to translate it to python. However, I am encountering a syntax error. Can I remove the limitation of 5000 firms or add a limitation of 1000 firms if the number of retrieved funds is becoming…
-
What is the difference between 'OR' and 'AND' in Refinitiv Eikon Fund Screener?
What is the difference between 'OR' and 'AND' in Refinitiv Eikon Fund Screener? Because when I put, for example: Asset status is active AND Primary flag is yes AND asset universe is Mutual funds AND (Lipper Global is Equity France AND Lipper Global is equity sector energy), it works only when I use OR, that is (Lipper…
-
From FundCompany to LEI
I post the following code. I am retrieving info starting from ISIN codes and I want to retrieve FundCompany and LEI code. To do that I first retrieve the RIC code, then fetch fund company and from here I look for the LEI. The problem is that using the FundCompany retrieved from Refinitiv, the API can never find the LEI…
-
requestData for the funds API
In the python starter code for RDP the following can be used for the funds API: EDP_version = "/v1" base_URL = "https://api.refinitiv.com" category_URL = "/data/funds" endpoint_URL = "/assets" RESOURCE_ENDPOINT = base_URL + category_URL + EDP_version + endpoint_URL lipperID = "40003333" requestData = { "symbols": lipperID,…
-
EOD close price for ETFs
using the funds API, I want to get the EOD close adjusted price for ETFs. I am using this (it has 2 ETFs and one mutual fund). https://api.refinitiv.com/data/funds/v1/assets?properties=prices[start:2023-01-09%3Bend:2023-01-10]&symbols=SPY.N,QQQ.N,FCNTX for the ETFs (SPY.N and QQQ.N) I get MID and NAV and for the mutual…
-
primary RIC for ETFs
Say I have a list of ETFs, SPY, QQQ, XLF, etc... I would like to get the primary adjusted EOD close prices primary. Which suffix should I add is it .O or .N? Is there a unique suffix that I can use that maps automatically to the primary? I am using the funds api as follows:…
-
FUND and INVESTORS data
Since it is time-consuming if I get those funds and investors’ info one by one. I wanna use API to get a large amount of data and do my own analysis. Is it possible?
-
How to get ESG data for funds?
The case in the above screenshot uses a RIC for a fund which has ESG data on the Workspace. Unfortunately, when we try to read this into Python it does not return anything. The example case is MSFT.O and this loads the ESG data successfully. How would we do the same for Funds? One of the funds we are looking into is: Name:…
-
How to get the fund YIELD RATE and DIVIDEND info via Eikon API?
How to get the fund “预期收益率” and “股息” via Eikon API?
-
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 =…
-
What types of fund codes does the Eikon API support
There are many types of fund code, refer to the screenshot, what types of fund codes be supported when I using the Eikon get_data api? If I can use China Code CE as instruments param or not? df, err = ek.get_data(instruments=[fund code], fields=[ "TR.RICCode", "CF_NAME", "CF_CURR", "CF_DATE", "CF_TIME", "TR.FundLaunchDate"…
-
How to get fund issue date via Eikon API?
I want to get the fund issue date via Eikon API, but it returns empty, kindly help check if the field "ISSUE_DATE" is correct or not? Thanks. data, err = ek.get_data(instruments=['LP68728214'], fields=[ "TR.RICCode", "ISSUE_DATE" ]) Response: { "instrument": { "0": "LP68728214" }, "ricCode": { "0": "LP68728214" },…
-
How to get historical stock splits for mutual funds?
On 15th Oct 2020, there was a 1:6 stock split for CRSOX mutual fund. How to get stock split ratio or the adjusted factor to adjust the Fund NAV for any mutual fund? Image 1 code: column_fields = [ "TR.FundNAV.Date", "TR.FundNAV", "TR.TickerSymbol", "TR.InstrumentType", ] refinitiv_data, err = ek.get_data( ["CRSOX.O"],…
-
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 retrieve the entire mutual fund universe trading in the US market?
With the below code I can only retrieve upto 10k mutual funds. I can use IssueLipperGlobalSchemeName filter but there are too many lipper schemes in this PDF and some of the lipper schemes are not exactly matching with the Python output (Eg: In the PDF one of the schemes is called "Equity Sector Information Technology "…
-
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 =…
-
Retrieve fund derived holdings data via Python API
Hi, I would like to retrieve particular data upon Mutual funds/ETFs using Python (Refinitiv data platform and/or Eikon libraries): * Maturity allocation, * Debt structure and * Asset universe (whether the fund is ETF or Mutual). Here are some examples from Refinitiv Desktop: Thanks!
-
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?
-
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?
-
How to get total returns of US mutual funds using python eikon API?
The Fund NAV data for mutual funds is dont adjusted for dividends or capital gains. For stocks and ETFs I'm able to get the total returns using "TR.TotalReturn1D" but for mutual funds Im not able to get the total returns. Because the prices are not adjusted, calculating return on the unadjusted price will be wrong on the…
-
Mutual fund data extraction
We have reviewed the query you raised in relation to extracting time series mutual funds domiciled in the U.S. and Europe and their holdings using API (Python) and filtering ESG from conventional mutual funds.
-
Excel formula for fund flows in Global Fund Flows App
Dear support team, How can I directly download using the time series request in Excel data from the Global Fund Flows App in Eikon? I am interested in the fund flows (flows(LC)). What is the name of the datatype? Is there an alternative formula to get this data? Thanks in advance.
-
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…
-
Can I retrieve all mutual fund data via Eikon API with python?
I need to retrieve all fund data e.g. nav, Lipper ric,,.. can I use python with eikon API to retrieve all fund data? because I need to retrieve automatically everyday
-
Fund ESG scores - which API?
1. Which API is suitable to fetch Fund ESG Scores including all Fund ESG sub-category scores? 2. Are Fund ESG Scores available historically? 3. Is there a list of available Fund ESG data items?
-
Mutual Fund Holdings - (S12)
Hi, I want to know how to download the S12 mutual fund holdings data. I have a workspace account. Can I download it using RDP? Thanks.
-
How to get holdings on the fund/portfolio level?
Hello! I'm using the Eikon APIs, I'm looking to get holdings on the fund/portfolio level. On the full firm level, I can do: data, err = ek.get_data([cusip], ['TR.H.REPORTDATE', 'TR.H.HoldingCompanyName', 'TR.H.PARHELD',] However, if a firm has multiple funds invested in that CUSIP, this will return it on a firm aggregated…
-
Fund's asset status
Is there a way to obtain asset status with excel formula ? In this example, LU1254140103 is liquidated Matthieu