[GNC] Formulas in Scheduled Transactions

[David Carlson]

I just recently saw that you could enter an arbitrary string as a variable
name and the Since Last Run would ask you to assign an amount to that
variable when it ran.  I have not tried it though.

On Tue, Nov 16, 2021 at 2:38 PM Fross, Michael <michael at fross.org> wrote:

> Thanks Derek....that's what I thought the answer would be.  Much
> appreciated.
>
> Michael
>
> On Tue, Nov 16, 2021 at 2:14 PM Derek Atkins <derek at ihtfp.com> wrote:
>
> > GnuCash SX does not have a "Get Account Balance As Of Date" function, so
> > there is no way to get "OldAmount" here.
> >
> > -derek
> >
> > On Tue, November 16, 2021 3:02 pm, Fross, Michael wrote:
> > > Hello all,
> > >
> > > I have a fixed annuity account which updates with a new total, but does
> > > not
> > > show the interest that contributes to that total.  Here is the simple
> > > formula to calculate the interest:
> > >
> > > Interest = NewAmount - OldAmount
> > >
> > > I thought it would be interesting to have a monthly scheduled
> > > transaction that would request the new value from me (which I get from
> my
> > > brokerage).  The function would then subtract the current value of the
> > > account (OldAmount) from the value I entered (NewAmount) and then add
> the
> > > interest as a transaction in the account.
> > >
> > > While it's not a big deal to figure it out and just put in the
> interest,
> > I
> > > thought it would be fun to see if I can get GnuCash to do it, although
> I
> > > admit I may be asking a bit too much of the scheduled transaction
> > > capability.  Getting the NewAmount is probably as easy as adding a
> > > variable
> > > to the scheduled transaction.  Adding the interest as a variable is
> > > probably something that can be done.  I'm not sure how I could get the
> > > current amount in the scheme file to do the subtraction.
> > >
> > > Any thoughts on this?   Is it possible?  Pointers on where to begin?
> > (I'm
> > > been looking through the fin.scm file, but I didn't see much
> > documentation
> > > on this capability)
> > >
> > > Thanks in advance!
> > >
> > > Michael
> > > _______________________________________________
> > > gnucash-user mailing list
> > > gnucash-user at gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > If you are using Nabble or Gmane, please see
> > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > > -----
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> > >
> >
> >
> > --
> >        Derek Atkins                 617-623-3745
> >        derek at ihtfp.com             www.ihtfp.com
> >        Computer and Internet Security Consultant
> >
> >
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson