RHistoryAPI

h.k
h.k
in Eikon Data APIs

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

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1
    Answer ✓

    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.

Answers

  • h.k
    h.k

    Thank you for your reply. I had another problem. I used local variable to save request result. With global variable it works perfectly!

Categories