question

Upvotes
Accepted
36 0 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 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvote
Accepted
39.2k 75 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.refinitiv.com/en/api-catalog/eikon/com-apis-for-use-in-microsoft-office/tutorials#tutorial-9-time-series-history-r-history-api

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 5.0 MiB each and 10.0 MiB total.

Perfect- thank you Alex!

Click below to post an Idea Post Idea