Tracking Error
I am trying to get the tracking error item ("TR.FundTrackingError1Year") taken from the data item browser over an extended period
The code below just gives me the last available value for item "TR.FundTrackingError1Year".
- Is there a way to obtain the time series? I think "TR.FundTrackingError1Year" is just a static value?
- Which formula has been used to obtain the "TR.FundTrackingError1Year", haven't been able to reproduce the results
ric = ['IVV','SPY'] # example
fields = ["TR.CUSIP", "TR.FundTrackingError1Year"]
params = {'DateType': 'XD', 'SDate' : '1993-01-01', 'EDate' : '2023-12-31'}
fund_data = rd.get_data(ric,fields, params)
Best Answer
-
Hi @lanzani.juli, As @raksina.samasiri pointed out, if you need the formula or business rules, it is better to raise to the customer support. For you questions about the time-series availability, I think you mean the historical data, and that is only available on the Lipper for Investment Management (Lipper IM) desktop services at this stage. Because Lipper IM use the user's calculation parameters, including time periods settings, to calculate the results on-the-fly.
About the formula, Lipper should be using the standard formular for Tracking Error and it uses "log returns" for the calculation by default. I got the values in Lipper IM that matches the Workspace API which is as of end of June. So, it is the latest 1-year period as of the latest month-end.
The value I got for the IVV is 0.002869552. Using the Audit Details in Lipper IM shows me the formula that it uses monthly "excess return" (monthly total return of the fund - monthly total return of the benchmark index). Then the result is just the standard deviation (sample) for these 12 data points.
0
Answers
-
Hi @lanzani.juli ,
Checked in Data Item Browser (DIB), the available output of this field doesn't contain 'date' and considered from the field description, the historical data of this field is not available
To check if the timeseries of the same data is available, as the moderators
on this forum are expertise on Refinitiv APIs usage. However, they do not have
deep expertise in every type of content available.
Such expertise is available through Refinitiv Helpdesk, which can be reached
via MyAccount and the support team is going to contact you soon to assist with this.Hope this helps
and please let me know in case you have any further questions0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛