Hi,

I have private equity cashflow data from which I want to calculate the IRR for every fund.

The variable TransactionCategory includes three different strings (Categories): Capital Call, Distribution and Value.

To calculate the IRR I only need the last value (as this is the final value of the portfolio) in the column (based on TransactionDate) by every fundID.

Does anybody know how to keep only TransactionCategory == "value" based on the last TransactionDate by fundID?

Tips on calculating the IRR of the separate funds are also very welcome!!

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input long FundID int TransactionDate str12 TransactionCategory
3 12418 "Capital Call"
3 12508 "Value"       
3 12554 "Capital Call"
3 12554 "Distribution"
3 12599 "Value"       
3 12691 "Value"       
3 12737 "Capital Call"
3 12783 "Value"       
3 12828 "Capital Call"
3 12828 "Distribution"
3 12873 "Value"       
3 12919 "Capital Call"
3 12919 "Distribution"
3 12964 "Value"       
3 13010 "Capital Call"
3 13010 "Distribution"
3 13056 "Value"       
3 13102 "Capital Call"
3 13102 "Distribution"
3 13148 "Value"       
3 13194 "Capital Call"
3 13194 "Distribution"
3 13239 "Value"       
3 13285 "Capital Call"
3 13285 "Distribution"
3 13330 "Value"       
3 13376 "Capital Call"
3 13422 "Value"       
3 13468 "Capital Call"
3 13468 "Distribution"
3 13514 "Value"       
3 13559 "Capital Call"
3 13559 "Distribution"
3 13650 "Capital Call"
3 13695 "Value"       
3 13741 "Distribution"
3 13787 "Value"       
3 13833 "Distribution"
3 13879 "Value"       
3 13924 "Distribution"
3 13969 "Value"       
3 14015 "Distribution"
3 14060 "Value"       
3 14106 "Distribution"
3 14152 "Value"       
3 14198 "Distribution"
3 14244 "Value"       
3 14289 "Distribution"
3 14334 "Value"       
3 14380 "Distribution"
3 14425 "Value"       
3 14471 "Distribution"
3 14517 "Value"       
3 14563 "Distribution"
3 14609 "Value"       
3 14655 "Capital Call"
3 14655 "Distribution"
3 14700 "Value"       
3 14746 "Distribution"
3 14791 "Value"       
3 14837 "Distribution"
3 14883 "Value"       
3 15020 "Distribution"
3 15065 "Value"       
3 15111 "Distribution"
3 15156 "Value"       
3 15202 "Distribution"
3 15248 "Value"       
3 15294 "Capital Call"
3 15294 "Distribution"
3 15340 "Value"       
3 15430 "Value"       
3 15521 "Value"       
3 15613 "Value"       
3 15659 "Distribution"
3 15705 "Value"       
3 15750 "Capital Call"
3 15750 "Distribution"
3 15795 "Value"       
3 15841 "Distribution"
3 15886 "Value"       
3 15932 "Capital Call"
3 15932 "Distribution"
3 15978 "Value"       
3 16024 "Capital Call"
3 16024 "Distribution"
3 16070 "Value"       
3 16116 "Capital Call"
3 16116 "Distribution"
3 16161 "Value"       
3 16207 "Capital Call"
3 16207 "Distribution"
3 16252 "Value"       
3 16298 "Distribution"
3 16344 "Value"       
3 16390 "Distribution"
3 16436 "Value"       
3 16481 "Distribution"
3 16526 "Value"       
3 16572 "Distribution"
end
format %td TransactionDate