-
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()…
-
Refinitiv python API: How to build dynamic queries for credit curve selection by python?
I'd like to clarify my use case further and seek advice on building a dynamic and parameterized search using Python. My objective is to automate DCF discount rate derivation based on the issuer’s profile. Specifically, I want to: 1. Filter for credit curves based on: • Credit rating (e.g., “BBB”) • Currency (e.g., “USD”) •…
-
How to match PERMNOs (from CRSP) to RICs
Hi, I have a list of PERMNOs (from CRSP) and I’d like to know if there’s an easy way to find the corresponding RICs for these identifiers. My understanding is that each PERMNO should map to one unique RIC. For example, I have PERMNOs 10104 and 10107 — how can I match these companies with their respective RICs? Thank you!
-
Facing issue in Refinitiv Futures API
Hi Team, We use user 9039365 to generate the token through the API endpoint - https://selectapi.datascope.refinitiv.com/RestApi/v1/Authentication/RequestToken API Response - Token generated successfully. We use the token in the API Endpoint for Data Retrieval -…
-
How can I get a list of RICs/Companies that have earnings announcements as of a particular date?
How can I get a list of RICs/Companies that have earnings announcements as of a particular date using Eikon API / RDP API? Are there other APIs where this is available?
-
How to get all the Rics of a sector (ex. consumer discretionary) and then calculate with its numbers
import pandas as pd # Example test data for 5 stocks in the Consumer Discretionary sector df = pd.DataFrame({ "Instrument": ["A", "B", "C", "D", "E"], "TR.TotalNetIncome": [100, 200, 150, -50, 300], # Net income "TR.AverageTotalEquity": [1000, 2000, 1200, 500, 2500] # Equity }) # Calculate ROE (Return on Equity = Net…
-
HTTP 303 - Forbidden in Refinitiv Data Library for .Net
We are getting a 303 Forbidden error whenever using the Search() for Isins. It was working nicely as of yesterday. Is this an administrative problem ? Also the example for dot net Search in the package gives me the same error. This is utterly urgent since we need to move to Workspace as of June 30th. Could this be related…
-
Clarification Request on LSEG API vessel information
I have been reviewing the documentation titled LSEG_API_VESSEL_INFO.pdf in shipping APP-tool, and I came across a section that I would appreciate some clarification on. Specifically, on page 9, the example code related to the ld.discovery.search function appears to be incomplete—approximately half of the code snippet is…
