VBA Intraday Ticks, Dynamic array

thomas.kursawe

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.

Alex Putkov.1

Hi @thomas.kursawe

Use the RHistory API available with Eikon Excel.

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

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