.NET implementation of Excel Yield function

Question

Excel's add-in named "Analysis ToolPak" provides "Yield" function for calculation of yield on security that pays periodic interest.

Function works well and returns proper data.

My understanding is function base on kind of iteration it is not so easy implement it in my code.

My question is anybody know/seen implementation in C# (eventually other languages) and can share? Or (maybe) some tips how to implement it? Than I can share :)

EDIT:

Thanks all posting me "formula" but this is not fully useful to me.
Please note that MS' formula finds application in 1 case only:
"when there is one coupon period or less until redemption",

otherwise:

"(...) Yield is calculated through a hundred iterations."
and there is no exact formula for that case

I can read equations and implement them (hopefully), but my question was if somebody has or saw already implemented function in programming language.

I'm not lazy but I dont like break down open doors...

Answer 1

First learn the mathematical formulas needed for your expression. Then if it's needed to be implemented in a enumerable fashion, check out "yield return" and iterators in c#

Answer 2

The whole formula is here:

http://office.microsoft.com/en-us/excel/HP052093451033.aspx

First match on Google for 'excel yield'.

Answer 3

Here is the formula if you don't want to browse through web pages.

I tried to post the image but I am a new user and it didn't allow me.

Graphic showing formula.

Answer 4

Assuming a function which is passed all the variables required for the formula as explained on

http://office.microsoft.com/en-us/excel/HP052093451033.aspx

then

return (((redemption/100 + rate/frequency) - ( par/100 + ( A/E * rate/frequency ))) / (par/100+( A/E * rate/frequency ))) * ((frequency*E)/DSR);