question

Upvotes
Accepted
1 1 1 2

Automatically download Excel files

Hi, I'd like to automatically download an Excel file exactly like the one you get by pressing the Excel button on the Economic Monitor page in Eikon at a specified time every day. The Eikon help desk suggested that VBA might be used for this - any suggestions are appreciated.

eikoneikon-com-apiexcel
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
39.2k 75 11 27

Hi @eikonuser,

I don't believe there's a way to automate download of Excel spreadsheets from Economic Monitor app. The closest you can get to this is construct a spreadsheet to retrieve the same data as displayed in Economic Monitor app. And then use VBA to snap the data at a given time and store it wherever you wish to store it, e.g. in another Excel workbook. For an example of a spreadsheet retrieving economic content see "Cross Economic Data" template in the Template library accessible through Templates button in Thomson Reuters ribbon.

Similarly you can snap the data you're interested in with help of a custom application using one of Eikon's market data retrieval APIs: currently available COM or .NET, or soon to be released Python library.

Best regards,

Alex

icon clock
10 |1500

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

Click below to post an Idea Post Idea