-
DSWS API returns invalid data
Hi, When I execute the following via the DSWS API I receive the following data: ds.get_data(tickers = '8857RL', fields = ['DSCD','ENAME','ISIN','RIC','T1C','LEI',] ,kind = 0) When I use the same DSCD in the web portal, the ISIN is correct. When I try to search the web portal for the ISIN returned by the API, I receive no…
-
What are the ColumnNames in the backend for the following variables in workspace:
What are the ColumnNames in the backend for the following variables in workspace: - Price Date - Has Warrants - China Securities Regulatory Commission - ASEAN Capital Markets Forum - National Association of Financial Market Institutional Investors - Amount Issued (USD) - Next Coupon Payment Date - Amount Issued - Amount…
-
Historical S&P Constituents
Hello, I am currently writing my Master thesis and I am in need of the constituents of the S&P500 on several historical dates. I am using the Workspace Formula Builder in Excel. Unfortunately it does not work. Does anybody have an idea or knows how to do it in the web version? Many thanks!!! Robin
-
Industry codes in MnA
I need granular NAICS codes for MnA deals. However, I only seem to get industry labels and descriptions. Merging these back to codes would be extremely painful. How can I pull these with TR.MnA through the API? If this isn't possible, does Eikon provide a match table?
-
Delistings in Europe
Hello Guys, I have the following Problem and i would really appreciate help. I want voluntary and unvoluntary delistings in Europe between 2010 and 2024. Additionally i need the delisting announcement date (not when the company delisted). Therefore i need the reason why a company delisted (Bankruptcy, Liquidation, M&A,…
-
Data item definition in Refinitiv Data Library
My formal colleague left a Python code (refinitiv.data) for entity search purpose (part of it is as below), which is running fine. But I want to get deep dive on the entity information, now I couldn't find any document like a data dictionary for me to know what get_data() returns, and what are the items meaning in returns.…
-
Hang Seng Bank wants to understand if Market By Order data is available via MBO data domain. They wa
Hang Seng Bank wants to understand if Market By Order data is available via MBO data domain. They want to understand if the order can be mapped to the broker ID; such that they can identity which order is belong too Hang Seng Bank (2313)
-
Help Needed: Historical OMXSPI Constituents Using Eikon Excel Add-Ons
Hi everyone! I’m a bachelor’s student from Sweden, currently writing my thesis on excess comovement by index events. This is my first time using Eikon, and I have access to the Eikon Excel add-ons. I’m trying to retrieve historical data on the constituents of the OMX Stockholm All-Share Index (.OMXSPI) for my research.…
-
Real-Time SDK TRADE_DATE
I am planning to use TRADE_DATE field that is FID16 in Real-Time service for stock exchange data. It is not clear from the documentation what timezone it is. This is all the info: The date of the value in the field TRDPRC_1. Category Real-Time Trades Closing Run Logic Does not clear Data Source Feed DDE Acronym TRADE DATE…
-
'NoneType' object has no attribute 'get' error for API data
Hello all, I am trying to download a list of index constituents using the eikon data API, however, i am getting a 'NoneType' object has no attribute 'get' error for this code : import eikon as ek import pandas as pd from tqdm import tqdm # Import tqdm for progress tracking Your Datastream API keyapi_key = 'kEY ' Initialize…
-
Please help with this code, since I am unable to make this code work "OLS Regression[3]" from RDP wi
The chart table is not returning any values for OLS regression. Full code below and I have highlighted in bold for the code on "OLS Regression[3]". import getpass import refinitiv.dataplatform as rdp # the RDP library for Python import pandas as pd import numpy as np import cufflinks as cf # to plot graph by pandas data…
-
how to calculate annual dividends per share using direct functions or python?
I need assistance with obtaining dividend data from various companies. Since not all companies pay dividends at the same intervals, it is most practical to calculate the total annual dividend. In the attached image, you can see that individual dividend payments are listed. However, I would like to display the summed annual…
-
Retrieving Data using Datastream Codes
Hi, I am trying to retrieve data using datastream codes from Excel Add-in (workspace). But, whenever I give LSEG instructions to download the data, even if it is for one company, it shows "Retrieving" forever. What can I do to download data? Please help!
-
Would appreciate an explanation for it?
I am trying to pass a request for a ticker symbol, that is valid. Still it always throws an error with message of Investor Full Name. Any idea what is about? I can relate it to having investor names empty and so on.
-
Generic Contract RIC
Is there concept of a generic contract RIC? For example in Bloomberg, CL1 refers to the current active WTI Crude contract. This points to CLX4 now, and rolls over to CLZ4 next month. CL2 points to the first deferred contract etc. If so, what is the naming convention for generic contracts for Refinitiv? I am trying to get…
