*URGENT* (due to sanction in Russia): Unable to run eikon package in .bat file (Windows 10 Enterpris

jiacheng.oh

Hi,

I am using Anaconda with the respective eikon package installed offline, following the link: Offline Installation for Eikon Data APIs (Python) | Refinitiv Developers. All files are copied over EXCEPT "setuptools-61.2.0-py3-none-any" due to security restriction.

Nonetheless i was able to install, and with "pip show eikon", I see:

______________________________________________________________________________

Name: eikon

Version: 1.1.14

Summary: Python package for retrieving Eikon data.

Home-page: https://developers.refinitiv.com/eikon-apis/eikon-data-api

Author: REFINITIV

Author-email:

License: Apache 2.0

Location: c:\users\ga2ohji\anaconda3\lib\site-packages

Requires: certifi, rfc3986, datetime, idna, httpx, websocket-client, h2, pandas, nest-asyncio, requests, python-dateutil, appdirs, numpy, chardet, deprecation

Required-by:

______________________________________________________________________________

I was able to run on Jupyter notebook ("For_RUB_email") itself with the required email:

import eikon as ek

ek.set_app_key('XXXXXXXXX')

import win32com.client

df, err = ek.get_data(['TRADRUBSOFRA'], ['ROW80_3', 'ROW80_4'])

df

df.to_excel(r'P:\Singapur\Data\CM_BUC\For_Ruble.xlsx', index=True, header=True)

outlook = win32com.client.Dispatch('outlook.application')

mail = outlook.CreateItem(0)

mail.To = 'XXXXX'

mail.Subject = 'Hourly Ruble Prices from Reuters'

mail.HTMLBody = '<h3>This is HTML Body</h3>'

mail.Body = "This is the normal body"

mail.Attachments.Add('XXXXXXXX')

mail.CC = 'XXXXXXXXX'

mail.Send()

I then generate "For_RUB_email.py" from above code. However, when it was run using a .bat file, the code fails to run.

My .bat file is:

"C:\Users\GA2ohji\Anaconda3\python.exe" "C:\Users\GA2ohji\Desktop\For_RUB_email.py"

All eikon files are parked at C:\Users\GA2ohji\Anaconda3\pkgs.

Is this due to missing "setuptools-61.2.0-py3-none-any"?

I'm using:

Python 3.8.5 (default, Sep  3 2020, 21:29:08) [MSC v.1916 64 bit (AMD64)]

Appreciate the urgent assistance!

Jirapongse

@jiacheng.oh

It may relate to this question on stack overflow.

You may need to run the bat file in the anaconda prompt.

jonathan.legrand

Hi @jiacheng.oh ,

Do you get an error message when your code fails? Or does it file to even trigger all together?