-
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 =…
-
how to get all the contracts based on underlying Ric including expired?
Hi Devportal team, good morning. Requesting for your assistance. trying to get all the contracts based on underlying ric. but the result is missing contracts which have expired. need to get all the contracts [{"View": "EquityQuotes","Top": 10,"Filter": "( SearchAllCategoryv2 eq 'Options' and ((UnderlyingQuoteRIC eq…
-
If I want to populate a list in python with all the mutual funds existing, how do I do that ?
If you’re familiar with the process, would you be able to share the code or point me in the right direction? I have tried to use the material given but it does not really explain how to correctly write a query in the function. For now I have written this: rd.open_session() search = rdp.search( view =…
-
I want historical option data for NSE/BSE related Index options
Hi I have been able to navigate a bit using a lot of your articles but reconstructing the expired rics is tricky without examples Below was my attempt which was sucessful for recent expiry dates but not historical. index_ric = '.NSEI' options_contracts = rd.discovery.search(view = rd.discovery.Views.EQUITY_QUOTES,top =…
-
WS API How to Retrieve MBS, ABS, and Corporate Bond by Country or Currency
Currently, Our client is looking to obtain data on U.S. MBS (Mortgage-Backed Securities), ABS (Asset-Backed Securities), as well as corporate bonds categorized by country or currency. Until now, he has been using the following method to retrieve government bond data. However, he have not been successful in acquiring MBS…
-
Client is facing the issue while running these code
I am always encountering a timeout error when running this code: # Define the start and end dates (go two years by two years) start_date = '2025-01-01' end_date = '2025-06-30' # Generate a list of dates between the start and end dates date_range = pd.date_range(start=start_date, end=end_date) # Convert to a list of strings…
-
How do I can get full RIC list from Reuters?
Hi, I'm currently working on my dissertation and need to verify whether the RIC codes I extracted match the official RICs used by Reuters. I’ve heard that this can be done using the Search API, but I’m not sure how to access it. Is there also an Excel file or database available that contains the full list of RICs from…
-
Workspace API python:Retrieve EUR-denominated French government bonds
Our client is currently working on the government bond curve for the European region. However, using the method below, He is unable to retrieve EUR-denominated French government bonds (while major countries such as Germany and Belgium are returned correctly). If you happen to know a way to obtain them, I would greatly…
-
How to determien Peer Groups on own criteria
Hi Refinitiv Developer Community, I am working with a list of ~450 companies (primarily listed firms) and would like to retrieve, for each company, a list of peer companies — ideally 5 to 10 — using the Refinitiv Eikon or Workspace Python API. In the Workspace platform, I know the “Peers” tab in the GUI and the PEERS()…
