Coding the "yield" function in Access

[laurentc via AccessMonster.com]

Hi there.


I would like to calculate the yield of some bonds in my Access database.


I thought I could use the "Automation" of Microsoft to calculate these yields
through Excel, but it is a very long process, and my Access database does no
more work correctly with so many calculations through Excel.

So I need to build my own Yield function in Access.
Many people probably already did this job, but I was unable to find their VBA
module code.

Does someone know where I could find the VBA code of this YIELD function?

Thanks a lot for your help.

Regards,

Laurent

 

[laurentc via AccessMonster.com]

Hi again.

I found the VBA code to build the YIELD function thanks to the result of the
PRICE function.
However, I cannot find the VBA code of the PRICE function, so I do not make
any real progress.

Does anyone know any VBA code that would help me to calculate the function
YIELD? (this YIELD function is an "add-in" in Excel which is not provided in
Access)

Many thanks.

Laurent

 

[laurentc via AccessMonster.com]

I eventually found the great VBA code of Myrna Larson.

http://www.mcse.ms/archive161-2004-12-1308011.html


Thanks a lot for your great Job, Myrna !
Regards,

Laurent

Hi again.

I found the VBA code to build the YIELD function thanks to the result of the
PRICE function.
However, I cannot find the VBA code of the PRICE function, so I do not make
any real progress.

Does anyone know any VBA code that would help me to calculate the function
YIELD? (this YIELD function is an "add-in" in Excel which is not provided in
Access)

Many thanks.

Laurent

Hi there.

[quoted text clipped - 15 lines]

Laurent