-
How to get all fields from MUNICIPAL_INSTRUMENTS through refinitiv.data API
Hi all, I'm currently using the following code through refinitiv.data API to download data from Views.MUNICIPAL_INSTRUMENTS: rd.discovery.search(view=search.Views.MUNICIPAL_INSTRUMENTS, select = "IssuerName, MaturityDate, IssueDate, MuniState, CUSIP, ISIN, AssetType, RatingType, SPRating, MoodysRating", top = 20) However,…
-
Search API - what are the available columns name for select and filter arguments?
Hi, I am using refinitiv.data.content.search.Definition() which has two argument select and filter. My question is how can I know which columns name are available for specific views and how can I select all columns. "*" doesn't work. For example, in screenshot, your example code select columns…
-
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…
-
Filter for companies with Carbon (CO2) emissions.
I wish to filter for U.S. companies with accessible CO2 emissions data. I have implemented this in the screener by establishing filters for, for instance, 5 and 10 years (filtering for GHG Scope 1 emissions > 0). Is there a method to filter for companies that possess emission data spanning the last 10 years (including…
-
Classification criteria for public or private company
Hello! I'd like to know what i sthe classification criteria Refinitiv use to distinguish Private Company by Public Company. And I also would like to know if there is in Refinitiv a section in which are described all the classification criteria for all filters that you can apply in the AppLibrary Screeener. Thanks in advance
-
Datastream - How to retrieve all series that match my filters or categories?
I want to pull time series data for Datastream mnemonics that match a certain criteria. Datastream interface/desktop has categories for time series that allow you to filter your search to the relevant results. For example you can search for all time series that match: Type=Commodities, Country=USA, Activity=Dead,Settlement…
-
Filter list in discovery search function
Is there a filter list we can refer to when using discovery search function for what filters we can have for a particular query? thank you
-
Filtering Python Dataframe by Minutes
Hi Developer Community! I have filtered my minute time series data frame by specific hours and minutes. The first Loop filters for 11:30 the second for 9:30. Lastly, I concatenated them next to each other. Is there a way to do the same procedure without using an extra (second) loop? I would like to add more time and hour…
-
[WorldCheckOne v2.46] How to filter cases using API?
Hi, As mentioned in the title, how can I filter cases using API. The use case I am trying to achieve is to get all cases with Resolution Status = Positive. Going through the v2.46 documentation I believe I am able to use the following API. POST /cases/summaries However, the query seems to support the following fields only.…
-
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…
-
DSS Rest call for Corporate Actions with filter
I am using the Extractions/ExtractWithNotes endpoint to get corporate actions for a list of instruments and a set timeframe. I believe there is a feature in the API to use filters. What is the syntax to add a filter to the ExtractionRequest? For example, if I only want to retrieve records where "Capital Change Event Type"…
-
Possibility to filter for low-tech/high-tech/deep-tech venture capital activity?
Hi all, I was wondering whether there is an already existing filter for VC investment activities in ventures that are considered to be either low-tech, high-tech, or deep-tech within the Eikon PE and VC Screener. I am currently analysing the correlation of GPs/Funds experiences and the respective fund failure rates. The…
-
List of all active and non active Bonds filtering for Maturity Date
I am looking to get a list of Bonds (Active and Matured) for a series of entities, within the last twenty years. At the moment I am using the following to gather a list of active fixed income securities issued by a particular entity: fi_fields = ['BondRatingLatest',…
-
How to return M&A deals for selected countries using Excel TR Formula?
Hello, I am trying to get the M&A deals based on few criteria among which one important one is the acquiror nation. I cannot find that criteria in the deal screener from where I normally create the formula. Setting TR.MnAAcquirorNation for the desired country in the TR function in excel directly does not work either. This…
-
Equities Data - S&P/Nasdaq/DAX filtered by financial/accounting numbers possible to create?
Hey Developers, i would like to create a CSV within Eikon by equities and their accounting/financial numbers f.e Price/Book, Total Accruals/Total Assets, Debt to Equity etc. Till now i just could find singular equities by which i i could see the wished for data. But not as a total. What im thinking of is a tabular form…
