question

Upvotes
Accepted
13 6 4 12

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-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-api
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
Upvote
Accepted
4.6k 27 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 512.0 KiB each and 1.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.

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.