-
How can i get all companies listed in any exchange for a period?
I am using both refinitiv web and plug-in in Excel. I would like to get all listed companies in London Business Exchange between 2005 and 2020 (active, inactive… everything) Thanks in advance!!
-
Which recordtypes to select to decode an exchange equity index
Hello, I want to decode an exchange index , example CAC40 0#FCHI and I only want to show the stocks that are part of the index. I do not want to show the RICS: " EUR=, .DJI , /.STOXX50E,.AD.FCHI". The filtering should probably be done by RECORDTYPE. Which are the RECORDTYPES I have to select so that only the RICs that are…
-
Where to get a historical name change database?
For example Office Depot is not called Office Depot anymore, and instead ODP, problem is that the old data still has to be mapped to ticker via name combination, so without these historical name changes, I am not sure how it could be done.
-
where can I find a mapping between Refinitiv Exchange Codes to Market identifier codes (MIC) & Servi
Example of one such us NSI -> XNSE? Any links for any xls/csv or anyway to extract this data using Java? Example: NEO Exchange NEO-D for NEO-listed securities -----> ???? exchange code
-
Is there an API to fetch the Foreign Exchange Data history
It seems that we have, but I can't get any information from this page FX Pricing Data | Refinitiv .
-
How to retrieve exchange-specific RIC from ISIN input
Hi , I am aware this question was asked before, but since the advanced time since it was asked in 2017 I was wondering if there was a more elegant and proper way to retrieve the RIC for an instrument at a specific exchange now? Hope there is since the existing solution are not very satisfying. And if there is no direct…
-
How to find the list with the exchange for which the suffix of a RIC stands for?
I have a list of RICs belonging to the same ISIN. However, I do not know to which exchange each ric belongs to.
-
Is there any API to get all the Exchange Rates for Central Bank UAE
Hi Team, Do we have any particular API where we can pass Central Bank UAE as data source code and get all the Exchange rates w.r.to the Bank that are available. Thanks & Regards Khambu Swetha Naraharisetti
-
Asia Exchange Trading Hours Information
Dear Refinitiv Support, We would like your advice on 2 questions: * How should we best get information about Asia exchanges' trading hours from Elektron Real-time feed? e.g. Stock Connect, Hong Kong, Shanghai etc. * For the RICs that provide such data, what is the timeline of the data being published by Refinitiv? Since we…
-
Screener: Historic market cap of certain exchanges
Hello all, I was wondering if there is a way to see all the companies that were listed on a certain stock exchange on a certain date. For example, I want to see all the companies that were listed atSIX in 2000 and then do the same for the next 20 years and calculate the sum of the market capitalisation to see how it has…
-
Retrieve normalized company data (e.g. revenue) form foreign currency to EUR by the average exchange
Retrieve normalized company data (e.g. revenue) form foreign currency to EUR by the average exchange rate of the regarded period?
-
get exchange rate on a certain time
Hi, May I ask how to get the traded exchange rate of EUR/USD on 5:00 P.M. by ek.get_timeseries? Thank you
-
Get all Index RICs for a particular country
Hello, I'm trying to use the Eikon API (ideally) to get a list of all of the Exchange RICs for a particular country (say, all Exchange RICs for the United States). I've looked at the answer posted here. However, that doesn't really answer my question as I'm not interested in the constituents of the Exchanges, but instead…
-
Retrieve type (e.g. fund or stock) of RIC in Thomson Reuters Eikon API
Hello, i have managed to retrieve a Pandas Dataframe, which includes all the RICs from "stocks" traded on exchanges of a specific country. The code I have used was taken from this post in the Eikon Community Forum. However, I have two follow up questions: 1. Since the request also includes ETFs, I am curious how to request…
-
Obtain both active and inactive stocks on an exchange using Datastream
Hello, I'm trying to obtain both active and inactive/delisted stocks on a few exchanges, let's say the NYSE and Deutsche Börse. The period doesn't matter, I'll take everything and deal with that later. I'm aware that this isn't possible on Eikon, both thanks to this thread and also from using the Screener in the Eikon…
-
Screener APP and Primariness.
Hi, If I use this code I'll get a dataframe of all stocks that are: Public, Active and also PRIMARY (example for Berling Stock Exchange): df, e = ek.get_data("SCREEN(U(IN(Equity(active,public,primary))),IN(TR.ExchangeMarketIdCode,""XBER""))", ["TR.CommonName;TR.ExchangeName"]) print(df) What I want to know, if what…
-
GET ExchangeTypes Does not Return all Exchanegs
When trying to retrieve the Exchanges configured in Datascope Select using the service: https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/CorporateActionsIpoReportTemplateGetExchangeTypes , a total of 438 Exchanges are returned. When querying the prices for the security with Ric "LP68407002": {…
-
Too many correction message for Exchange Istanbul[IS] , Today I got over 661K
I am getting too many correction message(message type 7) for exchange IS. Please take a look...
-
How can I get a list of all stock tickers in all exchanges ?
so that I can use this list to get monthly price data of all stocks
-
How to find a list of listed companies on Nasdaq Stockholm for 2009-2014 in Eikon?
Hello, I'm currently writing my Master thesis and I have not used Eikon before. I need to get a list of companies listed in Stockholm exchange for each year separately 2009-2014. I'm only able to get a list of companies that are listed currently. The information I would need is the name of the company and industry. In…
-
How do I get the closing prices of the 10-first trading days for all stocks listed at german stock e
Currently I am writing my thesis investigating in IPO-Underpricing and to test one hypotheses, which explains underpricing on the german stock market I need the the closing prices of the 10-first trading days for all stocks listed at the german stock exchange over the last 20 years. I woud be very thankful if someone could…
-
Getting list of all nasdaq/nyse stocks
Hi. I am using Eikon .NET API. I want to get list of all nyse/Nasdaq symbols and then subscribe to prices. Is there a sample code?
-
How may i download list of RIC for an exchange including non longer traded stocks ? TRTH/DSS
How may i download list of RIC for an exchange including non longer traded stocks ? TRTH/DSS
-
How to get all list stock of exchange, like Hong Kong Stock Exchange?
How to get all list stock of exchange, like Hong Kong Stock Exchange?
-
Trading Status for Europe Exhanges
Hello, we get feeds from many of European Exchanges via Electron platform (we're using RFA C++ API 8.x). we'd like to get trading status information about instruments (normal, halt, suspended) so we look at TRD_STATUS field as well as others we think it's related (like INST_PHASE, HALT_RSN/HALT_REASON). However, many of…
-
Find out if a company is listed on multiple exchanges using the Python API?
Is there a way to determine if a company is listed on multiple exchanges using the Python API? Currently I can find out where a company is based: ek.get_data(['RIO.AX'], ['CF_NAME', 'TR.CompanyMarketCap', 'TR.HeadquartersCountry'], {'SDate': '0CY'}) However, I haven't been able to find a way to determine if this company is…
-
REST DSS ISIN to RIC for specific exchange
Hi, I'm using .NET DSS REST example Tutorial 8 restful_api_TandC.sln to translate ISIN to RIC using the TermsAndConditionsExtractionRequest. When I specify the instrument without using the Source field: new InstrumentIdentifier {Identifier = "ZAE000097580", IdentifierType = IdentifierType.Isin} It correctly returns RIC…
-
List all the Symbolds listed on the exchange along with their volume and traded quantity ?
Hi Experts , can one help me list all the fonds/etf listed on particular stock exchange along their volume ? regards kumar
-
Timestamps of deletions in TRTH market by price data
In market BY price data (level 2) we can use fields LV_TIM_MS or LV_TIM_NS to get the timestamp of updates. However if an update consist of just DELETE updates, these fields are not set and the only time related fields left to use are TIMACT_MS or TIMACT_NS. However sometimes TIMACT get substantially behind LV_TIM and is…
-
Some Instruments not returning correct data for Composite Extraction
I am trying to obtain a list of exchange codes that the security is traded on using the 9th tutorial example in the .NET SDK set of tutorials - On Demand Composite Extraction. I have replaced the requested fieldnames with : string[] requestedFieldNames = { "Instrument ID", "Exchange Code", "Exchange Country Code",…
-
Where can I find the list of fields available for RFA or Elektron streams for each exchange ?
For exemple I would like to retrieve the list of quotation fields available on HKSE, is there a dedicated page per exchange to get the description of what is available ?
-
What does the ALIAS name "NMP" in Consolidated XBO feeds?
We subscribe European XBO trades from ELEKTRON via RFA API. In our XBO feeds, we use ALIAS to identify exchanges. For example, LSE for London Stock Exchange, BTE for BATS. However, in some of XBOs, like Helsinki, other than other aliases, we encounter the ALIAS that is set to "NMP". It seems that the trades are OnBook Dark…
-
Venue Pause & Resume Controls
Hello, we're the subscriber of the Elektron platform using RFA API. We'd like to know if we can receive pause and resume events etc. for venues in Europe? or there are other means to do so? I don't see there are ways for those symbol events but I'd like to confirm, and to know if any plans. Thanks!
-
Is there a mapping between consolidated and individual RIC?
We know now that we can compose a consolidated symbol by using ticker + curreny _ ".xbo". For example, the consolidated symbol for VOD.L is VODGBP.xbo. However, is there a reverse mapping such that we know what Exchanges are included as part of the consolidated? We understand that the consolidated RIC may not cover all…
-
is VOD.L a composite or LSE only trade?
I can only subscribe to VOD.L; however there are other exchanges like Bats (VODL.BS), Chi-X (VODL.CHI), Turquoise etc. However I can't subscribe to them. So is VOD.L a composite trade on LSE? If not, how can I get subscribe to Euro Bats, Chi-X and Turquoise? Thanks.
-
What is the recommended way to subscribe to all RICs on a particular exchange?
My questions concern a few things about symbol list requests, the ITEM_LIST field of source directory messages and generally segmenting RICs by exchange. What is the recommended way for me to programmatically, from my C or C++ application, to subscribe to, say, "all RICs on Nasdaq"? I have tried sending a symbol list…