-
May I know how to use Swaption template from refinitiv.data.content.ipa.financial_contracts?
Hi, I am trying to use the pricing template for swaption from the codebook. However, I am not sure how to enter the field and the final fair value can not match with my sample. I have attached the screenshot of the sample information and testing result to the question as well as pasting my code below. Would you mind advise…
-
company ID from company name by eikon data api
Hi Dev Portal team good morning. May I request for your assistance. Client wants to convert company name list into PermID list in API. Some are private, some are public on the lists. Sample companies: TOMY COMPANY SOCIETY FOR IMAGING SCIENCE AND TECHNOLOGY (IS&T;) TOKINA CORPORATION TAMRON SEA & SEA SUN PACK CO.,LTD. Thank…
-
Refinitiv-Data package installation
I am new to the API environment, fairly novice at Python. I am trying to install the Refinitiv-Data package and get the following error. Any assistance would be appreciated. Collecting refinitiv-data Using cached refinitiv_data-1.6.2-py3-none-any.whl.metadata (10 kB) Requirement already satisfied: appdirs~=1.4.4 in…
-
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…
-
Python APIs
We used an excel file provided by the FMC team with APIs and works very well for this initial research stage. The excel file pulls 20 days turnover data per ISIN across all the on/off book exchanges. On our side we would like to move towards a more structured way to consume these volume data in the coming months: our…
-
rd.get_history returning null values for some equities while Workspace shows full history
I’m using the Refinitiv Data Library for Python to pull daily historical prices for a large universe of global equities (around 20,000 RICs) for some downstream calculations. dailyFields: ["BID", "ASK", "TR.OpenPrice", "TR.HIGHPRICE", "TR.LOWPRICE", "TRDPRC_1", "TR.Volume"] My code (simplified) looks like this: ricsToFetch…
-
Symbology: SEDOL → RIC returns null in Python, but Workspace finds a RIC (ETF holdings use SEDOL)
I’m building an ETF holdings pipeline. Provider files list constituents primarily by SEDOL. I need to resolve these SEDOLs to pricing RICs (and also capture ISIN/CUSIP). I’m using the Python Eikon/Workspace API. What works / what doesn’t In Workspace (desktop), if I search by SEDOL I can see the security and its RIC. In…
-
API connection fail (Workspace was running):
import lseg.data as ld ld.open_session() An error occurred while requesting URL('http://localhost:9000/api/status').ReadTimeout('timed out')An error occurred while requesting URL('http://localhost:9000/api/status').ReadTimeout('timed out')An error occurred while requesting…
-
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…
-
unstable data downloading via python api
I was using python api to download daily data, it seemed that the whole process was not stable. was it because I used for cycles? import lseg.data as ld# Install with `pip install lseg.data` ld.open_session() DateTable2['startDs']=DateTable2.startD.dt.strftime('%Y-%m-%d')…
-
unstable data downloading via python api
I was using python api to download daily data, it seemed that the whole process was not stable. was it because I used for cycles? import lseg.data as ld# Install with `pip install lseg.data` config = ld.get_config() config.set_param("logs.transports.file.enabled", True) config.set_param("logs.transports.file.name",…
-
Why does this code snippet return an empty list? I need the Asset Type set to Mutual Funds.
import refinitiv.data as rd from refinitiv.data.content import search rd.open_session() df = search.Definition( view=search.Views.FUND_QUOTES, select="RIC,TickerSymbol,DocumentTitle,ExchangeCode,AssetStateName,CommonName,ExchangeName,FundType,FundClassCurrency,IssuerCountry,AssetType,", filter="AssetStateName eq 'Active'…
-
RDP and workspace to retrieve TRDPRC_1
Hello, I’m working on a Python script that needs to connect to LSEG without Workspace being launched. My goal is to retrieve the last closes (TR.PriceClose) and the latest trade via (TRDPRC_1). It turns out that I can retrieve TR.PriceClose without any issue, but not TRDPRC_1. here is part of the connect code: import…
-
Data seems to be incorrect using Python API for RIC aUSUNR/A
Hi team, I am raising this on behalf of an external client: Based on what I have checked, I compared the data to our excel workspace as well on our Charts app and we can't seem to get the said incorrect values. Please see screenshots below: Excel: Chart: Please see attached file for the client's script. Estimates data team…
-
Issue when opening new session using python lseg.data library
Receiving below error when opening session using python lseg.data library Code: import lseg.data as ld ld.open_session(config_name='./config.json') Error: Traceback (most recent call last): File "<stdin>", line 1, in <module> File…
