-
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…
-
How to filter various asset type based on the most primary market
Hi, I am using Refinitiv Data Scope Select API for in my project and want to filter out various asset types based on data received from Refinitiv. <add key="ReutersWSRequestAllListings" value="true"/> I have been using the above filter, for Refinitiv to send only One Silver copy for the instrument requested based on the…
-
How can I get only Equities, Indexes, ETFs and ADR from the "main market"?
Hi, I'm using TRTH api with this url https://hosted.datascopeapi.reuters.com/RestApi/v1/Search/EquitySearch with this body requestBody = { "SearchRequest": { "ExchangeCodes": ["NYS", "ARC", "ASE", "NAQ"], "PreferredIdentifierType": "Ric" } } and everything is working fine, but how can I get only Equities, Indexes, ETFs and…
-
Filtering data at source
Hi, I am querying data from TRTH Intraday summary via python. Is it possible to do any of the below: 1. Only call certain fields: For instance, I do not need to to get data on default fields such as Domain, Underlying RIC Alias, Type. 2. Is there a way to only get non empty data. For instance, if Price ("Last") and Volume…
-
Eikon python API: Formulating search queries to order news by popularity or filter by the media comp
I'm trying to retrieve the most popular news headlines for a given company's ric in a given day. 1. Is there any way to form a search query to output news ordered by how popular they are? 2. Is it possible to filter the search queries to show only certain media companies? How can I encode a newspaper ID in the search…
-
In the Python news API, how can I filter out all the NEWSWIRE news? Thanks.
Currently using this filter: Language:LEN AND Source:SUGG AND ( Topic:GLOFIN OR Topic:TOPNWS ) NOT ( Source:TRAUT OR Source:ECLCTA OR Source:ECLTND OR Source:ECLPCM OR Source:ECLBFI OR Topic:ENT OR Topic:JOB OR Topic:SPO OR Topic:BACT OR Topic:STXOPS OR Topic:INTER OR Topic:MTPDF OR Topic:VID OR Topic:REP OR Topic:VEN OR…
-
How do I add additional criteria when retrieving RIC codes to a ‘screener_exp’ statement?
In answer to my question ‘How do I retrieve RIC codes of stock symbols for a country, e.g. Canada?’ jirapongse.phuriphanvichai showed me some very useful snipper code such as screener_exp = 'SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), IN(TR.ExchangeCountryCode,"CA"))' companies_data, err =…
-
How best to filter invalid instruments in HistoricalSearch?
I am currently trying to query historical instruments on the Hong Kong exchange. I am using the following query: Search/HistoricalCriteriaSearch { "Request": { "RicPattern": ".HK$", "Range": { "Start": "2010-11-07T00:00:00.000Z", "End": "2010-11-08T00:00:00.000Z" } } } This returns to me a bunch of duplicate values for…
-
How can we apply a filter in quick consumer application in RFA.net to get only Ask/Bid Prices.
Sample code: FieldList fieldList = payload as FieldList; ///Console.WriteLine("FieldList's entry count: " + fieldList.StandardDataCount); short fieldId; foreach (FieldEntry fieldEntry in fieldList) { fieldId = fieldEntry.FieldID; try { RDMFidDef fidDef = rdmFieldDictionary.GetFidDef(fieldId); } moragodkrit
-
What is wrong with news filtering?
I have a problem with news filtering. I only selected “Bahrain” as a filter, but the news article has no relevance to Bahrain (as you can see in screenshot no.2). I don’t know if it helps, but I noticed that “Bahrain” appears in Geographies on the right side. This is another example, same situation: