For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
RHistoryAPI
Hello,
I am using RHistoryAPI to retrieve historical data. I tried to use Reuters Query RHistoryAPI from a VBA class module .xlam project but it is not working. I did not have error but the result table was empty. I tried the same thing in a Microsoft Excel Object(like the example of the tutorial) and it is working.
Is the RHistoryAPI only working with Microsoft Excel Objects ?
Thank you for your help.
Best regards
I don't see any reason why you couldn't use RHistory API in an xla or an xlam. Do you want to post your project here for me to take a look? It would be best if you strip it to bare bones required to reproduce the issue you experienced. Q&A forums support limited types of attachments, so put your xlam file into a zip archive before posting it.
Thank you for your reply. I had another problem. I used local variable to save request result. With global variable it works perfectly!