Can you use the XIRR function on multiple investments with different number of dates and rates in the same data set?

Reply
Contributor
Posts: 47

Can you use the XIRR function on multiple investments with different number of dates and rates in the same data set?

Hello

I would like to know if it is possible to use the XIRR function on multiple investments, where each investment has its own number/range of dates and rates. 

I am unsure of how to do this in SAS and hoping that someone would be willing to help me

I've attached a sketch from Excel of how my data looks like and what I am hoping to achieve. In the picture below the first row are just the variable names.

XIRR data.PNG

I would greatly appreciate any help.

Thanks

Best Regards

Bruce

Ask a Question
Discussion stats
  • 0 replies
  • 191 views
  • 0 likes
  • 1 in conversation