Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon COM /
avatar image
Question by thomas.kursawe · Jan 23, 2017 at 06:36 AM · documentationRHistoryAPI

Docu for RHistoryAPI

Hi! Where can get a documentation for the RHistoryAPI using VBA/Excel? Without that new code is hard to develop

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

4 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov. · Jan 26, 2017 at 11:40 AM

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.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Answer by Alex Putkov. · Jan 23, 2017 at 06:20 PM

Hi @thomas.kursawe

Here's the link to the tutorial on this portal:

https://developers.thomsonreuters.com/eikon-apis/com-apis-use-microsoft-office/learning?content=3563&type=learning_material_item

I hope you find it helpful.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
Answer by thomas.kursawe · Jan 24, 2017 at 03:03 AM

@Alex Putkov
Hi Alex

this 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


Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Answer by Alex Putkov. · Jan 27, 2017 at 09:56 AM

Hi @thomas.kursawe

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

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
7 People are following this question.

Related Questions

where can i get the document for the field list for desktop api?

Can I find the default Eikon for Excel RHistory fields for an instrument using the COM APIs and VBA?

Is there a way to put a loop using the RHistoryAPI file example?

How can I run Rhistory in a loop?

COM RHistory API, Historical Series & Currency Conversion

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges