I have a really heavy excel file 400K rows, and I need, using cusip or ticker and date of shareholder meeting (variables for each row) to download data such as revenues, total asset, market cap, etc. for my thesis. I tried excel =TR(...) formula, but does not recognise cusip or ticker, while datastream recognise the ticker…
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…
Replicated the code and notice that the issue is replicable: The Last day becomes N/A for March 29, 2004, when we adjust the end date to March 30,2004 then the 29 has value and the N/A moves to the day 30. Here is the code try changing the End date into march 29, 2004 then 30 and then 31 import refinitiv.data as rd…
Hi there. The rd.get_history method does not appear to be returning prices for granular intervals. this code: testobj = rd.get_history(universe=CLF3^2, fields=['TR.SETTLEMENTPRICE'], interval="daily", start="2022-11-12", end="2022-11-25" ) print(testobj.shape) testobj (9, 1) CLF3^2Settlement PriceDate…
...rsion 1) from Eikon? For example ITRAXX Europe Serie 35 (version 1) has components as shown in the screenshot. I want to use python to get the RIC for each of them. What should I do? Thanks!
Hello, when I try to set the API key , I got this error message , Can you help me ?
I am using the refinitiv data library for python to connect to the Refinitiv Data Platform API. I would like to check what the signon_control parameter does as I am getting this warning? You open a platform session using the default value of the signon_control parameter (signon_control=True). In future library version…
...3000 constituents using API? Hi team. I have a client who needs to pull company name, GICS Industry Group Name, 260 day volatility, and market cap of Russell 3000 constituents using API. I tried to pull this data using Codebook and was successful. Please see screenshot below. However, when client tried it using Python…
... fields When using Workspace API in Python under Windows 10, some fields produce "NaT" results, but these fields have full values in Data Item Browser. E.g. the Python command df=rd.get_data(['MMM.N','BAG.L','AOS.N'], ['TR.ISUpdateType','TR.IsISFlashUpdated','TR.IsBSFlashUpdated','TR.IsCFFlashUpdated'],…
...->'Search&Discover' and 'Advanced News Search' I want to know how to use GET/POST to send requests and call the following two APIs
It looks like you're new here. Sign in or register to get started.