-
Data S&P 500 to excel - beginner
Hello everyone, I'm a complete beginner using refinitive Eikon for my Master's thesis. I need data on the manufacturing companies of S&P 500 from the years 2010 to 2019. How can I dowload lists like this so that I have it in an excel file? Is it possible to download who was CEO for the respective company in those years?…
-
New functions in Reuters
=RHistory(WIPLN3MD=;"ASK.Timestamp;ASK.Close";"START:"&2021-09-30-2&" END:"&2024-09-30&" ADJUSTED:YES INTERVAL:1D";;"SORT:ASC NULL:PREVIOUS TSREPEAT:NO DAY:A CH:Fd";GM3) Hi, Due to an update, my old functions are not working - any idea how to improve the code above?
-
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()…
-
RDP.Data
Hello, the following RDP.Data executes correctly at the time specified, however, it does not execute the Macro specified (FremdprodisOpenA) =RDP.Data(E5,D5,"ONTIME="&B11&" MACRO=FremdprodisOpenA CH=Fd",F5) Would you be able to point out where the problem might l? Thank you.
-
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
-
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?
