-
Why is data not flowing in API while available in Excel for active funds?
Hi Team, We have use Code like this one: import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['LP68702800','LP68611492'], fields = ['TR.ISIN', 'TR.FundName','TR.FundObjective','TR.FundRIESGEnviron','TR.FundRIESGGov','TR.FundRIESGSoc'], ) display(df) These fund RICs are active so we are curious why it…
-
the sample code for "WorkspaceRefreshAll" on WS Excel
Could youd please provide the sample code for "WorkspaceRefreshAll" on WS Excel to use REFRESH button?
-
How can I retrieve in Excel historical swaption volatility surfaces?
I need to get swaption volatility surfaces for a time lenght of at least 8/9 years. I have 14 different exercise dates and 14 different tenors. It is for my master thesis. I looked up at the Q&A and I tried to insert them with RHistory function: =RHistory("EUR3MX1Y=TTKL; EUR3MX2Y=TTKL; EUR3MX3Y=TTKL; EUR3MX4Y=TTKL;…
-
How to retrieve historical swaption volatilities in Excel?
I need to get swaption volatility surfaces for a time lenght of at least 10 years. It is for my master thesis. I looked up at the Q&A and I tried to insert them with RHistory function: =RHistory("USD3MFSR";"BID.TIMESTAMP;BID.CLOSE";"NBROWS:1500 INTERVAL:1D";"CH:IN;Fd STREPEAT:N";B3) Unfortunately it's not working. It says…
-
Refreshing a Specific Worksheet on Workspace VBA
Having difficulty with using the Application.Run "WorkspaceRefreshWorksheet" VBA function on Workspace. I found the information below on refreshing worksheets: 2 - EikonRefreshWorksheet takes a third optional parameter worksheetToRefresh. This is the name of the worksheet to refresh. It can be in "[Book1]Sheet1" format to…
-
PLVApi.Dll
Hi, I'm trying to run VBA code written by someone else, in Excel. I have the Workspace Add In running, and logged in. When I run the VBA code, I get this error message: This dll indeed does not exist in the path indicated in the error window. I thought it might be elsewhere, but I cannot find it in my PC. I looked in the…
-
How to identify stale prices if the index is ticking Real time ?
I am trying to identify way how we can identify if a index is ticking real time or not. Is there a datapoint which provides the last tick time? Also if the index is decimating the stale value how can that be identified ? Is there a datapoint which would tell us if the index data is stale and the exchange is open ? I am…
-
How to use organisation perm_id to find their co2 emission equivalents total on excel?
Dear Sir/Madam, I have a list of organisation perm_id (about 3000companies), is it possible to use them to find their co2 equivalents emission data on excel Datastream? If it is possible, could you please provide some guidance for showing how to do it as i have tried lots of time it always shows error on my worksheet. Many…
-
How to filter ownership data using the Eikon Formula Builder?
Hello, I am using the following formula to extract ownership data in Excel: =@RDP.Data(A2:A1000;"TR.InvestorFullName;TR.InvestorType;TR.InvInvmtOrientation;TR.PctOfSharesOutHeld;TR.OwnTrnverRating;TR.InvestorTotalAssets";"SDate=#1 CH=Fd RH=IN";E4;$D$1) However, as I am trying to analyze a large number of companies over…
-
eikon data on excel not working when launched with python
Hi, I have an excel file with eikon formulas and macros to update spot, swap points and do some math etc... I would like to launch that excel file using Python and execute the excel's macros also with Python. Manually everything works but when I use Xlwings or win32com to launch the excel with python, the dates are…
-
refinitiv formula excel generate issue
I am trying to retrieve data for a list of ticker and date in excel, the formula for the single cell work well, example of formula =@RDP.Data(N1782,"TR.CGBoardSize","SDate=#1 EDate=#2 Period=FY1",,TESTO(Z1782-364,"YYYY-MM-DD"),$Z1782) When I copy and paste the formula in the other cells the formula is correctlycopied for…
-
Eikon Data API Excel Addon for Linux RHEL environment
Hi all. I plan to use Linux RHEL as an operating system for one of my devices. The web version of Eikon works just fine. However, I do not have MS Office Excel. Hence, I can't use the Refinitiv Excel COM API Addon in LibreOffice Calc to retrieve and update data using formulas, as I usually do. It was very convenient to do…
-
Excel Add-in Formula for get_symbology()?
Hi, I was wondering if there an Excel formula equivalent to the function get_symbology() in the Python API? Thanks, TTa
-
How to use formula builder beta in Excel to retrieve previous day's settlement price?
Hi! I'm trying to import the previous date's settlement price for different commodities futures (I believe the data item is STL), but I don't see that on the data items list. Is there a way I can pull the previous day's settlement price into Excel? I'm able to retrieve the current day's settlement, and I want to be able to…
-
Workspace codebook transfer results to Excel
Hi there - I am extremely new to this. Within the Workspace Codebook I was able to receive an output (see attached). How do I move these results into Excel for further analysis? Thank you for your help!
-
How can I download price data only on trading days?
Hi, I'm using the Excel add-in (workspace), and I need to download price data for different companies using a table request (datastream). I need to download data only when the market is open, on trading days. How can I do it? Thanks for your help
-
Refinitiv Workspace addin runtime error when starting Excel via VBO object
Hello, I successfully upgrade my Workspace to 1.24.159. I have a powershell script that opens Excel application via VBO object. If I run the script my addin does not load. I get 'Runtime error' (see attachment) If I start Excel manually, the addin loads correctly Thanks you for your support
-
impact of ESG in M&A transactions
Hello, I would like to know how I can select filters for my research regarding the impact of ESG factors in M&A transactions, initially for a general search, then for a comparison between Asia, Europe, and America, and subsequently for an analysis between sectors. Finally, I would like to compare the ESG scores of the…
-
ESG Scores for M&A Deals
Hi, I have a list of M&A Deals screen and I would like to obtain the ESG Scores of the companies involved in each deal (Target and Acquirer) in the year of the announcement and also 2 years later. I tried to use TR.TRESGScore on Excel but i would have to specify for each deal the specific date, is there any quicker way?
-
LSEG Workspace Excel Addin - startup load failure from C# app
Hello I try to open Excel workbook with LSEG Workspace COM addin from C# app but it fails to load addin on startup; while if I open same file manually addin loads correctly. please help me to open Excel file with workspace addin active through C#, thanks
-
Excel COM API "Server response is not valid"
Is anyone getting or had this error using =TR(...) function? If so how did you solved the issue?
-
starmine data available in excel but gives strange warning in code book
In Excel when asking for the starmine rank I don't need to supply any additional parameters. In Codebook it ask me to supply fields or functions I don't understand in the first place why I need to supply additional information and second it is not clear to me what I need to supply then. Please help me solve this! See the…
-
How can one retrieve a list of Bonds in Workspace Excel?
Until the migration from Eikon to Workspace, I used the function RSearch in Excel under Windows 10 to retrieve a number of bonds according to prespecified criteria. After the migration, RSearch does not work anymore. I have tried replacing it with RDP.Search, bit I get the error "Invalid search criteria". Please see the…
-
How to get ownership percentage panel data through formula builder?
I want to draw a variable on the percentage of shares held by the largest shareholder at FYE for a panel sample through the excel formula builder but I could not find a variable yet that gives me this information and that I can get the panel data for. So I wanted to ask whether such a variable exists and if so, what the…
-
Excel Formula for Beginner
I'm trying to do a couple of very simple tasks in Excel: 1. retrieve a RIC based on ISIN and 2. retrieve GICS industry group based on the RIC (I'm not even sure if there is a way to retrieve the industry group from ISIN). Currently, I would first use Build Formula to grab RICs. An example of formula looked like…
-
When migrating from Refinitiv Eikon to LSEG Workspace, what actions need to be taken to be able to c
When migrating from Refinitiv Eikon to LSEG Workspace, what actions need to be taken to be able to continue using the "TR", "RHistory" and "RSearch functions in MS Excel?
-
refinitiv in excel
hi, I have created a formula for the last trade prices, but I can't make the interval show in seconds instead of minutes. Is there any way to do this? =@RHistory($A$2:$A$15,"TRDPRC_1.Timestamp;TRDPRC_1.Close;TRDPRC_1.Open","START:"&$C$3&" END:"&$D$3&" CODE:SEDOL INTERVAL:1M",,"TSREPEAT:NO CH:IN;Fd",D8)
-
I am getting a message in excel cell saying "server response is not valid"
-
Identify family firms in time
I am trying to identify the family firms among listed firms in time dimension (since ownership changes), using Excel Eikon. I try this code for Walmart company: =@TR("WMT.N","TR.MnAIsTarFamilyOwned; TR.MnAIsTarFamilyOwned.Date","CH=Fd RH=IN",B6) I got only one "TRUE" response for one date: Does that mean that Walmart was…
-
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!!
-
Redi API not showing positions
I have the Redi API running but it's only showing values for 2 positions and others are giving a Ref error. This is despite the Ref column being a copy paste of ticker format from the Redi portal itself. I have spoken to customer service multiple times they have not been able to resolve this. I have also used the Redi API…
-
Question on how to retrieve data from EIKON Refinitiv add in in Excel
Hello dear community, I am trying to retrieve the following data (time series, from 01.01.2003 to 01.01.2015) from companies using their ISIN code as reference in the Eikon Refinitiv add in in Excel: S&P's, Moody's and/or Fitch's (depending on data availability) credit ratings on the same bonds; value of the bond issue in…
-
ISIN to WKN (Wertpapier)?
Hello, if I have a list of ISIN numbers in Excel, is it possible to get them as WKN (securities identification number in Germany)? Thank you very much!
-
How can i get every day prices of RELI.NS including holdays
(eg: for saturday & sunday the FRIDAY prices should reflect), In Bloomberg the command we use is =BDH("RELIANCE IB Equity","PX_LAST","01/01/2023",TODAY(),"DAYS=A","FILL=P"), Here FILL=P used to fill for previous prices where HOLIDAY exists
-
DSGRID and DataStream request differences
I'm currently working on a python model that extracts and processes company data that is largely based on a pre-existing model in excel I received from a colleague. One part of this model uses a function: @Thomson.Reuters.AFOSpreadSheetFormulas.DSGRID(...) To my understanding this translates to a Datastream call using DSWS…
-
How to connect to Refinitiv Workspace Excel programmatically with VBA?
In its previous version, Eikon. I am able to connect and sign in Eikon Excel programmatically with VBA as below. Is there any similar VBA codes for Workspace? Sub signin_connect() 'Enable COM Add-ins For i = 1 To Application.COMAddIns.Count If Application.COMAddIns(i).Description = "Refinitiv Eikon - Microsoft Office" Then…
-
How can I build Excel formula to find financial data for specific firm
I need to collect financial data such as Total Revenue, ROE, etc..., for at least 15 years for only specific firms using Excel formulas like the table below.
-
$$ER: E100,INVALID CODE OR EXPRESSION ENTERED for a Credit Default Swap
Hello, I am having trouble getting the Total Return Index from selected Credit Default Swaps. The Error-Code: $$ER: E100,INVALID CODE OR EXPRESSION ENTERED keeps showing up, regardless of which CDS I choose in Datastream. I am able to get the Total Return Index for Stocks and Bonds, CDS are the only type that do not work:…
-
VBA Question on Application.Run Range("PLPauseResumeEventHandler") and Application.Run Range("TRExce
1. For Application.Run Range("PLPauseResumeEventHandler") and Application.Run Range("TRExcelReCalculateUpdatedFctManualMode"), instead of running for certain range is there a way to write it so it can pause and resume the 1 excel workbook? 2. Also, after we have started refreshing Refinitiv's data into excel, is there a…
-
Refinitive World-Check - bulk/batch archive cases via XLSX template (no api)
I'm using only the web-based Refinitiv World-check One UI, I would like to archive a couple thousand cases using only the below batch template, which I will of course populate with the relevant name/case ID's. Is this possible or would I have to sign up for API access? Furthermore, is this even possible using an API?…