-
How to Retrieve ETF Split / Reverse Split Events (Including Cancellations)?
I am currently working on an ETF data integration project and need to track corporate actions such as forward splits, reverse splits (consolidations), and their scheduled dates for ETFs. Here’s what I have observed so far: • Using the RDP Lipper Funds API, I can retrieve historical data on ETF assets, pricing, and…
-
Where can I find a guide or documentation that lists all ETF data items available in Workspace?
Hi all, I am a student using Refinitiv Workspace through my university, and I’m currently working on a project involving Exchange traded funds domiciled in Europe. I’d like to better understand what’s possible with my account and how to find the right resources. Is there a field guide or documentation that lists all ETF…
-
Is there an existing metric that computes the Total Return including dividends and net of costs?
Hi, I am looking forward to understand how a pool of actively managed mutual funds yields benchmarked to three ETFs using LSEG Refinitiv's workspace. I want to download and personally go through the analysis, but I need to find the right metric to download first. I have three different questions: 1. The NAV is net of every…
-
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…
-
Refinitiv API - full ETFs holdings list and weight
Hi team, I am trying to get the full holdings list for a series of etf using the refinitv API. I have a code to do it for lists / indices, but the same doesn't work for etfs, for which I can only seem to get the top 10. The first code below gives you the top 10 holding of the etf. The second gives you the full list (for a…
-
Dividend Yield of All ETFs
Is there a way to get dividend yield data for all US stocks and ETFs in bulk using a Python API?
-
ETF data for Issuer, AUM, NAV and other fields
I am currently trying to retrieve two types of data: Static Data and Historical Data. Below is a sample code that I've been working with, but I am having trouble identifying the correct fields to use. I would appreciate your help in correctly adjusting the Select or Fields sections. * For Static Data, I need the following…
-
Data retrival using RIC vs CUSIP
I am using a list of RICs to retrieve data: fields = ["TR.CUSIP","TR.OPENPRICE", "TR.CLOSEPRICE", "TR.BIDPRICE", "BID", "TR.ASKPRICE", "ASK", "NAVALUE", "TR.NETASSETVAL", "TR.Volume", "TR.NUMBEROFTRADES", "TR.CompanySharesOutstanding", "TR.SharesOutstanding", "TR.Name"] month = rd.get_history(universe="TZA", fields=fields,…
-
we were looking for some ETF about HST_Close avec Adjust_CLS on excel an Python
Hello we were looking for some ETF about HST_Close avec Adjust_CLS on excel an Python, For each ETF we found a difference between Adjust_close and HST_CLOSE despite there are no corporate actions. By the way, GF and CAGG ETF symbol are converted to FCc1 and CACG.B within our script provided from refinitiv and returns no…
-
Data retrival for delisted ETFs
Hi Team, trying to get benchmark name and ric for several ETFs (using their respective rics). The following code works perfectly for listed/ active ETFs: fields = ["TR.FundBenchmarkName", "TR.FundBenchmarkType", "TR.FundBenchmarkInstrumentRIC"] ric = "SPY" benchs = rd.get_data(ric, fields=fields) However, for all delisted/…
-
Aggregating historical fundamental metrics by ETFs/Index through Refinitiv API
Hi guys, I would loke to know if there is a smart way to get time series for valuation/fundamental data at etfs/index level. The only way I found for now is to pull the historical weights and the fundamental/valuation data for each stock and then to aggregate manually, but this is - as you can imagine - not so clean, as…
-
Historical daily market caps for constituents of ETF
Using Refinitiv Data API with Python: Exploring if it is possible, especially without looping any requests, to get the daily historical market cap for any given ETF? By that I do not mean the market cap for the ETF but the sum of market caps for the constituents. Is this data that is available?
-
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…
-
NAV of ETC (e.g. 4GLD.DE) missing
Hi Team, I'm interested in getting historical NAVs of ETPs at all. Therefore i use the ek.get_data to get NAVs vom ETFs (which works fine for SPY5 e.g. ). If i want to receive NAVs from ETCs (g.e. 4GLD.DE "Xetra Gold") with the same code, i don't get sufficient data. Here's my code: NAVs =…
-
Had a query where we receive the price updates outside exchange hours for LQD.P. What could be tr...
...igger for price change if exchange is yet to open? We have US ETF and before market opened we see prices are fluctuating Had a query where we receive the price updates outside exchange hours for LQD.P. What could be trigger for price change if exchange is yet to open?
