Where can i find the date of Forward price?

jwlee08
jwlee08
in Eikon Data APIs

Hi,

I am struggling with finding dates of Forward Price in Eikon.

i want a list of the name of Forward price month.

eg) Nov, Dec, Jan ...

please kindly let me know ;)

Tagged:

Best Answer

  • aramyan.h
    aramyan.h
    Answer ✓

    Hi @jwlee08 ,


    The RIC (CMZNc1) is a continuation RIC and it doesn't have an expiry date as such as it rolls automatically at or before the expiry of the individual underlying contract. You can request the prices for that RIC in the following way:

    df  = ek.get_timeseries('CMZNc1')
    df

    screenshot-2023-11-16-at-100236.png

    If you wish to get individual contract RICs along with the expired dates you can expand the chain containing the individual contracts using the following code:

    df, err =  ek.get_data('0#CMZN:', ['CF_NAME', 'EXPIR_DATE'])
    df

    screenshot-2023-11-16-at-100346.png

    Please note that the chain contains only the active contracts. For already expired contracts you would need to reconstruct the RICs following the RIC construction Rules. More on that, including a Python object for reconstructing one can be found in this article.


    Hope this helps.


    Best regards,

    Haykaz

Answers

  • aramyan.h
    aramyan.h

    Hi @jwlee08 ,


    Could you please kindly elaborate a bit on your request, particularly which API you are trying to use, what is the RIC and if you are getting an error please post it here as well. That will help us to investigate this further.


    Best regards,

    Haykaz

  • jwlee08
    jwlee08

    i was using 'REFINITIV EIKON DATA API FOR PYTHON'

    and the RIC was 'CMZNc1' and i got the Expire_date thank you for ur help!

Categories