-
Empty response when searching for derivative by underlying
Hi, I'm building a tool that requires me to search for information on derivatives. Here i'm trying to find some futures contracts. To find these contracts I have information on the underlying of the contract. I tried using the content search like so : df1 = rd.content.search.Definition( view=rd.discovery.Views.SEARCH_ALL,…
-
https://developers.lseg.com/en/api-catalog/refinitiv-data-platform/symbology-API
Is the symbology API accessible only through v1 authentication or is it possible to use it via v2 as well?
-
Extract Primary RIC from Symbology API
Hi there, Client has a list of 38k PermID. They would like to extract Primary RIC using PermID from Symbology API. They would like to know how they can do this in Postman. Thank you!
-
Getting SSL error while running OpenPermID library in python
I tried running the following command but got the error: output,err = opid.lookup("1-4295880893", orient="row", format='dataframe') err requests.exceptions.SSLError(urllib3.exceptions.MaxRetryError("HTTPSConnectionPool(host='permid.org', port=443): Max retries exceeded with url:…
-
Symbology API using Postman
I want to extract Primary RIC from PermID, for this I have written a JSON in API playground using Symbology API but due to small batch size of API playground I want to use POST request in Postman to extract the same. Can you list out the ways to do it using Postman. JSON I am using is as follows: { "from": [ {…
-
What is the ID retrieved in the API?
Hello, Using the following two fields: ['TR.InvestorFullName.investorid','TR.InvestorFullName'], I may get as ID "2928306", corresponding to "Mitsubishi UFJ Financial Group Inc". If I try to use ek.get_data() with 'TR.ISIN' for the ID above then I get no match. If I try to use ek.get_symbology() I have the same issue. (For…
-
Is there a way to map PermID to all the RICs associated to that company, if a company is listed in m
Q1 I am trying to match PermID to RIC in API Playground and wanted to know if there’s a way to Identify all stock exchange listings for a particular group ? For example NIKE is listed in NYSE and ETR Stock exchanges but when I pass Nike’s PermID it only gives one output. * Is the mapping between PermID and RIC is one to…
-
Is it possible to get company's PermID using symbology API Playground, from only passing its name an
I have used record matching functionality where an excel of max 1000 records can be passed to get permid, but is there any other alternative using API playground to achieve it ?
-
How to extract instrument changes in eikon api
Hi I am trying to find a way to download data displayed in https://my.refinitiv.com/content/mytr/en/symbolchanges.html/ via eikon api. Will there be any method to do this? I would like to export upcoming changes in RIC/ISIN and SEDOL and also to extract data related to delisting of the companies .
-
Symbology Library Just Went Down
About 15 minutes ago, the Symbology library just went down. I'm now unable to get the RIC, ticker, and company name info. "Object reference not set to an instance of an object" is the error I get when using the Symbology library
-
Getting RICs using TR.CIKNUMBER
I need to get RICs for a list of CIKs I have in possession. I tried to use this command ek.get_symbology But it does not have CIKs as identifiers so I am wondering is there a way to use TR.CIKNUMBER to get the list of RICs for my list of CIKs. My list consists of firms under SEC "1311" industry code.
-
How to convert a RIC-list to ISINs?
I want to convert a list of RICs to ISINs. I tried with symbology: import refinitiv.dataplatform as rdp from refinitiv.dataplatform.content import symbology sv_fields5 = ["TR.ISIN"] sv_result5 = get_symbology(ric_liste, from_symbol_type="RIC", to_symbol_type="ISIN") sv_result5.data.df But I get the error "name…
-
Symbology/Symbol Conversion API does not work as intended
Example 1: When I use Symbol Conversion to convert Ticker "RDHL" into RIC, the API response is RDHL.O. The news feed however, tags all RDHL news items with the RIC "2RH0y.F". This means that if I use the Symbol Conversion tool and news feed together, I will not be able to find news items as intended. Moreover, if I try to…
-
get_symbology() got an unexpected keyword argument 'bestMatch'
Since yesterday when I've upgrade Eikon 1.0.2 to 1.1.16 (latest) and Python from 3.6 to 3.11, I can't use get_symbology with the parameter "bestMatch". ¿Any idea? get_symbology() got an unexpected keyword argument 'bestMatch'
-
Issue to retrieve RICS list for a given bond using Refinitiv Data under C#
Dear Developer community. i'm facing an issue to retrieve Ric list for a given ISIN by using Refinitiv Data (version beta4) under C#. Indeed, i'm used to retieve this list using TR.RICS field with Excel and also Python (as shown below), but it doesn't work when using FundamentalAndReference module under .Net and i have no…
-
Where to get a historical name change database?
For example Office Depot is not called Office Depot anymore, and instead ODP, problem is that the old data still has to be mapped to ticker via name combination, so without these historical name changes, I am not sure how it could be done.
-
Are there any ways to retrieve the RICs and PermIDs of all the companies which were historically mer
Are there any ways to retrieve the RICs and PermIDs of all the companies which were historically merged/acquired by a currently existing company or a new company was founded from via RDP Symbology API?
-
I am trying to extract RICs symbology API based on the below conditions, could you please tell me ho
I am trying to extract RICs symbology API based on the below conditions, could you please tell me how i can get this data using conditions? 'First trading date' == 'Sysdate' and 'RIC' == 'EDCOID'
-
ISIN returns no best match in GetSymbology or get_data. Records found manually
I am having trouble matching some ISIN codes to their respective company information (attached the list). I tried the get_symbology() and get_data() methods without luck. However, when I look for each ISIN manually on the RefinitivWorkspace Search Bar, there is information on the company, with a given RIC and all. I wanted…
-
Eikon API Symbology Lookup - Why would Best Match fail?
Sometimes the API returns bestMatch and other times it does not. Is there any API additional developer documentation that explains when/why the bestMatch would fail? Find Python lookup here: symbol = ek.get_symbology(ticker, from_symbol_type="ticker", to_symbol_type="RIC", raw_output=True, debug=True, best_match=False)…
-
Extracting data from Datastream R API using Sedol
Hi, I am using an R API call to extract historic returns from the datastream API from a dataframe of Sedols and Dates. The API call works perfectly for ISIN's however for this dataset I only have Sedols. I have noticed that the call only works on numeric Sedols and not alpha numeric Sedols. I don't have a country code so…
-
symbol_conversion wont convert CUSIPS that begin with a letter?
I run the following code which works for ALL CUSIPS except those that begin with a letter response = symbol_conversion.Definition( symbols=["G1151C101", "G5494J103", "56585A102", "22822V101"], from_symbol_type=symbol_conversion.SymbolTypes.CUSIP, to_symbol_types=[ symbol_conversion.SymbolTypes.RIC, ], ).get_data()…
-
PermID ordering from /discovery/symbology/v1/lookup API
How do I correctly use the symbology lookup API to retrieve PermIDs for a list of SEDOLS (with potentially inactive SEDOLs on the list). I have used the showHistory=True functionality as suggested in an earlier Q&A…
-
How to retrieve exchange-specific RIC from ISIN input
Hi , I am aware this question was asked before, but since the advanced time since it was asked in 2017 I was wondering if there was a more elegant and proper way to retrieve the RIC for an instrument at a specific exchange now? Hope there is since the existing solution are not very satisfying. And if there is no direct…
-
"This account is not entitled to all requested identifier types"
Hi, I'm using Jupyter Notebook trying to run a simple lookup using this Symbology API endpoint, https://api.refinitiv.com/discovery/symbology/v1/lookup, and I get the message below. I tried this same code in CODEBOOK and I get the same error. The AppKey I used to run the query in Jupyter is generated using my RDP login.…
-
get_symbology can not find consolidated ric
I can not find correct consolidated ric for some tickers through get_symbology() for example, 1. consolidated ric for ASM should be ASM 2. consolidated ric for MCFT should be MCFT.O 3. etc But they are not part of the returned results of get_symbology(). Please help
-
Given a RIC or PermID, how to find ALL HISTIORICAL tickers exhange ISIN CUSIP SEDOL?
Dear Sir/Madam, I am using Eikon with Datastream for Office. Q1)In Eikon’s Python API/Datastream, given a RIC or PermID, how can I find ALL historical change of its primary listing with Ticker and Exchange name? Q2) In Eikon’s Python API/Datastream, given a RIC or PermID, how can I find ALL historical change of its ISIN,…
-
Is there a solution to access the APIR code identifier on Eikon
Hi, I'm trying to solve the problem of looking up the idendifier codes such as RIC, ISIN on EiKon for a given intrument specified with its APIR code? I tried get_data(instruments=['APIR code'], filed='TR.RIC'...), it doesn't work for this case. Is there another way to get access to the APIR code on Eikon?
-
Unable to query Symbology Changes using DataScope Select API
I'm trying to generate a symbology change report using DataScope Select API, however it is unable to process many Ric Roots. Example 1: Symbology Change for FW20 using continuous RIC Input URL: https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractRaw (POST) { "ExtractionRequest": { "@odata.type":…
-
How can I use C# APIs to convert SEDOLs into RICs?
I'm using the Refinitiv Data Platform (RDP) API and wondered how I could convert SEDOLs into RICs. I know that it's possible in Python with that API (e.g.: in CodeBook with the code below), but I want to get the same results in C#. Is that possible? If so: what endpoint should I use? import refinitiv.dataplatform as rdp…
-
How can I match multiple ISIN codes to company names in Excel using the Refinitiv Eikon Datastream t
Hello, I have a dataset with roughly 20.000 strategic alliances that occurred from 2011 until 2020, retrieved from the SDC platinum database. I want to measure the impact of these strategic alliances on firm financial performance and therefore I need to connect the company names to a measurable company identifier, such as…
-
[Errno 110] Connection timed out
Hi, I am getting the below error while trying to pull data using get_symbology method. I don't think I am exceeding any limits with this request as I tested for 20 items and it still comes up. What is usually the logic behind this error please? ConnectionError: HTTPConnectionPool(host='10.87.101.215', port=8000): Max…
-
How many identifiers can we include in a request of Symbology API?
How many identifiers can we include in a request of Symbology API? - I'd like to retrieve the corresponding PermIDs from as many DUNS Numbers as possible in one request. Also, are there any restrictions on the numbers of requests per second/day/month?
-
Creating Very Basic Search
Hi Everyone, this might be a very simple solution or not. We are implementing a simple Search function for the following Exchanges PAR,ASX, BRU, OSL, MUN, LSE, LIS, NSE, MIL, TLV, TO, NYS, NAS If for example Id like for a user to search for a specific Ticker, but that same ticker is on multiple exchanges, for example Royal…
-
Is there a way in RDP Symbology to pull up all security-related mappings (GlobalTickerMap record, Cu
Is there a way in RDP Symbology to pull up all security-related mappings (GlobalTickerMap record, Cusip or Sedol, etc.) for Angion Biomedica Corp.?
-
Is Datastream code (DSCD) a unique and permanent identifier?
Will datastream code (DSCD) change after a company is dead or changes its name or merges with other companies? And is DSCD unique for each instrument?
-
How to find OPRA code using stock+exp+strike via REDI API
GetOptionL1Value() requires the OPRA code as below:- tmpVal = L1Cache.GetOptionL1Value("VICI M2023D350000", "PUT_AskPrice", askPx) But if I only have the stock+exp+strike how can I find the OPRA code? Is there a lookup function? Thanks
-
Example queries using "OR" and "AND" in discovery/symbology/v1/lookup API
Hi Refinitiv team, I cannot find examples for usage of "OR" or "AND" in symbology/lookup API. Can we have some examples of how to construct a query using the "OR" or "AND" operator (symbology_user_guide.pdf, page 14). What I try to accomplish is the same as what I get with this PermID request:…
-
GetSymbology function in ekiondataAPI does not return results for conversion from ISIN to RIC code.
List<SymbologyType> toSymbolType = new List<SymbologyType> {SymbologyType.RIC }; var responseSymbol = eikon.GetSymbology(isin, SymbologyType.ISIN, toSymbolType); {series [ error => series [ XS1816199373 => No best match available; US900123BY51 => No best match available; TRT120822F16 => No best match available;…
-
Company PermIDs Changing Over Time
Hi, I've noticed that some companies have PermIDs (OrgPermIDs) that change over time, with the metadata (the knowledge graph, the linked stock quote) being migrated from one to the other. There doesn't appear to be any obvious reason why this occurs, could I please get some product specialist insight into why and when this…