-
Getting Best Match via Entity Search API
Hi, Please see my code below my sanctions_df_upgrade has a column caption which are company names. I am looping over that column and mapping it against the PermID db via the Entity Search API My ask is - now I am assuming that the first match found with the parameter num set to 1 is the best match. But is there a better…
-
How to map entity names to identifiers?
Hi, I have used the OpenSanctions API /search endpoint and retrieved results of entities under the UFLPA dataset My next task is to map these entities to permIDs (if available) The entities retrieved from the API call are API native fields and names of companies. I want to map the names to permIDs Please can someone guide…
-
Query export not working to build query string
I am trying to export a search query in Eikon, and the fields I choose are: However, the code provided by the Export Query does not contain the fields I added. So my questions are: 1. Why are the user-added fields not in the Export Query screen on Workspace? 2. Could you tell me the correct field for all the variables I…
-
Search API not case sensitive
Dear Developer Community i'm sharing with you an issue facing with Search API. Indeed, using Sraech API, i want to find Options matching criteria below (given for example purpose): - ExpiryDate:15/11/2024 - StrikePrice: 5200 - Ric starts with SPXw the issue is that the Search Module (and also Search API) is not case…
-
Tick History - Criteria Search - Pull all RICs starting with 0#
Hello, I am trying to extract all Chains for given exchange using criteria search but keep getting error. What am i missing in the code? Request: https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/HistoricalCriteriaSearch HTTP/1.1?Prefer=respond-async&Content-Type=application/json { "Request": { "RicPattern":…
-
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…
-
Euro-Bund RIC Code Searchlight API
Hi all, I am trying to obtain euro-bund future RIC code and access to its data using Searchlight API. I have try with: * "Query": "euro-bund futures" * "Filter": "RIC eq ''FGBLZ4'" * "Filter": "startswith(RIC , 'FGBL')" And many others. Is there an easy way to obtain the RIC Code for a product? Sorry in advance if I have…
-
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'…
-
Futures and Options Search using RICRoot
In the DSS GUI, you can perform a Futures and Options Search using a RICRoot, e.g. FFI (FTSE Index futures on LIFFE). This returns a list of the current individual contract RICs (FFIZ7, FFIH8, FFIM8, FFIU8 in November 2017) and the continuity RICS (FFIc1, FFIc2 etc). Which DSS REST API request performs this type of search?
-
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…
