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
1
●1 ●1 ●1
What is the Best way to get a Stock future's RIC code if you have the exchange ticker symbol and maturity date
Hello @james.dennelly
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar 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
39.4k
●77 ●11 ●27
See page RULES5, which you can view in a Quote app in Eikon, and which describes RIC construction rules for futures. E.g. RIC ESZ1, which currently represents Dec 2021 contract on E-mini S&P 500 consists of RIC root 'ES', which is typically the same as the exchange ticker for the future, + 'Z' for December + '1' for 2021. For a table of expiry month codes see page RULES2.
Alternatively you can use Search service on RDP. The following call using RDP Library for Python currently returns 'ESZ1':
rdp.search(view=rdp.SearchViews.EquityDerivativeQuotes, filter = "RicRoot eq 'ES' and ExpiryDate eq 2021-12-17 and RCSAssetClass eq 'FUT'", select = "RIC")
