Quantitative Finance Stack Exchange is a question and answer site for finance professionals and academics. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to backfill the price of bonds for testing a startegy.

The method employed is:

  1. Regressing the YTM of the bond against a benchmark.
  2. Using the regression estimates to calculate the YTM for the period in which the bond data is not available.
  3. Using the "price" function in excel to calculate the bond price with the earliest backfill date as the issue date.

However, using this method, there is a big difference in price at the point where my backfill data begins.

Could somebody please suggest any alternative?

share|improve this question
Please next time make sure that the title is a question and that the content has proper formatting. – SRKX Jun 24 '12 at 12:41

First of all, you should be using OAS, not YTM, as the risk-free interest rate component of YTM is known and should be imposed rather than estimated. Second, rather than regressing OAS against a benchmark, regress changes in OAS against changes in a benchmark OAS. Then calculate a fitted OAS series from the change series, which naturally will not have any jumps where the backfill begins.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.