-
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…
-
[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?
-
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
-
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…
-
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…
-
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…
