-
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,…
