question

Upvotes
Accepted
0 0 0 1

My client wrote: I would like to fix an issue with the refresh data button in Excel. I have some tickers and I would like to know a to download the historical data directly using vba code. Could please send a template or explain to me how to do that?

eikoneikon-com-api
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.

Upvotes
Accepted
39.4k 77 11 27

Hi @aurelia.casella,

Instead of the tutorial suggested by Zhenya Kovalyov I would recommend this one assuming the client is interested in price history. AdxRtHistory that the tutorial suggested by Zhenya is about is a legacy object and should be avoided.

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

If the client is interested in other types of history such as dividend history, earnings history and so on and so forth, I recommend the user to look at the following tutorial:

https://developers.thomsonreuters.com/eikon-apis/com-apis-use-microsoft-office/learning?content=5760&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.

Upvotes
4.6k 26 7 22
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.