Reply to thread

Message: [QUOTE="Wesslan, post: 6384609"] Hi guys, Know this is a forum for VBA questions and I have done quite a bit of programming so that I will shoot this by the pros here :) I have the following data: Date* Value 31-Dec-06 -353,727,346 30-Nov-07 -70,866,490 31-Dec-07 333,502,702 31-Jan-08 507,604 29-Feb-08 -1,841,266 31-Mar-08 -1,125,842 30-Apr-08 -950,991 31-May-08 -193,437 30-Jun-08 -444,026 31-Jul-08 -962,122 31-Aug-08 -2,059,591 30-Sep-08 58,164 31-Oct-08 -1,040,522 30-Nov-08 -2,766,378 31-Dec-08 -46,006,913 For some reason my XIRR function will not work (even if I provide a negative guess). I have calculated the TSR on a yearly basis which is approx -24% and the total drop over the two years is approx -42%. Anyone have a clue why my Excel only gives me #Num. Using VBA I have sorted the data in terms of first date and then amount. Still have the error... Any help would be truly appreciated! [/QUOTE]