Re: KMyMoney2-IRR calculation - Request for feedback

View: New views
2 Messages — Rating Filter:   Alert me  

Parent Message unknown Re: KMyMoney2-IRR calculation - Request for feedback

by allan anderson :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

> Hi Alvaro

> I thought I'd better throw this in in case it helps.

> I did a bit of checking between KMM and the XIRR function in OO.  I
> just checked a couple of funds and the results were spot on in one,
> and within 0.4% in the other.  Then, I realised that they both went
> over three years without a freeze, 3 years and 11 months, in fact.

> So, I did a bit more playing around with KMM.  Concentrating on one
> fund, from opening on 4 Nov 2004 to today, the investment report
> worked and produced a sensible result.  So, I went into the ledger and altered
> the opening date from 4 Nov to 3 Nov, and KMM immediately froze.  The
> report was still set to run from 4 Nov.  I could alter the ledger date
> to 5 Nov and back to 4 Nov, without problem, but KMM froze each time I
> set it to 3 Nov.

> Then I tried a different fund.  This was opened 5 Dec 2001, and
> produced a report for the whole period without problem!!!

> So, why?  This fund has a series of regular monthly dividend payments,
> whereas the other fund had an opening purchase, a second purchase two
> months later, a reinvestment two months later, then six-monthly
> dividends.

> Anyway, some while later.......  Again, concentrating on the first
>fund.....  If I set the report start date first, to an earlier date,
>say 2001, then alter the ledger fund opening date to that same date, it
> works, no freeze.

>I'll see if it gets any clearer.

>Allan

Continued...

Again, working just with a (that should be, THE) failing fund,  first
purchase date is 4 Nov 2004, and second purchase is 10 Jan 2005.

If the report starting date is before 5 Nov 2004, OK.
 "............................................"    between 5 Nov and 7 Jan 2005 inc., FAIL.
 "............................................"    after 7 Jan 2005, OK.

That's almost logical, but does it help?  I can run the report for all
funds except that one.

Allan

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer

Re: KMyMoney2-IRR calculation - Request for feedback

by Alvaro Soliverez :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Great job, Allan.

So the problem seems to be when you have a starting balance?
That is weird. I will have to keep looking into it.
Wish the debug weren't so slow. :))


On Fri, Jul 18, 2008 at 8:26 PM, allan <aganderson@...> wrote:
> Hi Alvaro

> I thought I'd better throw this in in case it helps.

> I did a bit of checking between KMM and the XIRR function in OO.  I
> just checked a couple of funds and the results were spot on in one,
> and within 0.4% in the other.  Then, I realised that they both went
> over three years without a freeze, 3 years and 11 months, in fact.

> So, I did a bit more playing around with KMM.  Concentrating on one
> fund, from opening on 4 Nov 2004 to today, the investment report
> worked and produced a sensible result.  So, I went into the ledger and altered
> the opening date from 4 Nov to 3 Nov, and KMM immediately froze.  The
> report was still set to run from 4 Nov.  I could alter the ledger date
> to 5 Nov and back to 4 Nov, without problem, but KMM froze each time I
> set it to 3 Nov.

> Then I tried a different fund.  This was opened 5 Dec 2001, and
> produced a report for the whole period without problem!!!

> So, why?  This fund has a series of regular monthly dividend payments,
> whereas the other fund had an opening purchase, a second purchase two
> months later, a reinvestment two months later, then six-monthly
> dividends.

> Anyway, some while later.......  Again, concentrating on the first
>fund.....  If I set the report start date first, to an earlier date,
>say 2001, then alter the ledger fund opening date to that same date, it
> works, no freeze.

>I'll see if it gets any clearer.

>Allan

Continued...

Again, working just with a (that should be, THE) failing fund,  first
purchase date is 4 Nov 2004, and second purchase is 10 Jan 2005.

If the report starting date is before 5 Nov 2004, OK.
 "............................................"    between 5 Nov and 7 Jan 2005 inc., FAIL.
 "............................................"    after 7 Jan 2005, OK.

That's almost logical, but does it help?  I can run the report for all
funds except that one.

Allan

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
KMyMoney2-developer mailing list
KMyMoney2-developer@...
https://lists.sourceforge.net/lists/listinfo/kmymoney2-developer