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?
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
13
●6 ●4 ●12
Get settle price using get_timeseries
Hello @leiy,
Thank you for your participation in the forum.
Is the reply below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
-AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such. Thanks, AHS
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'})
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.
