Docu for RHistoryAPI
Hi! Where can get a documentation for the RHistoryAPI using VBA/Excel? Without that new code is hard to develop
Best Answer
-
Hi @thomas.kursawe,
Thanks for the feedback. We are uploading a more thorough documentation on the portal now. It should be available in the Documentation tab for COM APIs for use in MS Office tomorrow. This documentation will contain description for all classes and interfaces available through RHistory API together with their properties, methods and events.
https://developers.thomsonreuters.com/eikon-apis/com-apis-use-microsoft-office/docs
In the meantime I can answer the specific questions you raised here.
- what string parameter to use when creating a query (HistoryManager.CreateQuery)Alex: You're referring to custom classes implemented in the example. These custom classes demonstrate one way of using RHistory API, but the classes themselves are not part of the API, and therefore are not documented. You can create as many of these or similar classes of your own as you wish. Before you start looking at the custom classes in the example, I suggest you look at the tutorial I mentioned in my previous response. I may be wrong, but I have a very strong impression that you downloaded the example and right away tried to follow the code in it, but that you didn't read the tutorial. Perhaps you didn't even realize that there is tutorial text on the page underneath the embedded video? The tutorial provides a simple example of RHistory API usage. The code used in the tutorial is also available in the example spreadsheet you downloaded. This code is in Sheet01(Tutorial 9 - RHistoryAPI). It's a much simpler example than the one in the next module Sheet02(Tutorial 9 - RHistoryAPI Class), which uses custom classes.
- what happens when subscribing a query and how to the result. I only see that the query is subscribed and then I see an output on the function "DisplayArray" using a Variable a_historyTable. I can't see where this table gets the data.
Alex: All Eikon COM APIs provide asynchronous data retrieval. After the query is subscribed one of the following three events will be raised: OnImage, OnUpdate or OnError. The example you've been looking at implements event handlers for all 3 events. The data retrieved is delivered as a parameter into OnImage or OnUpdate event handlers. These two events then call custom DisplayArray function implemented in the example. Again, before you delve into more complex example, I strongly suggest you follow the basic tutorial.
0
Answers
-
Here's the link to the tutorial on this portal:
I hope you find it helpful.
0 -
@Alex Putkov
Hi Alexthis file I already worked with. And when working with that there are so many open questions, how to use whioch functions, which parameters, which syntax
For example
- what string parameter to use when creating a query (HistoryManager.CreateQuery)
- what happens when subscribing a query and how to the result. I only see that the query is subscribed and then I see an output on the function "DisplayArray" using a Variable a_historyTable. I can't see where this table gets the data.
Therefore I wasn't looking for an example sheet but for a docu which describes functionality, syntax, propertys and conditions for the used parameters and so on.Where can I find this docu?
Thomas
0 -
RHistory Reference Guide is now available from the Documentation tab for COM APIs for use in MS Office:
https://developers.thomsonreuters.com/eikon-apis/com-apis-use-microsoft-office/docs
0
Categories
- All Categories
- 6 AHS
- 38 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 中文论坛