-
How to get the country of domicile using searchlight
Hello, I was trying to get the domicile country and the HQ country of a company. Using /data/entity-reference/v1/organization/company-info I can get the Country of Legal Registration, I was testing it using "BABA.N" and I was hoping to have another field with "China" as a value for the HQ country. How can I get both of…
-
Corporate Bonds: Retrieving Dates of Coupons paid this year, and other bond data
Hi everyone, I have 2 questions regarding the retrieval of Corporate Bond data with the Refinitiv Data Library in Python. I am currently trying to retrieve the coupon rate, next payment date, and coupon payment frequency, with the following formulae: 'TR.CouponRate','TR.FiNextPayDate','TR.FiCouponFrequency' I checked that…
-
orgId property in rdp search API
https://api.refinitiv.com/discovery/searchlight/v1/ { "View": "Organisations", "Select": "Orgid, BusinessEntity, CommonName,PrimaryRIC,PrimaryRICTickerSymbol,PrimaryRICExchangeCode,GicsName", "OrderBy": "CommonName asc", "Filter" : "PrimaryRICExchangeCode eq 'ASX' and IsPublic eq true", "UnentitledAccess": true, "Top": 10…
-
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…
-
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.
-
RDP.Data() and RDP.HistoricalPricing - Is there any known inconsistencies between xlwings and RDP?
Hi I use refinitiv excel addins for functions like RDP.Data() and RDP.HistoricalPricing and so on. I am now tried to write another addon using xlwings with Python. As I'm having trouble getting excel to load my code, I wanted to check whether there are any known inconsistencies between xlwings and RDP?
-
How to get all the search result from refinitiv.data.discovery.search?
I ran below search. But got Error message: refinitiv.data._errors.RDError: Error code 400 | Validation error: json.Top in body should be less than or equal to 10000 rd.discovery.search( view = rd.discovery.Views.FUND_QUOTES, top = 56364, filter = "(AssetState ne 'DC' and SearchAllCategoryv2 eq 'Funds' and…
-
Search API filter
Hi everybody! I am currently utilizing the Search API for my project, which involves gathering data on delisted companies. I have successfully collected the required data, but I am now facing a challenge in filtering this dataset to include only companies based in the United States. Despite trying various values, I have…
-
Batch request bondholders and ultimate parents for multiple bond RICs - python RDP API
Hi there, I am trying to pull the bondholders for several RICs, before finding the ultimate parents of each of these bondholders as well as their identifiers. At the moment, I am doing this RIC by RIC/name by name in a loop. This is resulting in too many API calls to the Refinitiv server, but at least for bondholding data…
-
Unhashable type: 'list' with rd.discovery.search
Hello everyone, I try to retrieve bond data with rd.discovery.search function using Python: start_year = 2021 end_year = start_year + 0 start_date = datetime.date(start_year, 1, 1) end_date = datetime.date(end_year, 11, 30) df = rd.discovery.search( view=rd.discovery.Views.GOV_CORP_INSTRUMENTS, top=10000,…
-
getting TR.LastObservationDate in results for rd.discovery.search
i am searching for economic indicator via above search and want to get the same fields i would get in the workspace. for example the field TR.LastObservationDate, which seems impossible to get in the result data. this is my attempt: search = rd.discovery.search( view = rd.discovery.Views.INDICATOR_QUOTES, filter = "(…
-
Retrieve Equity Index Info via fuzzy search on RDP
Hi Team, Hi Nick nick.zincone is there any reason why the below query gives results on Advanced Search Tool of EIKON, but not in RDP? Also, how can I get the constituents (and weights thereof) of whatever Equity Index that comes out of the query below? import refinitiv.dataplatform as rdp rd.open_session() sFilter = "(…
-
Fuzzy name company search
Hi @nick.zincone , I am doing a company search based on fuzzy names. Following issue came up with the search namely: say I specify companies "SoftwareONE" , "Accenture". The query below returns results in random order. How to map results back to the companies I specified? (have 20K names). Many thanks. Grigorios >>>mystr =…
-
COMPANY SEARCH RDP Python
Actually I wanted to look for getting all kind of companies with ISINs, Revenue etc . Can I do that with Python rdp? I know that Excel box has this corporate search engine but I can export only 10000 at a time .. I know that I should be using some universe with rdp.search but do not know which one to use and what to put in…
-
Real-Time Dealer Research API
Are there any other Real-Time Research API to retrieve Dealer Reports that is NOT based on SQS messaging?
-
Real-Time Dealer Research API
Are there any other Real-Time Research API to retrieve Dealer Reports that is NOT based on SQS messaging?
-
TRAPI Scope
When attempting to test python modules in rdp_python_samples_v2.zip, we encountered the error message Missing scopes: [trapi.alerts.research.crud]. Does this mean I need to go to my Refinitiv account manager to make sure the scope is permissioned for account/credential? >$ python researchMessages.py -l Existing token read…
-
Dealer Research Report API
Is there sample python code to subscribe Dealer Research Report based on SQS and retrieve API?
-
How to get data for all exchange-traded stocks historically but now delisted?
I am trying to create a backtest using all the stocks that have been publicly traded at some point in time historically (i.e. excluding OTC traded stocks) but currently are delisted or OTC traded. But using RDP search I am not getting stocks like Lehman Brothers and BankUnited Financial in my list as the exchange presently…
-
ERROR!!! An error occurred while requesting URL('http://localhost:9060/api/rdp/discovery/search/v1/'
I get this error when I run code using a python editor (VSCode). This issue randomly pops up and usually resolves itself after a few minutes, but now it's not working at all. I checked and i can run the code using Eikon's Codebook app. The code breaks at line 10.
-
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…
-
How to retrieve the entire mutual fund universe trading in the US market?
With the below code I can only retrieve upto 10k mutual funds. I can use IssueLipperGlobalSchemeName filter but there are too many lipper schemes in this PDF and some of the lipper schemes are not exactly matching with the Python output (Eg: In the PDF one of the schemes is called "Equity Sector Information Technology "…
-
Symbology conversion for vessel IMOs
Hi, I have a list of vessels for which I have the IMO numbers (more than 20,000 vessels) and I would like to get the RICs for these vessels. There seems to be no data item for Vessel RIC and hence Eikon Get Data functionality wont be helpful. RDP search for Vessel Physical assets can be one option but I am not sure how to…
-
Download limit number
Hello, I got a query from client. How many bonds extracted by conditional search can be downloaded at once? No limit? In case of EIKON, download limit number is 10000.
-
Python Library to make rd.discovery.search run/work
Hello, I would like to replicate this query for bonds within a Jupyter notebook using our API key. Can you please guide me on how i could do so? rd.discovery.search( view = rd.discovery.Views.GOV_CORP_INSTRUMENTS, top = 10, filter = "(DbType eq 'CORP' and RCSAssetCategory eq 'A:1A' and IsActive eq true and…
-
How to get Amount Issued for expired Corporate Bonds
The Eikon API for getting data eikon.get_data() does not have data for expired bonds. So I tried to use the search APIs in Eikon, namely rdp.Search and data.content.search() in order to get the Amount Issued for expired bonds. (As a side note, what is the difference between these search APIs ?) Here is an example of…
-
Search API cannot find US ESG equity indices from US indices
Using the Search API, I want to identify (standard and ESG) equity indices by location (starting from US, then Europe…). But I am not getting back the expected list of indices. The list changes if use filter or query parameters. If I use filter to find the indexes within the USA, following this previous threat: filter =…
-
Advanced search for equity indices. How to filter Price Return, Net Total Return, or Total Return?
Hello again, Using the advanced search tool, I filtered US Quality equity indices. However, I often find different suffixes for the same indices. For example, the three instruments below are from the same HSBC Quality US index. RIC: Name .HSIEQUGP : HSBC Quality ESG US Price Return Index (USD) .HSIEQUGN : HSBC Quality ESG…
-
Keywords search in News Screener
Hi, I am trying to use the get_news_headlines to run a keyword search on Python. I have noticed that if I use a single word this works as expected, as per example: ek.get_news_headlines(query = 'plastic', count=100) However, I am trying to use in this case multiple words combined in a single string as my query. For example…
-
How I can retrieve the data in delayed For RIC EUR= and use the ‘/’-RIC.
How I can retrieve the data in delayed For RIC EUR= and use the ‘/’-RIC. The request that I make: https://api.refinitiv.com/data/historical-pricing/v1/views/intraday-summaries//EUR=?interval=PT1M&sessions=normal returns in the playground the next error message: “failed to fetch”. What is wrong?
-
rdp.search suddenly returns nothing
I am a regular user of rdp.search that was perfectly working for months. For some reasons I do not understand, it returns now None whatever the query is. IT_Bonds = rdp.search(view=rdp.SearchViews.FixedIncomeInstruments, filter = "IssuerCountry eq 'IT' and \ Currency eq 'EUR' and DbType eq 'GOVT' and IsActive eq true and…
-
RDP Searchlight - Search for US options that are ATM ( At the money )
Can we do s a search for US options that are ATM ( At the money ). For example all AAPL options that are ATM?
-
How can I make rdp.search() work?
I am a student at Copenhagen Business School, the school has access to EIKON and Datastream. Therefore, I have access to the application called "advance search" in Refinitiv Eikon. From advance search, I have exported a query that uses the following syntax: rdp.search( view = rdp.SearchViews.GovCorpInstruments, top = 10,…
-
escape character in rdp.search
I am trying to look for some data on the option chain root 0#WM*.U. I used both the query "0#WM*.U" as well as the filter "RIC eq 0#WM*.U". However this * is taken as an arbitrary character in stead of only returning "0#WM*.U" . Is there a way to only return "0#WM*.U" with * taking only the value * ?
-
Currently, we get prefixed benchmarks like TONA TSR by old-style data flow but for the new benchmark
Currently, we get prefixed benchmarks like TONA TSR by old-style data flow from Refinitv but for the new benchmark like TONA compounding rate, we get it by using IPA service. Is there a way to get the rate of SOFR ICE Swap Rate and FB of it?
-
RDP Inactive corporate Bonds
Hi, Happy New Year! I am trying to capture, using RDP query in Python, the inactive bonds for a given ParentOAPermID. Can you please confirm that the following (upper) snippet does what I am looking for. A couple of more questions: a. I see that there are quite few bonds without ISIN. Why is that? b. I see that my query…
-
Return all active fixed-rate Australia government bonds using the rdp.Search.search function in Pyth
Return all active fixed-rate Australia government bonds using the rdp.Search.search function in Python
-
ERROR!!! An error occurred while requesting URL('http://localhost:9060/api/rdp/discovery/search/v1/'
Hi This morning I tried to access the new search api example using my python editor and also via Codebook. (EX_01_02_02__Function__Search) when I run the same code in my python editor directly i get the following error: ERROR!!! An error occurred while requesting URL('http://localhost:9060/api/rdp/discovery/search/v1/').…
-
RDP query which includes the stock tickers and names for a ALL equities , ADRS and ETFs which trade
In a nutshell, we are looking for an RDP query which includes the stock tickers and names for a ALL equities , ADRS and ETFs which trade in the US, either on an exchange or OTC. This should include approximately 14,000 securities. It is difficult to see exactly all the US exchanges that are available through OTC but the…
-
Getting MONitor list of the user
Hi Experts, Is there a smart way to get a list of MONs created by the user using rdp endpoint? Currently the only option I have found is: rdp.get_data("MONITOR('monitor_name')",["TR.CommonName"]) however it is extremely slow comparing to e.g. search endpoint. Any other idea how to check whether the MONitor with that name…