PGA2298 is an object of Quote. I need to use Eikon API get_data to get the PGA2298 content. But get_data can only be used like: ek.get_data(['PGA2298'],['TRDPRC_1', 'BID', 'ASK', 'ACTIV_DATE', 'TIMACT'] ) So my question is how can I get the content of PGA2298 . Is there a special Field for the content ? Thanks
Hi, I want to extract daily spot and forward FX data at the exact same time of the day. It seems that ek.get_timeseries is not using standardized time and I want to enforce that. I am using the code: ek.get_timeseries(RICs, fields, start_date, end_date, interval = "daily") However, for a simple example of "EUR=" and "JPY="…
I use eikon api to get dxy data, such as TR.CLOSEPRICE TR.CLOSEPRICE.date but data I got is not the same as I found on some fin websites. I think the problem is due to TR.CLOSEPRICE.date is not the same as I saw on other sites. For example, the following are I get from eikon api, Instrument Close Price Date High Price Low…
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…
It looks like you're new here. Sign in or register to get started.