Can you confirm whether the Eikon Excel formulas (=TR(...), =RHistory(...)) fully support dynamic re
We are using a macro-enabled Excel file that retrieves historical financial data (including stock prices, company fundamentals, and returns) via the Refinitiv Eikon Excel add-in. The macro loops through a list of tickers and for each ticker:
Writes the ticker into a designated input cell (calculationTicker) on a “Calculator” sheet.
Relies on Refinitiv formulas (e.g., =TR(...), =RHistory(...)) that reference calculationTicker to retrieve historical data.
Refreshes the formulas via EikonRefreshSelection.
Copies the output to a “Data” sheet for further processing (beta regressions, etc.).
Recently, we observed the following issues:
Identical data for multiple tickers
After running the macro, all columns in the Data sheet contain the same values, even though the macro is iterating over different tickers.
This results in beta regressions with negative or unrealistic betas and R² = 100%, which is clearly incorrect.
Symptoms suggest ticker input not propagating
In the Calculator sheet, the input cell calculationTicker only shows the last ticker after the macro finishes.
Formulas that are supposed to dynamically reference calculationTicker may not update during the macro loop.
Formulas in the sheet
Some formulas use constructs like =INDEX(...MATCH(calculationTicker,...)) or reference a cell linked to calculationTicker.
During testing, manually changing calculationTicker sometimes does not update the dependent formulas immediately, suggesting potential issues with formula recalc timing or refresh behavior in combination with the Eikon add-in.
Steps already taken internally:
Verified that calculationTicker updates correctly during the macro loop.
Added forced worksheet calculation (Worksheet.Calculate) and small delays (Application.Wait) to give formulas time to recalc.
Confirmed that Excel is in Automatic Calculation mode.
Still, some tickers fail to refresh correctly, resulting in identical data columns for multiple tickers.
Impact:
Historical data for multiple tickers cannot be reliably retrieved.
Beta and other derived calculations are incorrect, affecting valuation models.
The macro relies heavily on dynamically referencing calculationTicker, so this issue prevents automated retrieval across a list of tickers.
Request to Refinitiv Support:
Can you confirm whether the Eikon Excel formulas (=TR(...), =RHistory(...)) fully support dynamic references to a cell that is updated by VBA macros?
Are there known issues with timing or formula recalculation when updating a ticker input cell and immediately calling EikonRefreshSelection via VBA?
Are there recommended practices for looping over multiple tickers in VBA to retrieve historical data reliably?
Is there a way to force Eikon formulas to recalc immediately after updating the ticker, other than manual refresh?
Formula examples: =@TR (calculationTicker,"TR.CompanyMarketCap(Scale=6);TR.TotalEquity(Scale=6)","SDate=#1 EDate=#2 Curn=EUR Frq=#3",,$D$2,$D$3,$D$4)
=@TR (calculationTicker,"TR.PriceClose","SDate=#1 EDate=#2 Curn=EUR Frq=#3",,$D$2,$D$3,$D$4)
Answers
-
Thank you for reaching out to us.
For the questions regarding the =@TR and =RHistory functions in Excel, please contact the Workspace Excel support team directly via LSEG Support.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 37 Alpha
- 167 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 713 Datastream
- 1.5K DSS
- 639 Eikon COM
- 5.3K Eikon Data APIs
- 20 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 12 Trading API
- 3K Elektron
- 1.5K EMA
- 260 ETA
- 574 WebSocket API
- 42 FX Venues
- 16 FX Market Data
- 2 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 26 Messenger Bot
- 5 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 285 Open PermID
- 47 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 25 RDMS
- 2.3K Refinitiv Data Platform
- 20 CFS Bulk File/TM3
- 939 Refinitiv Data Platform Libraries
- 6 LSEG Due Diligence
- 1 LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 12 World-Check Customer Risk Screener
- World-Check On Demand
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 46 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 126 Open DACS
- 1.1K RFA
- 108 UPA
- 197 TREP Infrastructure
- 232 TRKD
- 925 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 107 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛