No RIC matched for several CUSIPs and thus unable to get_timeseries

Question

Question by jwang3 · Mar 11, 2019 at 05:10 PM · eikon eikon data api ric eikon python

No RIC matched for several CUSIPs and thus unable to get_timeseries

I wanted to convert three CUSIPs to RICs so that I can use ek.get_timeseries to retrieve data. But there is no RIC matched even when I set bestMatch as False:

ek.get_symbology('94984DAB0', from_symbol_type = 'CUSIP', to_symbol_type = 'RIC', bestMatch=False)

The result:

bestMatch symbol{'error': 'No best match available'}94984DAB0

The three CUSIPs are '94984DAB0', '61749NAD9', '80556BAE5'. Is there other way to convert them to RIC or get time series data using non-RIC instruments?

Thank you in advance!

0

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2019-03-12T06:33:46Z

REFINITIV

Best Answer

Answer by marcin.bunkowski · Mar 12, 2019 at 06:33 AM

Hi @jwang3

Those CUSIPs belong to CMOs and ABSs. The timeseries is not directly accessible using CUSIP or ISIN code, however you get some data if you add suffix '=RRPS'. The below code returns bid yield.

df= ek.get_timeseries(['94984DAB0=RRPS','61749NAD9=RRPS','80556BAE5=RRPS'], start_date = "2017-03-01", end_date = "2019-02-22",interval='daily')
df

1 Show 2 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jwang3 · Mar 12, 2019 at 12:24 PM 0

Share

Thank you @marcin.bunkowski for your help! Could you please kindly elaborate more on what `=RRPS` actually stands for and how we know when we need to use it?

REFINITIV

marcin.bunkowski jwang3 · Mar 13, 2019 at 10:01 AM 1

Share

Hi @jwang3 this is more of a question of a data availability and mapping. From what I know the market of CMOs on US/CA market is not fully covered on real time and therefore your formula was not effective. The solution I have provided is somehow a workaround to get the timeseries data using Eikon API or Excel. RRPS stands for Reuters Realtime Pricing Service.

If want to more know about the data availability please open a case with your local Refinitiv Helpdesk

No RIC matched for several CUSIPs and thus unable to get_timeseries

1 Reply

Watch this question

Related Questions