Yield function in Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TonyW - 19 Jan 2004 20:16 GMT

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.

Reply to this Message

Douglas J. Steele - 19 Jan 2004 23:37 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

> 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.

Reply to this Message