How to convert a RHistory function into a EikonDataApi request?
I'm trying to find out how I can translate the following function found in our excel document.
=@RHistory(".MERF0C4","NDA_RAW.Nda_spread","START:"&$C$46&" END:"&$C$46&" INTERVAL:1D")
Into a request built within EikonDataAPI (C# library)?
Update:
1. I can get the current days value using
eikon.GetData(".MERF0C4", "GEN_VAL10")
but try as I might I can't get historical values. Everything I try returns missing as the only value.
2. This other excel functions retrieves the same info if it helps translate the function.
=@RHistory(".MERF0C4","ROAS.Timestamp;ROAS.Value","START:01-Oct-2020 END:19-Oct-2020 INTERVAL:1D",,"TSREPEAT:NO",W37)
I've tried to extrapolate what it could be but nothing seems to work. I pasted bellow my current attempt with a sample or alternatives I've tried.
var dictParam = new Dictionary<string, string>();
dictParam.Add("SDATE", "01-Oct-2020");
//dictParam.Add("NBROWS", "50");
dictParam.Add("SORT", "ASC");
dictParam.Add("INTERVAL", "1D");
var fields = new List<string>();
//fields.Add("GEN_VAL10");
//fields.Add("TR.ROAS");
fields.Add("TR.NDA_raw");
//fields.Add("FIELDS");
var instruments = new List<string>();
instruments.Add(".MERF0C4");
var abdc = eikon.GetDataRaw(instruments, fields, dictParam);
Best Answer
-
I'm afraid these timeseries are not available through Eikon Data APIs. At the moment the only way to retrieve this data programmatically is by using legacy Eikon .NET APIs.
1
Answers
-
Thank you for the info and link. I'm now working on implementing this Api specifically for this request.
I'm now debating if I should convert my app to only use the legacy Api. Would you know what benefits the new Api has over the old one (security, performance, ...) and more confusingly, would you happen to know why the new Api (Eikon Data Api) has access to less data than the legacy Api (Eikon .NET Api) and the Excel Add-On?
0 -
Eikon .NET APIs only provide access to streaming market data and timeseries of price history. Eikon Data APIs also provide access to fundamental and reference data, screening capabilities etc. We're in the process of building out a new data platform that will consolidate all Refinitiv data assets and provide access to them through consistent interface. The newer APIs are meant to retrieve data from this new platform dubbed Refinitiv Data Platform, and will eventually replace legacy APIs. However in the meantime, while the new data platform is being developed, there are some (fairly small) datasets that are only accessible through legacy APIs.
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 162 App Studio
- 4 Block Chain
- 5 Bot Platform
- 17 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
- 370 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
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛