After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 168700 - Canadian mortgage rates are not easily usable in gnucash
Canadian mortgage rates are not easily usable in gnucash
Status: VERIFIED FIXED
Product: GnuCash
Classification: Other
Component: Scheduled Transactions
unspecified
Other All
: Normal enhancement
: ---
Assigned To: Josh Sled
Josh Sled
Depends on:
Blocks:
 
 
Reported: 2005-02-27 22:45 UTC by Ludovic
Modified: 2018-06-29 20:50 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
Patch to fix this bug for canadian mortgages, at the scheme level (1.62 KB, patch)
2005-02-27 22:51 UTC, Ludovic
committed Details | Review

Description Ludovic 2005-02-27 22:45:11 UTC
In the SX editor and Loan/Mortgage Druid, there is an assumption about american-style mortgage rates 
that makes using the "official" rate given by any canadian bank difficult if you don't know how to do the 
math. The reason is that posted Canadian rates for mortgages are compounded semi-annually, 
although the actual interest itself is compounded monthly or biweekly or whatever based on your 
payment period.
There is a way to convert the canadian loan to an effective periodic rate, just as a US rate is simply 
divided by the number of periods. However, this is compicated and non intuitive to the end-user.

On the long run, it would be good to actually improve the SX Editor/Druid so that it can generate the 
proper formulas by itself, but a first step is to add basic scheme code so that users can manually enter 
the needed formula if required.

I also have issues with rounding where the two components of a mortgage repayment (Int+Principal) 
don't match the payment, typically by one cent.
Comment 1 Ludovic 2005-02-27 22:51:18 UTC
Created attachment 38027 [details] [review]
Patch to fix this bug for canadian mortgages, at the scheme level

This is a patch that defines 4 functions to deal with cpd interest, with
builtin rounding, although the comments added in the source file explain how to
get either the rounding without the compounded, or the compounded without the
rounding.
All exisitng functions were left untouched, so no compatibility issues are
expected. This only adds 4 new functions to the gnc: scope, so that they are
visible in the SX editor.

No GUI code code added at this point.
Comment 2 Derek Atkins 2005-02-28 04:53:50 UTC
Added PATCH keyword
Comment 3 Josh Sled 2007-01-28 20:30:21 UTC
Applied to trunk, r15452; 2.2.
Comment 4 John Ralls 2018-06-29 20:50:31 UTC
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=168700. Please update any external references or bookmarks.