-
Different execution result between codebook and python API
Good morning, I'm using the refintiv.data api to query some bond data. In the codebook I'm running rd.discovery.search( filter = f"RIC eq '458140BP4=RRPS'", select = "MaturityDate" ) this runs without issues and gives me the maturity date. However when i copy paste the same thing in my code editor, i get ValueError…
-
How to Efficiently Retrieve TR.PrimaryInstrument for Delisted Equities?
Hello everyone, I'm currently working on a project where I retrieve RICs and PrimaryRICs for a set of ordinary shares from various global markets using the Refinitiv Research API (EQUITY_QUOTES) through codebook. Then I use the PrimaryRICs to gather fundamental data for these companies. However, I've encountered a problem…
-
Retrieve RIC codes from ISIN and Exchange in instrument search
I am currently working on retrieving RICs for instruments using the Refinitiv API, given an ISIN and exchange. I am using the endpoint: https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/InstrumentSearch. My goal is to obtain the specific RIC for a given exchange and ISIN from the search results. For example, I am…
-
"Too many requests" when trying to download historic bond yields
Hello - I need to download historic yields for bonds -- and the size of the download would be too big for Excel. When I increase the size of the download, I get errors, usually this one: "RDError: Error code 429 | Too many requests, please try again later." I've also just had timeouts or it returns empty data frames. Below…
-
Retrieve all available fields in rd.content.search
Hi all, I'm trying to search for some information using the refintiv.data.content.search module I know there a re a lot of available fields that you can search for or use to filter. However is there a way of searching for all available fields ? Like this : response = rd.content.search.Definition(…
-
How to link screener list with codebook to search a specific keyword?
Hi I have created a list of US banks for my research purpose using Refinitiv Screener, however, I am required to create a column for 'digital scoring', is it possible to use Refinitiv CODEBOOK to generate this column by searching for specific keywords like 'online banking', 'financial technology', 'digital banking'..etc in…
-
How to retrieve bond data using a huge list of Tickers?
Using Eikon API, I extracted a huge list of Tikers, which contains all green bond issuers before 2023 (n=2370). The following is the command I used. response=search.Definition( view = rd.discovery.Views.GOV_CORP_INSTRUMENTS, top=8172, filter = "((DbType eq 'GOVT' or DbType eq 'CORP' or DbType eq 'AGNC' or DbType eq 'OMUN'…
-
Looking for all possible column headers for a script for Shipping Assets
I am trying to find all the possible column headers for a script but there doesn't seem to be any help finding what are the possible filters. Using Codebook and taking one of their examples on shipping and want to return a different set of columns on the dataframe but within codebook examples-> 06 - > Shipping, you find…
-
How to get all possible values for `RCSUnderlyingProductGenealogy`
Hi! I'd like to figure out how to get all possible values for `RCSUnderlyingProductGenealogy`, to be able to easily search for commodities. The filter part of my query is this: `( (SearchAllCategoryv2 eq 'Commodities' and RCSUnderlyingProductGenealogy eq 'U:8') and (RCSUnderlyingProductGenealogy eq 'U:D\\U:5S' and (not…
-
Wrong Ric Root code in API
Hi all, I've noticed some inconsistencies in the API data, I'm wondering if I did anything wrong or if this is a data quality issue. I'm trying to retrieve the Ric Root code for indices. For this I use this function : def getRicRootFromIsin(isin): df = rd.discovery.search( view = rd.discovery.Views.SEARCH_ALL,…
-
API Pagination in Python Using Refinitiv Data API
Hello, I'm working on a Python project using the Refinitiv Data API to retrieve large sets of equity quote data. I need to fetch data in chunks of 10,000 records due to API limitations, but I'm struggling with implementing effective pagination to avoid overlapping data without missing any records. The API doesn't seem to…
-
What are all OrgSubTypes supported via GET /permid/search API endpoint?
So far I've come across the following OrgSubTypes: - Company - National Government - Quasi-Governmental Organization - Foundation/Charity - Central Bank - Treasury Does anyone have a complete list?
-
Searchlight for bonds
Hi there, i want to know how to filter out by using searchlight endpoint for top5 Issue amount of US corporate bonds (Apple as an example) Thanks for your help in advance.
-
Eikon API - News Monitor Headlines vs Headline & Story Test
Hi I'm trying to replicate a search I complete using the Eikon News Monitor. Below is the code I use in the search bar when completing the search. Topic:GB AND "restatement" The issue I am having is that in the News Monitor, I change the Search Mode from 'Headlines' to 'Headline & Story Text' which I am unsure how to do…
-
PemID website search redirects to homepage
Search on the PermID website stopped working at about 11.35 GMT on 1st March. All search requests are redirecting back to the home page.
-
how to correctly paginate through search results?
Hi, i have a search which would result in roughly 450,000 results. So, i thought i could just paginate through the search(results) via using the top and skip parameters. but that does not work. The issue i get is: Result is maxed at 10000 while the total is 453761 rows. Requested - 100, skipped - 9900 rows. the code i use…
-
Search API - what are the available columns name for select and filter arguments?
Hi, I am using refinitiv.data.content.search.Definition() which has two argument select and filter. My question is how can I know which columns name are available for specific views and how can I select all columns. "*" doesn't work. For example, in screenshot, your example code select columns…
-
How do retrieve distinct expiry dates of listed options on .SPX
Hi, I am using refinitiv.data in Python. I need to retrieve the distinct expiry dates of the active listed options on .SPX. I think I need to find the distinct dates inside the request rather than outside, because there are so many listed options on .SPX I am likely to exceed the data cap if I retrieve all the non-distinct…
-
Search API "ReasonDelisted"
Hi, everybody! I keep working with delisted companies' data and I have successfully retrieved a list of these companies using the "ReasonDelisted" selector, as illustrated in the attached screenshot. However, I have encountered a limitation with the scope of reasons provided for delisting. Currently, the data only reflects…
-
PropertyNames for 'filter'
Hi! I was following a previous recommendation to utilize the Search API for my project. The integration has been successful, but I've encountered an obstacle with configuring the filters. Specifically, I am having difficulty identifying the appropriate PropertyNames to use within the "filter" parameter, as these were not…
-
DataScope Select Search API failing when maxpagesize variable is set
Hi, I've noticed when using the following payload and headers: payload = json.dumps({ "SearchRequest": { "ExchangeCodes": [ "CMX" ], "IdentifierType": "RICRoot", "Identifier": "GC", "AssetStatus": "Active", "FuturesAndOptionsType": "FuturesOnOptions" } }) headers = { 'Prefer': 'respond-async;odata.maxpagesize=100000',…
-
Datastream - How to retrieve all series that match my filters or categories?
I want to pull time series data for Datastream mnemonics that match a certain criteria. Datastream interface/desktop has categories for time series that allow you to filter your search to the relevant results. For example you can search for all time series that match: Type=Commodities, Country=USA, Activity=Dead,Settlement…
-
Batch Search via DSS API
Hi, Is it possible to search multiple instruments/batches of instruments via the DSS API searches at the same time? My client from Baader Bank AG is would like to provide multiple ISINs and MICs in order to search the correct RIC. The only solution I found is to map statically MICs to Exchange Code and then use the…
-
Python API Error: Microsoft Visual C++ Runtime Library ---- Assertion Failed
It shows Microsoft Visual C++ Runtime Library ---- Assertion Failed when I am trying to run a search function with Admin right. Is it because my Microsoft Visual C++ setting has some issues? Thank you. After click Abort:
-
Historical Search using .NET SDK API
I'm using the C# .NET API to query Tick History / DSS. Can you show me the API for Historical Search for an instrument where I can search by SEDOL code? Thanks
-
Search API: how to structure the credit rating data like in the GOVSRCH interface?
If I add a credit rating filter to my query in GOVSRCH, I get a nicely formatted table with a nested column containing e.g. Moody's Long-term Issuer Rating. See screenshot. If I run the same query with the API, I get several columns that look like they are related to the credit rating filter, but contain only the raw data.…
-
Seasonally adjustment fields in Search Light
Hi, In the result of the next searchlight query { "View": "SearchAllLight", "Filter": "RIC eq 'USNFAR=ECI'", "Select": "_debugalllight" } I have 3 fields that contain seasonal adjustment information: "SeriesDescription": "United States, Employment, Overall, Nonfarm payroll, total, SA, Absolute change",…
-
Codes for Search Light results
Hi, I am investigating RDP search light and wondering where I can find list of all codes for the following fields: AdjustmentFactorCode, RCSCurrency, Unit. For example, all these fields can be found in results of next query: { "View": "SearchAllLight", "Filter": "RIC eq 'aXZCGDPD/CA'", "Select": "_debugalllight" } Can you…
-
Replicate GOVSRCH search results using Search API
For an internal tool, I want to copy the results of arbitrary GOVSRCH searches by copying the identifiers (e.g. RIC/ISIN) of each search result and retrieving each result using the Search Lookup API (i.e. `/api/rdp/discovery/search/v1/lookup`). Exporting the search results as Excel is not an option. I would use the…
-
Equity Search API Results Order
We are using the Search/EquitySearch API and would like to understand the order of the results, this is an example of a search we are performing The first result back is "Identifier": "WISH.O", followed by "Identifier": "WISH.OQ", and then "Identifier": "WISH.A", It doesn't seem to be based on Alphabetical order, so we…
-
DSS API: search for historical RIC returns empty result
I am trying to get data from DSS for ended RIC EONIA=. It appears in the DSS RIC search, but only has "Reference History." No prices tab. When I attempt to search for it using DSS REST API I get no results: In [8]: headers = {"Authorization": "..."} In [9]:…
-
Is there an API for get data tables from Ric Search?
Is there an API, library or any function that can be used for get data tables, especially for economic indicators data from Ric Search Tool https://developers.refinitiv.com/en/tools-catalog/ric-search# in Python? If it is, can you give an example code?
-
Where is the button for export data table to csv file in ric search?
Can´t find the button or the function to export data table to csv file in ric search tool https://developers.refinitiv.com/en/tools-catalog/ric-search#
-
Can we pass multiple RIC roots while searching for Futures and Commodity Search.
For searching RIC codes using KeywordQuery, @{ "SearchRequest": { "KeywordQuery": "PROCNWEM","ExpirationDate": { "@odata.type": "#DataScope.Select.Api.Search.DateValueComparison","ComparisonOperator": "LessThanEquals","Value": "2026-12-31T12:00:00.000" },"PreferredIdentifierType": "Ric","AssetStatus": "Active" } } this…
-
Custom indicator for Advanced Search
Could you pls advise what is the best way to create an filter indicator and to get every week on the email the excel with results? For examples there are these “Stock Reports Plus Average Score” (current and some from the past): 'TR.SRPAverageScore','TR.SRPAverageScoreOneWeekAgo','TR.SRPAverageScoreOneMonthAgo' In Advanced…
-
GOVSRCH produces malformed JSON queries when using 'export query'
GOVSRCH 'export query' produces malformed JSON-representation queries that result in an error when used with the API. This happens when a complex rating filter is created. This makes it impossible to export the query to e.g. Python code, because the query will result in Error 400 "Invalid filter: unmatched closing…
-
CLPNDIRS=TWEB showing Valid
As per DN204841, the chain CLPNDIRS=TWEB is replaced with CLPNDIRS=TWEB. However on running an API query below the old discontinued Tradeweb RIC chains are still tagged as “active” in Refinitiv’s back-end. See Status as Valid E.g. CLPIRS=TWEB RIC chain requested with a datetime range of [2023-01-16T00:00:00.000;…
-
Search US Stocks traded on German Gettex (XMUN)
Hi all, Could you pls advise on the following issue. I try to find all US stocks which are traded on Munich Gettex Exchange (code: XMUN). When I do it via Eikon API Screen in Python I get only ~250 items: fields =…
-
TRTH API: Searching futures RICs
I'm trying to search some future RICs by using TRTH API "/Search/FuturesAndOptionsSearch". You can see the example json here. The initial request returned only 250 rows of result, so I tried to use the "@odata.nextlink". For the whole process of the example request, I requested for the url without skiptoken first, then…
-
/case/search API
Hi, I'm trying to perform a case research using this end point: https://api-worldcheck.refinitiv.com/v2/cases/search/ https://developers.refinitiv.com/content/dam/devportal/en_us/product-docs/wc1-api/documentation/v2/schema-reference/wc1-api-schema-reference-documentation.html#tag/case-search/paths/~1cases~1search/post The…