RTD links - Estimates |
![]() ![]() ![]() |
Description SME Direkt Level 2 Consensus Estimates data may be accessed from other applications (such as Excel) via Real Time Data (RTD). Requirements
Please note
Creating RTD links from SME Direkt Consensus EstimatesStep 1Highlight the areas you would like to have updated in Excel from SME Direkt Consensus Estimates window. Step 2From the main menu select Edit | Copy RTD Link, or just press CTRL+R after you have selected the area. Alternatively, you can copy all the visible fields from the SME Direkt Details window using the same command. Step 3Select Edit | Paste in Excel. Now you have a link to live data in Excel. Embedding RTD formulas in ExcelThe RTD formula for estimates takes five to ten parameters: =RTD("ontrade.estimates"; ""; "(Blank)/ISIN/<Feed>"; "FundID/<ISIN>/<Ticker>"; "Variable"[; "Period"; "ValueType"; "Aspect"; "Aggregation"; "Field"])
Sample RTD formulas (ABB):=RTD("ontrade.estimates"; ""; ""; "87"; "Name") See the topic about RTD links for quotes on tips on how to reference other Excel cells inside the RTD formula.
TIP: By default Excel only updates RTD links every 2 seconds. This limit can be reconfigured, see Microsoft's FAQ (search for "RTD Throttle Interval"). References
|