-
Excel VBA
Client like to use the command code "RtGet("IDN","LCOc1","LAST") in Excel VBA. Is that possible please?
-
Data Limitation
I am Facing a data Limitation Problem in Refinitive in Excel. Plus If you can Provide me code for the data of the given variables for the US and Europe. Scope1_Emissions Scope2_Emissions Scope3_Emissions Total_Emissions ESG_Score Environmental_Score Decarbonization_Target Renewable_Energy_Use Total_Assets…
-
There's a delay in API data updates.
A discrepancy exists between Excel and the API: Excel successfully pulls the latest crude oil data immediately after the 22:30 (Beijing Time) Wednesday release, but the API endpoints return outdated data. Is there a way to optimize the API's refresh cycle to ensure real-time data availability? Eg:…
-
Formula error
can you please check if you can assist? “Basically, I have a formula RDP.Search("COMPANY", $B$8, "NBROWS:500 SORT:DTSubjectName:A", , ) which returns a sample 5073619959 5073620114 5073620117 5073619966 5074009689 5051175432 5084167849After I copy it and paste it back as values, I get 5073619959. all values after the first…
-
Excel Spreadsheet crashing (Workspace Data Retrieval, Macros)
Hello Team, Our excel spreadsheet crashes upon retrieving data from Workspace add-in. It can be replicated inhouse. We checked with excel experts (GBC team) and they informed that it has macros and so needs to be raised to Developers to check further. Could you please advise? The file has .xlsm extension, so its not even…
-
Bizzare behaviour on TR download.
I have several spreadsheets that were working fine earlier today but now have this cryptic message. The '5' is unexpected in identifiers. Only the whole lexeme could be quoted. Escape sequence for quote and apostrophe is doubling. No data is returned. The Excel cell formula is: =TR("SCREEN(U(IN(indices(TRGBLD/TR…
-
Standardized Fundamentals are Appearing in Company profile but not appearing in Screener & in Exce
I have access to Refinitiv Workspace via my academic account. I can view financials (e.g., Revenue from Business Activities - Total) from company profiles such as RVSB.O. However, when I attempt to retrieve the same standardized fundamental fields using the Screener tool or Excel Add-in formulas, the values do not appear.…
-
Linking VBA with the Data Tools functions
Is there a way to link the excel functions with VBA? I want to start my VBA code as soon as i resume updates.
-
How can I retrieve GDP information via the Excel Formula Builder?
Hello everyone, I am quite new to Refinitiv Workspace and have up until now only retrieved company information in Excel using the formula builder. However, now I need to retrieve historical GDP data in Excel for broader geographic regions, namely the US, Europe and Asia from the year 2002 until 2012. Is there any way to do…
-
Behavior of VBA in the workspace
When the following VBA macro is executed line by line in debug mode, it successfully retrieves the result date of the Reuters function in Eikon Excel and complete without issues. However, in Workspace Excel, the cell remains at "Retrieving..." and a type mismatch error occurs. Is this behavior specific to the validation…
-
Excel sheet with macros crashes
Hello Team, An excel sheet crashes upon retrieving data from Workspace add-in. It can be replicated inhouse. We checked with excel experts (GBC team) and they informed that it has macros and so needs to be raised to Developers to check further. Could you please advise? The file has .xlsm extension, so its not even allowing…
-
Workspace Excel Add-in
Hi, Anyone experiencing an issue with the Workspace Excel add-in for streaming rates? Mines keeps freezing after 2-3 minutes.
-
Facing issue on SFIL global
Hi Team, Query : SFIL global issue The first issue is they would like to know if there is a VB code for Workspace refresh function as they have a file that gets their data for BID and ASK which uses workspace formula and they also have MID which is the average of BID and ASK but doesn't use workspace formula. When they…
-
Could you please build a macro that can extract daily data? Please see attached file.
Hello Team, Hope you're okay today. I'm raising this request on behalf of an external client. Kindly check the attachment, is it possible to build a macro for the above file? I'm looking forward to your positive response.
-
Institutional Ownership Data
I’m wondering how I can obtain institutional ownership percentage data in Excel format for time series analysis across multiple firms. Thank you in advance for your help.
