Hi Prashant

Sorry, that I can't help you with. I don't know how to implement 100
iterations of the Newton method if there is more than one coupon period
remaining which there almost certainly will be.

Good luck
Rowan

Prashant Shah wrote:
Res. Mr.Rowan,
I thank you very much for help on the Yield function. I had made a
mistake in asking the question. I have read the formula in the excel help
section but I could not transfer into VBA language.
I want the exact code that I should use to imitate the Yield function.
Suppose there is no add-in of analysis toolpack available. Then how to
create a macro to get the result same as Yield function gives.

Sorry for the error in asking,
Can you help further?
Thanking you once again,
Yours
Prashant