Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
39 3 2 11

Unable to retrieve data using get_timeseries()

Hi,


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

@RHistory("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")
            )
python apiexcel
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.

1 Answer

· Write an Answer
Upvotes
Accepted
6.9k 21 3 6

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


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 (31.9 KiB)
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.

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?

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] 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'

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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