For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
thseol avatar image
1 ●0 ●0 ●0

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

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.


eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

Upvote
Accepted
umer.nalla avatar image
25.1k ●87 ●11 ●24

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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

azzopardic avatar image azzopardic

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 avatar image umer.nalla azzopardic
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.


Upvote
pimchaya.wongrukun01 avatar image
9.6k ●10 ●7 ●7

Hello @thseol

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.