question

Upvotes
Accepted
thomas.kursawe avatar image
1 ●1 ●1 ●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 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
Alex Putkov.1 avatar image
39.4k ●78 ●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.thomsonreuters.com/eikon-apis/com-apis-use-microsoft-office/learning?content=3563&type=learning_material_item

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.