Search results for query: *

MajP, So far no incorrect solutions or no solutions, where the cash flows are with the right signs. I am also checking this frequently against excel workings, and will bring any anomalies to your notice. Thank you once again for the excellent and committed assist in solving this problem. Sanjay

MajP, Apologies for the delay in posting this. I have worked with your XIRR module across a few months, and have validated the workings compared with the earlier excel model I was using. It is accurate down to 0.1%. Also, saw your last post above just last week, and the tip there enabled me to...

MajP, Please ignore earlier message- figured out the problem. All cash flows in the [Live Amount] field cannot have the same sign- some are inflows, and some outflows. I need to build in a separate cash flow field to handle that, and then,I think the function will work fine. Thanks a million...

MajP, Checked out the revised code, and modified the last date to function CurrentMonth(), which is the formula I had given in my previous post...i.e., considering we are in Sept, the last date has to be the last working date in Aug, not July, which is what your date(i-1) function gives. The...

MajP, Thanks a million for the help! 76% sounds about right for the data that we have. Let me try and use the new code on the actual database and report back to you on the speed and accuracy. I hope to do this by tomorrow. Sanjay

MajP, Apologies for the late revert. I tried the method you had suggested, but I still cannot get the excel reference to work. No matter, as the the other method works just fine. Thank you once again. A different query though, and kindly excuse my rudimentary VBA knowledge. In the attached...

MajP, Thank you once again for your interest- I did think of trying out your other code for XIRR, and did get a result out of it. I had to modify the line: "AccessXIRR = MyXIRR(Payments, Dates, GuessRate)" to "AccessXIRR = Format(Round(MyXIRR(Payments, Dates, GuessRate), 4), "Percent")" to get...

Hi MajP, You were the one who wrote this code, so thank you for your interest. I did notice that I would have to do the field parameters in the query to match those in the table. So I modified the query as : SELECT tblPayees.PayeeID, AccessXIRR("TblPayees","[Payment Value]","[Payment...

I had tried to use the first part of the XIRR code (calling the function from excel) given by MajP in the above thread, but I get an error "Run Time Error 3061 Too Few Parameters. Expected 2, and the debug stops at the line :"Set rs = CurrentDb.OpenRecordset(strSql)". I have put the table...