-
Hi how can i refresh all TR formulas in a workbook for the new workspace add in, in vba? I used to d
Hi how can i refresh all TR formulas in a workbook for the new workspace add in, in vba? I used to do: Application.Run "EikonRefreshWorksheet", True, 10000 when eikon was still in place
-
From VBA to Python
Years ago I programmed some macros in Eikon that capture and save in a folder on his PC hard disk the graphs of about 200 RICs (stocks, indices, currencies, etc.). They are graphs that have studies, annotations, trend lines, Fibonacci, and that are generated in daily and weekly format. The macros convert all the graphics…
-
Issue with "WorkspaceRefreshWorksheet" on Workspace VBA
I'm having difficulty with including the workbook name on "WorkspaceRefreshWorksheet". I'm using: Sub WSRefreshSheet() DoEvents Application.Run "WorkspaceRefreshWorksheet", True, 120000, "[Book1]Sheet1" DoEvents End Sub But it doesn't run unless I remove the Workbook name ([Book1]). Works perfectly fine if only "Sheet1" is…
-
Hi Team, one of our client is facing issue with Macro not working when try to save PDF
Macro1.PNG Hi Team, one of our client is facing issue with Macro not working when try to save PDF
-
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…
-
Replacement for Rhistory and Dex2 for migration from Eikon to Workspace
Hi, I am currently using RhistoryAPI.dll and Dex2.dll in my VBA code with Refinitiv Eikon. Apparently these APIs are under COM APIs for use in Microsoft Office and aren't supported in Refinitiv Workspace. What are the replacements that I can use?
-
Could we log in Refinitiv Workspace Addin using the VBA code like before? (Before: Eikon COM Addin)
Now, we can still use the VBA code [Application.Run "PLLoginEventHandler"] to log in Eikon COM Addin. However, we will be using a new version of Eikon, the Refinitiv Workspace, so common VBA code may no longer work. I would like to ask if there is a way to log in Refinitiv Workspace Addin using VBA code like before?…
-
Macro "Application.Run "EikonRefreshAll", True, 30000" not working
I am using Eikon Refinitiv in Excel as add-in. Office 365. VBA. Windows 10. I have a workbook with numerous worksheets, in which there are Refinitiv formulas. There are two types of formulas used: 1) Screeners in the form of formula TR(Screen. 2) data retrieval in form of RHistory. 3) data retrieval in form of TR When…
-
EikonRefresh in VBA (LSEG Workspace)
We will shortly migrate from Refinitiv Eikon to LSEG Workspace and I would like to understand whether the EikonRefresh functions in VBA will continue to work or whether a different approach will be needed. Thanks, Michail
-
Hello, I can open QuoteWindow with F4. But how can I open QuoteWindow with VBA Code for RIC like EUR
I'm looking forward for VBA Code to open QuoteWindow (F4) about VBA Code in EIKON Excel.
-
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 to automatically download a list of domestic investment trusts using VBA
Hi,I want to automatically download a list of domestic investment trusts list everyday using task scheduler. I think if I could write Excel VBA(32bit) by setting the Thomson Reuters .dll as a reference. Which dll and library should I use? and where do I find how to write code(ex:tutorial or documentation) Thank you.
-
Application.Run Range("PLPauseResumeEventHandler")
Application.Run ("PLPauseResumeEventHandler") or other vba codes? fixing some vba codes wanted to pause workbooks auto update for eikon via excel using vba was using Application.Run (PLPauseResumeEventHandler) anyway to split it into pause and resume only? or any other methods to control it? Application.Run…
-
Runtime Error The Object 'DfAddPeriod' Method Fails 'iAdxdateModule
Hi team client encountered this execution error: Runtime Error The Object 'DfAddPeriod' Method Fails 'iAdxdateModule, has this something to do with the Eikon version? current version of Eikon is ( 4.0.53 )
-
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…
-
Access error while accessing refinitive Eikon through VBA
Hi, I am having a problem while trying to access to some data through excel. In the Excel file I am getting the error in the line of code: This script has been working for long time until today. The error that I get in excel is this one: While pasting the gateway URL into internet and put my credentials, I get this message…
-
Quote for stock and options
Very basic skills in VBA. Looking for something very simple: Cell A1 is a stock symbol or option symbol Cell A2 is bid Cell A3 is ask Cell A4 is last trade Any help?
-
Stability issue using VBA to update Eikon formula
Hi all, I am having a stability issue in my excel when I use VBA to refresh Eikon formula. I often use one formula for 3000 companies at a time, such as '=TR($B$9:$B$3100,"TR.PriceClose","CH=Fd RH=IN",E8) For Price data, such as TR.PriceClose, using VBA to refresh it is very stable. But for financial statemant data, such…
-
Enable pre market trading in the spread trader (REDI) via VBA
Hi team, Can I enable the Pre-Market Trading (see pictures) in the advanced parameters via VBA? Thanks!
-
Is there an option to receive TimeSeries data in reverse order from Datastream Web Service?
Hello, I am trying to receive TimeSeries data from the Datastream API in Excel VBA under Windows, using the code examples shown in https://product.datastream.com/DswsClient/Docs/AboutRestSvc.aspx . The data comes back as oldest to latest, but I would like to reverse this order (from latest to oldest ). In the Excel DSGRID…
-
Retrieving RediPlus Position Table With Excel VBA Error
When retrieving information using excel vba from the redi position table, an error is encountered. The error is something to the effect of "automation error". Sometimes it happens after a few hundred rows. Sometimes after ten thousand rows. But it always happens at some point.
-
Optimizing Speed of Application.Run "EikonRefreshWorkbook"
I am trying to fetch some historical prices in large blocks of at least 50000 and inserting them directly into SQL with a VBA-Loop. Thanks to this forum I was already able to figure out that a synchronous refresh of the TR-formulas can be done with Application.Run "EikonRefreshWorkbook". Everything works fine for a small…
-
COM APIs in Office 64bits
Hello Team, My configuration is: Windows 10 64bits Office 365 64bits I tried running the ALL_COM_APIs.xlsm tutorials file and I performed the following fixes: -Added PtrSafe keyword where missing -Remapped the rtx.dll reference path Tutorials 1 to 5 and 9keep failing with error "Runtime error '91' Object Variable or With…
-
OPTIONORDER.GetExchangeCount() returns no exchanges
Hi, ORDER.GetExchangeCount() returns a full count of destinations for me but OPTIONORDER.GetExchangeCount() does not. NOTE: I can see the destinations for options orders in the UI. The actual return value of these functions is Empty for ORDER and False for OPTIONORDER. Permissions issue? Thanks
-
VBA - Refresh matrix formula
Hello, Application.Run "PLRefreshWorksheetEventHandler" This line of code does not refresh Matrix Formula so my question is the following one : How do I recalculate/refresh reuters Matrix Formula with VBA ? Matrix formula for exemple : =FxCalcPeriod($P$4;S9;M9;"FROM:MMTRADE") Kindly,Dorian
-
Type Mismatch VBA - DfAddPeriod
Hello, I am trying to use DfAddPeriod in VBA : Public Function CreateAdxDateModule() As AdfinXAnalyticsFunctions.AdxDateModule Set CreateAdxDateModule = CreateReutersObject("AdfinXAnalyticsFunctions.AdxDateModule") End Function CreateAdxDateModule.DfAddPeriod("FRA", "12/02/2021", "1M", "EMC:S") But this does return a Type…
-
RIC/Flied combination in VBA requests
Good morning, I have a question about the Eikon API and the way historical data requests are constructed using VBA. It has to do with RIC/field combination. I have a sample sheet that requests historical data via VBA for all the RICS provided as long as I want the same field for all of them. I would like to use different…
-
Excel to Eikon apps via Side by Side
I have a client who has an Excel sheet with direct links to Bbg apps which display research, estimates and news. We can achieve this in Eikon by the use of RACE hyperlinks. HOWEVER, the user is not entirely satisfied, because in his Bbg solution, the links are always pushed to the same window in the same screen position,…
-
Can we download un-adjusted stock price under DEX2 COM API
Hi team, using Excel VBA and DEX2 COM API, is it possible to download un-adjusted historical stock price? I am trying "Adjusted:0" in either "Request Parameters" and "Display Parameters" and no luck. Any thoughts?
-
Is there a VBA macro to refresh DataStream DSGRID() functions?
Hi I'm posting this on behalf of a client, : "Is there a VBA macro to refresh DataStream DSGRID() functions?" Is there a walkthrough I can use or directly provide them?
-
In VBA I have *Application.Run "EikonRefreshWorkbook"* as a code line to refresh my excel workbook.
If Application.Run "EikonRefreshWorkbook" works for RHistory just let me know. Call Sheet4.SpinButton1_SpinDown DoEvents Application.Run "EikonRefreshWorkbook" DoEvents Application.Run "EikonRefreshWorkbook" DoEvents Call CopyPaste DoEvents
-
Difference between TRDPRC_1.close and .close
Hi, could you please explain the difference between TRDPRC_1.Close and simple .Close request field? I noticed, that TRDPRC_1 does not work for currencies, but works for indices. And simple .close works for both. Do I extract different data? Example EURUSDFIXM=WM and .SPX I am using RHistory API in VBA-Excel Thank you!…
-
VBA / Refresh Eikon Formulas
Hello, I am using a VBA in file A to update prices. Those prices are found with Reuters formulas located in file B. I open the file B as read only, refresh the formulas with the below instructions, but nothing happens and the prices dont get updated. It seems that if I open file B manually and refresh, the prices update…
-
Is there any way to get primary Chain for a RIC? (not looking for Chain Dissector)
RICs can be extracted through EIKON using RData function in Excel. In the similar way, is there any possibility to get a primary Chain/Main chain for a RIC?
-
Refresh All Files button not working
File "Demand Forecast EU.xlsm" is customized version of "Power Gas Carbon Agriculture Research and Forecasts" where additional button is added to run VBA. About 2 weeks ago, the sheet-tabs started to not update when clicking on Refresh All Files. Thought the file was corrupted so created new file but it is the same issue…
-
I am not able to refresh the Refinitv "Download Manager" MS Excel workbook programatically
I'm trying to use your MS Excel Download Manager template to download commodity forecasts automatically. To refresh the file, I can successfully press the " Refresh All Files" vba button and it updates the sheet with the data as intended. However, when I try and do this same task programmatically, by calling the underlying…
-
Tick History Time and Sales data through Microsoft VBA, facing issue in downloading zipped files & m
The client is able to make it work for ‘smaller’ reports – e.g. a Terms and Conditions report, where the returned data is relatively small but not for a Tick History file, specifically around the downloading of Tick History where the files are zipped. The client is following TRTHv2 API scheduled Workflow: using the…
-
How do I get data for holidays and weekends in Excel VBA via RHistoryAPI
Hi, I use the Basic AdxHistory.xlsm Makro in order to download daily closing price for some instrument. I get only the dates, when the price was published. However, I need the complete time series, where holidays and weekends are also present. What do I do? I would expect the .Mode property, but it does not help. Small…
-
forecast dividend excel file not working anymore on excel 32b version 2003
Hello, The Forecasted dividend and ATM implied volatility excel sheet was working fine on excel version 1700. Now with the latest update of excel, version 2003, it generates an error. Can we have your input on this ? Thanks