-
GovCorp Search showing limited data
One major client is doing a GovCorp search via API and the response from the API is limited compared to the results in the GUI (I am able to reproduce it). They are specially interested in getting if the bond is a corporate or government bond. Fields responded by the API with GovCorpSearch: {'Identifier': 'XS3102778191',…
-
Can you please confirm how to add filter to screen the funds via API on Workspace?
Can you please confirm how to add filter to screen the funds via API on Workspace? How to build the screening parts into the filter? For example IA sector = North America using the script below : import refinitiv.data as rd import pandas as pd rd.open_session() df_universe = rd.discovery.search(…
-
ESG Bonds and RCSFIClassificationCodes
Hi! I am looking at ESG bonds issued by firms. I am trying to understand the RCSFIClassificationCodes variable, which for each ESG bond outputs one or more lists the following structures:{'Code': String, 'CodeDescription': String, 'CodePermID': String, 'IsESGStandard': Boolean, 'Type': String, 'TypeDescription': String,…
-
API query
Hi Team, Is there a way in API to pull a RIC using Company name? Our client has a total of 1500++ Company name, we are trying to check if we can have an option to pull the RIC using API.
-
how to find the fields available in search views?
How to find data filelds such as in workspace API
-
How can I change it to download the RIC?
The original call (search.Views.GOV:CORP_INSTRUMENTS ….) calls the Ticker. How can I change it to download the RIC? When I writeresponse = search.Definition(view = search.Views.GOV_CORP_INSTRUMENTS, filter = f"(DbType eq 'CORP' and RCSAssetCategory eq 'A:J' and ((ParentOAPermID eq '{org_id}') and IssueDate le 2024-12-31…
-
How to add LEI to the query
Hi, I’m reaching out to ask for assistance with an LSEG API query. I’d like to add the LEI to this query: response = search.Definition(view = search.Views.GOV_CORP_INSTRUMENTS, filter = f"(DbType eq 'CORP' and RCSAssetCategory eq 'A:J' and ((ParentOAPermID eq '{org_id}') and IssueDate le 2024-12-31 and MaturityDate ge…
-
How to retrieve MICs for single RICs
Hello, I have a dataframe comprising all the RICs for a number of ISINs, and I would like to know how I can retrieve the MIC of each RIC using Python. Using the search API I was only able to retrieve the LSEG codes for exchanges and trading venues, not the official MICs. Thank you!
-
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,…
-
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'…
-
Please confirm if this request is possible in Eikon/WS API
Could you please help me with modifying the Python code so that we can pass multiple RICs at once and retrieve data for all of them in a single function execution? We would like to avoid looping through each RIC individually, so any guidance on how to handle multiple RICs in one call would be appreciated. import…
-
How to get all ports in a country?
I'm exploring the notebook examples provided in the CODEBK. In get_vessels_info.ipynb , there is this following code, which retrieves information on vessels entering a specific port: for i in range(0, len(vessels_imo), batch_size): temp = ld.get_data(vessels_imo[i:i+batch_size…
-
Circumventing Search API request limits
Hi, I am working on a larger project where I am integrating job listings with firm-level (parent company data). I need to link firm names with their parent companies (to get the publicly listed entities for subsidiaries) which I am doing via the Search API in LSEG Workspace. The entire dataset contains about 200,000 firms…
-
How to extract the RIC of a company using API?
How to extract the RIC of a company using API? Please provide sample code.
-
Hello team how to bypass the TOP=10,000 limit in Workspace API CODEBK?
import refinitiv.data as rd rd.open_session() rd.discovery.search( view = rd.discovery.Views.GOV_CORP_INSTRUMENTS, top = 10000, filter = "((DbType eq 'GOVT' or DbType eq 'CORP' or DbType eq 'AGNC' or DbType eq 'OMUN' or DbType eq 'OTHR') and IsActive eq true and (RCSCountryGenealogy in ('G:DE')))", select =…
