How to get historical future data with python api?

I would like to get historical price, open interest and volume from Eurex futures, however, ek.get_timeseries() is not working and e.get_data() gives me only the values of the day, altough I have specified sdate and edate:

df, err = ek.get_data('VOWG_p2Q1',

['CF_DATE', 'CF_CLOSE','SETTLE'],

{'SDate': 0, 'EDate': -15, 'Frq':'D' })

How can I retrieve the data?

Find more posts tagged with

python

eikon

futures

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

{'SDate': 0, 'EDate': -15, 'Frq':'D' } should be replaced by {'SDate': -15, 'EDate': 0, 'Frq':'D' }

And CLOSE field is a relatime data. You have to request TR.CLOSEPRICE to get historical.

But it seems that historical price for Eurex futures isn't available.
I requested timeserie in EXCEL and I got NULL value :

All comments

{'SDate': 0, 'EDate': -15, 'Frq':'D' } should be replaced by {'SDate': -15, 'EDate': 0, 'Frq':'D' }

And CLOSE field is a relatime data. You have to request TR.CLOSEPRICE to get historical.

But it seems that historical price for Eurex futures isn't available.
I requested timeserie in EXCEL and I got NULL value :

m.bunkowski

Hi @laturnus

To get the timeseries of settlement prices please try this:

ek.get_data('VOWG_p2Q1',['TR.SETTLEMENTPRICE.date','TR.SETTLEMENTPRICE'],{'SDate':-15, 'EDate':0, 'Frq':'D' })

EXPLORE OUR SITES