question

Upvotes
Accepted
36 1 3 5

Time Series w/ AdxRtHistory (Multiple RICs)

Hello,

Following the tutorial and sample, I have a spreadsheet setup for time series data of one RIC at a time. I need to retrieve multiple RICs and have the time series data imported to my spreadsheet (side by side). I am not very familiar with Visual Basic (beyond using it for Excel) and am having trouble figuring out how to do this with the async nature of the process. Could you please provide a basic sample of how to achieve this?

Thank you!

Steven

eikoneikon-com-apiricstime-seriesexcel
icon clock
10 |1500

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

1 Answer

· Write an Answer
Upvote
Accepted
39.4k 77 11 27

Hi @StevenH,

I suggest instead of AdxRtHistory class you use RHistory API, where you can retrieve multiple instruments with a single request. Follow the link below for the tutorial.

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

The tutorial shows timeseries retrieval for a single instrument, but if you replace a single instrument string with a semicolon separated multi instrument string, it will happily retrieve multiple instruments. I.e. in the code snippet used in the tutorial replace

.InstrumentIDList = "AAPL.O"

with say

.InstrumentIDList = "AAPL.O;IBM.N;TRI.N;FB.O"
icon clock
10 |1500

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

Perfect- thank you Alex!

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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