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

[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 will cause 
a single test in Finance::Quote to fail. You can use cpan -f Finance::Quote to 
force it to install anyway. Do that after everything else is installed, you 
don’t want to force all of the dependencies.

Regards,
John Ralls

> On Oct 7, 2024, at 00:29, Boniforti Flavio  wrote:
> 
> 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:32 Builder.pm
> -r--r--r--   1 root  wheel  54359 Sep 14 19:32 More.pm
> -r--r--r--   1 root  wheel   6479 Sep 14 19:32 Simple.pm
> drwxr-xr-x   5 root  wheel160 Oct  6 20:43 Tester
> -r--r--r--   1 root  wheel  18323 Sep 14 19:32 Tester.pm
> -r--r--r--   1 root  wheel  19346 Sep 14 19:32 Tutorial.pod
> drwxr-xr-x   3 root  wheel 96 Oct  6 20:43 use
> 
> F.
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com 
> 
> Am Mo., 7. Okt. 2024 um 00:07 Uhr schrieb John Ralls  >:
>> Flavio,
>> 
>> OK, good. Does /Library/Perl/5.34/Test/Simple.pm exist?
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Oct 6, 2024, at 11:45, Boniforti Flavio >> > wrote:
>>> 
>>> Hi John.
>>> 
>>> The output of "sudo cpan Test::Simple" is very long, the last part being:
>>> 
>>> Appending installation info to 
>>> /Library/Perl/Updates/5.34.1/darwin-thread-multi-2level/perllocal.pod
>>>   EXODIST/Test-Simple-1.302204.tar.gz
>>>   /usr/bin/make install  -- OK
>>> 
>>> Do you need more output?
>>> F.
>>> 
>>> https://www.instagram.com/boniforti_music
>>> https://soundcloud.com/boniforti_music
>>> https://bonny-j.bandcamp.com 
>>> 
>>> Am So., 6. Okt. 2024 um 18:37 Uhr schrieb John Ralls >> >:
 Flavio,
 
 No, you don’t need to install perl from Homebrew. You’d also have to edit 
 GnuCash’s environment file to make it work and there’s no benefit. We were 
 chasing the Homebrew perl possibility trying to figure out if 
 Finance::Quote’s dependencies had gotten installed.
 
 Your list shows that everything got at least downloaded, so at least that 
 much worked. IIRC Test::Simple has no dependencies,, so try 
   sudo cpan Test::Simple
 If you followed Bruce’s instruction to chown ~/.cpan leave off sudo.
 
 What’s the output?
 
 Regards,
 John Ralls
 
 
> On Oct 6, 2024, at 03:39, Boniforti Flavio  > wrote:
> 
> Hi John.
> 
> Yes, indeed I used gnc-fq-update.
> 
> Do you suggest that I get Perl from Homebrew? If so, do I need to 
> uninstall the existing Perl installation (which apparently came with 
> MacOS)?
> 
> Here's the output of the ls command:
> 
> bonny@Flavios-MacBook-Pro ~ % ls ~/.cpan/build
> Archive-Any-Lite-0.11-0   HTTP-Daemon-6.16-0  
> Sereal-Decoder-5.004-0
> Archive-Any-Lite-0.11-0.yml   HTTP-Daemon-6.16-0.yml  
> Sereal-Decoder-5.004-0.yml
> Array-Diff-0.09-0 JSON-Parse-0.62-0   
> Sereal-Encoder-5.004-0
> Array-Diff-0.09-0.yml JSON-Parse-0.62-0.yml   
> Sereal-Encoder-5.004-0.yml
> B-Keywords-1.27-0 Lingua-EN-Inflect-1.905-0   
> Software-License-0.104006-0
> B-Keywords-1.27-0.yml 
> Lingua-EN-Inflect-1.905-0.yml   
> Software-License-0.104006-0.yml
> Config-Tiny-2.30-0List-SomeUtils-0.59-0   
> Spreadsheet-ParseExcel-0.66-0
> Config-Tiny-2.30-0.yml
> List-SomeUtils-0.59-0.yml   
> Spreadsheet-ParseExcel-0.66-0.yml
> Crypt-RC4-2.02-0  List-SomeUtils-XS-0.58-0
> Spreadsheet-XLSX-0.18-0
> Crypt-RC4-2.02-0.yml  
> List-SomeUtils-XS-0.58-0.yml
> Spreadsheet-XLSX-0.18-0.yml
> Data-Binary-0.01-0MCE-1.900-0 
> String-Format-1.18-0
> Data-Binary-0.01-0.ymlMCE-1.900-0.yml 
> 

Re: [GNC] Newbie trouble deleting transaction

[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-A via gnucash-user  
> wrote:
> 
> I've just started using gnucash, and have imported a few years worth of
> data successfully from a bank account.  Afterwards I manually entered
> two more transactions, where one is mistaken.
> 
> I'd like to remove the mistake, but am unable to do so with either
> the Delete button or "Delete transaction" menu choice.  Shouldn't I
> at least get some error if something is failing?
> 
> The transaction I'm removiing is blank except for a date.
> 
> Am I missing something obvious or could something be wrong with my
> 4.13 setup on Debian bookworm?
> ___
> 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] Automatic capital gains question

[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
to be aware of that when you enter your data into GnuCash.  I am old school
so I track gains in a spreadsheet and manually link lots, so I have not
tried using lots lately to see if that has changed in the last few years.
If you live in the U.S., your brokerage statements list the correct values
according to U.S. law and whatever agreement you have with your broker
regarding lot selection, FIFO by default, or other.

On Mon, Oct 7, 2024 at 6:26 AM Jon Schewe  wrote:

> 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 account to determine gains and loses across
> multiple transactions. I've now tried it on one of my investment
> accounts where I purchased shares over multiple transactions and then
> eventually sold all shares over some amount of time. So the balance in
> the account is currently zero. I tried using the automatic gains
> feature and am left with a question about the value of the gains. In my
> mind the gains/loses should be equivalent to me adding up how much I
> paid for all shares and subtracting from that how much I sold all
> shares for and that tells me my gains. I compared that with what shows
> up in my capital gains account after the scrub and they don't match. Is
> this expected and I'm not understanding something about how GnuCash
> computes capital gains?
>
> Jon
>
> ___
> 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] To whoever explained the 4% safe withdrawal rule - thank you

[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 it again and ask my wife to read it so we are both on the
> same page. I've tried Wade Pfau's book a few times, but that is too in
> depth for me. I'll take a closer look at guardrails.
>
>
> On 10/6/24 14:10, Stan Brown (using GC 4.14) wrote:
> > This may not be relevant to GnuCash, but I'm a retiree too, and
> > strategies for retirement spending are certainly interesting to me. I'm
> > not a financial professional, nor was I one before retirement, but I've
> > done a lot of reading over the past 10 years and will be happy to
> > exchange knowledge, which we can each take with a pinch of salt.
> >
> > I've written some initial thoughts below. If this is too off topic for
> > the mailing list, feel free to email me off list if you want to talk
> > more about this. (That's not just for Bruce, but for anyone interested.)
> >
> > On 2024-10-06 09:56, Bruce Griffis wrote:
> >> So I also misunderstood the 4% rule. I figured I would calculate it as I
> >> can take out 4% of my investments in 2024, then in 2025 take out 4%
> >> based on what I had in my portfolio as of 1/1/2025. And I misunderstood
> > Maybe you were confused because that's actually how the Required Minimum
> > Distribution from an IRA works.(*) Each calendar year you must withdraw
> > a certain fraction of the balance in your IRA at the end of the previous
> > year. In 2024 you withdraw that fraction of your balance on 2023-12-31,
> > in 2025 the fraction of your balance on 2024-12-31, and so on. The
> > "certain fraction" is in the mortality tables in Publication 590-B.
> >
> > (*) I assume you're in the US.
> >
> > But that's how much you must withdraw from your IRA, and what you
> > actually need to spend may well be different. The IRS tables are
> > designed to have the average person draw their account down to zero
> > before they die. To accomplish this, the withdrawal amounts are
> > typically above the 4% level, and the percentages increase as you age.
> >
> >> it. I recalculated based on 4% of what was in investments on the day I
> >> retired, then checked inflation rate (2.5% on August 2024 - I would need
> >> to check again at the end of the year) - and compared it to 4% of what I
> >> have in my portfolio today - and there was over a 2K difference in
> >> calculations. I could have taken out too much.
> > This sounds like the strategy in many books, such as Jane Bryant Quinn's
> > excellent /How to Make Your Money Last/. The idea is you look at your
> > total portfolio (not just IRA) when you retire, and spend no more than
> > 4% in the following year. Each year after that your spending limit is
> > the same number of dollars, adjusted for the year's inflation, not the
> > same percentage. If you stick with this plan, conventional wisdom
> > (backed up by some computer analyses) is that you have a very good
> > chance of not running out of money before you die.
> >
> > If the amount you must withdraw from your IRA for your Required Minimum
> > Distribution exceeds your spending limit for the year, you don't spend
> > the excess but plow it back into investments. (You can't put it back
> > into a traditional IRA, nor into a Roth IRA.)
> >
> > Quinn discusses how you can determine whether the right starting number
> > is 4%, 4½%, or something else.
> >
> > But this strategy has a couple of vulnerabilities. For one, what if your
> > portfolio really tanks one year? Since this strategy does not take
> > investment performance into account, spending on your regular schedule
> > could dangerously drain your assets, locking in losses. Then when the
> > portfolio rises again, the shares you liquidated are gone, so your
> > assets don't recover as much as they would have if you'd cut back on
> > spending.
> >
> > One solution for this is to add "guardrails" to the basic strategy. Do a
> > google search for "guardrails retirement withdrawal" (without quotes),
> > or begin at
> > <
> https://www.cnbc.com/select/guardrails-approach-retirement-withdrawal-strategy-how-it-works/
> >.
> >
> >
> >> So, note to self. Each year check what was in investments on date of
> >> retirement. Check inflation rate. Recalculate safe withdrawal amount.
> > What matters in year N is not what your portfolio was at retirement, but
> > rather what your spending limit was in year N-1, and the year's
> > inflation. Your portfolio's _current_ value will be relevant, if you add
> > a guardrail strategy, but the historical value at retirement isn't part
> > of the calculations.
> >
> >> Now I need to go back and read up on what to do in years three, four,
> >> five, ... - I only know what to do in years one (4%) and two (4% plus
> >> annual inflation rate).
> > Suppose you ret

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

[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 security 
setup page (Tools --> Security Editor; "double click" any security; at the 
bottom of the displayed page) will display how your security is setup to 
retrieve "last" pricing. By default "Get Online Quotes" is not checked in that 
"Edit Security" box, meaning don't get them from online.

For currency conversion, F::Q defaults to Alphavantage as the source which DOES 
require an API key. Not sure if F::Q dev have changed it to default to some 
other as Alphavantage has gotten to the point where it is not so useful for 
free as they limit number of requests and throttles them.

For securities, if you use Yahoo for price, if it is available from them, then 
you don't need anything, and you can safely ignore the warning message for 
Alphavantage. For most, other than Alphavanatage you define a specific env 
variable for API key, if it is required, which gets read by F::Q when it is run 
to retrieve prices (Tools --> Price Database). For Alphavantage you can either 
define via an env variable or you can set it in GNC (Edit --> Preferences --> 
Online Quotes). Devs, correct me if this usage has changed in anyway. 

Since you are using F::Q outside of GNC (calling F::Q on command line is 
outside of GNC 😊), it is better to define an env variable for it. The perldoc 
for F::Q lists what variable name should be for a specific module, thus the 
source that you will select in the security editor window. You can defined this 
way for as many sources you want to use and they all will happily live with 
each other without complaining or stepping on each other.

-Original Message-
From: Boniforti Flavio  
Sent: Monday, October 07, 2024 11:03 AM
To: John Ralls 
Cc: GnuCash users group 
Subject: Re: [GNC] Finance::Quote failed to initialize

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 quotes and other AlphaVantage based quotes won't 
work.

Found Finance::Quote version 1.63.

Finance::Quote sources:

aex  alphavantage  amfiindiaasegrasx


aufunds  australiabamosz   bats bet  bloomberg


borsa_italianabourso   bse  bseindia bvb


canada   comdirectconsorsbank  cse  deka dutch


dwsfunds europe   fetch_live_currencies financeapi

finanzpartner fondsweb fool france   ftfunds


goldmoneygooglewebgreece   hu   hufund   hungary


hustock  iexcloud indiaindiamutual  known_currencies


marketwatch  morningstarau morningstarch

morningstarjp morningstaruk mstaruk  nasdaq


nseindia nyse nzx  onvista  oslobors poland


romania  seb_fundssinvestorsix  stockdatastooq


tesouro_diretotiaacref tmx  tradegatetradeville


treasurydirecttroweprice   troweprice_direct tsp


tsx  twelvedata   ukfunds  unionfunds   usa  xetra


yahoo_json   yahoojsonyahooweb za

Do you still recommend to install "Find.pm"?
And now, to get the quotes, do I need to somehow "subscribe" to a service and 
get/use an API key? I'm asking because of this:

me@MacBook-Pro ~ % /Applications/Gnucash.app/Contents/MacOS/gnucash-cli -Q dump 
currency USD CHF EUR

Application Path /Applications/Gnucash.app/Contents/MacOS/gnucash-cli

* 16:58:56  WARN  [GncFQQuoteSource::set_api_key()] No Alpha 
Vantage API key set, currency quotes and other AlphaVantage based quotes won't 
work.

CHF Finance::Quote returned no data and set no error.

EUR Finance::Quote returned no data and set no error.

Thanks,
F.

https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com


Am Mo., 7. Okt. 2024 um 16:36 Uhr schrieb 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 
> will cause a single test in Finance::Quote to fail. You can use cpan 
> -f Finance::Quote to force it to install anyway. Do that after 
> everything else is installed, you don’t want to force all of the dependencies.
>
> Regards,
> John Ralls
>
> On Oct 7, 2024, at 00:29, Boniforti Flavio  wrot

Re: [GNC] Newbie trouble deleting transaction

[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 the register it cannot be deleted.
>
> If it has entries above and below it, you should be able to delete it and
> if you cannot, there is an issue.
>
> Geoff
> +33 6 22 93 00 53
> +44 7770 58 48 38
>
> > On 7 Oct 2024, at 08:05, Paul-A via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >
> > I've just started using gnucash, and have imported a few years worth of
> > data successfully from a bank account.  Afterwards I manually entered
> > two more transactions, where one is mistaken.
> >
> > I'd like to remove the mistake, but am unable to do so with either
> > the Delete button or "Delete transaction" menu choice.  Shouldn't I
> > at least get some error if something is failing?
> >
> > The transaction I'm removiing is blank except for a date.
> >
> > Am I missing something obvious or could something be wrong with my
> > 4.13 setup on Debian bookworm?
> > ___
> > 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.
>


-- 
_
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] Convert xml <-> sqlite on command line

[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 
occasionally used SQL queries against the data, so I just saved to SQL as 
needed. It's really not that much of a burden for occasional purposes. 

⁣David T. ​

On Oct 7, 2024, 1:57 PM, at 1:57 PM, Kevin Buckley via gnucash-user 
 wrote:
>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 the Gnucash UI, but I would like to do
>it
>> > from the command line so that I can automate it.
>> > Thanks,
>> > Eberhard
>
>I am not aware of any existing tools that do that - in either
>direction.
>
>Back in the day, ..., when files were saved, by default, with a 
>dot-xac extension, it might have been really simple to do it
>using GnuCash, from the command line, in that much/most of the 
>functionality inside the application was coded in Guile/Scheme 
>and so you could load the "GnuCash library" into, and do some 
>basic stuff inside, a Guile interpreter, but I'm guessing that 
>may no longer be an option for you, as there's been a lot of C++ 
>added over the years (and a lot of C "upgraded" to C++) although 
>one of the Devs might know if enough of the Guile library routines
>are still/now in there, and accessible.
>
>Then again, the ability to talk to a "database backend" itself 
>is "fairly recent", at least in geological time spans, so maybe 
>there are no Guile mappings for the "export to SQL" capability, 
>in which case you are looking at something like an XSLT transform 
>to go in the 
>
> xml -> sqlite
>
>direction, and some sqlite parsing tool/library for the other
>direction.
>
>The "trick" will be im mimicing GnuCash's internal data structures,
>so that you don't lose anything (or maybe even add something!) 
>across the transformations. 
>
>As Michael D Novack suggests though, it should be do-able, given
>enough time and effort.
>
>
>___
>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] Newbie trouble deleting transaction

[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 hidden?

David Cousens

On Mon, 2024-10-07 at 08:24 +0200, Geoff Jankowski via gnucash-user
wrote:
> If it is the last entry in the register it cannot be deleted. 
> 
> If it has entries above and below it, you should be able to delete it
> and if you cannot, there is an issue. 
> 
> Geoff
> +33 6 22 93 00 53
> +44 7770 58 48 38
> 
> > On 7 Oct 2024, at 08:05, Paul-A via gnucash-user
> >  wrote:
> > 
> > I've just started using gnucash, and have imported a few years
> > worth of
> > data successfully from a bank account.  Afterwards I manually
> > entered
> > two more transactions, where one is mistaken.
> > 
> > I'd like to remove the mistake, but am unable to do so with either
> > the Delete button or "Delete transaction" menu choice.  Shouldn't I
> > at least get some error if something is failing?
> > 
> > The transaction I'm removiing is blank except for a date.
> > 
> > Am I missing something obvious or could something be wrong with my
> > 4.13 setup on Debian bookworm?
> > ___
> > 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] Finance::Quote failed to initialize

[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:32 Builder.pm

-r--r--r--   1 root  wheel  54359 Sep 14 19:32 More.pm

-r--r--r--   1 root  wheel   6479 Sep 14 19:32 Simple.pm

drwxr-xr-x   5 root  wheel160 Oct  6 20:43 Tester

-r--r--r--   1 root  wheel  18323 Sep 14 19:32 Tester.pm

-r--r--r--   1 root  wheel  19346 Sep 14 19:32 Tutorial.pod

drwxr-xr-x   3 root  wheel 96 Oct  6 20:43 use

F.
https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com


Am Mo., 7. Okt. 2024 um 00:07 Uhr schrieb John Ralls :

> Flavio,
>
> OK, good. Does /Library/Perl/5.34/Test/Simple.pm exist?
>
> Regards,
> John Ralls
>
>
> On Oct 6, 2024, at 11:45, Boniforti Flavio  wrote:
>
> Hi John.
>
> The output of "sudo cpan Test::Simple" is very long, the last part being:
>
> Appending installation info to
> /Library/Perl/Updates/5.34.1/darwin-thread-multi-2level/perllocal.pod
>   EXODIST/Test-Simple-1.302204.tar.gz
>   /usr/bin/make install  -- OK
>
> Do you need more output?
> F.
>
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
>
>
> Am So., 6. Okt. 2024 um 18:37 Uhr schrieb John Ralls :
>
>> Flavio,
>>
>> No, you don’t need to install perl from Homebrew. You’d also have to edit
>> GnuCash’s environment file to make it work and there’s no benefit. We were
>> chasing the Homebrew perl possibility trying to figure out if
>> Finance::Quote’s dependencies had gotten installed.
>>
>> Your list shows that everything got at least downloaded, so at least that
>> much worked. IIRC Test::Simple has no dependencies,, so try
>>   sudo cpan Test::Simple
>> If you followed Bruce’s instruction to chown ~/.cpan leave off sudo.
>>
>> What’s the output?
>>
>> Regards,
>> John Ralls
>>
>>
>> On Oct 6, 2024, at 03:39, Boniforti Flavio  wrote:
>>
>> Hi John.
>>
>> Yes, indeed I used gnc-fq-update.
>>
>> Do you suggest that I get Perl from Homebrew? If so, do I need to
>> uninstall the existing Perl installation (which apparently came with MacOS)?
>>
>> Here's the output of the ls command:
>>
>> bonny@Flavios-MacBook-Pro ~ % ls ~/.cpan/build
>> Archive-Any-Lite-0.11-0 HTTP-Daemon-6.16-0 Sereal-Decoder-5.004-0
>> Archive-Any-Lite-0.11-0.yml HTTP-Daemon-6.16-0.yml
>> Sereal-Decoder-5.004-0.yml
>> Array-Diff-0.09-0 JSON-Parse-0.62-0 Sereal-Encoder-5.004-0
>> Array-Diff-0.09-0.yml JSON-Parse-0.62-0.yml Sereal-Encoder-5.004-0.yml
>> B-Keywords-1.27-0 Lingua-EN-Inflect-1.905-0 Software-License-0.104006-0
>> B-Keywords-1.27-0.yml Lingua-EN-Inflect-1.905-0.yml
>> Software-License-0.104006-0.yml
>> Config-Tiny-2.30-0 List-SomeUtils-0.59-0 Spreadsheet-ParseExcel-0.66-0
>> Config-Tiny-2.30-0.yml List-SomeUtils-0.59-0.yml
>> Spreadsheet-ParseExcel-0.66-0.yml
>> Crypt-RC4-2.02-0 List-SomeUtils-XS-0.58-0 Spreadsheet-XLSX-0.18-0
>> Crypt-RC4-2.02-0.yml List-SomeUtils-XS-0.58-0.yml
>> Spreadsheet-XLSX-0.18-0.yml
>> Data-Binary-0.01-0 MCE-1.900-0 String-Format-1.18-0
>> Data-Binary-0.01-0.yml MCE-1.900-0.yml String-Format-1.18-0.yml
>> Data-Section-0.28-0 Mock-Config-0.03-0 String-Util-1.35-0
>> Data-Section-0.28-0.yml Mock-Config-0.03-0.yml String-Util-1.35-0.yml
>> Date-Manip-6.95-0 Module-CPANTS-Analyse-1.02-0 Test-FailWarnings-0.008-0
>> Date-Manip-6.95-0.yml Module-CPANTS-Analyse-1.02-0.yml
>> Test-FailWarnings-0.008-0.yml
>> Date-Range-1.41-0 Module-CPANfile-1.1004-0 Test-File-1.993-0
>> Date-Range-1.41-0.yml Module-CPANfile-1.1004-0.yml Test-File-1.993-0.yml
>> Date-Simple-3.03-0 Mozilla-CA-20240924-0 Test-Inter-1.11-0
>> Date-Simple-3.03-0.yml Mozilla-CA-20240924-0.yml Test-Inter-1.11-0.yml
>> DateTime-Format-Builder-0.83-0 Mozilla-PublicSuffix-v1.0.7-0
>> Test-Kwalitee-1.28-0
>> DateTime-Format-Builder-0.83-0.yml Mozilla-PublicSuffix-v1.0.7-0.yml
>> Test-Kwalitee-1.28-0.yml
>> DateTime-Format-ISO8601-0.16-0 OLE-Storage_Lite-0.22-0
>> Test-LeakTrace-0.17-0
>> DateTime-Format-ISO8601-0.16-0.yml OLE-Storage_Lite-0.22-0.yml
>> Test-LeakTrace-0.17-0.yml
>> DateTime-Format-Strptime-1.79-0 PPI-1.279-0 Test-LongString-0.17-0
>> DateTime-Format-Strptime-1.79-0.yml PPI-1.279-0.yml
>> Test-LongString-0.17-0.yml
>> DateTime-Locale-1.43-0 PPIx-QuoteLike-0.023-0 Test-More-UTF8-0.05-0
>> DateTime-Locale-1.43-0.yml PPIx-QuoteLike-0.023-0.yml
>> Test-More-UTF8-0.05-0.yml
>> Devel-CheckLib-1.16-0 PPIx-Regexp-0.088-0 Test-NoWarnings-1.06-0
>> Devel-CheckLib-1.16-0.yml PPIx-Regexp-0.088-0.yml
>> Test-NoWarnings-1.06-0.yml
>> Devel-Symdump-2.18-0 PPIx-Utils-0.003-0 Test-Perl-Critic-1.04-0
>> Devel-Symdump-2.18-0.yml PPIx-Utils-0.003-0.yml
>> Test-Perl-Critic-1.04-0.yml
>> Digest-Perl-MD5-1.9-0 Parse-Distname-0.05-0 Test-Pod-Coverage-1.10-0
>> Digest-Perl-MD5-1.9-0.yml Parse-Distname-0.05-0.yml
>> T

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

[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. And if both of our health fails, we'll
> need all of that IRA and then some. My wife can't get life insurance or
> long term care insurance, but I carry a life insurance policy on myself
> to help offset costs for my wife if I go first.

I think you need to pay attention to your feeling that 4% is too much.
There's a "sleep-at-night factor" for withdrawals from investments, just
as there is for selecting choosing a ratio of stocks to bonds in your
portfolio, or choosing individual stocks and bonds versus mutual funds.

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] Convert xml <-> sqlite on command line

[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 the Gnucash UI, but I would like to do it
> > from the command line so that I can automate it.
> > Thanks,
> > Eberhard

I am not aware of any existing tools that do that - in either
direction.

Back in the day, ..., when files were saved, by default, with a 
dot-xac extension, it might have been really simple to do it
using GnuCash, from the command line, in that much/most of the 
functionality inside the application was coded in Guile/Scheme 
and so you could load the "GnuCash library" into, and do some 
basic stuff inside, a Guile interpreter, but I'm guessing that 
may no longer be an option for you, as there's been a lot of C++ 
added over the years (and a lot of C "upgraded" to C++) although 
one of the Devs might know if enough of the Guile library routines
are still/now in there, and accessible.

Then again, the ability to talk to a "database backend" itself 
is "fairly recent", at least in geological time spans, so maybe 
there are no Guile mappings for the "export to SQL" capability, 
in which case you are looking at something like an XSLT transform 
to go in the 

 xml -> sqlite

direction, and some sqlite parsing tool/library for the other
direction.

The "trick" will be im mimicing GnuCash's internal data structures,
so that you don't lose anything (or maybe even add something!) 
across the transformations. 

As Michael D Novack suggests though, it should be do-able, given
enough time and effort.


___
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] Automatic capital gains question

[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 account to determine gains and loses across
multiple transactions. I've now tried it on one of my investment
accounts where I purchased shares over multiple transactions and then
eventually sold all shares over some amount of time. So the balance in
the account is currently zero. I tried using the automatic gains
feature and am left with a question about the value of the gains. In my
mind the gains/loses should be equivalent to me adding up how much I
paid for all shares and subtracting from that how much I sold all
shares for and that tells me my gains. I compared that with what shows
up in my capital gains account after the scrub and they don't match. Is
this expected and I'm not understanding something about how GnuCash
computes capital gains?

Jon

___
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] Newbie trouble deleting transaction

[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@gnucash.org
Subject: Re: [GNC] Newbie trouble deleting transaction

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-A via gnucash-user  
> wrote:
> 
> I've just started using gnucash, and have imported a few years worth 
> of data successfully from a bank account.  Afterwards I manually 
> entered two more transactions, where one is mistaken.
> 
> I'd like to remove the mistake, but am unable to do so with either the 
> Delete button or "Delete transaction" menu choice.  Shouldn't I at 
> least get some error if something is failing?
> 
> The transaction I'm removiing is blank except for a date.
> 
> Am I missing something obvious or could something be wrong with my
> 4.13 setup on Debian bookworm?
> ___
> 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] Finance::Quote failed to initialize

[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 quotes and other AlphaVantage based
quotes won't work.

Found Finance::Quote version 1.63.

Finance::Quote sources:

aex  alphavantage  amfiindiaasegrasx


aufunds  australiabamosz   bats bet  bloomberg


borsa_italianabourso   bse  bseindia bvb


canada   comdirectconsorsbank  cse  deka dutch


dwsfunds europe   fetch_live_currencies financeapi

finanzpartner fondsweb fool france   ftfunds


goldmoneygooglewebgreece   hu   hufund   hungary


hustock  iexcloud indiaindiamutual  known_currencies


marketwatch  morningstarau morningstarch

morningstarjp morningstaruk mstaruk  nasdaq


nseindia nyse nzx  onvista  oslobors poland


romania  seb_fundssinvestorsix  stockdatastooq


tesouro_diretotiaacref tmx  tradegatetradeville


treasurydirecttroweprice   troweprice_direct tsp


tsx  twelvedata   ukfunds  unionfunds   usa  xetra


yahoo_json   yahoojsonyahooweb za

Do you still recommend to install "Find.pm"?
And now, to get the quotes, do I need to somehow "subscribe" to a service
and get/use an API key? I'm asking because of this:

me@MacBook-Pro ~ % /Applications/Gnucash.app/Contents/MacOS/gnucash-cli -Q
dump currency USD CHF EUR

Application Path /Applications/Gnucash.app/Contents/MacOS/gnucash-cli

* 16:58:56  WARN  [GncFQQuoteSource::set_api_key()] No
Alpha Vantage API key set, currency quotes and other AlphaVantage based
quotes won't work.

CHF Finance::Quote returned no data and set no error.

EUR Finance::Quote returned no data and set no error.

Thanks,
F.

https://www.instagram.com/boniforti_music
https://soundcloud.com/boniforti_music
https://bonny-j.bandcamp.com


Am Mo., 7. Okt. 2024 um 16:36 Uhr schrieb 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 will
> cause a single test in Finance::Quote to fail. You can use cpan -f
> Finance::Quote to force it to install anyway. Do that after everything else
> is installed, you don’t want to force all of the dependencies.
>
> Regards,
> John Ralls
>
> On Oct 7, 2024, at 00:29, Boniforti Flavio  wrote:
>
> 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:32 Builder.pm
> -r--r--r--   1 root  wheel  54359 Sep 14 19:32 More.pm
> -r--r--r--   1 root  wheel   6479 Sep 14 19:32 Simple.pm
> drwxr-xr-x   5 root  wheel160 Oct  6 20:43 Tester
> -r--r--r--   1 root  wheel  18323 Sep 14 19:32 Tester.pm
> -r--r--r--   1 root  wheel  19346 Sep 14 19:32 Tutorial.pod
> drwxr-xr-x   3 root  wheel 96 Oct  6 20:43 use
>
> F.
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
>
>
> Am Mo., 7. Okt. 2024 um 00:07 Uhr schrieb John Ralls :
>
>> Flavio,
>>
>> OK, good. Does /Library/Perl/5.34/Test/Simple.pm exist?
>>
>> Regards,
>> John Ralls
>>
>>
>> On Oct 6, 2024, at 11:45, Boniforti Flavio  wrote:
>>
>> Hi John.
>>
>> The output of "sudo cpan Test::Simple" is very long, the last part being:
>>
>> Appending installation info to
>> /Library/Perl/Updates/5.34.1/darwin-thread-multi-2level/perllocal.pod
>>   EXODIST/Test-Simple-1.302204.tar.gz
>>   /usr/bin/make install  -- OK
>>
>> Do you need more output?
>> F.
>>
>> https://www.instagram.com/boniforti_music
>> https://soundcloud.com/boniforti_music
>> https://bonny-j.bandcamp.com
>>
>>
>> Am So., 6. Okt. 2024 um 18:37 Uhr schrieb John Ralls > >:
>>
>>> Flavio,
>>>
>>> No, you don’t need to install perl from Homebrew. You’d also have to
>>> edit GnuCash’s environment file to make it work and there’s no benefit. We
>>> were chasing the Homebrew perl possibility trying to figure out if
>>> Finance::Quote’s dependencies had gotten installed.
>>>
>>> Your list shows that everything got at least downloaded, so at least
>>> that much worked. IIRC Test::Simple has no dependencies,, so try
>>>   sudo cpan Test::Simple
>>> If you followed Bruce’s instruction to chown ~/.cpan leave off sudo.
>>>

Re: [GNC] Automatic capital gains question

[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 buys minus the sells
give me my capital gains? I'm trying what I feel like is a pretty
simple account to understand how the automatic lots work. If it can't
get that right, I can't trust it to get the gains right when I don't
sell off all of the shares.
Again, what am I missing in my understanding of how GnuCash does things
that would explain why the numbers don't add up?



My guess is that your basis may be off.  Does your cost basis in GnuCash 
actually match the cost basis your brokerage has?  If not, can you 
pinpoint the differences?  I am assuming that you already checked that 
the number of shares matches.


You may already know this, but for anyone who doesn't:
- If you have reinvested dividends, they will be part of your cost basis.
- If the stock or mutual fund paid any dividends that were partial (or 
entire!) "return of capital" dividends in a time of lower or no profits, 
then your basis will be reduced by that return of capital amount.
- If the stock had a spin-off, part of your old basis will go to the new 
stock.  (For example, if Tech company does a spin-off of Division at 10% 
of cost basis, you will end up with Tech at 90% of your original basis 
and Division at 10% of your original basis.)
- If the purchase prices in GnuCash accidentally got switched for two 
different stocks, you would end up with the wrong basis for both stocks 
but still have your cash/clearing account match.  I've done that with 
funds with similar tickers.


And sometimes I've had a broker allocate basis for a sale/split one way 
initially, then a while later silently correct it, which I only notice 
when I get the 1099 forms.


If you have few enough shares acquisitions, it might be easiest to go 
through these manually, just scrolling down the lines of your ledger and 
comparing them to information from your brokerage.


I cannot see your books, so this is just my best guess.

(I don't currently use the lots function just because of how particular 
I am about gains display in my records.)


- NoobAlice
___
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] Specify account for realized gains/loss

[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
> created by GnuCash for Capital Gains/Loss to assign another account. Is
> there a way to tell GnuCash what account to use instead of the Orphan
> account?
>
> Jon
>
> ___
> 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] Newbie trouble deleting transaction

[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
normal user-interface waiting for data entry?


On Tue, Oct 08, 2024 at 06:00:23AM +1000, David Cousens wrote:
> 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 hidden?
> 
> David Cousens
> 
> On Mon, 2024-10-07 at 08:24 +0200, Geoff Jankowski via gnucash-user
> wrote:
> > If it is the last entry in the register it cannot be deleted. 
> > 
> > If it has entries above and below it, you should be able to delete it
> > and if you cannot, there is an issue. 
> > 
> > Geoff
> > +33 6 22 93 00 53
> > +44 7770 58 48 38
> > 
> > > On 7 Oct 2024, at 08:05, Paul-A via gnucash-user
> > >  wrote:
> > > 
> > > I've just started using gnucash, and have imported a few years
> > > worth of
> > > data successfully from a bank account.  Afterwards I manually
> > > entered
> > > two more transactions, where one is mistaken.
> > > 
> > > I'd like to remove the mistake, but am unable to do so with either
> > > the Delete button or "Delete transaction" menu choice.  Shouldn't I
> > > at least get some error if something is failing?
> > > 
> > > The transaction I'm removiing is blank except for a date.
> > > 
> > > Am I missing something obvious or could something be wrong with my
> > > 4.13 setup on Debian bookworm?
> > > ___
> > > 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.
___
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] Automatic capital gains question

[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 gains? I'm trying what I feel like is a pretty
simple account to understand how the automatic lots work. If it can't
get that right, I can't trust it to get the gains right when I don't
sell off all of the shares.
Again, what am I missing in my understanding of how GnuCash does things
that would explain why the numbers don't add up?

On Mon, 2024-10-07 at 09:43 -0500, David Carlson wrote:
> 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 to be aware of that when you enter your
> data into GnuCash.  I am old school so I track gains in a spreadsheet
> and manually link lots, so I have not tried using lots lately to see
> if that has changed in the last few years.  If you live in the U.S.,
> your brokerage statements list the correct values according to U.S.
> law and whatever agreement you have with your broker regarding lot
> selection, FIFO by default, or other.
> 
> On Mon, Oct 7, 2024 at 6:26 AM Jon Schewe  wrote:
> > 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 account to determine gains and loses across
> > multiple transactions. I've now tried it on one of my investment
> > accounts where I purchased shares over multiple transactions and
> > then
> > eventually sold all shares over some amount of time. So the balance
> > in
> > the account is currently zero. I tried using the automatic gains
> > feature and am left with a question about the value of the gains.
> > In my
> > mind the gains/loses should be equivalent to me adding up how much
> > I
> > paid for all shares and subtracting from that how much I sold all
> > shares for and that tells me my gains. I compared that with what
> > shows
> > up in my capital gains account after the scrub and they don't
> > match. Is
> > this expected and I'm not understanding something about how GnuCash
> > computes capital gains?
> > 
> > Jon
> > 
> > ___
> > 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.

[GNC] Specify account for realized gains/loss

[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 account to use instead of the Orphan
account?

Jon

___
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] To whoever explained the 4% safe withdrawal rule - thank you

[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
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] To whoever explained the 4% safe withdrawal rule - thank you

[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 date 1 and tell you what the
> equivalent inflation-adjusted dollar amount would be for date 2.
> 
> https://www.bls.gov/data/inflation_calculator.htm
>...
> *** Note that it would not be wise to use this USA inflation calculation
> for those living in other countries. ***  ...
___
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] Newbie trouble deleting transaction

[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 via gnucash-user  
> wrote:
> 
> 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
> normal user-interface waiting for data entry?
> 
> 
>> On Tue, Oct 08, 2024 at 06:00:23AM +1000, David Cousens wrote:
>> 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 hidden?
>> 
>> David Cousens
>> 
>>> On Mon, 2024-10-07 at 08:24 +0200, Geoff Jankowski via gnucash-user
>>> wrote:
>>> If it is the last entry in the register it cannot be deleted.
>>> 
>>> If it has entries above and below it, you should be able to delete it
>>> and if you cannot, there is an issue.
>>> 
>>> Geoff
>>> +33 6 22 93 00 53
>>> +44 7770 58 48 38
>>> 
 On 7 Oct 2024, at 08:05, Paul-A via gnucash-user
  wrote:
 
 I've just started using gnucash, and have imported a few years
 worth of
 data successfully from a bank account.  Afterwards I manually
 entered
 two more transactions, where one is mistaken.
 
 I'd like to remove the mistake, but am unable to do so with either
 the Delete button or "Delete transaction" menu choice.  Shouldn't I
 at least get some error if something is failing?
 
 The transaction I'm removiing is blank except for a date.
 
 Am I missing something obvious or could something be wrong with my
 4.13 setup on Debian bookworm?
 ___
 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.
> ___
> 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] Newbie trouble deleting transaction

[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

> On 8 Oct 2024, at 08:17, Geoff Jankowski  wrote:
> 
> 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 via gnucash-user  
>> wrote:
>> 
>> 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
>> normal user-interface waiting for data entry?
>> 
>> 
 On Tue, Oct 08, 2024 at 06:00:23AM +1000, David Cousens wrote:
>>> 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 hidden?
>>> 
>>> David Cousens
>>> 
 On Mon, 2024-10-07 at 08:24 +0200, Geoff Jankowski via gnucash-user
 wrote:
 If it is the last entry in the register it cannot be deleted.
 
 If it has entries above and below it, you should be able to delete it
 and if you cannot, there is an issue.
 
 Geoff
 +33 6 22 93 00 53
 +44 7770 58 48 38
 
> On 7 Oct 2024, at 08:05, Paul-A via gnucash-user
>  wrote:
> 
> I've just started using gnucash, and have imported a few years
> worth of
> data successfully from a bank account.  Afterwards I manually
> entered
> two more transactions, where one is mistaken.
> 
> I'd like to remove the mistake, but am unable to do so with either
> the Delete button or "Delete transaction" menu choice.  Shouldn't I
> at least get some error if something is failing?
> 
> The transaction I'm removiing is blank except for a date.
> 
> Am I missing something obvious or could something be wrong with my
> 4.13 setup on Debian bookworm?
> ___
> 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.
>> ___
>> 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.