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.

Find more posts tagged with

eikon

historical

eikon-com-api

Accepted answers

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

All comments

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

Quick Links