-
Historical S&P Constituents
Hello, I am currently writing my Master thesis and I am in need of the constituents of the S&P500 on several historical dates. I am using the Workspace Formula Builder in Excel. Unfortunately it does not work. Does anybody have an idea or knows how to do it in the web version? Many thanks!!! Robin
-
Problem connecting to excel PowerlinkCOMAddIn.COMAddIn using python win32com.clieny
I am trying to open an excel workbook, connect to the Refinitiv Addin and refresh some formulas using python win32com.client, but unfortunately that is yielding an error as highlighted below. Here's the code I am using: import win32com.client excel = win32com.client.Dispatch("Excel.Application") wb = excel.Workbooks.Add()…
-
What are the ColumnNames in the backend for the following variables in workspace:
What are the ColumnNames in the backend for the following variables in workspace: - Price Date - Has Warrants - China Securities Regulatory Commission - ASEAN Capital Markets Forum - National Association of Financial Market Institutional Investors - Amount Issued (USD) - Next Coupon Payment Date - Amount Issued - Amount…
-
Delistings in Europe
Hello Guys, I have the following Problem and i would really appreciate help. I want voluntary and unvoluntary delistings in Europe between 2010 and 2024. Additionally i need the delisting announcement date (not when the company delisted). Therefore i need the reason why a company delisted (Bankruptcy, Liquidation, M&A,…
-
We're consuming data using the Real Time SDK (https://github.com/Refinitiv/Real-Time-SDK/tree/master
We're consuming data using the Real Time SDK (). When opening the item JPYNOK=X, we get a reasonable call to OnRefreshMsg() with a conversion rate and a scaling of 100. However, when we receive calls to OnUpdateMsg() for this item, the scaling is set to 1. We believe this is a bug. Are you able to confirm and possibly fix…
-
I would like to check if the .bat file attached is compatible to run with Workspace?
Hi Team, the client wants to use a .bat file that will allow him to launch the Workspace Excel add-in. However, it is causing an runtime error in Workspace Excel. May I know if this is compatible with Workspace? Please note the same .bat file is working with Eikon.
-
A mix of Request timeout/channel down/Service not up
Our feedhandler uses C# Real-Time SDK, it subscribed to ~5000 names. On Dec 18, 2024 we notice that there were some issue from ~14:30 to 16:30 EST. The below are some of the samples we received: 2024-12-18 14:51:58.9900 | Refinitiv StatusMsg: Name: CASY.O, ServiceName: hEDD, State: Open / Suspect / None / 'channel down.'…
-
Currency of sovereign CDS
I found there are different currencies options for a sovereign CDS when downloading via Eikon. For instance, the US government 5Y CDS, i.e., USGV5Y**AC=R with ** stand for the currency. This CDS can be quoted by USD, GBP or EUR. But what does it mean with quoted by different currencies, and what are exactly the difference…
-
Getting Best Match via Entity Search API
Hi, Please see my code below my sanctions_df_upgrade has a column caption which are company names. I am looping over that column and mapping it against the PermID db via the Entity Search API My ask is - now I am assuming that the first match found with the parameter num set to 1 is the best match. But is there a better…
-
Historical data for bid/ask spread for stocks
Hello, I would like to retrieve bid/ask spread for a list of stocks on a specific date historically. But I found it is not possible to directly retrieve in the desktop. Therefore I am considering using Python. Could anyone help me with this? Thanks a lot in advance!
-
Use DSS api from a python call
hi, I have the below code to fetch EOD data via eikon api. I frequently end up with connectivity issues - sometimes no data retireved, sometime partial data retrieved. I have been asked to use DSS api instead. Can you please provide me with a alternate version of ek.get_data()? My code is:-…
-
Unable to pull intra-day bid/ask price historical data at 1min frequency
The following code returns bid/ask price data at daily frequency despite mentioning 'minute' in the interval option. Could anyone please help in resolving this? Code: import refinitiv.data as rd import datetime start_date = datetime.datetime(2005, 1, 1) end_date = datetime.datetime(2005, 3, 2) rd.open_session() df =…
-
Looking to publish custom data
I'm looking for a business contact to talk to about setting up some custom fields for a product we wish to publish to Reuters, can anyone provide a business contact?
-
Eikon Data API
I have two questions Is there any endpoint I can hit to get me metadata for a given RIC? I have tried searching the lseg.data api or eikon api and could not find anything, 2. No data coming out of: Or more specifically, the entire timeseries comes out as NaNs ek.get_timeseries( rics = ['SYB-2YNOLAF-F'],…
-
Data item definition in Refinitiv Data Library
My formal colleague left a Python code (refinitiv.data) for entity search purpose (part of it is as below), which is running fine. But I want to get deep dive on the entity information, now I couldn't find any document like a data dictionary for me to know what get_data() returns, and what are the items meaning in returns.…
-
Symbol Conversion parameters in C# vs Python
Hello, How do we pass the same additional parameters such as preferred_country_code and asset_class in the C# version of the SymbolConversion (https://github.com/LSEG-API-Samples/Example.DataLibrary.DotNet/blob/lseg-data-examples/src/2.%20Content/2.5-Symbology/2.5.01-Symbology-Convert/2.5.01-Symbology-Convert.cs) just like…
-
Replacement for RTX.AdxRtList.StartUpdates regarding Workspace upgrade
Upon checking LDL for .Net sample code, Pricing_StreamingSnapshot might be the one to replace RTX.AdxRtList.StartUpdates. However, the data was not retrived with the same field names as AdfinX. Please let us know how to find which data fields should be used. Otherwise please let us know which namespace should be used.…
-
How can I extract all cases with a HIT?
How can I extract all cases with a HIT?
-
Industry codes in MnA
I need granular NAICS codes for MnA deals. However, I only seem to get industry labels and descriptions. Merging these back to codes would be extremely painful. How can I pull these with TR.MnA through the API? If this isn't possible, does Eikon provide a match table?
-
Hang Seng Bank wants to understand if Market By Order data is available via MBO data domain. They wa
Hang Seng Bank wants to understand if Market By Order data is available via MBO data domain. They want to understand if the order can be mapped to the broker ID; such that they can identity which order is belong too Hang Seng Bank (2313)
