Contract Expiry

Hello,

Why isn't the field "EXPIR_DATE" consistently available for futures contracts (expired or not)?

The following gives the field value only for the active (non-expired) contract:

dfe, _ = ek.get_data(['MZNH20^2', 'MZNH20', 'MZNH21'], 'EXPIR_DATE')

InstrumentEXPIR_DATE0MZNH20^2<NA>1MZNH20<NA>2MZNH212021-03-17

Find more posts tagged with

python

eikon

commodities

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Jirapongse

@r0k3

As mentioned by my colleague, those RICs are expired or invalid so their data may not be available via the get_data method. You need to contact Refinitiv Content Helpdesk to confirm it.

However, I have tried to use other APIs to retrieve the expiration date for MZNH20^2 and found that DSS REST API can return this information.

For more information about DSS REST API, please refer to this page.

All comments

chavalit-jintamalit

Hi @r0k3

Seems that MZNH20^2 and MZNH20 are not valid RIC.

If you still have further questions regarding content.

Please contact Refinitiv Content Helpdesk at https://my.refinitiv.com

Jirapongse

@r0k3

As mentioned by my colleague, those RICs are expired or invalid so their data may not be available via the get_data method. You need to contact Refinitiv Content Helpdesk to confirm it.

However, I have tried to use other APIs to retrieve the expiration date for MZNH20^2 and found that DSS REST API can return this information.

For more information about DSS REST API, please refer to this page.

r0k3

Expired or invalid

Are the symbols of expired contracts "invalid". Why?

I have put both the original symbol (MZNH20) and the expired version of it (MZNH20^2) so we can see the difference.

Why shouldn't one be able to get data items for a contract that was live a day ago but not today (after expiry) ? Although you show now you can get it but from a different API.

I am confused. Not sure what to do - ask my company to buy a new API access?

EXPLORE OUR SITES