-
The query is: We have several questions regarding the Python API and would appreciate your guidance
1. It appears that it is not possible to retrieve historical data (price, yield, fundamental data) using the TR.organizationID field. Could you confirm if this is the case, or if there is a specific API function we should be using for this purpose? 2. We have noted that TR.organizationID serves as a company identifier…
-
My Workspace user is struggling to get history out of the WS API
My Workspace user is struggling to get history out of the WS API. She sees error “TS.Intraday.UserNotPermission.92000, User has no permission' when trying to pull data on 'EUR=' using the 'get_history' function. She has confirmed she sees a chart of EUR= in desktop WS. Any ideas? Does the API need to be permissioned…
-
How to search for inactive/matured corporate bonds via Data Library for Python (equivalent to GOVSRC
I'm using the lseg-data Python package (v2.1.1) to retrieve corporate bond data. What works: ld.discovery.search(view=GOV_CORP_INSTRUMENTS, filter="IssuerName eq 'Apple'") returns active bonds (AssetState=AC) ld.get_data(universe=['US03785EPC20'], fields=['TR.FiOriginalYieldMaturity'], parameters={'CH': 'Fd', 'RH':…
-
What is the formula in cbook showing the quotient of money quantity M2 and margin Debt of United Sta
Client is asking they need a chart showing the quotient of money quantity M2 and margin Debt in cbook. Can you please help with the formula I also need -> US Margin Debt and then in CBOOK -> M2/ Margin Debt as chart
-
Why are we getting duplicate entries in the Below code
import refinitiv.data as rd import pandas as pd ── Config ───────────────────────────────────────────────────────────────────START_DATE = "2023-01-01" END_DATE = "2026-06-10" MONTH_CODES = { 'F': 1, 'G': 2, 'H': 3, 'J': 4, 'K': 5, 'M': 6, 'N': 7, 'Q': 8, 'U': 9, 'V': 10, 'X': 11, 'Z': 12, } MONTH_NAMES = { 1: 'Jan', 2:…
-
How to get all historical data for RIC FCPOQ26-U26?
The client wanted to get all historical data for RIC FCPOQ26-U26. I had provided him the below code: import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['FCPOQ26-U26'], fields = [ 'TR.CLOSEPRICE(SDate=2025-08-18,EDate=2026-06-10).date', 'TR.CLOSEPRICE(SDate=2025-08-18,EDate=2026-06-10)' ] )…
-
RIC NCLH FY 2027 Earnings Per Share Smart EPS when pulling using a date parameter for yesterday retu
I am replying to this case with a new issue because it appears related. RIC NCLH FY 2027 Earnings Per Share Smart EPS when pulling using a date parameter for yesterday returns an erroneous value of 2.65126 and then when pulling using no date parameter it returns the correct 2.03 value. This has been happening every day for…
-
Discovery Symbology API-Datsatream macro economic identifiers
One of user is asking, The Discovery Symbology API (image below) is designed precisely to map between different identifiers (RIC, ISIN, CUSIP, PermID, etc.) and supports an internal identifier called DatastreamId among the “LSEG specific and heritage identifiers.” So this works for Equities / ETF and similar. Please…
-
Symbol conversion using lseg.data
I wanted to convert between security identifiers depending on the identifier type I may have. I have checked the symbol conversion module and the fundamental reference module, both under content layer. There are some differences in their behaviors. Below is an example based on CUSIP to ISIN/RIC mapping. Symbol Conversion…
-
Why is the last traded price not available for USDSROIS RICs in open_pricing_stream, and how can the
I have wrote codes below to get USDSROIS quotes data and latest trade price. import lseg.data as ld def on_data(data, instrument, stream_obj): print(data) stream = ld.open_pricing_stream( universe=['USDSROIS1WZ=R', 'USDSROIS2W=', 'USDSROIS3W=', 'USDSROIS1M=', 'USDSROIS2M=', 'USDSROIS3M=', 'USDSROIS4M=', 'USDSROIS5M=',…
