Hello Everyone,
I have a sample file with different possibilities. I've tried calculating XIRR without putting each cashflow of individual securities with no luck.
Few Points:
I have a sample file with different possibilities. I've tried calculating XIRR without putting each cashflow of individual securities with no luck.
Few Points:
 Interest Due date column indicates the 1st interest payment date. I want to put a formula wherein this will change every month/quarter/year depending on the frequency of the payments.
 If the Interest due date is within the next 20 days from today, it should reflect the next due date
 I have a big list of securities & for each of these I need to calculate XIRR separately. That's why looking for a way by which I can automate the whole process by putting in a fixed set of data for each of the security
Attachments

8.6 KB Views: 4