question

Upvotes
Accepted
36 4 6 10

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

@Vinod A

Hi,

Thank you for your participation in the forum.

Is the reply below satisfactory in answering your question?

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

@Vinod A

Hi,

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

Thanks,

AHS

1 Answer

· Write an Answer
Upvote
Accepted
32.2k 40 11 20

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.

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.