Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
yield function
I wish to calculate yields using monthly compounding. Excel spreadsheet has
a 'yield' function that allows 1, 2, or 4 compound periods per year (I need 12). I have a custom function written by a friend that calculates yield, but it too, does not calculate monthly compounding. In fact, it is only accurate semi-annually and is inaccurate outside of that. My question is: can I get monthly compounding for the 'yield' or 'price' function on excel (not necessarily in code), like an add-in? Or better yet, is there code available (preferably free) that will calculate yield and price w/ more than 1, 2, and 4 compounding periods? Thank you, Mike Allen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Current Yield vs. Yield to Maturity at low prices | Excel Worksheet Functions | |||
Problem with Yield() function | Excel Worksheet Functions | |||
what is PAR in the Yield Function | Excel Worksheet Functions | |||
In Excel, can a function yield a drop-down list? | Excel Worksheet Functions | |||
yield function | Excel Worksheet Functions |