Can I use Eikon API in Colab.research.google.com?

thseol

import eikon as ek

ek.set_app_key('826xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx')

2020-05-13 08:26:48,497 P[208] [MainThread 140443013973888] Error on checking port 9000 : HTTPConnectionPool(host='localhost', port=9000): Max retries exceeded with url: /api/v1/data (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x7fbb4620c978>: Failed to establish a new connection: [Errno 111] Connection refused',)) 2020-05-13 08:26:48,499 P[208] [MainThread 140443013973888] Error on checking port 36036 : HTTPConnectionPool(host='localhost', port=36036): Max retries exceeded with url: /api/v1/data (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x7fbb4620cdd8>: Failed to establish a new connection: [Errno 111] Connection refused',)) 2020-05-13 08:26:48,503 P[208] [MainThread 140443013973888] Error on handshake port None : Failed to parse: localhost:None 2020-05-13 08:26:48,510 P[208] [MainThread 140443013973888] Error: no proxy address identified. Check if Eikon Desktop or Eikon API Proxy is running. 2020-05-13 08:26:48,511 P[208] [MainThread 140443013973888] Port number was not identified, cannot send any request 2020-05-13 08:26:48,512 P[208] [MainThread 140443013973888] Port number was not identified. Check if Eikon Desktop or Eikon API Proxy is running.

---------------------------------------------------------------------------

EikonError                                Traceback (most recent call last)

<ipython-input-19-822979004c45> in <module>()
      1 import eikon as ek
      2 
----> 3 ek.set_app_key('826xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx')

---

2 frames

---

/usr/local/lib/python3.6/dist-packages/eikon/Profile.py in check_profile(self)
    369             # port number wasn't identified => raise EikonError exception
    370             self.logger.error('Port number was not identified.\nCheck if Eikon Desktop or Eikon API Proxy is running.')
--> 371             raise EikonError(-1, 'Port number was not identified. Check if Eikon Desktop or Eikon API Proxy is running.')
    372 
    373 

EikonError: Error code -1 | Port number was not identified. Check if Eikon Desktop or Eikon API Proxy is running.

umer.nalla

Hi @thseol

To use the Eikon Data API you have to have a locally running instance of Eikon or Refinitiv Workspace - i..e on the same PC as where you are executing any EDAPI script.

pimchaya.wongrukun01

Hello @thseol

Please see Eikon Data API(Python) Troubleshooting | Refinitiv which explains how to solve this problem thoroughly.

azzopardic

https://community.developers.refinitiv.com/discussion/comment/59814#Comment_59814

Hi @umer.nalla ,

I am currently having a similar issue. I am trying to run a Python notebook that connects to Eikon API and collects data on news stories. The connection is successful when the code is run on other IDEs such as JupyterLab and Azure Data Studio, but it seems the same doesn't happen when using Google Colab. I have a running Refinitiv Workspace every time I run the code, but the issue remains.

2021-12-06 07:32:58,900 P[583] [MainThread 140156271007616] Error: no proxy address identified.
Check if Eikon Desktop or Eikon API Proxy is running.
2021-12-06 07:32:58,905 P[583] [MainThread 140156271007616] Error on handshake url http://127.0.0.1:None/api/handshake : UnsupportedProtocol("Request URL is missing an 'http://'; or 'https://'; protocol.")
2021-12-06 07:32:58,908 P[583] [MainThread 140156271007616] Error on handshake url http://127.0.0.1:None/api/handshake : UnsupportedProtocol("Request URL is missing an 'http://'; or 'https://'; protocol.")
2021-12-06 07:32:58,911 P[583] [MainThread 140156271007616] Port number was not identified, cannot send any request

Is there something that I am missing please?

umer.nalla

https://community.developers.refinitiv.com/discussion/comment/88162#Comment_88162

Hi @azzopardic

When posting on the Forum it is recommended that you post a new Query when the subject matter has changed somewhat from the original.

This will make it more likely your query will be noticed by all our forum moderators and responded to in a more timely manner. It also helps other developers with similar issues to yourself.

In terms of your question, my understanding is that Google Colab is a cloud computing-based service - therefore the code is not executing locally on your PC - rather it is executing on a Google server somewhere.

I have not tried Azure Data Studio - but certainly, Jupyterlab notebooks normally execute locally.