-
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…
-
How to get Insider's ownership for a specific date for a panel of RIC?
I am trying to collect insiders ownerhsip and role as of 31 december of each year (2018-2022) for a list of RICS but cannot find any data. What is the proper way to download them? Best regards,
-
could you please provide me an function exemple in Python code for import EURUSD Spot price from 03
Further working on the query please find the below python script to get the data. import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['EUR='], fields = ['TR.BidPrice'], parameters = { 'SDate': '2024-01-03', 'EDate': '2025-09-15', 'Frq': 'D' } ) display(df) Client has got the below error. Can you…
-
Getting News headlines using python
I am using workspace, is there way i can query the news headline using python ?
-
how can i get open/close/high/low price of 'XAUUSD' by python api
like "ld.get_data"
-
HisoricalPricing not returning today as most recent date
HI, When I use RDP.HIstoricalPricing on "LCOc1" (and also various currencies) in Excel, it returns data with today (Nov 5) as the most recent row. This is the formula that Workspace creates when you export a chart to Excel. When I run this code in Python, it returns data with the previous session (Nov 4) as the most…
-
Sourcing historical 30D Volatilities with Python
Dear Team, What is the python code to source historical 30D volatilities for a ticker? I have tried with the below code with the lseg-data package, but it's only returning the current 30d vola: df = ld.get_history( universe=['AAPL.O'], fields=['TR.VOLATILITY30D'], interval= "1D",…
-
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).…
-
How can I download price history data in 5 minutes intervals for several stocks for more than 1 year
I’m currently looking for a list of US companies along with their stock prices at 5-minute intervals from 2012 to 2025 — for example, at 09:30, 09:35, 09:40, …, 15:55, and 16:00. May I know how can I download them? FYI, I am mainly using LSEG workspace and excel add-ons. Thank you!
-
Financial data quarterly wrong date?
When doing some data quality checks I found some instances where the "Original Announcement Date" was before the date of some values like Total Assets. I came to reproduce that error in a simple request: from lseg.data.content import fundamental_and_reference fundamental_and_reference.Definition( ["4295859017"],…
-
For LSEG Data chain.py, example using platform.deployed, getting A18: Service unknown.
The connection is to RTC. I see in a post need: \*rtc\*defaultJsonServiceId, I believe in RTC rtc.cnf. Is this correct ? How to use chain.py example to connect to local rtc ?
-
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!
-
Can't fetch stories for some storyid via lseg.data.news.get_story() python module
Dear Team , Facing issue with pulling stories for some storyids via python but these are visible when I navigate from workspace UI. Please guide me with this issue. I am appending below some example storyids for which I don't get any news stories. using following method to fetch: story = ld.news.get_story(str(storyid))…
-
How to get READCOUNTS of NEWS
Hi folks, is there anyway that I can see the readcounts of a specific news anywhere in LSEG?
-
Obtaining Effective From and To Date Times for firms' former names
Hi, I am using the python module lseg-data to retrieve the former names of certain firms by using the following formula: import lseg.data as ld df = ld.get_data(universe=['4295904307'], fields=['TR.FormerlyKnownAsName']) While this code downloads the list of names, I was wondering if there is some way to access the…
