Name: Corporate Bonds Indices
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

About this Dataset

Corporate Bonds Indices

Content

Yield and total return indices for many categories of corporate bonds, mostly US and EM. Different indices have different durations of availability, ranging from 1975 onwards for US Gen Y to 1998 onwards for EMEA Gen TR.

For the naming convention:
Location
US=United States, EM=Emerging Markets, EMEA= Europe, Middle East & Africa
Type/Grade
Gen=General (All grades), Good= High Grade, High= High Yield, AAA=AAA-rated, AA=AA-rated and so on ...
Index type
Y=Yield, TR=Total Return

Sources

Data collected using Quandl API reference from Merrill Lynch into Python, before writing to csv using Pandas. For the combined mastersheet, I used pd.merge so the indices were inner joined on the date column starting with the longest range (US Gen TR) so the final range for the combined spreadsheet is shorter than the individual ranges.

Inspiration

How do the movement of yieldss and total return indices correlate to each other? Will post my notebook showing the correlation matrix of the bond yields and bond total returns soon!

Tables

Combined Bond Indices Yields

@kaggle.denzilg_corporate_bonds_indices.combined_bond_indices_yields

540.17 kB
5,797 rows
23 columns

CREATE TABLE combined_bond_indices_yields (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "date" TIMESTAMP,
  "emea_gen_tr" DOUBLE,
  "em_gen_tr" DOUBLE,
  "em_good_y" DOUBLE,
  "em_high_y" DOUBLE,
  "us_aaa_tr" DOUBLE,
  "us_aaa_y" DOUBLE,
  "us_aa_tr" DOUBLE,
  "us_aa_y" DOUBLE,
  "us_a_tr" DOUBLE,
  "us_a_y" DOUBLE,
  "us_bbb_tr" DOUBLE,
  "us_bbb_y" DOUBLE,
  "us_bb_tr" DOUBLE,
  "us_bb_y" DOUBLE,
  "us_b_tr" DOUBLE,
  "us_b_y" DOUBLE,
  "us_ccc_tr" DOUBLE,
  "us_ccc_y" DOUBLE,
  "us_gen_tr" DOUBLE,
  "us_gen_y" DOUBLE,
  "us_high_y" DOUBLE
);

Emea Gen Tr

@kaggle.denzilg_corporate_bonds_indices.emea_gen_tr

85.85 kB
5,797 rows
2 columns

CREATE TABLE emea_gen_tr (
  "date" TIMESTAMP,
  "bamlemrecrpiemeatriv" DOUBLE
);

Em Gen Tr

@kaggle.denzilg_corporate_bonds_indices.em_gen_tr

84.89 kB
5,797 rows
2 columns

CREATE TABLE em_gen_tr (
  "date" TIMESTAMP,
  "bamlemcbpitriv" DOUBLE
);

Em Good Y

@kaggle.denzilg_corporate_bonds_indices.em_good_y

64.56 kB
5,797 rows
2 columns

CREATE TABLE em_good_y (
  "date" TIMESTAMP,
  "bamlemibhgcrpiey" DOUBLE
);

Em High Y

@kaggle.denzilg_corporate_bonds_indices.em_high_y

67.49 kB
5,797 rows
2 columns

CREATE TABLE em_high_y (
  "date" TIMESTAMP,
  "bamlemhbhycrpiey" DOUBLE
);

Us Aaa Tr

@kaggle.denzilg_corporate_bonds_indices.us_aaa_tr

123.47 kB
8,372 rows
2 columns

CREATE TABLE us_aaa_tr (
  "date" TIMESTAMP,
  "bamlcc0a1aaatriv" DOUBLE
);

Us Aaa Y

@kaggle.denzilg_corporate_bonds_indices.us_aaa_y

69.32 kB
6,316 rows
2 columns

CREATE TABLE us_aaa_y (
  "date" TIMESTAMP,
  "bamlc0a1caaaey" DOUBLE
);

Us Aa Tr

@kaggle.denzilg_corporate_bonds_indices.us_aa_tr

123.63 kB
8,373 rows
2 columns

CREATE TABLE us_aa_tr (
  "date" TIMESTAMP,
  "bamlcc0a2aatriv" DOUBLE
);

Us Aa Y

@kaggle.denzilg_corporate_bonds_indices.us_aa_y

69.46 kB
6,316 rows
2 columns

CREATE TABLE us_aa_y (
  "date" TIMESTAMP,
  "bamlc0a2caaey" DOUBLE
);

Us A Tr

@kaggle.denzilg_corporate_bonds_indices.us_a_tr

123.73 kB
8,373 rows
2 columns

CREATE TABLE us_a_tr (
  "date" TIMESTAMP,
  "bamlcc0a3atriv" DOUBLE
);

Us A Y

@kaggle.denzilg_corporate_bonds_indices.us_a_y

69.67 kB
6,316 rows
2 columns

CREATE TABLE us_a_y (
  "date" TIMESTAMP,
  "bamlc0a3caey" DOUBLE
);

Us Bbb Tr

@kaggle.denzilg_corporate_bonds_indices.us_bbb_tr

123.9 kB
8,372 rows
2 columns

CREATE TABLE us_bbb_tr (
  "date" TIMESTAMP,
  "bamlcc0a4bbbtriv" DOUBLE
);

Us Bbb Y

@kaggle.denzilg_corporate_bonds_indices.us_bbb_y

69.8 kB
6,316 rows
2 columns

CREATE TABLE us_bbb_y (
  "date" TIMESTAMP,
  "bamlc0a4cbbbey" DOUBLE
);

Us Bb Tr

@kaggle.denzilg_corporate_bonds_indices.us_bb_tr

91.96 kB
6,316 rows
2 columns

CREATE TABLE us_bb_tr (
  "date" TIMESTAMP,
  "bamlhyh0a1bbtriv" DOUBLE
);

Us Bb Y

@kaggle.denzilg_corporate_bonds_indices.us_bb_y

70.48 kB
6,316 rows
2 columns

CREATE TABLE us_bb_y (
  "date" TIMESTAMP,
  "bamlh0a1hybbey" DOUBLE
);

Us B Tr

@kaggle.denzilg_corporate_bonds_indices.us_b_tr

91.02 kB
6,316 rows
2 columns

CREATE TABLE us_b_tr (
  "date" TIMESTAMP,
  "bamlhyh0a2btriv" DOUBLE
);

Us B Y

@kaggle.denzilg_corporate_bonds_indices.us_b_y

72.24 kB
6,316 rows
2 columns

CREATE TABLE us_b_y (
  "date" TIMESTAMP,
  "bamlh0a2hybey" DOUBLE
);

Us Ccc Tr

@kaggle.denzilg_corporate_bonds_indices.us_ccc_tr

93.07 kB
6,316 rows
2 columns

CREATE TABLE us_ccc_tr (
  "date" TIMESTAMP,
  "bamlhyh0a3cmtriv" DOUBLE
);

Us Ccc Y

@kaggle.denzilg_corporate_bonds_indices.us_ccc_y

75.08 kB
6,316 rows
2 columns

CREATE TABLE us_ccc_y (
  "date" TIMESTAMP,
  "bamlh0a3hycey" DOUBLE
);

Us Gen Tr

@kaggle.denzilg_corporate_bonds_indices.us_gen_tr

144.58 kB
9,086 rows
2 columns

CREATE TABLE us_gen_tr (
  "date" TIMESTAMP,
  "bamlcc0a0cmtriv" DOUBLE
);

Us Gen Y

@kaggle.denzilg_corporate_bonds_indices.us_gen_y

69.54 kB
6,316 rows
2 columns

CREATE TABLE us_gen_y (
  "date" TIMESTAMP,
  "bamlc0a0cmey" DOUBLE
);

Us High Y

@kaggle.denzilg_corporate_bonds_indices.us_high_y

72.21 kB
6,316 rows
2 columns

CREATE TABLE us_high_y (
  "date" TIMESTAMP,
  "bamlh0a0hym2ey" DOUBLE
);