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
vanderkroon avatar image
42 ●9 ●6 ●13

What is the RIC for EMINI S&P?

I am trying to look at the EMINI S&P. I can find it in "https://emea1.apps.cp.thomsonreuters.com/web/Explorer/Default.aspx?s=EScv1&st=RIC"

as ESc1 or ESc2. But how does this translate to a RIC code?

I would like to retrieve data for it using python code such as:

mydata = ek.get_timeseries([tickersymbol], fields=['OPEN', 'CLOSE', 'HIGH', 'LOW', 'VOLUME','TR.FundSFFactor'],
                                 start_date=startdate, end_date=enddate)

Where 'ticker symbol' = de RIC code for the Emini S&P500 future.

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

pimchaya.wongrukun01 avatar image   pimchaya.wongrukun01

Hello @vanderkroon

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

wasin.w avatar image   wasin.w

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

Thanks,


AHS

2 Answers

· Write an Answer
Upvotes
Accepted
jason.ramchandani01 avatar image
10.2k ●18 ●6 ●9

Hi @vanderkroon - the code ESc1 is the RIC for the continuous ES (S&P500 e-mini future) - there are 4 expiries per year (Dec, Mar, Jun, Sept) - so rather than having to know which future is the front month eg ESU0, ESH0 etc you can just use ESc1 which will always provide you with the current front month contract, similarly ESc2 will provide you with the second front month etc.

We also provide another variant EScv1, EScv2 etc and this provide you with the front month contract where the volume is largest - so say the second front month contract is trading more volume than the first front month BEFORE expiry of the first front month - the larger volume contract with be returned ie the second front month.

Please try the following code - note I have removed the field 'TR.FundSFFactor' - which is not a timeseries model field - in fact its not relevant for futures contracts at all. You can see what fields are applicable for an instrument by using the Data Item Browser (type DIB into Eikon search bar)

mydata = ek.get_timeseries('ESc1', fields=['OPEN', 'CLOSE', 'HIGH', 'LOW', 'VOLUME']) mydata

I hope this can help

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
Agnes Terada avatar image
318 ●1 ●0 ●4

Hi @vanderkroon

If you want to pull all the fields, you could use:

data = ek.get_timeseries(["ESc1"], start_date = "2020-02-20", end_date = "2020-02-27")

data


esc1.jpg (93.1 KiB)
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.