-
Excel Formula to Python API code conversion: =@spotcalc(today,2)
Please convert in Python API: =@spotcalc (today,2) It is just a function that pulls the spot date and you can input a "days to spot" parameter. That's what I need to do in python.
-
Constituents of an equity index?
Can anyone tell me why it returns an error? Are there indices that are compatible with 0# notation and those are not? Is there something wrong in my code? How can I see the list of all the constituents of an index? import lseg.data as ld ld.open_session() This one works.str_test = "0#.TSPM" l_field_test = ['TR.RIC']…
-
Fund data points not pulling in through Python
Hello, It seems fund data points such as 'TR.FundCompany' or 'TR.FundType' or 'TR.Fund1YearPerf' are not pulling in through Python (I use Jupyter Notebook). Here is an example code: import lseg.data as ld ld.open_session() df = ld.get_data(universe = ['LP65011527'], fields = […
-
What are the item codes to use in a python code for Promoter holding, MF holdings, institutional hol
What are the item codes to use in a python code for data fields Promoter holding, MF holdings, institutional holdings, and their change on quarterly basis?
-
LD Library Configurations
Hi Team, we received a query related to python set up and he wanted to have a training on how to navigate in dept the python program. So far what we have done are the following: I've provided the link for the configuration process: LSEG's Refinitiv Data Library for Python and its Configuration Process | Devportal along…
-
I am getting no proxy error while trying to run this code.Workspace is already running in background
Sometimes this code throws an error and sometimes it runs fine Code: Error:
-
CodeBook: Error code -1 when trying to access historical bid/ask prices via batch queries.
I am trying to access historical bid/ask prices for a list of RICs (bonds). I am querying them in batches of 500 RICs at a time. Some batches return an error code -1 with the message 'headers'. When this occurs, the entire batch is treated as invalid, and none of the observations from that batch are returned. For example,…
-
Module error
Client Query I am trying to get open interest data from the get_eikon_timeseries API. Open interest at settles, need it for August 2025, not sure which field to use to extract that from python Provided resolution below import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['LGOc1'], fields =…
-
error using the API "insufficient scope" when calling ld.get_data() using the LSEG data library for
LDError Traceback (most recent call last) Cell In[4], line 1 ----> 1 df = ld.get_data( 2 universe = ['ORAN.PA'], 3 fields = ['TR.CompanyName', 'TR.InvestorFullName', 'TR.InvParentType', 'TR.InvestorType', 4 'TR.InvInvestmentStyleCode','TR.SharesHeld', 'TR.PctOfSharesOutHeld', 5 'TR.InvestorAddrCity', 'TR.InvAddrCountry' 6…
-
Unable to make the script work
Hi Team, Good day! This is under case: 15584196 Query here is that the client seems to have experienced some issues pulling up the script below: try: session.open() ld.session.set_default(session) session.open_state Pull selected rics, in this case a GoC bond, the 10 year benchmark and the 5 year benchmark. To get a list…
-
How to pull historical financial data from ISIN's
Hi, =@DSGRID ($A$1:$A$1007,RI,P,PO,PB,PA,VO,IBNOSH,04/01/2025,,Daily,RowHeader=true;ColHeader=true;Heading=true;Transpose=true;Code=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false;MonthlyTSFormat=true;AutoRefresh=false) is what I used to pull the historical data for some stocks in the excel…
-
Commodities Tradeflow via API
Hi Team. We have a client looking to pull Commodities Tradeflow data monthly as part of their automated process to store the data into a database using a python client. Could you let us know what API options are available?
-
Most recent news headlines of specific news category for multiple ISINs
Via the python API, what is the most cost-efficient way of obtaining the news headline of a given news category (e.g., scheduled events) from a date closest to a given input date for a given list of different ISINs? More precisely, the inputs are a list of ISINs, a date, a news category while the outputs should be…
-
Query on Accessing Global Exchange Holiday Calendars via LSEG Python API
I am currently working on global equities data and need access to official trading holiday calendars across multiple exchanges. I am using the LSEG Python API for data ingestion and wondering if there is a way to retrieve: i) Future trading holidays across global equity exchanges ii) Historical holiday calendars, including…
-
Clarification on Academic Licence Permissions for Accessing News Text and Earnings Call Transcripts
Hi, I am an academic user from a university using LSEG Workspace, and I would like to clarify the data access permissions for textual datasets under our academic licence. I am conducting research that requires both news text and earnings call transcripts, so I would like to understand which datasets and APIs are available…
