Re: Fixed-rate bond pricing can yield different results compared to Excel's built-in functions

Posted by StephenWong on Oct 29, 2011; 5:36pm
URL: http://quantlib.414.s1.nabble.com/Fixed-rate-bond-pricing-can-yield-different-results-compared-to-Excel-s-built-in-functions-tp6340p6344.html

Gavin08 wrote

Download this worksheet (using "save as") for a few examples of bonds where the prices coincide (the top 3 rows), and where they differ slightly (the rows below). Every row represents a different case/bond. Check out the blue area to compare prices.

Would be glad to hear some feedback.

Thanks and regards,
Gavin

Gavin08 wrote

I was pricing U.S. corporate bonds. If it helps I can compile a sheet where the problem manifests.

Why are you comparing clean price with dirty price? qlBondCleanPriceFromYield calculates the price without  accrued interests while PRICE from Excel includes that interests. No?