RTD links - SME Estimates

Description

SME Direkt Level 2 Consensus Estimates data may be accessed from other applications (such as Excel) via Real Time Data (RTD).

Requirements

•Subscription to an SME Direkt Level 2 package

•Using RTD requires Excel 2002 or later.

Please note

•Please note that the program must be running in order to provide RTD links

•Make sure that the application has been started and completely logged in before opening any spreadsheets containing RTD links

Creating RTD links from SME Direkt Consensus Estimates

Highlight the areas you would like to have updated in Excel from SME Direkt Consensus Estimates window.

rtd_sme

From 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.

Select Edit | Paste in Excel. Now you have a link to live data in Excel.

sme_rtd_paste

Embedding RTD formulas in Excel

The RTD formula for estimates takes five to ten parameters:

=RTD("ontrade.estimates"; ""; "(Blank)/ISIN/<Feed>"; "FundID/<ISIN>/<Ticker>"; "Variable"[; "Period"; "ValueType"; "Aspect"; "Aggregation"; "Field"])

ProgID	Always set to "ontrade.estimates"
Server	Leave blank ""
Feed	Leave blank "" (future extension)
FundID	Internal numerical identifier for the company
Variable	Variable (Sales, Gross profit, EBIT, Pretax, Net profit, EPS, DPS, Yield, P/S, P/E) or Meta-variable (Name, Currency, Ticker, EstimateDate, FundID, Country, RecomendationDate, RecommendationsAvg, RecommendationsBar).
Period	Period, e.g. 2008Y, 2009Q3, etc.
Value Type	Estimated (default), Actual, EstimatedNRI, ActualNRI or Deviation
Aspect	Value (default), GrowthYear, GrowthPeriod or Margin
Aggregation	Average/Actual (default), Max, Median, Min, StDev, StDevA, Count, CountUp, CountUnchanged, CountDown, ChangeLastReport, ChangeLastYear
Field	Value (default), Currency, Note

Sample RTD formulas (ABB):

=RTD("ontrade.estimates"; ""; ""; "87"; "Name")
=RTD("ontrade.estimates"; ""; ""; "87"; "Sales"; "2009Y")
=RTD("ontrade.estimates"; ""; ""; "87"; "Sales"; "2008Y"; "Actual")
=RTD("ontrade.estimates"; ""; ""; "87"; "Sales"; "2008Y"; "Actual"; "Value"; "Actual"; "Currency")
=RTD("ontrade.estimates"; ""; ""; "87"; "Sales"; "2008Y"; "Actual"; "Value"; "Actual"; "Note")

See the topic about RTD links for quotes on tips on how to reference other Excel cells inside the RTD formula.

Mail us feedback on this topic!

9/4/2017