report on account monthly average amounts?

[Robert C. Ramsdell III]

On Sat, 2005-06-25 at 09:44 -0400, Derek Atkins wrote:
> Robert,
> 
> This python script seems rather overkill; Gnucash can do exactly
> that with the Account Summary Report. 
You are absolutely right.  You can even cut and paste the report into
Gnumeric.  Thanks for the pointer.

>  Wouldn't it be better to
> write it in scheme and add it to gnucash as a report, rather than
> have an external program that's dependent on the GnuCash data file
> format (which _is_ subject to change)...
Except that I don't know Scheme?  I wrote this over 3 years ago in an
effort to create a budget.  The Python is not completely useless, since
it is standalone and spits out account balances to stdout.  At least one
guy used to use it in a chron job to generate weekly e-mails with
account balances.

> 
> Terrence, As far as I know gnucash has no report currently written to
> display _average_ balances.  A little bit of scheme could be added to,
> say, the account summary report to add a column with average balances,
> but of course you'd need to supply a period (average balance over what
> period of time).
Quick fix now is to copy this months report and the report from the
first of the year into gnumeric or another spreadsheet, then take the
difference between the account balances divided by the number of months.

BTW Gnucash is great, and I appreciate all the time and effort you and
the other devs put into it.

Robert C. Ramsdell III
5528 Middaugh Avenue
Downers Grove, IL 60516
(630) 435-1776
rcriii at ramsdells.net