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