Eikon API / Spyder - Port unassigned

JeanFrancois.Courtin
JeanFrancois.Courtin
in Eikon Data APIs

Hi,

I am experiencing an issue running Python (3.9) Script calling Eikon API (1.1.16) under Anaconda/Spyder IDE environment (4.2.5) under Windows. Below error message is issued with no port number allocated>

Error message :

2023-07-21 15:52:00,752 P[1928] [MainThread 18932] Error on handshake url http://127.0.0.1:None/api/handshake : UnsupportedProtocol("The request to ':///' is missing either an 'http://' or 'https://' protocol.")

2023-07-21 15:52:00,752 P[1928] [MainThread 18932] Error on handshake url http://127.0.0.1:None/api/handshake : UnsupportedProtocol("The request to ':///' is missing either an 'http://' or 'https://' protocol.")

2023-07-21 15:52:00,752 P[1928] [MainThread 18932] Port number was not identified, cannot send any request

Eikon API is running.Same piece of code is working under EIKON CODEBOOK and test on browser are showing that port 900 and 9060 are available.

Seems SPYDER is not able to assigned port number when running script?


Code sample:

#coding:utf-8

import eikon as ek

Cme_Code=['CZ3']

ek.set_app_key("APPKEY")

df=ek.get_timeseries(items,'CLOSE',interval='daily',start_date='2020-jan-01',end_date='2023-mar-30')


Any idea what is possible resolution or any specific setting to check with Spyder ?


Tagged:

Best Answer

  • Jirapongse
    Jirapongse
    Answer ✓

    @JeanFrancois.Courtin

    Thank you for reaching out to us.

    First, we need to verify that the Eikon Proxy API is running properly.

    You can refer to the Eikon Data API and Refinitiv Data Library - Troubleshooting article to verify if the Eikon Proxy API is running properly.

    You can also use a web browser to access the following URL:

    With the second URL, you may try different TCP ports, such as 9000, 9002, and so on.1690168543448.png You can use the following Powershell command to check the http://127.0.0.1:9060/api/handshake endpoint.

    (Invoke-WebRequest -Method POST -Body (@{"AppKey"="<app key>";"AppScope"="trapi";"ApiVersion"="1";"LibraryName"="RDP Python Library";"LibraryVersion"="1.1.7"}|ConvertTo-Json) -Uri http://127.0.0.1:9060/api/handshake -ContentType application/json)

    1690168801830.png

    Please change the <app key> to your application key.

    If the Eikon Proxy API is running properly, we need to verify the Python environment by using the following commands.

    1. python --version
    2. pip list


Answers

  • JeanFrancois.Courtin
    JeanFrancois.Courtin

    @Jirapongse

    Eikon API is running properly after checking all troubleshooting checklist items with Eikonhelpdesk.

    python version is 3.8.8

    conda list of environment used :

    # Name Version Build Channel

    _ipyw_jlab_nb_ext_conf 0.1.0 py38_0

    alabaster 0.7.12 pyhd3eb1b0_0

    anaconda-client 1.7.2 py38_0

    anaconda-project 0.9.1 pyhd3eb1b0_1

    anyio 2.2.0 py38haa95532_2

    appdirs 1.4.4 py_0

    argh 0.26.2 py38_0

    argon2-cffi 20.1.0 py38h2bbff1b_1

    asn1crypto 1.4.0 py_0

    astroid 2.5 py38haa95532_1

    astropy 4.2.1 py38h2bbff1b_1

    async_generator 1.10 pyhd3eb1b0_0

    atomicwrites 1.4.0 py_0

    attrs 20.3.0 pyhd3eb1b0_0

    autopep8 1.5.6 pyhd3eb1b0_0

    babel 2.9.0 pyhd3eb1b0_0

    backcall 0.2.0 pyhd3eb1b0_0

    backports 1.0 pyhd3eb1b0_2

    backports.functools_lru_cache 1.6.4 pyhd3eb1b0_0

    backports.shutil_get_terminal_size 1.0.0 pyhd3eb1b0_3

    backports.tempfile 1.0 pyhd3eb1b0_1

    backports.weakref 1.0.post1 py_1

    bcrypt 3.2.0 py38he774522_0

    beautifulsoup4 4.9.3 pyha847dfd_0

    bitarray 1.9.2 py38h2bbff1b_1

    bkcharts 0.2 py38_0

    black 19.10b0 py_0

    blas 1.0 mkl

    bleach 3.3.0 pyhd3eb1b0_0

    blosc 1.21.0 h19a0ad4_0

    bokeh 2.3.2 py38haa95532_0

    boto 2.49.0 py38_0

    bottleneck 1.3.2 py38h2a96729_1

    brotli 1.0.9 ha925a31_2

    brotlipy 0.7.0 py38h2bbff1b_1003

    bzip2 1.0.8 he774522_0

    ca-certificates 2023.7.22 h56e8100_0 conda-forge

    camelot-py 0.9.0 pyhd8ed1ab_0 conda-forge

    certifi 2023.7.22 py38haa95532_0

    cffi 1.14.5 py38hcd4344a_0

    chardet 4.0.0 py38haa95532_1003

    charls 2.2.0 h6c2663c_0

    charset-normalizer 3.2.0 pyhd8ed1ab_0 conda-forge

    click 7.1.2 pyhd3eb1b0_0

    cloudpickle 1.6.0 py_0

    clyent 1.2.2 py38_1

    colorama 0.4.4 pyhd3eb1b0_0

    comtypes 1.1.9 py38haa95532_1002

    conda-content-trust 0.1.1 pyhd3eb1b0_0

    conda-package-handling 1.7.3 py38h8cc25b3_1

    conda-repo-cli 1.0.4 pyhd3eb1b0_0

    conda-verify 3.4.2 py_1

    contextlib2 0.6.0.post1 py_0

    cryptography 3.4.7 py38h71e12ea_0

    curl 7.71.1 h2a8f88b_1

    cycler 0.10.0 py38_0

    cython 0.29.23 py38hd77b12b_0

    cytoolz 0.11.0 py38he774522_0

    dask 2021.4.0 pyhd3eb1b0_0

    dask-core 2021.4.0 pyhd3eb1b0_0

    decorator 5.0.6 pyhd3eb1b0_0

    defusedxml 0.7.1 pyhd3eb1b0_0

    deprecation 2.1.0 pyh9f0ad1d_0 conda-forge

    diff-match-patch 20200713 py_0

    distributed 2021.4.0 py38haa95532_0

    docutils 0.17 py38haa95532_1

    eikon 1.1.16 pyhd8ed1ab_0 conda-forge

    entrypoints 0.3 py38_0

    et_xmlfile 1.0.1 py_1001

    fastcache 1.1.0 py38he774522_0

    filelock 3.0.12 pyhd3eb1b0_1

    flake8 3.9.0 pyhd3eb1b0_0

    flask 1.1.2 pyhd3eb1b0_0

    fpdf 1.7.2 pyhd8ed1ab_0 conda-forge

    freetype 2.10.4 hd328e21_0

    fsspec 0.9.0 pyhd3eb1b0_0

    future 0.18.2 py38_1

    get_terminal_size 1.0.0 h38e98db_0

    gevent 21.1.2 py38h2bbff1b_1

    ghostscript 9.54.0 h0e60522_2 conda-forge

    giflib 5.2.1 h62dcd97_0

    glob2 0.7 pyhd3eb1b0_0

    greenlet 1.0.0 py38hd77b12b_2

    h11 0.12.0 pyhd8ed1ab_0 conda-forge

    h2 3.2.0 py38h32f6830_1 conda-forge

    h5py 2.10.0 py38h5e291fa_0

    hdf5 1.10.4 h7ebc959_0

    heapdict 1.0.1 py_0

    hpack 3.0.0 py_0 conda-forge

    html5lib 1.1 py_0

    httpcore 0.13.4 pyhd8ed1ab_0 conda-forge

    httpx 0.20.0 py38haa244fe_1 conda-forge

    hyperframe 5.2.0 py_0 conda-forge

    icc_rt 2019.0.0 h0cc432a_1

    icu 58.2 ha925a31_3

    idna 2.10 pyhd3eb1b0_0

    imagecodecs 2021.3.31 py38h5da4933_0

    imageio 2.9.0 pyhd3eb1b0_0

    imagesize 1.2.0 pyhd3eb1b0_0

    importlib-metadata 3.10.0 py38haa95532_0

    importlib_metadata 3.10.0 hd3eb1b0_0

    iniconfig 1.1.1 pyhd3eb1b0_0

    intel-openmp 2021.2.0 haa95532_616

    intervaltree 3.1.0 py_0

    ipykernel 5.3.4 py38h5ca1d4c_0

    ipython 7.22.0 py38hd4e2768_0

    ipython_genutils 0.2.0 pyhd3eb1b0_1

    ipywidgets 7.6.3 pyhd3eb1b0_1

    isort 5.8.0 pyhd3eb1b0_0

    itsdangerous 1.1.0 pyhd3eb1b0_0

    jdcal 1.4.1 py_0

    jedi 0.17.2 py38haa95532_1

    jinja2 2.11.3 pyhd3eb1b0_0

    joblib 1.0.1 pyhd3eb1b0_0

    jpeg 9b hb83a4c4_2

    json5 0.9.5 py_0

    jsonschema 3.2.0 py_2

    jupyter 1.0.0 py38_7

    jupyter-packaging 0.7.12 pyhd3eb1b0_0

    jupyter_client 6.1.12 pyhd3eb1b0_0

    jupyter_console 6.4.0 pyhd3eb1b0_0

    jupyter_core 4.7.1 py38haa95532_0

    jupyter_server 1.4.1 py38haa95532_0

    jupyterlab 3.0.14 pyhd3eb1b0_1

    jupyterlab_pygments 0.1.2 py_0

    jupyterlab_server 2.4.0 pyhd3eb1b0_0

    jupyterlab_widgets 1.0.0 pyhd3eb1b0_1

    keyring 22.3.0 py38haa95532_0

    kiwisolver 1.3.1 py38hd77b12b_0

    krb5 1.18.2 hc04afaa_0

    lazy-object-proxy 1.6.0 py38h2bbff1b_0

    lcms2 2.12 h83e58a3_0

    lerc 2.2.1 hd77b12b_0

    libaec 1.0.4 h33f27b4_1

    libarchive 3.4.2 h5e25573_0

    libcurl 7.71.1 h2a8f88b_1

    libdeflate 1.7 h2bbff1b_5

    libiconv 1.15 h1df5818_7

    liblief 0.10.1 ha925a31_0

    libopencv 4.0.1 hbb9e17c_0

    libpng 1.6.37 h2a8f88b_0

    libsodium 1.0.18 h62dcd97_0

    libspatialindex 1.9.3 h6c2663c_0

    libssh2 1.9.0 h7a1dbc1_1

    libtiff 4.2.0 hd0e1b90_0

    libxml2 2.9.10 hb89e7f3_3

    libxslt 1.1.34 he774522_0

    libzopfli 1.0.3 ha925a31_0

    llvmlite 0.36.0 py38h34b8924_4

    locket 0.2.1 py38haa95532_1

    lxml 4.6.3 py38h9b66d53_0

    lz4-c 1.9.3 h2bbff1b_0

    lzo 2.10 he774522_2

    m2w64-gcc-libgfortran 5.3.0 6

    m2w64-gcc-libs 5.3.0 7

    m2w64-gcc-libs-core 5.3.0 7

    m2w64-gmp 6.1.0 2

    m2w64-libwinpthread-git 5.0.0.4634.697f757 2

    markupsafe 1.1.1 py38he774522_0

    matplotlib 3.3.4 py38haa95532_0

    matplotlib-base 3.3.4 py38h49ac443_0

    mccabe 0.6.1 py38_1

    menuinst 1.4.16 py38he774522_1

    mistune 0.8.4 py38he774522_1000

    mkl 2021.2.0 haa95532_296

    mkl-service 2.3.0 py38h2bbff1b_1

    mkl_fft 1.3.0 py38h277e83a_2

    mkl_random 1.2.1 py38hf11a4ad_2

    mock 4.0.3 pyhd3eb1b0_0

    more-itertools 8.7.0 pyhd3eb1b0_0

    mpmath 1.2.1 py38haa95532_0

    msgpack-python 1.0.2 py38h59b6b97_1

    msys2-conda-epoch 20160418 1

    multipledispatch 0.6.0 py38_0

    mypy_extensions 0.4.3 py38_0

    navigator-updater 0.2.1 py38_0

    nbclassic 0.2.6 pyhd3eb1b0_0

    nbclient 0.5.3 pyhd3eb1b0_0

    nbconvert 6.0.7 py38_0

    nbformat 5.1.3 pyhd3eb1b0_0

    nest-asyncio 1.5.1 pyhd3eb1b0_0

    networkx 2.5 py_0

    nltk 3.6.1 pyhd3eb1b0_0

    nose 1.3.7 pyhd3eb1b0_1006

    notebook 6.3.0 py38haa95532_0

    numba 0.53.1 py38hf11a4ad_0

    numexpr 2.7.3 py38hb80d3ca_1

    numpy 1.20.1 py38h34a8a5c_0

    numpy-base 1.20.1 py38haf7ebc8_0

    numpydoc 1.1.0 pyhd3eb1b0_1

    olefile 0.46 py_0

    opencv 4.0.1 py38h2a7c758_0

    openjpeg 2.3.0 h5ec785f_1

    openpyxl 3.0.7 pyhd3eb1b0_0

    openssl 1.1.1u h2bbff1b_0

    packaging 20.9 pyhd3eb1b0_0

    pandas 1.2.4 py38hd77b12b_0

    pandoc 2.12 haa95532_0

    pandocfilters 1.4.3 py38haa95532_1

    paramiko 2.7.2 py_0

    parso 0.7.0 py_0

    partd 1.2.0 pyhd3eb1b0_0

    path 15.1.2 py38haa95532_0

    path.py 12.5.0 0

    pathlib2 2.3.5 py38haa95532_2

    pathspec 0.7.0 py_0

    patsy 0.5.1 py38_0

    pdfminer.six 20220524 pyhd8ed1ab_0 conda-forge

    pep8 1.7.1 py38_0

    pexpect 4.8.0 pyhd3eb1b0_3

    pickleshare 0.7.5 pyhd3eb1b0_1003

    pillow 8.2.0 py38h4fa10fc_0

    pip 21.0.1 py38haa95532_0

    pkginfo 1.7.0 py38haa95532_0

    plotly 5.1.0 py_0 plotly

    pluggy 0.13.1 py38haa95532_0

    ply 3.11 py38_0

    prometheus_client 0.10.1 pyhd3eb1b0_0

    prompt-toolkit 3.0.17 pyh06a4308_0

    prompt_toolkit 3.0.17 hd3eb1b0_0

    psutil 5.8.0 py38h2bbff1b_1

    ptyprocess 0.7.0 pyhd3eb1b0_2

    py 1.10.0 pyhd3eb1b0_0

    py-lief 0.10.1 py38ha925a31_0

    py-opencv 4.0.1 py38he44ac1e_0

    pycodestyle 2.6.0 pyhd3eb1b0_0

    pycosat 0.6.3 py38h2bbff1b_0

    pycparser 2.20 py_2

    pycryptodome 3.15.0 py38h294d835_0 conda-forge

    pycurl 7.43.0.6 py38h7a1dbc1_0

    pydocstyle 6.0.0 pyhd3eb1b0_0

    pyerfa 1.7.3 py38h2bbff1b_0

    pyflakes 2.2.0 pyhd3eb1b0_0

    pygments 2.8.1 pyhd3eb1b0_0

    pylint 2.7.4 py38haa95532_1

    pyls-black 0.4.6 hd3eb1b0_0

    pyls-spyder 0.3.2 pyhd3eb1b0_0

    pynacl 1.4.0 py38h62dcd97_1

    pyodbc 4.0.30 py38ha925a31_0

    pyopenssl 20.0.1 pyhd3eb1b0_1

    pyparsing 2.4.7 pyhd3eb1b0_0

    pypdf2 2.11.1 pyhd8ed1ab_0 conda-forge

    pyqt 5.9.2 py38ha925a31_4

    pyreadline 2.1 py38_1

    pyrsistent 0.17.3 py38he774522_0

    pysocks 1.7.1 py38haa95532_0

    pytables 3.6.1 py38ha5be198_0

    pytest 6.2.3 py38haa95532_2

    python 3.8.8 hdbf39b2_5

    python-dateutil 2.8.1 pyhd3eb1b0_0

    python-jsonrpc-server 0.4.0 py_0

    python-language-server 0.36.2 pyhd3eb1b0_0

    python-libarchive-c 2.9 pyhd3eb1b0_1

    python_abi 3.8 2_cp38 conda-forge

    pytz 2021.1 pyhd3eb1b0_0

    pywavelets 1.1.1 py38he774522_2

    pywin32 227 py38he774522_1

    pywin32-ctypes 0.2.0 py38_1000

    pywinpty 0.5.7 py38_0

    pyyaml 5.4.1 py38h2bbff1b_1

    pyzmq 20.0.0 py38hd77b12b_1

    qdarkstyle 2.8.1 py_0

    qt 5.9.7 vc14h73c81de_0

    qtawesome 1.0.2 pyhd3eb1b0_0

    qtconsole 5.0.3 pyhd3eb1b0_0

    qtpy 1.9.0 py_0

    regex 2021.4.4 py38h2bbff1b_0

    requests 2.25.1 pyhd3eb1b0_0

    rfc3986 1.5.0 pyhd8ed1ab_0 conda-forge

    rope 0.18.0 py_0

    rtree 0.9.7 py38h2eaa2aa_1

    ruamel_yaml 0.15.100 py38h2bbff1b_0

    scikit-image 0.18.1 py38hf11a4ad_0

    scikit-learn 0.24.1 py38hf11a4ad_0

    scipy 1.6.2 py38h66253e8_1

    seaborn 0.11.1 pyhd3eb1b0_0

    send2trash 1.5.0 pyhd3eb1b0_1

    setuptools 52.0.0 py38haa95532_0

    simplegeneric 0.8.1 py38_2

    singledispatch 3.6.1 pyhd3eb1b0_1001

    sip 4.19.13 py38ha925a31_0

    six 1.15.0 py38haa95532_0

    snappy 1.1.8 h33f27b4_0

    sniffio 1.2.0 py38haa95532_1

    snowballstemmer 2.1.0 pyhd3eb1b0_0

    sortedcollections 2.1.0 pyhd3eb1b0_0

    sortedcontainers 2.3.0 pyhd3eb1b0_0

    soupsieve 2.2.1 pyhd3eb1b0_0

    sphinx 4.0.1 pyhd3eb1b0_0

    sphinxcontrib 1.0 py38_1

    sphinxcontrib-applehelp 1.0.2 pyhd3eb1b0_0

    sphinxcontrib-devhelp 1.0.2 pyhd3eb1b0_0

    sphinxcontrib-htmlhelp 1.0.3 pyhd3eb1b0_0

    sphinxcontrib-jsmath 1.0.1 pyhd3eb1b0_0

    sphinxcontrib-qthelp 1.0.3 pyhd3eb1b0_0

    sphinxcontrib-serializinghtml 1.1.4 pyhd3eb1b0_0

    sphinxcontrib-websupport 1.2.4 py_0

    spyder 4.2.5 py38haa95532_0

    spyder-kernels 1.10.2 py38haa95532_0

    sqlalchemy 1.4.7 py38h2bbff1b_0

    sqlite 3.35.4 h2bbff1b_0

    statsmodels 0.12.2 py38h2bbff1b_0

    sympy 1.8 py38haa95532_0

    tbb 2020.3 h74a9793_0

    tblib 1.7.0 py_0

    tenacity 8.2.2 py38haa95532_0

    terminado 0.9.4 py38haa95532_0

    testpath 0.4.4 pyhd3eb1b0_0

    textdistance 4.2.1 pyhd3eb1b0_0

    threadpoolctl 2.1.0 pyh5ca1d4c_0

    three-merge 0.1.1 pyhd3eb1b0_0

    tifffile 2021.4.8 pyhd3eb1b0_2

    tk 8.6.10 he774522_0

    toml 0.10.2 pyhd3eb1b0_0

    toolz 0.11.1 pyhd3eb1b0_0

    tornado 6.1 py38h2bbff1b_0

    tqdm 4.59.0 pyhd3eb1b0_1

    traitlets 5.0.5 pyhd3eb1b0_0

    typed-ast 1.4.2 py38h2bbff1b_1

    typing_extensions 3.7.4.3 pyha847dfd_0

    ujson 4.0.2 py38hd77b12b_0

    unicodecsv 0.14.1 py38_0

    urllib3 1.26.4 pyhd3eb1b0_0

    vc 14.2 h21ff451_1

    vs2015_runtime 14.27.29016 h5e58377_2

    watchdog 1.0.2 py38haa95532_1

    wcwidth 0.2.5 py_0

    webencodings 0.5.1 py38_1

    websocket-client 1.6.1 pyhd8ed1ab_0 conda-forge

    werkzeug 1.0.1 pyhd3eb1b0_0

    wheel 0.36.2 pyhd3eb1b0_0

    widgetsnbextension 3.5.1 py38_0

    win_inet_pton 1.1.0 py38haa95532_0

    win_unicode_console 0.5 py38_0

    wincertstore 0.2 py38_0

    winpty 0.4.3 4

    wrapt 1.12.1 py38he774522_1

    xlrd 2.0.1 pyhd3eb1b0_0

    xlsxwriter 1.3.8 pyhd3eb1b0_0

    xlwings 0.23.0 py38haa95532_0

    xlwt 1.3.0 py38_0

    xmltodict 0.12.0 py_0

    xz 5.2.5 h62dcd97_0

    yaml 0.2.5 he774522_0

    yapf 0.31.0 pyhd3eb1b0_0

    zeromq 4.3.3 ha925a31_3

    zfp 0.5.5 hd77b12b_6

    zict 2.0.0 pyhd3eb1b0_0

    zipp 3.4.1 pyhd3eb1b0_0

    zlib 1.2.11 h62dcd97_4

    zope 1.0 py38_1

    zope.event 4.5.0 py38_0

    zope.interface 5.3.0 py38h2bbff1b_0

    zstd 1.4.5 h04227a9_0


  • Jirapongse
    Jirapongse

    @JeanFrancois.Courtin

    Please also share the result from the web browser and powershell command.

    You can also use a web browser to access the following URL:

    With the second URL, you may try different TCP ports, such as 9000, 9002, and so on.1690168543448.pngYou can use the following Powershell command to check the http://127.0.0.1:9060/api/handshake endpoint.

    (Invoke-WebRequest -Method POST -Body (@{"AppKey"="<app key>";"AppScope"="trapi";"ApiVersion"="1";"LibraryName"="RDP Python Library";"LibraryVersion"="1.1.7"}|ConvertTo-Json) -Uri http://127.0.0.1:9060/api/handshake -ContentType application/json)
  • JeanFrancois.Courtin
    JeanFrancois.Courtin

    @Jirapongse

    Please see attached.

    api1.png

    api2.png


  • JeanFrancois.Courtin
    JeanFrancois.Courtin

    @Jirapongse

    Please see attached.

    windowspowershell.png

  • Jirapongse
    Jirapongse

    @JeanFrancois.Courtin

    The connection looks okay. It may relate to the Python enviornment.

    Can you create a new Python virtual enviornment and then install the Eikon Data API on the new environment?

    The followings are the dependencies for Eikon Data API 1.1.17.

        install_requires=[
            "httpx>=0.18.0",
            "nest_asyncio>=1.5.1",
            "datetime",
            "pandas>=1.0.0",
            "numpy>=1.11.0",
            "appdirs>=1.4.3",
            "python-dateutil",
            "websocket-client>=0.54.0,!=1.0.0",
            "deprecation",
            # requests-async requirements
            "certifi",
            "chardet==3.*",
            "h2==4.*",
            "idna==2.*",
            "rfc3986==1.*",
            "requests==2.*",
        ],

    According to the provided 'pip list', you are using chardet 4.0.0.

Categories