Unable to retrieve data using get_timeseries()

Hi,

I have my eikon terminal running and am able to get data in excel using:

@RHistory(&quot;EUR1MX1Y=TTKL",".Timestamp;.Close","START:07-Mar-2021 END:07-Mar-2022 INTERVAL:1MO",,"SORT:ASC TSREPEAT:NO")

However, using python, this returns no data

ek.set_app_key("xxxxxxxxxxxxxxxxxx")
x = ek.get_timeseries(
                ["EUR1MX1Y=TTKL"],
                fields=['CLOSE'],
                start_date="2021-10-01",
                end_date="2021-11-20")
            )

Find more posts tagged with

excel

python api

Accepted answers

[Deleted User]

Hi @sumit ,

Please try the following:

ek.get_timeseries(
    ["EUR1MX1Y=TTKL"],
    start_date="2021-10-01",
    end_date="2021-11-20")

for which I got:

Note also that there is no field 'CLOSE' for the instrument 'EUR1MX1Y=TTKL', so if you'd like to use the ek.get_data function, please use the Data Item Browser (DIB) to find the fields available for specific instruments. For more information on the DIB, please se this tutorial:

https://developers.refinitiv.com/en/video-catalog/data-item-browser

1646659647862.png

All comments

[Deleted User]

Hi @sumit ,

Please try the following:

ek.get_timeseries(
    ["EUR1MX1Y=TTKL"],
    start_date="2021-10-01",
    end_date="2021-11-20")

for which I got:

1646659647862.png

sumit

Hi,

I did try that but no luck. I wonder if its an issue with with my eikon api for python. I have eikon==1.1.13 installed. Have also reached out to support team on Eikon.

Should I reinstall my eikon api?

sumit

Just got some log files which I wanted to share...

Check if Eikon Desktop or Eikon API Proxy is running.

2022-03-07 13:55:32,484 P[47480] [MainThread 29852] Error on handshake url http://127.0.0.1:None/api/handshake : TypeError("send() got an unexpected keyword argument 'timeout'")

2022-03-07 13:55:32,484 P[47480] [MainThread 29852] Port number was not identified, cannot send any request

2022-03-07 13:55:32,485 P[47480] [MainThread 29852] HTTP request failed: send() got an unexpected keyword argument 'timeout'

sumit

This seems to resolve my issueL https://community.developers.refinitiv.com/questions/86163/error-no-proxy-address-identified-and-error-on-han.html

EXPLORE OUR SITES