-
Can I use VBA code in Excel to do this?
Initially client was asking for How can I preserve the values while "erasing" the formula in Cell BB7 in DataStream? So I have provided the below steps: To preserve the values while removing the formula, use the "Save as Values" feature: 1. Open your file (ensure data is updated) 2. Right-click on cell BB7 (or select the…
-
Is there a data field or a formula that retrieves Fiscal Year convention like FY2026 in Excel?
Which fiscal year does the field TR.CompanyFYearEnd return exactly? For example, AAPL’s fiscal year end date is September 30, 2026, which corresponds to the end of its 2026 fiscal year.However, LULU’s fiscal year end date is January 31, 2026, which represents the end of its 2025 fiscal year. My goal now is to determine the…
-
How can I modify the VBA code to ensure that the RDP.HistoricalPricing formula always retrieves data
"We use a loop in Excel-VBA to retrieve historic data with RDP.HistoricalPricing() for a list of RICs. This process is often unstable as for some RICs we don't get data. The issue is not replicable, sometimes we get all data, sometimes some RICs don't get any data. We tried several ideas from LSEG help page e.g. use…
-
What's the python code for adinterp?
=AdInterp(C1,A1:A2,B1:B2,"IM:LOG") Whereas B1&B2 Yield (internal database) https://us.v-cdn.net/6038239/uploads/HDKZI3SJNPF1/reuters-inter.xlsx
-
Update excel files
I'm using Excel with Workspace and Datastream. I have many files that I want to update via the excel addin. I want to write a code (VBA or Python) to open these files and "click" "Refresh Worksheet" button, wait for the update, and then save and close the excel files. Could you assist me with a short code snippet that…
-
How to get buy, hold ,sell for a particular ticker by analysts. Ill be using the API.
How to get buy, hold ,sell for a particular ticker by analysts. Ill be using the API. I tried through excel: =@RDP .Data("VOD.L","TR.BrkRecLabel","CH=Fd RH=IN;brokername;analystname",B2)
-
Is there an easy way to convert 32 bit Excel/REDI-API workbooks to 64 bit?
I'm converting from an old laptop running 32 bit excel and have an excel workbook with REDI-API links to enter orders and display real-time quotes etc. that works just fine on that older system. When I move it to a new tower system running 64 bit excel, many of the code modules are not recognized or cannot be found. Is…
-
Corporate Action Check using Python API/Excel template
Hi team, is there an excel template or python script that I can run to see if my list of companies are having any sorts of corporate actions? It there is, can you please share it with me? Thanks.
-
API | Is it possible to pull all tickers at once using the excel API feature?
Case 15650660 hi team, Is it possible to pull the Cryptocurrency and Blockchain attributes for the specified fund into Excel using the excel API feature? Also is it possible to extract data directly from FSCREEN into API excel?
-
Parent Issuer Bond Rating
we need to monitor credit rating for any new trades timely with Excel/Python API. We would also like to check how to get the credit rating of its immediate parent for a bond position by Excel API. Can you please advice? For example, the issuer of the bond (ISIN: XS3081762828) is ICBC (London Branch) and its immediate…
-
Vba macro code to pause updates or resume updates
Hello Team, Hope everyone is well on your end, apologies for asking but can you assist with one of our client's query please? (CASE#15599046) "In reuters excel, there is a data tool to pause updates or resume updates, may i know if this is something we can use vba macro code to control?" Thank you in advance
-
Hi Team, posting on behalf of client - Macro Code refreshes a selection
Query : Do we have the same code for macro where it refreshes a selection? As per client, the file has a multiple tab. Upon checking, there are the available macro code that we have : - "WorkspaceRefreshAll" - refreshes all workbooks in the current instance of Excel. - "WorkspaceRefreshWorkbook" - refreshes current…
-
How to pull historical financial data from ISIN's
Hi, =@DSGRID ($A$1:$A$1007,RI,P,PO,PB,PA,VO,IBNOSH,04/01/2025,,Daily,RowHeader=true;ColHeader=true;Heading=true;Transpose=true;Code=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false;MonthlyTSFormat=true;AutoRefresh=false) is what I used to pull the historical data for some stocks in the excel…
-
EXCEL API
Hello team, requesting assistance for a query raised by 1 of our client 'How can I download min-by-min OHLC data for RIC <.IEBRT> using the excel API between two dates? Thank you
-
VBA Query
Hello Team, I am raising this query on behalf of a client. 1.Client would like to know more about below WORKSPACE office add-in update on VBA, such as how to use it? Below is the office add-in update log 26.20.9.0 New option to switch between Asynchronous and Synchronous modes in VBA. — How to use it? 2.Please provide an…
