-
Why does data item TR.HIGHPRICE not work for Nikkei 225 RIC .N225 when combined with other RICs?
Query: API Code is working but not with .N225 index Client's code: import lseg.data as ld # pip install lseg.data # pip install DatastreamPy from lseg.data.content import fundamental_and_reference ld.open_session() # import refinitiv.data as rd # pip install refinitiv-data import pandas as pd from tqdm import tqdm import…
-
Retrieve all US primary stock listings excluding OTC/pink sheets
Hi I am trying to get a list of all equities in the US - primary listings only - and excluding OTC stocks. Below is what I have now: DB4 = rd.discovery.search( view = rd.discovery.Views.EQUITY_QUOTES, top = 10,…
-
Code to get daily close price and the trade time for RIC 1398.HK
I update my data everyday after market closes and I am using python function like this: df, err = ek.get_data( instruments = instruments, fields = fields, parameters = {'Frq':'D','SDate':last_date_in_file, 'EDate':today_str} ) I ran the code just now, and the latest date in the dataframe I got is 11-19
-
When retrieving historical index constituents of the index SP500, there is only delivery of today's
When retrieving historical index constituents of the index SP500, there is only delivery of today's SP500 constituents irrespective of the date being enter as parameter, e.g. Google become SP constituent in 2006 but it is show as SP stock in previous years. This is misleading. Getting historical constituents is required to…
-
Bulk download stock price history and market cap via endpoint
Hi I am trying to set up a weekly download that loads the interday summary for the last five years. Additionally, I need the market cap for the last three months. In this regard I have a couple of questions below. For reference, I am including my code: Can you please help me with the token logic: I have it set up now that…
-
Differences between workspace and refinitiv.data
Hello Support Team, I'm retrieving quarterly fundamental data for XOM.N using the dl.get_data() function, and I've noticed a discrepancy in the data quality between the API output and Refinitiv Workspace. Specifically, for the field TR.F.CrudeOilProdPerDayAvgTot, my Python output contains numerical values (or zeros) for…
-
How to use lseg.data to get ADP data(Or other economic data)
I am using Pycharm IDE to finish my project. I wonder how to use lseg.data(or other LSEG's packages) to get US ADP employment data (monthly). Could you show me the detailed process, I am new to LSEG, and not familiar to using it. Thanks a lot!
-
how can i get open/close/high/low price of 'XAUUSD' by python api
like "ld.get_data"
-
"pip install refinitiv-data" Failed
I use the command line "pip install refinitiv-data".However, I encounter a problem, and could not install refinitiv-data. The screenshot is attached.My python version is 3.13
-
Extract ESG related data items
Hi Team, would you know if we can extract all of the ESG related data items in python API? See screenshot attached. We are looking for some guidance which works similarly like the DIB app in LSEG Workspace. As you can see, in the DIB app, user can use the Content Classification filter to display all of the related data…
-
Workspace data API Errors: Error Code -1|'headers'
Hello Data API team, I'm raising this issue on behalf of my client Workspace users. The issues are discribed below: When I using Workspace data API, I frequently get the Errors refinitiv.data._errors.RDError: Error code -1| 'headers'. Please kindly find the screenshot attached with the error message. I can confirm all the…
-
Unable to open lseg session
py:514:UserWarning: pkg_resources is deprecated as an API. See https://setuptools.pypa.io/en/latest/pkg_resources.html. The pkg_resources package is slated for removal as early as 2025-11-30. Refrain from using this package or pin to Setuptools<81. Response 503 on handshake url http://localhost:9000/api/handshake : Error…
-
Workspace + refinitiv.data – Analyst EPS history: some brokers visible, others “Permission Denied
Hi everyone, I’m working with Refinitiv Workspace and the Refinitiv Data Library for Python (refinitiv.data) for academic research on analyst EPS consensus. My goal is to retrieve analyst-level EPS broker estimates over time for an equity (here: ASSAb.ST), so that I can study how individual analyst contributions to the…
-
Survivorship bias free data
I would like to get the historical constituents for an ETF, S&P500 for example, using the lseg.data api in Python. Is there an easy way to do this and more importantly, will this data include stocks that are delisted so that my universe is free of survivorship bias? Moreover, in general is there a way to pull data for…
-
Extracting IBES analyst level detailed forecasts using python on single year and longer horizons
Dear LSEG Team, I want to pull the IBES analyst-level, detailed forecasts from the workspace using Python. I am using the following formula in Excel: =@RDP .Data("MSFT.O;AAPL.O", "TR.EPSEstValue.fperiod;TR.EPSEstValue.analystname;TR.EPSEstValue.analystcode;TR.EPSEstValue.date;TR.EPSEstValue","Period=FY1990:FY2024 RH=IN…
