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

Find more posts tagged with

python

eikon

workspace

eikon-com-api

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Alex Putkov.1

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.

All comments

Alex Putkov.1

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!

EXPLORE OUR SITES