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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
13 4 4 11

Get settle price using get_timeseries

I am using get_timeseries to collect the historical settle price of Futures. According to the collected observations and the talk with Reuters support team, the close price collected via get_timeseries is the last trade price of Futures, not the settle price. Is there an approach that i can retrieve the settle price of Futures historically?

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

Upvote
Accepted
4.6k 26 7 22

@leiy you can get some time series from the reference database. This gives you the settlement date for the last three months:

df, e = ek.get_data('EDc1', ['TR.SettlementPrice.date', 'TR.SettlementPrice.value'],{'SDate':'0D', 'EDate':'-3AM'})
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.

Thanks for the suggestion. Can you please explain a little on the meaning of the parameters SDate and Edate?

These are the parameters that define the time range for the timeseries request. For the format of these parameters see this thread.
You may also want to look at this tutorial that talks at length about generic metadata discovery, i.e. how you search for field names and parameters you can use in get_data method.

Click below to post an Idea Post Idea