Automatically download Excel files

eikonuser
eikonuser Newcomer
in Eikon COM

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.

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

    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

Categories