Fwd: Mortgage Questions -- Escrow handling

[Derek Atkins]

Josh Sled <jsled at asynchronous.org> writes:

> On Thu, 2007-04-26 at 21:46 -0500, Tommy Trussell wrote:
>> I've dug around for a formula that would help me with this, but I
>> haven't found one yet... I copied what the druid set up and (as you
>> said) it doesn't have a way to manage the additional principal. The
>> formulas don't look at the ACTUAL remaining amount in the loan, just
>> the original amount.
>
> Yes, that's what I said. The mortgage druid cannot handle over-payment.
>
> Without a good way to get the dated value of an account, it cannot be
> computed.
>
> There is internal API to get the value of an account as of a specific
> date.  It does not handle the case where multiple SXes are being
> instantiated at once.

I think in this case you'd need to iterate through the SXes, or you'd
need to change the "balance-at-date" API to take a list of "previously
instantiated but not yet posted" SXes to include in the balance
computation.

> Also, the template transaction editor formula cells aren't well-suited
> to entering formula/functions which include either Accounts or Dates;
> <http://wiki.gnucash.org/wiki/SoC2007#Enhanced_Expression_Parser>.

Well, I think the 'date' would be the post date, so I dont think we'd
need to include that in the formula.  Or at least I think in THIS case
the "date" can be properly assumed from the context (the date is the
post-date of the transaction).

-derek
-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available