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

question

Upvotes
Accepted
7 4 5 8

How can I get the name of the contract that belongs to ESc1 at the various points in time?

Hi

When I get a timeseries such as ESc1, I would now get the data for the March contract and then in a few weeks it would move to June. How can I get that information from the .NET API?

I use NDA_Raw to get all the timeseries data.

Thanks

Jerome

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api.net
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.

@jerome

Hi,

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

@jerome

Hi,

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

Upvotes
Accepted
39.4k 77 11 27

I see. Well, you can easily retrieve all the expiry dates as of today. But I don't believe this data is available through Eikon historically. It's not the matter of which API you use. I don't believe this history is available in Eikon at all. Again I suggest you verify this and get an authoritative answer from the Helpdesk. If this history exists in Eikon and the Helpdesk can show you how to retrieve it into Excel, then I can help you with retrieving it programmatically.

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.

Upvotes
39.4k 77 11 27

I don't believe this info is available historically from Eikon. You may want to verify this with Refinitiv Helpdesk by asking them if there's a way to retrieve the history of contract expiry dates or contract reference for continuation future RICs into Excel or to view it in Eikon application.
If I'm correct and this data is not available in Eikon historically, you can fairly easily calculate the expiry date yourself from the trade date, since the rollover schedule for these futures is predictable.

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.

Upvotes
7 4 5 8

Thanks Alex. I am dealing with 80+ different futures contracts on 17 exchanges. Each of them has a different roll mechanism. Is there a way to get all the expiry dates for the various E-mini Chains? Is that possible in C# or should that be done in Python?

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.

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.