Get timeseries for SPX in python

bendik.ronning

Problem: I get this error: "eikon.eikonError.EikonError: Error code 500 | Backend error. 500 Internal Server Error"

When i limit to only 200 stock I get only like 20 days... Loops dont work either

My code:

import eikon as ek

ek.set_app_id('APP ID')



dfSPX, e = ek.get_data(["0#.SPX"],["X_RIX_NAME"])
Tickere = dfSPX["Instrument"].tolist()

df = ek.get_timeseries(Tickere, fields=["Close"],start_date="2018-01-01",end_date="2019-12-27")

m.bunkowski

Hi @bendik.ronning

You can try another way:

ek.get_data('0#.SPX','TR.PRICECLOSE', {'SDate':'2018-01-01', 'EDate':'2019-12-27'})

chavalit-jintamalit

Hi @bendik.ronning

Please review this document.

You can split the big request into a smaller request and slow down the number of request per second.

bendik.ronning

https://community.developers.refinitiv.com/discussion/comment/43356#Comment_43356

How do I also get the timestamp?

m.bunkowski

https://community.developers.refinitiv.com/discussion/comment/43357#Comment_43357

Hi @bendik.ronning

You need to add an extra field with suffix ".date". Example below.

ek.get_data('0#.SPX',['TR.PRICECLOSE.date','TR.PRICECLOSE'], {'SDate':'2018-01-01', 'EDate':'2019-12-27'})