Re: [GNC] F::Q Interface to GNC for pricing update
Yes, GnuCash / Finance::Quote fetches the "latest" price for each security, there is no provision to retrieve historical prices (although you can enter them manually via the Price Editor, or import them from a CSV file - see attached). Geoff = On 18/01/2024 2:20 pm, Adrien Monteleone wrote: I'm pretty sure the answer to that is yes, as I seem to recall this question in the distant past, but things may have changed since then. Regards, Adrien On 1/17/24 5:32 PM, Kalpesh Patel wrote: Looking at the data structure returned by F::Q that is consumed by GNC, am I correct in understanding that GNC is currently designed to consume only one quote for one or more security per firing to update it? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] F::Q Interface to GNC for pricing update
Indeed yes, see the GnuCash Manual §8.6 Price Editor: https://lists.gnucash.org/docs/C/gnucash-manual/tool-price.html Regards, Adrien On 1/17/24 5:32 PM, Kalpesh Patel wrote: Looking at the data structure returned by F::Q that is consumed by GNC, am I correct in understanding that GNC is currently designed to consume only one quote for one or more security per firing to update it? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] F::Q Interface to GNC for pricing update
I'm pretty sure the answer to that is yes, as I seem to recall this question in the distant past, but things may have changed since then. Regards, Adrien On 1/17/24 5:32 PM, Kalpesh Patel wrote: Looking at the data structure returned by F::Q that is consumed by GNC, am I correct in understanding that GNC is currently designed to consume only one quote for one or more security per firing to update it? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Enhancement: Future sched txn update if updated template.
David, Are these still just scheduled or are they created and in the registers, but simply dated in the future? If they are still scheduled but not created, then changing the template will alter them when they do fire. If they are already created, there is no solution but individual manual entry, and as I noted in my other reply, I can't imagine that being implemented, but you can certainly ask. The proper place to do so is file it on the GnuCash Bugzilla site with the prefix "RFE:" in the title. Regards, Adrien On 1/17/24 4:56 PM, David G. Pickett via gnucash-user wrote: Yes, when editing the template and there are future transactions matching the old template, I want it to ask me if I want to update the pre-scheduled old matching future transactions to match the new template. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Enhancement: Future sched txn update if updated template.
You can't. They are already created. The solution is don't create them in advance. Otherwise, you are left with the tedium of manually editing each one individually. I doubt the result of an SX has any link or record at all that it was created that way, much less has any tie to the template once created. And I don't see how this usage of future transactions is anything other than related to budgeting. Forecasting is part of budgeting, and future transactions are forecasting. Of course, you don't have to take the next official literal step and budget an amount for those future periods, but that is just a formality. Regards, Adrien On 1/17/24 5:08 PM, Kalpesh Patel wrote: if there are already scheduled transaction fired from a given SX, and then you update the template for that SX, how do you back-fill all auto added transactions from that fired SX. Remember that these auto created transactions show up in the reports which could be used for multitudes of reason, for example to understand outlay of monies for a year (which is different than budgeting IMHO). ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Enhancement: Future sched txn update if updated template.
I understood the OP referenced already created future transactions. No matter what, those have to be manually and individually edited because they were already created. I can't imagine an auto-updating template being implemented. The solution would be to use a variable, and then not have them created so far in advance of the likelihood of that variable changing. Regards, Adrien On 1/17/24 1:08 AM, David H wrote: * think * not honk - spellcheck? Fat fingers ? On Wed, 17 Jan 2024 at 5:07 pm, David H wrote: I honk he’s talking about having 1 template but the transactions have already been created 12 months in advance. I.e. he wants to update the created tens based on an updated template after the fact. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Liability Balances - All payments disappeared
A little more detail to what Michael is asking for: While viewing the Checking account register, click on View > Transaction Journal. That will show all splits in all transactions. What you should see for each payment is a debit (left column amount) to the respective credit card account, and a credit (right column amount) to the checking account. (money going into the credit card account and out of the checking account) If you do *not* see that, let us know what you do see. If you can include a screenshot of one or more of these payment transactions, that won't hurt. Feel free to obfuscate/blur any sensitive info. (and be sure to 'attach' the screenshot, do not paste it as part of the reply) But you can also just type the info in a reply if you prefer. Regards, Adrien On 1/17/24 1:14 PM, Khristine Ann Ramella wrote: Hi there! So I opened my gnu cash this am and all of my credit card accounts show huge balances. My checking still shows them as paid, but all liabilities look as if they never rcd a payment. It was fine when i closed it the other day. A glitch in the matrix? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] F::Q Interface to GNC for pricing update
Looking at the data structure returned by F::Q that is consumed by GNC, am I correct in understanding that GNC is currently designed to consume only one quote for one or more security per firing to update it? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Enhancement: Future sched txn update if updated template.
I don't think it is matter of how many SXs you have for how many transactions but is more like if there are already scheduled transaction fired from a given SX, and then you update the template for that SX, how do you back-fill all auto added transactions from that fired SX. Remember that these auto created transactions show up in the reports which could be used for multitudes of reason, for example to understand outlay of monies for a year (which is different than budgeting IMHO). -Original Message- From: David Carlson Sent: Wednesday, January 17, 2024 7:42 AM To: David H Cc: Gyle McCollam ; Gnucash Users ; David G. Pickett Subject: Re: [GNC] Enhancement: Future sched txn update if updated template. An SX can be constructed to have at least two separate register transactions, and probably as many as 12 register transactions but they may be limited to firing on the same schedule and date. I have one SX wth two register transactions that has been in service for several months. On Wed, Jan 17, 2024 at 1:09 AM David H wrote: > * think * not honk - spellcheck? Fat fingers ? > > On Wed, 17 Jan 2024 at 5:07 pm, David H wrote: > > > I honk he’s talking about having 1 template but the transactions > > have already been created 12 months in advance. I.e. he wants to > > update the created tens based on an updated template after the fact. > > > > Regards David H. > > > > On Wed, 17 Jan 2024 at 10:43 am, Gyle McCollam > wrote: > > > >> Instead of having 11 or 12 sx templates, why not have one that > >> fires monthly? > >> > >> > >> > >> Sent from Samsung Galaxy smartphone. > >> > >> > >> > >> Original message > >> From: "David G. Pickett via gnucash-user" > >> > >> Date: 1/16/24 6:18 PM (GMT-05:00) > >> To: Gnucash Users > >> Subject: [GNC] Enhancement: Future sched txn update if updated template. > >> > >> I schedule my periodic transactions a year in advance, but with > >> constant inflation, often the amount goes up. It'd be nice to have > >> a way to, by interactive option after I update the template, have > >> gnucash update the already generated future transactions to match > >> an updated template transaction, so I do not need to update 11 or 12 more > >> places. > >> ___ > >> gnucash-user mailing list > >> gnucash-user@gnucash.org > >> To update your subscription preferences or to unsubscribe: > >> https://lists.gnucash.org/mailman/listinfo/gnucash-user > >> - > >> Please remember to CC this list on all your replies. > >> You can do this by using Reply-To-List or Reply-All. > >> ___ > >> gnucash-user mailing list > >> gnucash-user@gnucash.org > >> To update your subscription preferences or to unsubscribe: > >> https://lists.gnucash.org/mailman/listinfo/gnucash-user > >> - > >> Please remember to CC this list on all your replies. > >> You can do this by using Reply-To-List or Reply-All. > >> > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Enhancement: Future sched txn update if updated template.
Yes, when editing the template and there are future transactions matching the old template, I want it to ask me if I want to update the pre-scheduled old matching future transactions to match the new template. On Wednesday, January 17, 2024 at 02:07:36 AM EST, David H wrote: I honk he’s talking about having 1 template but the transactions have already been created 12 months in advance. I.e. he wants to update the created tens based on an updated template after the fact. Regards David H. On Wed, 17 Jan 2024 at 10:43 am, Gyle McCollam wrote: Instead of having 11 or 12 sx templates, why not have one that fires monthly? Sent from Samsung Galaxy smartphone. Original message From: "David G. Pickett via gnucash-user" Date: 1/16/24 6:18 PM (GMT-05:00) To: Gnucash Users Subject: [GNC] Enhancement: Future sched txn update if updated template. I schedule my periodic transactions a year in advance, but with constant inflation, often the amount goes up. It'd be nice to have a way to, by interactive option after I update the template, have gnucash update the already generated future transactions to match an updated template transaction, so I do not need to update 11 or 12 more places. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Liability Balances - All payments disappeared
On 1/17/2024 2:14 PM, Khristine Ann Ramella wrote: Hi there! So I opened my gnu cash this am and all of my credit card accounts show huge balances. My checking still shows them as paid, but all liabilities look as if they never rcd a payment. It was fine when i closed it the other day. A glitch in the matrix? Thanks! Khris Ramella So your checking account shows transactions. Well take a look at those transactions to see what the debit side accounts were. And we are just talking about your books, yes? not what on-line banking on-line credit cards shows << in other words, YOUR books as opposed to the books of the banks >> Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Liability Balances - All payments disappeared
Hi there! So I opened my gnu cash this am and all of my credit card accounts show huge balances. My checking still shows them as paid, but all liabilities look as if they never rcd a payment. It was fine when i closed it the other day. A glitch in the matrix? Thanks! Khris Ramella ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Enhancement: Future sched txn update if updated template.
I just never tried more than two. You did! On Wed, Jan 17, 2024, 9:36 AM Stan Brown (using GC 4.14) < stan...@fastmail.fm> wrote: > On 2024-01-17 04:41, David Carlson wrote: > > An SX can be constructed to have at least two separate register > > transactions, and probably as many as 12 register transactions but they > may > > be limited to firing on the same schedule and date. I have one SX wth > two > > register transactions that has been in service for several months. > > I'm wondering about the significance of your "probably as many as 12". > > My end-of-month SX, which contains deprecation of physical assets and > amortization of prepayments such as insurance, property tax, HOA > assessments, and subscriptions, has 29 transactions of two splits each. > There are no formulas, however. > > Stan Brown > Tehachapi, CA, USA > https://BrownMath.com > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Deferred Income << the general case is "imputed income"
I appreciate the various input here; it has been educational, so I wanted particularly to add my thanks. On Tue, Jan 16, 2024 at 4:17 PM Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > On 1/16/2024 1:42 PM, Adrien Monteleone wrote: > > I'm thinking of a case where someone starts using GnuCash either at > > the point they start taking disbursements or after. I'm about to help > > a family member in that exact situation. > > > > While Deferred Income wasn't tracked along the way, I'll set up the > > account with the present total as an opening balance and have them > > transfer against that each distribution. > > That's a reasonable solution. > > I'd do it under equity. You can create for them there an account with a > name like "deferred income". Presumably when you started the books for > them, the other side of the transaction(*) entering the IRA balance as > an asset was equity. All you would be doing now would be to "partition" > equity transferring the remaining IRA balance form undifferentiated > equity to ":deferred income:. > > Then as distributions are taken, the debits would be bank account and > deferred income and the credits the IRA balance and income > (current/taxable income) > > While this isn't necessary, could just debit equity, if you have the > deferred income separated out it SHOWS. I'd certainly want my balance > sheet to show that some of my net worth has a tax liability associated > with it. > > Michael D Novack > > * If you used the "starting balance" tool no explicit transaction. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Enhancement: Future sched txn update if updated template.
On 2024-01-17 04:41, David Carlson wrote: > An SX can be constructed to have at least two separate register > transactions, and probably as many as 12 register transactions but they may > be limited to firing on the same schedule and date. I have one SX wth two > register transactions that has been in service for several months. I'm wondering about the significance of your "probably as many as 12". My end-of-month SX, which contains deprecation of physical assets and amortization of prepayments such as insurance, property tax, HOA assessments, and subscriptions, has 29 transactions of two splits each. There are no formulas, however. Stan Brown Tehachapi, CA, USA https://BrownMath.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Enhancement: Future sched txn update if updated template.
An SX can be constructed to have at least two separate register transactions, and probably as many as 12 register transactions but they may be limited to firing on the same schedule and date. I have one SX wth two register transactions that has been in service for several months. On Wed, Jan 17, 2024 at 1:09 AM David H wrote: > * think * not honk - spellcheck? Fat fingers ? > > On Wed, 17 Jan 2024 at 5:07 pm, David H wrote: > > > I honk he’s talking about having 1 template but the transactions have > > already been created 12 months in advance. I.e. he wants to update the > > created tens based on an updated template after the fact. > > > > Regards David H. > > > > On Wed, 17 Jan 2024 at 10:43 am, Gyle McCollam > wrote: > > > >> Instead of having 11 or 12 sx templates, why not have one that fires > >> monthly? > >> > >> > >> > >> Sent from Samsung Galaxy smartphone. > >> > >> > >> > >> Original message > >> From: "David G. Pickett via gnucash-user" > >> Date: 1/16/24 6:18 PM (GMT-05:00) > >> To: Gnucash Users > >> Subject: [GNC] Enhancement: Future sched txn update if updated template. > >> > >> I schedule my periodic transactions a year in advance, but with constant > >> inflation, often the amount goes up. It'd be nice to have a way to, by > >> interactive option after I update the template, have gnucash update the > >> already generated future transactions to match an updated template > >> transaction, so I do not need to update 11 or 12 more places. > >> ___ > >> gnucash-user mailing list > >> gnucash-user@gnucash.org > >> To update your subscription preferences or to unsubscribe: > >> https://lists.gnucash.org/mailman/listinfo/gnucash-user > >> - > >> Please remember to CC this list on all your replies. > >> You can do this by using Reply-To-List or Reply-All. > >> ___ > >> gnucash-user mailing list > >> gnucash-user@gnucash.org > >> To update your subscription preferences or to unsubscribe: > >> https://lists.gnucash.org/mailman/listinfo/gnucash-user > >> - > >> Please remember to CC this list on all your replies. > >> You can do this by using Reply-To-List or Reply-All. > >> > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
