How to automatically download a list of domestic investment trusts using VBA

grenpark06
grenpark06
in Eikon COM

Hi,I want to automatically download a list of domestic investment trusts list everyday

using task scheduler.

I think if I could write Excel VBA(32bit) by setting the Thomson Reuters .dll as a reference.

Which dll and library should I use?

and where do I find how to write code(ex:tutorial or documentation)

Thank you.

Tagged:

Best Answer

  • jonathan.legrand
    jonathan.legrand
    Answer ✓

    Hi @Shue,

    I believe that the answer to your question can be found in the article "Migrating COM API calls to Python". If it is not, please do let me know by comenting on this answer below.

    With that said, as per that article, we do not suggest using VBA (32bit) because they will be deprecated in the future. Is writing a Python script to run via task scheduler an option?

Answers

  • grenpark06
    grenpark06

    Thanks for your response.

    I'd like to run it by python. so I got embeddable python.

    I think local batch.bat files should call that local test.py.


    <C/:Tmp/test.py>

    import refinitiv.dataplatform.eikon as ek

    import numpy as np

    ek.set_app_key('DEFAULT_CODE_BOOK_APP_KEY')

    data = ek.get_timeseries(rics='.N225',interval='daily',count=30)　←example

    np.savetxt('C/:Tmp/hoge.csv',data)


    but how do I get [refinitiv.dataplatform.eikon] library file?

  • grenpark06
    grenpark06

    Thanks for your response.

    I'd like to run it by python. so I got embeddable python.

    I think local batch.bat files should call that local test.py.


    <C/:Tmp/test.py>

    import refinitiv.dataplatform.eikon as ek

    import numpy as np

    ek.set_app_key('DEFAULT_CODE_BOOK_APP_KEY')

    data = ek.get_timeseries(rics='.N225',interval='daily',count=30)　←example

    np.savetxt('C/:Tmp/hoge.csv',data)


    but how do I get [refinitiv.dataplatform.eikon] library file?

Categories