Entering formulas in scheduled transactions

[Matthew Vanecek]

On Wed, 2003-09-03 at 21:11, Jordan Kyriakidis wrote:
> Hello,
> 
> I *really* want to use gnucash, but this loan thing is a bit of a
> drag.  Thanks for any help.
> 

This loan druid thing *really* needs some rework.  My mortgage, for
example, is amortized.  I can pay anytime within the grace period and
the principal/interest will still be what's in my amortization table.  I
know this for a fact--just checked it.  Each period, I know exactly what
my payments and principal/interest are going to be.  I don't need a
druid to tell me this.

My car payment, OTOH, is simple interest.  The monthly payments are
constant.  The principal/interest split is variable, depending on when
my payment hits the bank.  Interest is figured as:
 
((pay date) - (start date) * (daily int.)) * ROUND(prin. balance).

with some figures rounded prior to calculation.  There's a little more
to it, but that's the basics.  The loan wizard is incapable of handling
this scenario accurately.  So are spreadsheets, unless you use the
round() function.  In any case, I know up front what my monthly payments
are.  I don't need the loan druid to tell me.  It'd be nice to be able
to enter the formula, though, so I could set up the scheduled
transaction to compute principal/interest payment division per payment.

My solution: use a spreadsheet, enter the stuff by hand.  This, of
course, precludes the use of scheduled transactions. :(

Just my $.02 rant...

-- 
Matthew Vanecek
perl -e 'print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);'
********************************************************************************
For 93 million miles, there is nothing between the sun and my shadow except me.
I'm always getting in the way of something...