Re: [GNC] Finance::Quote failed to initialize

2024-10-07 Thread John Ralls
Yay. Proceed to install Finance::Quote and JSON::Parse.You can use cpan directly or gnc-fq-update, which is just a shell that runs cpan, as you prefer. One more thing to check: Does /System/Library/Perl/5.34/Pod/Find.pm exist? I expect it doesn’t, as it doesn’t on either of my Sequoia Macs. That

Re: [GNC] Newbie trouble deleting transaction

2024-10-07 Thread John Ralls
If it’s blank except for a date then it’s the “blank transaction”. It’s there to give you a place to enter new transactions. You can’t delete it because it’s just space in the form: There’s no transaction until you fill it in and commit it. Regards, John Ralls > On Oct 6, 2024, at 23:04, Paul

Re: [GNC] Automatic capital gains question

2024-10-07 Thread David Carlson
Jon, There is a big 'Gotcha' in the calculation of capital gains and losses consisting mainly of the transaction fees. IIRC, the lot feature does not work correctly if you do not embed those costs into the cost basis, but your brokerage confirmations usually list the fees separately, so you need

Re: [GNC] To whoever explained the 4% safe withdrawal rule - thank you

2024-10-07 Thread R Losey
I want to add my thanks; it was a clear explanation, and interesting reading. On Sun, Oct 6, 2024 at 4:22 PM Bruce Griffis wrote: > That is a great explanation! And I really like Jane Bryant Quinn's book. > It was good reading through that and getting an understanding. I think I > need to reread

Re: [GNC] Finance::Quote failed to initialize

2024-10-07 Thread Kalpesh Patel
It really depends upon which source you will be using to get the pricing for your commodities. F::Q is collection of difference sources contributed by member which GNC relies to retrieve pricing information. Out of those some require API key and some don't. You specify the source to use in the s

Re: [GNC] Newbie trouble deleting transaction

2024-10-07 Thread R Losey
Just for clarification, but "last", it is meant "the only transaction in the register", not the "last" (latest one you entered); I often delete the latest transaction. On Mon, Oct 7, 2024 at 1:25 AM Geoff Jankowski via gnucash-user < gnucash-user@gnucash.org> wrote: > If it is the last entry in t

Re: [GNC] Convert xml <-> sqlite on command line

2024-10-07 Thread sunfish62--- via gnucash-user
I guess I'd just ask what the purpose would be. Why change back and forth? If you need SQL for some purpose (e.g., to probe your financial data outside of GnuCash) then why not keep the data in SQL all the time? I generally don't have that need, so I've kept my data in xml, but I've occasiona

Re: [GNC] Newbie trouble deleting transaction

2024-10-07 Thread David Cousens
Geoff Have no problem deleting the last transaction in a register at least on 5.9 on Linux Mint, Don't ever remember having any problems deleting transactions previously. There is a popup asking for confirmation of deletion though. Paul do you get a popup confirmation window?  Is it possible it is

Re: [GNC] Finance::Quote failed to initialize

2024-10-07 Thread Boniforti Flavio
Hello John. Yes, the file exists: me@MacBook-Pro ~ % ls -la /Library/Perl/5.34/Test total 336 drwxr-xr-x 10 root wheel320 Oct 6 20:43 . drwxr-xr-x 8 root wheel256 Oct 6 20:44 .. drwxr-xr-x 8 root wheel256 Oct 6 20:43 Builder -r--r--r-- 1 root wheel 64973 Sep 14 19:

Re: [GNC] To whoever explained the 4% safe withdrawal rule - thank you

2024-10-07 Thread Stan Brown (using GC 4.14)
On 2024-10-06 14:22, Bruce Griffis wrote: > > I like to think we'll be okay taking out 4% adjusted for inflation, but > the reality is that if my health fails things will get real expensive > real quick. If my wife's health fails more than I am able to provide > care for, the same thing happens. A

Re: [GNC] Convert xml <-> sqlite on command line

2024-10-07 Thread Kevin Buckley via gnucash-user
On Sunday, October 6th, 2024 at 23:26, Michael or Penny Novack via gnucash-user wrote: > > On 10/5/2024 5:18 PM, Eberhard Beilharz wrote: > > > Hi, > > is there a way to convert a Gnucash file in XML format to SQLite > > format on the command line and the reverse? > > I know I can do Save As in

[GNC] Automatic capital gains question

2024-10-07 Thread Jon Schewe
I've been tracking my investments in GnuCash for some time, however haven't been using the capital gains features to track gains and losses. I recently spent time reading the sections of the manual about what accounts to create for gains and losses and how to use the lots feature to scrub an accoun

Re: [GNC] Newbie trouble deleting transaction

2024-10-07 Thread Kalpesh Patel
Telltale sign of such a “blank transaction” is that it will have today's date filled-in -- and no other columns -- for the entire transaction when you look at it in the register. -Original Message- From: John Ralls Sent: Monday, October 07, 2024 10:39 AM To: Paul-A Cc: gnucash-user@gn

Re: [GNC] Finance::Quote failed to initialize

2024-10-07 Thread Boniforti Flavio
Hi John. Now I was able to install Finance::Quote --> me@MacBook-Pro ~ % /Applications/Gnucash.app/Contents/MacOS/gnucash-cli -Q info Application Path /Applications/Gnucash.app/Contents/MacOS/gnucash-cli * 16:58:23 WARN [GncFQQuoteSource::set_api_key()] No Alpha Vantage API key set, currency q

Re: [GNC] Automatic capital gains question

2024-10-07 Thread NoobAlice
On 2024-10-07 09:52 PM, Jon Schewe wrote: In my case there are no transaction fees, those are handled separately though a cash account. However that wouldn't explain why the numbers don't add up. Shouldn't GnuCash put the trades into lots and if I've sold off all of my shares shouldn't all of the

Re: [GNC] Specify account for realized gains/loss

2024-10-07 Thread Christopher Lam
Are you using the Stock Transaction assistant? On Tue, 8 Oct 2024, 11:05 am Jon Schewe, wrote: > Looking at the bottom > of > https://www.gnucash.org/docs/v5/C/gnucash-guide/invest-sell1.html#invest-sellChgCapGainsAcctExample > it seems to me that one needs to manually edit all transactions > c

Re: [GNC] Newbie trouble deleting transaction

2024-10-07 Thread Paul-A via gnucash-user
Thanks for all the replies... no popup, and no indication that anything happened or is supposed to. It is the last entry, showing today's date, maybe I should've clued into that, since I thought it was from a few days ago. Is it just my imagination then that I entered this, and it's just the norm

Re: [GNC] Automatic capital gains question

2024-10-07 Thread Jon Schewe
In my case there are no transaction fees, those are handled separately though a cash account. However that wouldn't explain why the numbers don't add up. Shouldn't GnuCash put the trades into lots and if I've sold off all of my shares shouldn't all of the buys minus the sells give me my capital gai

[GNC] Specify account for realized gains/loss

2024-10-07 Thread Jon Schewe
Looking at the bottom of  https://www.gnucash.org/docs/v5/C/gnucash-guide/invest-sell1.html#invest-sellChgCapGainsAcctExample  it seems to me that one needs to manually edit all transactions created by GnuCash for Capital Gains/Loss to assign another account. Is there a way to tell GnuCash what acc

Re: [GNC] To whoever explained the 4% safe withdrawal rule - thank you

2024-10-07 Thread Stan Brown (using GC 4.14)
Thanks for the kind words! Stan Brown Tehachapi, CA, USA https://BrownMath.com On 2024-10-07 09:57, R Losey wrote: > I want to add my thanks; it was a clear explanation, and interesting > reading. ___ gnucash-user mailing list gnucash-user@gnucash.org T

Re: [GNC] To whoever explained the 4% safe withdrawal rule - thank you

2024-10-07 Thread Stan Brown (using GC 4.14)
Thanks for that, Alice. I didn't know that existed, but I'll find it useful. Stan Brown Tehachapi, CA, USA https://BrownMath.com On 2024-10-06 15:02, NoobAlice via gnucash-user wrote: > For those of us in the USA, the federal BLS has a nice inflation > calculator that can take a dollar amount on

Re: [GNC] Newbie trouble deleting transaction

2024-10-07 Thread Geoff Jankowski via gnucash-user
Sorry, Let me clarify. By last transaction in the register I mean the blank entry for the next input. This is the one that users cannot delete. Paul, let us know if you have sorted it or are still having problems. Geoff +33 6 22 93 00 53 +44 7770 58 48 38 > On 8 Oct 2024, at 05:53, Paul-A vi

Re: [GNC] Newbie trouble deleting transaction

2024-10-07 Thread Geoff Jankowski via gnucash-user
Yes it is the default entry for the next input. Be aware that it does not default to today’s date except on opening GNC. After that it will show the date of your last entry. I guess it assumes you have more transactions to enter with the same date. Geoff +33 6 22 93 00 53 +44 7770 58 48 38