question

Upvotes
Accepted
ricardo.henriquez avatar image
38 ●4 ●9 ●17

Description of variables using get_historical_price_summaries() on a bond index?

Hello,

I'm looking for information and descriptions of the variables returned in get_historical_price_summaries(), where universe is a bond index. I cannot find such descriptions on the CodeCreator App.

I have the following code:

df_data=rdp.get_historical_price_summaries(
        universe = '.IBBEU010B',
        start = '2004-01-01',
        end = '2021-07-01',
        interval=rdp.Intervals.DAILY)
display(df_data)

The df_data has the following columns:

Index(['TRDPRC_1', 'MOD_DURTN', 'YIELD', 'DURATION', 'AVG_LIFE', 'CONVEXITY',
'MTD_HPDRTN', 'BPV', 'OAS', 'MAC_DURTN', 'CPR_RATE', 'TOT_RETURN',
'TRTN_3M_H', 'EXS_RTN_H', 'TRTN_1Y_H'], dtype='object')

From their names, it is easy to assume a few of them. However, I cannot decipher what does 'MTD_HPDRTN' means. Regarding 'EXS_RTN_H', where do I find which benchmark is used?

'TRDPRC_1' = Traded Price
'MTD_HPDRTN'= ?
'TRTN_3M_H' =? 
'EXS_RTN_H' = ?
'TRTN_1Y_H' ?

Thanks!

rdp-apibondsindexprice-history
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.

1 Answer

· Write an Answer
Upvotes
Accepted
umer.nalla avatar image
25.3k ●87 ●12 ●25

Hi @ricardo.henriquez

Unfortunately, most of the moderators on these Q&A Forums are not Data content specialists.

Therefore, you can raise a Content ticket at My.Refinitiv - so that the relevant expert can help you.

You can also try using the Data Model Discovery tool which for example, describes MTD_HPDRTN as Month-to-Date Paydown Return - Hedged.

For the EXS_RTN_H field, the Content team should be able to advise on which benchmark is used also.

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.