G Guest Jan 19, 2006 #1 Why does excel seem to only calculate yield using prices under $100. What if a security is priced above par? Am I missing something?
Why does excel seem to only calculate yield using prices under $100. What if a security is priced above par? Am I missing something?
F Fred Smith Jan 22, 2006 #2 The Yield function works for me with prices over par. Post an example of your problem so we can help you track it down.
The Yield function works for me with prices over par. Post an example of your problem so we can help you track it down.
G Guest Jan 23, 2006 #3 Fred, appreciate the response, I got it figured out... had to do with the number of compounding periods.
Fred, appreciate the response, I got it figured out... had to do with the number of compounding periods.
