Yield function in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm converting an excel-based database into MS Access. As part of this, I need to compute the yield to maturity (or internal rate of return) for each bond in a bonds table. Is there any way I can use Excel's "yield" function for this or is there an add-in available for this?

Thanks!

Tony W.
 
It's a little tricky, but it can be done. Yield isn't an native Excel
function: it's from one of the add-ins. Check
http://support.microsoft.com/?id=198571 for instructions of how to do it.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



TonyW said:
Hi,

I'm converting an excel-based database into MS Access. As part of this, I
Click to expand...
need to compute the yield to maturity (or internal rate of return) for each
bond in a bonds table. Is there any way I can use Excel's "yield" function
for this or is there an add-in available for this?
 
Back
Top