Forum

Notifications
Clear all

Excel ODDFYIELD function issues

2 Posts
2 Users
0 Reactions
148 Views
(@vijay)
Posts: 23
Eminent Member
Topic starter
 

I have used different combinations of dates of cash flows. Some cases are of first odd/irregular period of coupon payment and some aren't. Most of the time this function throws #NUM error. I don't know what's wrong with this function? In each case I have complied with the condition of Issue date < Settlement date < First coupon payment date < Maturity date. I have attached the Excel file.

 
Posted : 20/02/2023 2:06 pm
(@catalinb)
Posts: 1937
Member Admin
 

Same advice: please try on a finances forum, looks like there is no expert in finances that can help answering your question.

 
Posted : 28/02/2023 3:27 am
Share: