...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!
