I'm looking to get expiration dates for contracts that are resolved from futures chain RIC using HistoricalChainResolutionRequest call.
Thank you.
1
●0 ●1 ●2
Is there a way to determine expiration data for a historical future contract using DSS or TRTH REST API
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
32.2k
●40 ●11 ●20
Hello @ekhosid,
My understanding is that once you have resolved the chain you should have RICs of the future contracts. Next, you can run a search, either by specific RIC or by root RIC and a wild card, something like:
{
{protocol}}{
{host}}{
{api}}Search/FuturesAndOptionsSearch
{
"SearchRequest": {
"FileCodes": null,
"CurrencyCodes": null,
"ExchangeCodes": null,
"ExpirationDate": {
"@odata.type": "#ThomsonReuters.Dss.Api.Search.DateValueComparison",
"ComparisonOperator": "LessThanEquals",
"Value": "2016-12-31T00:00:00.000Z"
},
"IdentifierType": "Ric",
"Identifier": "ED*",
"PreferredIdentifierType": "Ric"
}
}
resulting in:
{
"@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Search.FuturesAndOptionsSearchResult)",
"value": [
{
"Identifier": "ED1tmH2^1",
"IdentifierType": "Ric",
"Source": "TIM",
"Key": "VjF8MHgwMDAzZjgwNTEzOGM0ODI5fDB4MDAwM2Y4MDUxMzhjOWJmYXxUSU18RFZRVXxERVJWfEZVVHxEfHxFRDF0bUgyXjF8NTIyNQ",
"Description": "ED1 MAR2",
"InstrumentType": "DerivativeQuote",
"Status": "Valid",
"ExchangeCode": "TIM",
"CurrencyCode": "TWD",
"FuturesAndOptionsType": "Futures",
"PutCallCode": "",
"ExpirationDate": "2012-03-21T00:00:00.000Z",
"AssetStatus": "Inactive"
},
...
Does this work for your use case?
