get_timeseries returns TA-TSIIntervalNotSupported error

philip.xiang

Hi, one of the tickers I query returns the following error however other similar RICs (such as 'NSEA-BBL-STA') work just fine. Can you look into it? Thanks!

df = tr.get_timeseries('NSEA-BBL-TOT', start_date='20120101', end_date='20170714', fields='CLOSE', normalize=True, interval='monthly')

(u'NSEA-BBL-TOT', ': ', u'Error: TSIIntervalNotSupported, ErrorCode: TA-TSIIntervalNotSupported, Fault: TSIError, Description: Interval is not supported', '\n')

Alex Putkov.1

Hi @philip.xiang
This looks like a data, not an API issue. As far as I can see the RIC NSEA-BBL-TOT does not have any history in the timeseries database. You can easily demonstrate this by entering this RIC into a Chart object in Eikon or by using it in RHistory function in Eikon Excel.
I would advise you to open a service case with Thomson Reuters Support by either calling Thomson Reuters Helpdesk number in your country or by using Contact Us capability in Eikon application. A data specialist will then be able to provide an answer for you.

philip.xiang

https://community.developers.refinitiv.com/discussion/comment/16015#Comment_16015

Appreciate the prompt response Alex. Unfortunately I am able to pull the timeseries using RHistory. So I would say there must be an edge case in the API.

=RHistory("NSEA-BBL-TOT",{"LAST_QUOTE.TIMESTAMP","LAST_QUOTE.CLOSE"},"START:36526 END:43430.3661805556 INTERVAL:1MO",,"TSREPEAT:NO NULL:NA")

Alex Putkov.1

https://community.developers.refinitiv.com/discussion/comment/16038#Comment_16038

Thanks @philip.xiang
I guess I miscategorized the issue slightly. The problem is not that we don't have any timeseries for this RIC, but that the default timeseries view (the one that you retrieve when you enter the RIC into a new Chart app or when you choose fields from the Common category in Eikon Excel Formula Builder) returns no data. And Eikon Scripting API at least for the time being can only retrieve timeseries from the default view.

Alex Putkov.1

https://community.developers.refinitiv.com/discussion/comment/16038#Comment_16038

My guess is that the default view is incorrectly mapped for this RIC. Either way it's still a data problem. You can demonstrate it through =RHistory("NSEA-BBL-TOT",".Timestamp;.Close","INTERVAL:1MO"), which does not return any data.
I still recommend that you report the issue (best demonstrated using RHistory function above) to Thomson Reuters Helpdesk for investigation.