Check out Excel help , you will see the formula and this will allow you to calulate the yield that agrees with bondpage.comYIELD(settlement,maturity,rate,pr,redemption,frequency,basis)

Par yield : I am now confused as I always thought par yield as the yield to discount all future cash flows to get a price of 100. Could someone please provide a definition. Thank you.

Kane,Wow !Thank you very much that really works. That has helped my understanding greatly now that I can see it working in a spreadsheet.RegardsGWM

<t>Cparker, Thank you for the link. However it does not help my understanding (excuse my thickness!) My problem is that my Cholesky Matrix is 3X3 (the upper triangle 0) and by random number matrix is 1000 X1.What transformations and how do I apply these to do t a 3 x 1000 matrix where each column co...

<t>I am trying to understand the mechanics of generating three data samples (a,b,c) for MC generation I have the following building blocks.o X = 1,000 independent standard normal variables o C = Choleskys decomposed matrix of the VcV for the variables a,b,cHow do I apply matrix C to X to get 3 sets ...

<t>I want to get back into some software development, and I would like some direction on how to start again.Objective is to develop small desktop application for risk management using state of the art softwareThe main desktop tools in investment banking are EXCEL, ACCESS and the web as a distributio...

<t>I want to start do some useful software development in my spare time on fixed income credit risk (self development)<br/> <br/> web type applications are the way forward but I feel they are very complex.<br/> The architecture that I think is appropriate is <br/> Java Web Client<br/> +<br/> EXCEL S...

Can anyone recommend any good site or books on valuing Convertible BondsThank You in advance