-
Fund holdings data as at different dates
Hi, I am trying to obtain the holdings for a set of funds as at different points in time, on a quarterly basis over a 10-year period. I have tried using both the EIKON API, as well as CodeBook to do this. However, I notice that even though I change the date in the parameters field, the Number of Shares and Percentage of…
-
Retrieving 10-Year Monthly Returns for Multiple Mutual Funds via LSEG Workspace API in Python
Hi, I'm using LSEG Workspace for Students and trying to retrieve monthly returns for a list of mutual funds over the past 10 years using the API in Python. However, I haven't been able to find a function or endpoint that provides this type of time-series return data. I've checked the documentation, but couldn't identify a…
-
Peer funds retrieval
Hi, is there any way to pull the peers under the same classification under "Lipper Global" using Python. While pulling, i want to pull their ISINs and Benchmark names? below you can see to understand what i want.
-
Hi, is it a way to pull all fund peers in Python from the Refinitive Workspace which follow the clas
I need to pull this using Python. Who can help me?
-
ETF Ownership of equity
Hi, I am currently looking for a way to retrieve the % of outstanding shares held by ETFs of a single equity. I know that I can do this manually by looking at the Fund Ownership of an individual equity, however, I am looking at 150 equities over the past 20 years on a monthly basis. Thus, doing it manually is not an…
-
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…