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

grenpark06

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.

Find more posts tagged with

eikon

vba

eikon-com-api

#technology

#product

Accepted answers

jonathan.legrand

Hi @grenpark06,

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?

All comments

jonathan.legrand

Hi @grenpark06,

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?

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.

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?

EXPLORE OUR SITES