portfolio_holdings CUSIP.pdf Attached are the portfolio holdings I have retrieved from the 13F holdings from Refinitiv. The column name "CUSIP" provides the company 8-digit CUSIP. My next step is to obtain the Scope 1 and Scope 2 emissions from each company listed here. This is only a small part of my dataset; therefore, I…
...be header Date. This causes an issue when you pull the data with a python script to Power BI as the col is ignored.
How do i remove the extra row from my data set. df = ek.get_timeseries (["CAD=;CAD1M=;CAD2M=;CAD3M=;CAD4M=;CAD5M=;CAD6M=;CAD7M=;CAD8M=;CAD9M=;CAD10M=;CAD11M=;CAD1Y="], start_date="2024-01-01", end_date="2024-03-31", fields="CLOSE") df Thank you.
Please translate the attached template into Python? At least the data retrieval in the "Refinitiv" tab. The output would either be an Excel spreadsheet with the information in that tab (at least the Refinitiv "pull-out"; we can put the formulas somewhere else), or the full spreadsheet with the other tabs too. The point is…
Recently, SAIC.N is changed to SAIC.O. How to keep track of such RIC change via EIKON API functions? Our application relies on RIC as the unique identifier to a list of securities and needs to keep track of these RIC changes once it happen.
I have created below formula import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['META.O'], fields = [ 'TR.TPEstValue.brokername', 'TR.OverallAnalystEstimateRating' ] ) display(df) Can the team confirm if this is the best way to get the data required? Kindly advise. Thanks.
Hi I'm trying to replicate a search I complete using the Eikon News Monitor. Below is the code I use in the search bar when completing the search. Topic:GB AND "restatement" The issue I am having is that in the News Monitor, I change the Search Mode from 'Headlines' to 'Headline & Story Text' which I am unsure how to do…
Hello, I'm working with Brazilian data and trying to get price, return, trading volume and market capitalization (in units) for all firms in the past 15 years. However, I'm having trouble getting the data for delisted stocks. I asked Refinitv Support and they told me the following: "The information that exists for delisted…
Hi, When using the Eikon API from python, I am getting a "403 Forbidden Error". This was previously working. import eikon as ek ek.set_log_level(1) ek.set_app_key('XXXXXXXXXXXXXXX') df, err = ek.get_data(instruments = ["LSEG.L"], fields = ['BID','ASK']) print(df) When I run the simple test code above, I get the following…
Hi everyone, I'm kinda new in refinitiv and I wanted to get the historical ownership over time of some companies for a 20 year span. I have found that data is available in workspace but I was wondering how could I get it through the api to directly export it into a .CSV file df = ek.get_data('EQNR.OL',…
It looks like you're new here. Sign in or register to get started.
