question

Upvotes
Accepted
36 4 5 8

Refinitv Tick History Historical Search for Chain RIC


Chain RIC 0#SIRT- gives incorrect end date (2017-05-06) using 'ResultsBy': 'Entity, however without 'ResultsBy': 'Entity it gives correct end date:


with 'ResultsBy': 'Entity

when sending request
{'Request': {'@odata.context': 'http://selectapi.datascope.refinitiv.com:83/RestApi.Help/$metadata#DataScope.Select.Api.Search.HistoricalSearchRequest',
'IdentifierType': 'ChainRIC',
'Identifier': '0#SIRT-:',
'Range': {'Start': '1996-01-01T00:00:00.000Z',
'End': '2021-12-31T23:59:59.000Z'},
'ResultsBy': 'Entity'}}
to below
https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/HistoricalSearch



it returns
{'@odata.context': 'https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#Collection(DataScope.Select.Api.Search.HistoricalSearchResult)',
'value': [{'Identifier': '0#SIRT-:',
'IdentifierType': 'Ric',
'Source': '',
'Key': 'VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHwwI1NJUlQtOnw',
'Description': 'Historical Instrument',
'InstrumentType': 'Unknown',
'Status': 'Valid',
'DomainCode': '6',
'ValidFrom': '1996-06-04T04:43:43.200Z',
'ValidTo': '2017-05-06T14:09:09.000Z',
'FirstDate': '1996-06-04T00:00:00.000Z',
'LastDate': '2017-05-06T00:00:00.000Z',
'History': [{'Ric': '0#SI-:',
'ValidFrom': '1996-06-04T04:43:43.200Z',
'ValidTo': '2016-01-23T14:34:11.415Z',
'FirstDate': '1996-06-04T00:00:00.000Z',
'LastDate': '2016-01-23T00:00:00.000Z'},
{'Ric': '0#SIRT-:',
'ValidFrom': '2016-01-23T14:34:11.415Z',
'ValidTo': '2017-05-06T14:09:09.000Z',
'FirstDate': '2016-01-23T00:00:00.000Z',
'LastDate': '2017-05-06T00:00:00.000Z'}]}]}


Without 'ResultsBy': 'Entity : End date shows 2022-07-09

{

"Request": {

"Identifier": "0#SIRT-:",

"IdentifierType": "ChainRIC",

"Range": {

"Start": "1996-01-01T00:00:00.000Z",

"End": "2021-12-31T00:00:00.000Z"

},

"ResultsBy": "Ric"

}

}

{

"@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#Collection(DataScope.Select.Api.Search.HistoricalSearchResult)",

"value": [

{

"Identifier": "0#SIRT-:",

"IdentifierType": "ChainRIC",

"Source": "",

"Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHwwI1NJUlQtOnw",

"Description": "Historical Chain",

"InstrumentType": "Unknown",

"Status": "Valid",

"DomainCode": "6",

"FirstDate": "2016-01-23T00:00:00.000Z",

"LastDate": "2022-07-09T00:00:00.000Z",

"History": []

}

]

}

Also, why does the 1st API response shows 0#SIRT-: as RIC
And the chain0#SIRT-: is active till date(why doesnt end date shows as todays date)

trth-rest-api
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.

Thank you @zoya faberov

1 Answer

Upvote
Accepted
32.2k 39 11 19

Hello @Vinod A ,

The results can differ because Results By Entity specifier is only relevant to individual RICs not to chains. There is no entity that is associated with the chain. This is also why, I believe, if you include the specified the result it comes out as RIC, the service does not process the request as valid.

I suggest to additionally verify this with our content experts via Refinitiv Helpdesk Online for a definitive answer about this content, as well as to find any relevant recommendations.

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.