VBA Intraday Ticks, Dynamic array

Unknown

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