-
search.Definition - bonds
hello, are you aware of list of possible values for this field - 'select'? search.Definition object response = search.Definition( view=search.Views.FIXED_INCOME_INSTRUMENTS, select="ISIN,RIC,IssueDate,Currency,FaceIssuedTotal,CouponRate,CouponType,MaturityDate", filter=filter_str, top=10000, ).get_data() I am looking for…
-
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…
-
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…
-
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…
