-
News data for academic research
Hello, I am doing research for a PhD and I am trying to get news headlines data for certain keywords over a 5 year span using Workspace's APIs via Jupyter notebook. Are there restrictions on the amount of historical news data available via the Eikon Data API and the EDP API, even with an academic account? I have seen it…
-
How to obtain fiscal quarter period name, earnings release as well as period start and end dates
I am looking to obtain the fiscal period name, start and end date as well as earnings release date for a set of tickers. I can obtain the earnings release date and period end date using the code below, but I am unsure how to get the actual fiscal quarter/period (i.e. FY19 Q1)…
-
Insonsistent data retrieval with eikon get_data
Hello, I need to collect historical data for multiple companies. While I wrote the code to do this and experimented with it, I realized that data which is returned differs sometimes, even though I am using the exact call. This is more than inconvenient because I can not rely upon the data which is collected. Has anyone…
-
Daily prices for Nordic Prices
Hi I am trying to find the Daily prices for system price in Nordic Power market (POWNOORD), but only weekly is shown in the overview section, in the graph with name "Hydro Balance, System Price and SRMC COAL". Want the Day ahead prices from 2014 to 2024. Any help I can get with this?
-
Price Index and Return Index data for the MSCI World
I want to obtain the Price Index and Return Index data for the MSCI World over the past decade, but I am unable to find the correct API command or field. Could you please tell me which fields or parameters I should use in the Eikon API to extract this data?
-
How to retrieve monthly institutional shareholding data for over 200 firms from 2003 to 2023 usin...
...g Eikon API Hi everyone, I am relatively new using Eikon API and I am also relatively unfamiliar with the code. I want to retrieve the monthly institutional shareholding data for about 200 firms from 2003 to 2023 without having to download the shareholder report for every company one by one. Specifically, taking one…
-
How to pull whole list of active bonds for an issuer in python
In python, I need to download the full list of bonds that are currently active on the italian BTP curve. For each bond, I would like this information: -Cusip -ISIN -Dirty Price -Coupon -Last coupon date -Next coupon date -Issue date -Maturity -Description -yield to maturity For something else, I'm currently using the…
-
What's the differences between several municipal bonds dataset
Hi team, I am trying to retrieve issue data for U.S. municipal bonds. Currently, I’ve found a dataset called “U.S. Municipal New Issues” under the SDC app, which contains 334 fields and can be directly downloaded through Refinitiv Workspace. Additionally, when I navigate to Fixed Income – U.S. Municipal in Refinitiv…
-
Is it possible to obtain the aggregate average trading volume across different exchanges/share cl...
...asses? Hi, say TUYA INC has three different instruments trading, 2391.HK, TUYA.K, & TUYA.N the average trading volume (30 days) on DIB are: 8,533, 722,378, and 125,254 respectively, I was wondering if there's any way to obtain the aggregate trading volume - 856,165 of an security using Refinitiv.Data? Thanks
-
What is actual master RIC to get all SPY and SPX options ?
Can you please tell me What is actual master RIC to get all SPY and SPX options ? . I want to download SPY and SPX options complete data of 5 years.
-
Workspace is able to recognize specific SEDOLs but api fails
Hi, if you search 6195739 (sedol code), you'll get Chubu Steel Plate Co Ltd on Workspace; However, if I use rd.get_data(universe=['6195739'], fields=['TR.PriceClose']) it returns RDError: Error code -1 | Unable to resolve all requested identifiers in ['6195739']. However, if I use the corresponding RIC code: 5461.T, and…
-
Is it possible to get information of all share classes of a company using Refinitiv.Data on Python
Hi, I'm wondering if it's possible to get the information (e.g. price, volume) of another share class given a specific share class. say, GOOGL.O, Google, on GOOGL.O BUS page, there are 6 types of shares, and they're GOOGL.O, GOOG.O, GOGL34.SA, GOGL35.SA, GOOGLm.BA say given the RIC code - GOOGL.O, is it possible to obtain…
-
Refinitiv Python Connection Open session HTTTP Request id 0; get_date failed
Hello, I'm using Python and connecting to Refinitv.data. The script is run by Task Scheduler, after rd.open_session(), the get_data() function is failed to perform. It worked well when I'm using Jupyter. Below is the message. Would anyone be able to help me with the issue. Thank you for your help. Best, Tim
-
How to efficiently and briskly retrieve datapoints for all SNP 500 RICs
Hi everyone, I am trying to retrieve some Fundamental and Reference data for all of the SNP 500 stocks. These datapoints include values such as Income before Extraordinary Items, EBIT, Capital, etc. Now, I am trying to asynchronously retrieve all of this data. At first, I tried to loop ethrough the list of the RICs of the…
-
From where can I get RIC decoder for SPY options ?
I got RICs like this while downloading RICs for SPY options SPYJT091317100.U, SPYJH171317100.U, SPYJT091316850.U how to decode them. where can I find rules to decode such RICs ?