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

Options

...rise)

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!

Tagged:

Best Answer

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.