-
Missing ISIN/CUSIP/SEDOL from ld.get_data even though identifiers appear in Workspace (example: VSSL
Hi, I’m using the LSEG Data Library for Python to retrieve instrument identifiers (ISIN, CUSIP, SEDOL, etc.) from RICs as part of a global equity mapping pipeline. For most instruments, this works well. However, for a subset of equities the API does not return all identifiers, even though they are clearly visible in…
-
Get_history request is not returning same fields - Unexpected error in data returned from data sourc
Hi The below request has worked very reliably over the past few weeks when I tried: df_prices = get_history( universe=ticker, fields=['TRDPRC_1','ACVOL_UNS','TRNOVR_UNS','VWAP', 'TR.TotalReturn', 'TR.CompanyMarketCap'], interval='1d', start=start_date, end=end_date, adjustments='CCH' ) But today I tried three times and…
-
Beginner Guidance for LSEG SDK APIs, RTDS, and Refinitiv Workspace (Java)
Hi Community, I’m a beginner and aiming to become proficient in LSEG SDK APIs, RTDS (Real-Time Distribution System), and Refinitiv Workspace. I’ve chosen Java as my programming language and would appreciate guidance on the following: Where should I start as a complete beginner? Any recommended learning path or sequence for…
-
API script to get coupon payment date on business day basis.
Please advise how to get coupon payment date on business day basis (which is next day if coupon date falls on holiday) by API. Example of the expected result is attached. https://us.v-cdn.net/6038239/uploads/93CBCKEI7AH8/cash-flow-bond-structure-realtime-sample.xlsx I checked the site Documentation | Devportal but not able…
-
History of Ultimate Parent Given RIC or Perm ID
Hello, Hope everyone is doing well! I asked LSEG helpdesk about something and was redirected here. I have a list of RICs and Permanent IDs. Say I would like to get a 5 year history of multiple fields for these companies, including the history of the ultimate parent of those companies. Is there a way via Python's…
-
How to download panel data from Refinitiv workspace in a long format but not wide format?
I would like to extract ESG score of all public and private firms for the past 20 years. However, the data I extract from the screener is wide format, which is inconvenient to use. How can I download it in a long format? At the same time, the fiscal year end item does not have time series option as the ESG score item.…
-
Retrieving annual reports using LSEG API
For a research project, I would like to download the annual reports for a large set of European firms over the period 2010-2023 (following a similar approach as in this article: Global Evolution of Environmental and Social Disclosure in Annual Reports - Lin - 2024 - Journal of Accounting Research - Wiley Online Library).…
-
In refinitiv RawMarketByPrice is acc_size in round lots or shares?
The ACC_SIZE field in the RawMarketByPrice download. Is that in round lots of shares? A round lot is = 100 shares correct? So in a message like this: ,,,,MapEntry,,ADD,,,,,,155.000000A,,6 ,,,,FID,6529,,LV_DATE,2025-08-18, ,,,,FID,3427,,ORDER_PRC,155, ,,,,FID,6527,,LV_TIM_MS,28901767, ,,,,FID,3428,,ORDER_SIDE,2,ASK…
-
Clarification on RIC Suffix with “^”
Hi, I have a list of RICs that include the suffix “^” followed by a letter and number — for example, ARNC.N^H23 and GTX.N^I20. Could you please explain what the letter and number after the “^” represent? Thank you for your help!
-
S&P 500 Index constituents every month
How can I get S&P500 index constituents every month since 2012-01-01? I am using excel sheet to download the data. I have tried using the function =@RDP .Data(".SPX","TR.IndexConstituentRIC","SDate=2012-01-01 CH=Fd RH=IN",B1) to get the ConstituentRIC, but it returned NULL. May I know why and how to solve this problem?…
-
News Monitor 2.0 - Top news from a specific country
I´m trying to create a News Monitor 2.0 to look for the most important news from Mexico and USA. I have tried to filter them only to show me the most important ones about relevant matters like macroeconomics, commodities, equities, etc. Im also trying to generate a python code to send a top 10 list with the most important…
-
Adding story text to output using Python API
Hi I currently have the following code that is fetching specific new articles using Python API. However I am not sure how to add the story text to the output. I currently have the Headline, StoryId, and Link to the article. Code: df = ek.get_news_headlines( 'Topic:GB AND (SOURCE:CMPNY OR SOURCE:MCE OR SOURCE:GEN)',…
-
Volatility in the number of results returned.
I'm using a Workspace session to connect to the Data Platform to collect fundamental data for a subset of 1000 firms in my sample. Below is the function call and code (Python) that I use: response = fundamental_and_reference.Definition( df['ISIN'].unique().tolist()[0:1000],…
-
How do I get data for all the fields for the rics using ld.get_data() without providing the fields?
In refinitiv data library, while using rd.get_data() method, if we don't provide any fields, it returns data for every fields. But after migrating to lseg data library, when I try to use ld.get_data(), I get error that I have to provide fields name Is there a way, we can return data for every fields without passing the…
-
Is it possible to request the CARGO (Commodity flows) data thru API?
using RDP API, is it possible to request the CARGO (Commodity flows) data ? So all imports from Japan, in bbls. (Crude oil, Fuel oil and Dirty Petroleum) I want to query this in python can someone assist me on this from the relevant specialist group?
