question

Upvotes
Accepted
thomas.kursawe avatar image
1 ●1 ●0 ●2

VBA Intraday Ticks, Dynamic array

Hi, good morning
how can I load all ticks of an underlying between two given times into an dynamic array in VBA?
For example: I need all EUR=EBS ticks for a given timeframe. I dont want to display them in excel as I a) dont have the empty space in my excel sheet and b) it's too timeconsuming with an unneeded display output, but I want to proceed with the loaded data within my VBA code.

eikoneikon-com-apihistorical
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

Upvotes
Accepted
Alex Putkov.1 avatar image
39.2k ●75 ●11 ●27

Hi @thomas.kursawe

Use the RHistory API available with Eikon Excel.

Here's the link to the tutorial on this portal:

https://developers.refinitiv.com/en/api-catalog/eikon/com-apis-for-use-in-microsoft-office/tutorials#tutorial-9-time-series-history-r-history-api

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.

Click below to post an Idea Post Idea