-
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()…
-
Help Needed: Historical OMXSPI Constituents Using Eikon Excel Add-Ons
Hi everyone! I’m a bachelor’s student from Sweden, currently writing my thesis on excess comovement by index events. This is my first time using Eikon, and I have access to the Eikon Excel add-ons. I’m trying to retrieve historical data on the constituents of the OMX Stockholm All-Share Index (.OMXSPI) for my research.…
-
DoEvents Application.Run "WorkspaceRefreshWorksheet", True, 1200, ActShtName DoEvents what do True
DoEvents Application.Run "WorkspaceRefreshWorksheet", True, 1200, ActShtName DoEvents what do True If we set that false, what will happen in what case?
-
Python- workspace excel implementation
Hi Team, Can you please answer two questions below? 1) Will new workflow (Python-Excel) implementation require additional payable data access licensing (for instance to data API licenses). If yes – then where can we find pricing? 2) Is there a way (please share some sample python file or reference) to initiate some…
-
RDP Addin function in Excel and handling these functions by using Macro(VBA)
For the RDP function to ADDI to Excel, can I use the same Excel macro (VBA) to run a stop update and its recalculte? (as for eikon or workspace addin, I understand that we cannot do such a handle)
-
How to do do "Refresh All Workbooks" and "Pause Update" in Refinitiv Workspace Excel with VBA?
How to do do "Refresh All Workbooks" and "Pause Update" in Refinitiv Workspace Excel with VBA?
-
Workspace Excel-Addin: Pause/Resume Updates
How can I pause/resume the updates in Excel VBA for the Workspace Add-in? I know that for Eikon the function was "PLPauseResumeEventHandler". What is the equivalent for Workspace?
-
Skipping first 5 outputs of =RDP.Data(0#.AEX)
I am using excel and I want to ultimately get the closing price of the stocks currently in the AEX, from 2004 to today. I provide the chain RIC (0#.AEX correct?) and then I want to use =RDP.Data($B$3) (0#.AEX is in B3) to get all the stocks in the AEX. And then I would use an adjusted version of the following formula,…
-
Python data export to excel
Hi, I’m currently working on a large valuation model using Workspace and Excel. The issue I’m facing is that Excel is struggling to handle the volume of information, causing it to lag frequently. After doing some research, I realized that switching to Python could help solve this problem. I would like to know if it’s…
-
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…
