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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
3 0 0 1

time series data for basis RICs

I tried both get_data and get_timeseries to fetch history of cash basis data(which works with the EXCEL API) but returns only NaNs when called via python.

May be I do not know the correct field via eikon python api, but different options available under "Data Item Browser" is not fetching the data.

tmpdf,err=ek.get_data('CORNMQEHNP-Z', ['TR.MIDPRICE.date','TR.MIDPRICE'], parameters={'SDate':'20170906','EDate':'20181001'})
ethanol_spot = ek.get_timeseries('CORNMQEHNP-Z', start_date=datetime.datetime(2016, 1, 1), end_date=datetime.datetime(2018, 12, 31), interval='daily', fields=['LAST_QUOTE.Close'])

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
434 1 2 2

Hi @amith.sinha you can try the following:

ek.get_timeseries('CORNMQEHNP-Z','VALUE','2016-01-01','2018-12-31')

icon clock
10 |1500

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

Click below to post an Idea Post Idea