RHistoryAPI

Question

Question by h.k · Mar 11, 2019 at 11:07 AM · RHistoryAPI

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

0

10 |1500 characters needed characters left characters exceeded

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

Answer 1 · 2019-03-11T11:22:34Z

REFINITIV

Best Answer

Answer by Alex Putkov. · Mar 11, 2019 at 11:22 AM

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.

0 · Share

10 |1500 characters needed characters left characters exceeded

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

Answer 2 · 2019-03-19T12:14:56Z

Answer by h.k · Mar 19, 2019 at 12:14 PM

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

0 · Share

10 |1500 characters needed characters left characters exceeded

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

RHistoryAPI

2 Replies

Watch this question

Related Questions