Re: [GNC] Backup Solution - Linux Desktop to Synology NAS

[rsbrux via gnucash-user]

This message may not have reached the interested partie because I for 
got to change the subject line:


On 27.09.24 22:21, rsbrux wrote:

I have what I think is a simpler solution. My GC data file resides on my 
Synology NAS, in a directory that is mounted in the Linux file system.  I then 
use Synology Hyper Backup to back up all of the user files every night to one 
of two alternating USB drives, the other of which is always stored outside of 
my apartment.  Hyper Backup allows me to retrieve earlier versions with 
decreasing granularity: recent versions daily, older versions weekly and even 
older versions monthly. Of course, this kind of backup could also be done with 
rsync or with MEGA backup, but I found it easier to set up with Synology Hyper 
Backup.

--

Message: 2
Date: Fri, 27 Sep 2024 13:23:06 +1000
From: Alan Hopkins 
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Backup Solution - Linux Desktop to Synology NAS
Message-ID: <458802e6-3a48-4626-959f-248d3b264...@gmail.com>
Content-Type: text/plain; charset="UTF-8"

   Hi Dennis
   This is after the fact, but I use a program call SyncThing - it syncs
   my PC's (2 laptops, 1 desktop) which all run Linux and as well, there
   is third party SyncThing app for my Synology NAS.  Syncing is not
   really the same as backing-up but, as I have effectively have the same
   files on different drives, I feel happier about it but backup
   nevertheless. The beauty of it is that I can log on to any PC and have
   the same info (assuming they have all been on the LAN together).
   I don't, but I know people also use it with their phones.
   Cheers
   Hop

   On 27/9/24 12:59, Dennis West wrote:

 Hopefully this info will help someone that has been struggling with
 this issue...
 I recently abandoned Windows (after 40 years) and moved to Linux as
 my "Daily Driver".  I had used Synology's Active Backup for Business
 to backup my desktop PC's to my Synology NAS and was happy as a
 lark.  Trying to install the desktop client for that program on a
 Linux PC was problematic at best.  I finally gave up.
 After using other solutions for several weeks I stumbled on the fact
 that Synology had another program called Synology Drive that you
 could download from their website.  Lo and behold the desktop client
 came in a Linux version that downloaded and installed simply &
 flawlessly.  The client provides all the bells & whistles including
 scheduled automatic backup to your NAS. Obviously you could continue
 to use Hyper Backup to backup your NAS to the cloud and complete the
 3-2-1 backup strategy that I had been using.
 If everyone else here already knew all this, I'm sorry to have
 wasted your time.
 One Happy Camper
 ___
 gnucash-user mailing list
 [1]gnucash-user@gnucash.org
 To update your subscription preferences or to unsubscribe:
 [2]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.

References

   1. mailto:gnucash-user@gnucash.org
   2. https://lists.gnucash.org/mailman/listinfo/gnucash-user


--

Message: 3
Date: Fri, 27 Sep 2024 07:35:26 +0100
From: Chris Green 
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Backup Solution - Linux Desktop to Synology NAS
Message-ID: 
Content-Type: text/plain; charset=us-ascii


On Fri, Sep 27, 2024 at 01:23:06PM +1000, Alan Hopkins wrote:
   Hi Dennis
   This is after the fact, but I use a program call SyncThing - it syncs
   my PC's (2 laptops, 1 desktop) which all run Linux and as well, there
   is third party SyncThing app for my Synology NAS.  Syncing is not
   really the same as backing-up but, as I have effectively have the same
   files on different drives, I feel happier about it but backup
   nevertheless. The beauty of it is that I can log on to any PC and have
   the same info (assuming they have all been on the LAN together).
   I don't, but I know people also use it with their phones.

As you say syncthing isn't really a backup program.  It protects you
against hardware failure as you have other copies of your files but it
doesn't protect you against your own mistakes.  If you delete
something by mistake or mess up some GnuCash updates then those errors
will be duplicated on the other systems which are synchronised.

I use syncthing to keep things in step on my desktop and laptop
machines, it means that I can use GnuCash on either machine and
everything I do is copied to the other machine automatically so I can
pick up where I left off on either machine. (Just don't run GnuCash on
bath machines as the same time!).

For backup I use rsync with some simple home made code that automates
the process and gives me incremental backups of all important files.
I do hourly incremental backups on

Re: [GNC] gnucash-user Digest, Vol 258, Issue 87

[rsbrux via gnucash-user]

I have what I think is a simpler solution. My GC data file resides on my 
Synology NAS, in a directory that is mounted in the Linux file system.  I then 
use Synology Hyper Backup to back up all of the user files every night to one 
of two alternating USB drives, the other of which is always stored outside of 
my apartment.  Hyper Backup allows me to retrieve earlier versions with 
decreasing granularity: recent versions daily, older versions weekly and even 
older versions monthly. Of course, this kind of backup could also be done with 
rsync or with MEGA backup, but I found it easier to set up with Synology Hyper 
Backup.
> 
> --
> 
> Message: 2
> Date: Fri, 27 Sep 2024 13:23:06 +1000
> From: Alan Hopkins 
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Backup Solution - Linux Desktop to Synology NAS
> Message-ID: <458802e6-3a48-4626-959f-248d3b264...@gmail.com>
> Content-Type: text/plain; charset="UTF-8"
> 
>   Hi Dennis
>   This is after the fact, but I use a program call SyncThing - it syncs
>   my PC's (2 laptops, 1 desktop) which all run Linux and as well, there
>   is third party SyncThing app for my Synology NAS.  Syncing is not
>   really the same as backing-up but, as I have effectively have the same
>   files on different drives, I feel happier about it but backup
>   nevertheless. The beauty of it is that I can log on to any PC and have
>   the same info (assuming they have all been on the LAN together).
>   I don't, but I know people also use it with their phones.
>   Cheers
>   Hop
> 
>   On 27/9/24 12:59, Dennis West wrote:
> 
> Hopefully this info will help someone that has been struggling with
> this issue...
> I recently abandoned Windows (after 40 years) and moved to Linux as
> my "Daily Driver".  I had used Synology's Active Backup for Business
> to backup my desktop PC's to my Synology NAS and was happy as a
> lark.  Trying to install the desktop client for that program on a
> Linux PC was problematic at best.  I finally gave up.
> After using other solutions for several weeks I stumbled on the fact
> that Synology had another program called Synology Drive that you
> could download from their website.  Lo and behold the desktop client
> came in a Linux version that downloaded and installed simply &
> flawlessly.  The client provides all the bells & whistles including
> scheduled automatic backup to your NAS. Obviously you could continue
> to use Hyper Backup to backup your NAS to the cloud and complete the
> 3-2-1 backup strategy that I had been using.
> If everyone else here already knew all this, I'm sorry to have
> wasted your time.
> One Happy Camper
> ___
> gnucash-user mailing list
> [1]gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> [2]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.
> 
> References
> 
>   1. mailto:gnucash-user@gnucash.org
>   2. https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 
> 
> --
> 
> Message: 3
> Date: Fri, 27 Sep 2024 07:35:26 +0100
> From: Chris Green 
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Backup Solution - Linux Desktop to Synology NAS
> Message-ID: 
> Content-Type: text/plain; charset=us-ascii
> 
>> On Fri, Sep 27, 2024 at 01:23:06PM +1000, Alan Hopkins wrote:
>>   Hi Dennis
>>   This is after the fact, but I use a program call SyncThing - it syncs
>>   my PC's (2 laptops, 1 desktop) which all run Linux and as well, there
>>   is third party SyncThing app for my Synology NAS.  Syncing is not
>>   really the same as backing-up but, as I have effectively have the same
>>   files on different drives, I feel happier about it but backup
>>   nevertheless. The beauty of it is that I can log on to any PC and have
>>   the same info (assuming they have all been on the LAN together).
>>   I don't, but I know people also use it with their phones.
> 
> As you say syncthing isn't really a backup program.  It protects you
> against hardware failure as you have other copies of your files but it
> doesn't protect you against your own mistakes.  If you delete
> something by mistake or mess up some GnuCash updates then those errors
> will be duplicated on the other systems which are synchronised.
> 
> I use syncthing to keep things in step on my desktop and laptop
> machines, it means that I can use GnuCash on either machine and
> everything I do is copied to the other machine automatically so I can
> pick up where I left off on either machine. (Just don't run GnuCash on
> bath machines as the same time!).
> 
> For backup I use rsync with some simple home made code that automates
> the process and gives me incremental backups of all important files.
> I do hourly incremental b

Re: [GNC] gnucash-user Digest, Vol 258, Issue 20

[rsbrux via gnucash-user]

FWIW, I keep my GC data file on my NAS. Apart from privacy considerations, I 
don't trust my Internet connection enough to store it in the cloud.  I don't 
want the data to get corrupted by an interrupted connection.  The NAS gets 
backed up every night to one of two external drives, which are rotated. One of 
them is always stored in a separate location.
> 
> Message: 4
> Date: Sun, 8 Sep 2024 09:44:27 -0500
> From: David Carlson 
> To: Kalpesh Patel 
> Cc: David Cousens , gnucash-user@gnucash.org
> Subject: Re: [GNC] Recommendations for hosting gnucash file - Google
>Drive, Microsoft 365, Local server?
> Message-ID:
>
> Content-Type: text/plain; charset="UTF-8"
> 
> ? TY!
> 
>> On Sun, Sep 8, 2024 at 8:46?AM Kalpesh Patel  wrote:
>> 
>> If you are paranoid about cloud provider snooping into your files and
>> folders when storing data in the cloud, please look into excellent open
>> source tool called CryptSync (https://tools.stefankueng.com/CryptSync.html)
>> which I have mentioned it in the past.  It works as advertised so far. I do
>> not rely on anyone's word once that data leaves my control as they can
>> change their prerogative at their whims. I've been in IT world far too long
>> to know this for sure, sadly!
>> 
>> -Original Message-
>> From: David Carlson 
>> Sent: Saturday, September 07, 2024 9:21 PM
>> To: David Cousens 
>> Cc: gnucash-user@gnucash.org
>> Subject: Re: [GNC] Recommendations for hosting gnucash file - Google
>> Drive, Microsoft 365, Local server?
>> 
>> I would like to know what level of security these hosting methods provide.
>> The GnuCash .gnucash data file is essentially an un-encrypted text file.
>> I think some cloud services, possibly including Google Drive may also be
>> unencrypted, tho I have not checked.  Do other cloud services offer better
>> security?  Private NAS solutions need to be configured by the user, but
>> they can be secure. What do you consider needs to be done to achieve
>> adequate security?
>> 
>> On Sat, Sep 7, 2024 at 3:59?PM David Cousens 
>> wrote:
>> 
>>> Bruce,
>>> I keep my Gnucash data files in a Dropbox account which is accessible
>>> from my laptop (Linux Mint), desktop(Linux Mint), phones (Android) and
>>> my wife's laptop (formerly Windows 11 but now linux Mint).   In my
>>> situation the file is only ever accessed from one computer at a time
>>> so no conflicts usually.  I also use Unison to synchronize my laptop
>>> and desktop before using the laptop remotely (mainly for other work,
>>> but it can synch the user preference files if desired), but I don't
>> synch the
>>> Dropbox account.   It generally only takes a minute or two to sync the
>>> machines as I keep the sync updated fairly regularly.
>>> 
>>> I have an NAS for local backups, which is in turn backed up to cloud
>>> storage.  The Dropbox is useful if you need to share the files with
>>> your accountant or others (assuming they also use GnuCash) as you can
>>> just send them a link to the file and they can download a copy without
>>> disrupting your ongoing usage.  The Dropbox is mainly a hangover from
>>> days when I did some accounting/bookkeeping for others and these days
>>> I could have it shared form the NAS but it used to be useful for
>>> accessing client  files from client's computers back in the day.  I
>>> also have NFS network sharing setup on the LAN with automounting on
>>> demand but found that did not interact all that nicely with Linux
>>> Mint's  file manager (Nemo) as it used to take a long time to connect
>>> the file shares which delayed its startup at one stage ( where the
>>> files were automounted was the problem.
>>> 
>>> David Cousens
>>> 
>>> On Sat, 2024-09-07 at 09:57 -0400, Bruce Griffis wrote:
 I am running GnuCash 5.5 on my Ubuntu 24.04 desktop. I also have
 GnuCash installed on my Windows 11 laptop. Right now I just copy my
 most recent GnuCash file over to USB if I want to work on it using
 my laptop. I tried using Google Drive, but found the application
 hanging when using Google Drive under Ubuntu. Not sure if it is
 because my connection is too slow (1 Gig to my Cisco switch, 1 Gig
 to my router, 100 Megs across my carrier) or if Ubuntu has timing
 issues with Google Drive. I also have a subscription to Microsoft
 365 and my Windows backups go there.
 Ubuntu backups go to an attached USB drive. althouhg I'm considering
 cloud storage for Ubuntu as well.  I've read that Ubuntu 24.04
 supports Microsoft drive, but you may need to log in whenever you
 access the drive. Only reason I'd consider it is that my Microsoft
 subscription comes with a decent amount of cloud storage. Finally, I
 have a spare desktop under my desk I could fire up as a headless
 server. And I have an older Raspberry PI I could probably turn into
 a NAS and share it locally using Samba.
 
 What is the current recommendation for sharing GnuCash across
 multiple PCs when it will 

Re: [GNC] Scheduled Transaction with Currency Conversion

[rsbrux via gnucash-user]

Thanks for your responses, David and Fred.  In fact, I used to just duplicate 
the last transaction and adjust the CHF amount using "Edit Exchange rate", as 
Fred suggests. 
This invokes the conversion rate dialog which, as  David points out, *does* 
allow me to specify the target amount and let GC figure out the appropriate 
conversion rate.
I thought that using Scheduled Transactions to prompt for the amount would 
obviate the need to edit the transaction after creating it. Since it doesn't, I 
will go back to the
 original method of dupliacting the previous transaction and editing it 
afterwards.
Thanks again for your help.


___
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] Scheduled Transaction with Currency Conversion

[rsbrux via gnucash-user]

We have monthly transactions where a payment in USD is credited to a CHF 
bank account. The USD amount is fixed, but the CHF amount varies 
depending on the conversion rate. As has been recommended on this list, 
I have configured these as scheduled transactions with a variable in 
place of the CHF amount .  However, when the scheduled transaction 
triggers in GnuCash, I am asked to fill in both the CHF amount *and* the 
USD -> CHF conversion rate. Unfortunately the bank notification does not 
include the conversion rate.  In fact the bank doesn't even know the 
conversion rate, because this is determined by the payor, which performs 
the conversion before the bank deposit. We don't receive any 
notification from the payor (U.S. Social Security). IMHO, it should be 
enough to supply *either* the credited amount in CHF *or* the USD -> CHF 
conversion rate, since GnuCash can calculate one from the other, but GC 
won't allow me to click "OK" without supplying the USD -> CHF conversion 
rate explicitly. The scheduled transaction template has no place to 
enter the conversion rate, otherwise I would put in a formula based on 
the variable CHF amount. How can I get the scheduled transactions to 
complete, without knowing the conversion rate?


___
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] New accounts don't show up in GC 5.8 under Flathub

[rsbrux via gnucash-user]

As it turns out, dev...@asia.com was on the right track.

Although I had enabled "Show zero total accounts" under "View - Filter 
By... - Other", I had not enabled "Show unused accounts".


Enabling it results in the new (not yet used) accounts showing up.

Thanks again to all who responded!

On 19.07.24 11:15, rsbrux wrote:


Many thanks for your patient explanation and for updating the wiki.

As you suggested, the command:

sudo flatpak install gnucash 
org.gnucash.GnuCash//stable-C5.8-20-ga84189b79d-D5.7-2-ge45aa63c

successfully installed the nightly build.

When I start GnuCash, it now shows the expected build ID from 15 July on the 
splash screen.

However, I don't see any improvement in the described behavior.
When I create a new (sub-)account, it doesn't appear in tha account tree, not even after 
"View - Refresh".
Again, I have to search for the new account in "Edit - Find Account".
When the account shows up in the search results, double-clicking it then adds 
it to the account tree.

Please let me know what additional diagnostic data I can provide.
Thanks again for your help.
On 19.07.24 09:10, gnucash-user-requ...@gnucash.org wrote:

--

Message: 1
Date: Thu, 18 Jul 2024 09:53:18 -0700
From: John Ralls
To: Bruce Olson
Cc: rsbrux, GnuCash User eMail List

Subject: Re: [GNC] New accounts don't show up in GC 5.8 under Flathub
Message-ID:
Content-Type: text/plain;   charset=utf-8

Immediately above the example you quoted from the wiki page it says:

Often you can find test versions on the build-server. They come in two flavours:

   Stable
 Version 5.8 plus all recent bug fixes, but no new features:
 https://code.gnucash.org/builds/flatpak/stable/?C=M;O=D
   Future
 Only available after the implementation of a feature from Release 
Schedule#Goals for 6.0!
 Version 5.8 plus new features, but bug fixes can be delayed a few days:
  https://code.gnucash.org/builds/flatpak/future/?C=M;O=D
Tip
   The file names in these directories can be used in the example below after 
trimming the ?gnucash-? prefix and ?.flatpakref? suffix.


That means go to the first 
link,https://code.gnucash.org/builds/flatpak/stable/, and find the nightly 
build that you want. The build dates are in the right-hand column. Copy the 
filename without ?gnucash-? and ?.flatpakref? and paste it on the command line 
in place of the example commit.

You perhaps missed that we changed the branch names from ?maint? and ?master? 
to ?stable? and ?future? when we released 5.0.

  I?ve replaced the example in the wiki with the most recent build and added a 
note mentioning the old branch names.

Regards,
John Ralls


___
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] New accounts don't show up in GC 5.8 under Flathub

[rsbrux via gnucash-user]

Many thanks for your patient explanation and for updating the wiki.

As you suggested, the command:

sudo flatpak install gnucash 
org.gnucash.GnuCash//stable-C5.8-20-ga84189b79d-D5.7-2-ge45aa63c

successfully installed the nightly build.

When I start GnuCash, it now shows the expected build ID from 15 July on the 
splash screen.

However, I don't see any improvement in the described behavior.
When I create a new (sub-)account, it doesn't appear in tha account tree, not even after 
"View - Refresh".
Again, I have to search for the new account in "Edit - Find Account".
When the account shows up in the search results, double-clicking it then adds 
it to the account tree.

Please let me know what additional diagnostic data I can provide.
Thanks again for your help.

On 19.07.24 09:10, gnucash-user-requ...@gnucash.org wrote:

--

Message: 1
Date: Thu, 18 Jul 2024 09:53:18 -0700
From: John Ralls
To: Bruce Olson
Cc: rsbrux, GnuCash User eMail List

Subject: Re: [GNC] New accounts don't show up in GC 5.8 under Flathub
Message-ID:
Content-Type: text/plain;   charset=utf-8

Immediately above the example you quoted from the wiki page it says:

Often you can find test versions on the build-server. They come in two flavours:

   Stable
 Version 5.8 plus all recent bug fixes, but no new features:
 https://code.gnucash.org/builds/flatpak/stable/?C=M;O=D
   Future
 Only available after the implementation of a feature from Release 
Schedule#Goals for 6.0!
 Version 5.8 plus new features, but bug fixes can be delayed a few days:
  https://code.gnucash.org/builds/flatpak/future/?C=M;O=D
Tip
   The file names in these directories can be used in the example below after 
trimming the ?gnucash-? prefix and ?.flatpakref? suffix.


That means go to the first 
link,https://code.gnucash.org/builds/flatpak/stable/, and find the nightly 
build that you want. The build dates are in the right-hand column. Copy the 
filename without ?gnucash-? and ?.flatpakref? and paste it on the command line 
in place of the example commit.

You perhaps missed that we changed the branch names from ?maint? and ?master? 
to ?stable? and ?future? when we released 5.0.

  I?ve replaced the example in the wiki with the most recent build and added a 
note mentioning the old branch names.

Regards,
John Ralls


___
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] New accounts don't show up in GC 5.8 under Flathub

[rsbrux via gnucash-user]

Thanks for the tips. 
I do have a 64-bit OS, which is why I left out “ flatpak --arch=x86_64” in the 
commands that I executed.  I tried to make this clear in my post.  Sorry that 
it wasn’t. 
I am not familiar with downloading packages to install, especially in flatpak. 
I tried to follow your instructions, but when I try to install the downloaded 
package, flatpak wants to also install org.gtk.Gtk3theme.Breeze 3.22.  I am 
reluctant to do this, because Discover says that I already have version 6.13 
installed in flatpak.
You seem to have supplied the missing piece I was looking for in your post 
below:
> gnucash-stable-C5.8-20-ga84189b79d-D5.7-2-ge45aa63c.flatpakref
but I am still confused. 
The wiki suggests that a nightly build should contain “maint-“ rather than 
“stable-“.
Thanks again for your help.

> On 17 Jul 2024, at 20:32, gnucash-user-requ...@gnucash.org wrote:
> 
> Send gnucash-user mailing list submissions to
>gnucash-user@gnucash.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
>gnucash-user-requ...@gnucash.org
> 
> You can reach the person managing the list at
>gnucash-user-ow...@gnucash.org
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
> 
> 
> Today's Topics:
> 
>   1. Re:  New accounts don't show up in GC 5.8 under Flathub
>  (Bruce Olson)
>   2. Re:  New accounts don't show up in GC 5.8 under Flathub
>  (Bruce Olson)
> 
> 
> --
> 
> Message: 1
> Date: Wed, 17 Jul 2024 10:58:10 -0700
> From: Bruce Olson 
> To: rsbrux 
> Cc: gnucash-user@gnucash.org, 'John Ralls' 
> Subject: Re: [GNC] New accounts don't show up in GC 5.8 under Flathub
> Message-ID: 
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
>> On 7/17/24 04:16, rsbrux via gnucash-user wrote:
>> Thanks, but I'm still lost.
>> 
>> After executing:
>> 
>> sudo flatpak remote-add --if-not-exists gnucash 
>> https://code.gnucash.org/builds/flatpak/gnucash-nightlies.flatpakrepo
>> 
>> sudo flatpak remote-add --if-not-exists flathub 
>> https://flathub.org/repo/flathub.flatpakrepo
>> 
>> flatpak remote-ls gnucash  # because I have a 64-bit operating system
>> 
>> I get an extremely long list of versions starting with "master-", "maint-" 
>> or "stable-".
>> 
>> However, the list does not include commit dates, and I found no indication 
>> of the corresponding commit ID(s) in the Bugzilla entry 
>> <https://bugs.gnucash.org/show_bug.cgi?id=799370> .
>> 
>> The instructions on the wiki say I should execute:
>> 
>> sudo flatpak --arch=x86_64 install gnucash 
>> org.gnucash.GnuCash//maint-C3.8b-163-g0e6c9e219-D3.8b-15-g0479ece  # <-- 
>> change version here!
>> 
>> (in my case presumably sudo flatpak install gnucash 
>> org.gnucash.GnuCash//maint-C3.8b-163-g0e6c9e219-D3.8b-15-g0479ece  # <-- 
>> change version here!)
>> 
>> What do I need to enter in place of 
>> ?maint-C3.8b-163-g0e6c9e219-D3.8b-15-g0479ece??
>> 
>> Many thanks for your help!
>> 
>> 
>> 
>> 
>> 
>> -Original Message-
>> From: John Ralls 
>> Sent: Tuesday, July 16, 2024 6:28 PM
>> To: rsbrux 
>> Cc: gnucash-user@gnucash.org
>> Subject: Re: [GNC] New accounts don't show up in GC 5.8 under Flathub
>> 
>> 
>> 
>> I?ve added instructions for that to the wiki page.
>> 
>> 
>> 
>> Regards,
>> 
>> John Ralls
>> 
>> 
>> 
>>>> I confirmed that it was a side effect of the bug 799347 fix. I've now 
>>>> fixed that differently along with the rest of bug 799370. Please try 
>>>> tomorrow's nightly build, see  
>>>> <https://wiki.gnucash.org/wiki/Flatpak#Nightly_Test_Versions_at_gnucash.org>
>>>>  
>>>> https://wiki.gnucash.org/wiki/Flatpak#Nightly_Test_Versions_at_gnucash.org 
>>>> for installation instructions.
>>>> Regards,
>>>> John Ralls
> 
> From:
> https://wiki.gnucash.org/wiki/Flatpak#Nightly_Test_Versions_at_gnucash.org
> Note
> ??? flatpak --arch=x86_64 is only required, if you have a 64-bit
> processor with a 32-bit OS.
> 
> Do you have a 32-bit OS?
> I thought you said you have a 64 bit operating system. I don't think
> this applies if you ha

Re: [GNC] New accounts don't show up in GC 5.8 under Flathub

[rsbrux via gnucash-user]

Thanks, but I'm still lost.

After executing:

sudo flatpak remote-add --if-not-exists gnucash 
https://code.gnucash.org/builds/flatpak/gnucash-nightlies.flatpakrepo

sudo flatpak remote-add --if-not-exists flathub 
https://flathub.org/repo/flathub.flatpakrepo

flatpak remote-ls gnucash  # because I have a 64-bit operating system

I get an extremely long list of versions starting with "master-", "maint-" or 
"stable-".

However, the list does not include commit dates, and I found no indication of 
the corresponding commit ID(s) in the Bugzilla entry 
<https://bugs.gnucash.org/show_bug.cgi?id=799370> .

The instructions on the wiki say I should execute:

sudo flatpak --arch=x86_64 install gnucash 
org.gnucash.GnuCash//maint-C3.8b-163-g0e6c9e219-D3.8b-15-g0479ece  # <-- change 
version here!

(in my case presumably sudo flatpak install gnucash 
org.gnucash.GnuCash//maint-C3.8b-163-g0e6c9e219-D3.8b-15-g0479ece  # <-- change 
version here!)

What do I need to enter in place of 
“maint-C3.8b-163-g0e6c9e219-D3.8b-15-g0479ece”?

Many thanks for your help!

 

 

-Original Message-
From: John Ralls  
Sent: Tuesday, July 16, 2024 6:28 PM
To: rsbrux 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] New accounts don't show up in GC 5.8 under Flathub

 

I’ve added instructions for that to the wiki page.

 

Regards,

John Ralls

 

 

> On Jul 16, 2024, at 06:48, rsbrux < <mailto:rsb...@yahoo.com> 
> rsb...@yahoo.com> wrote:

> 

> Thanks, but I am a bit unsure about the instructions.

> 1. It says they won’t work if I have the flathub repository configured, which 
> I do.

> 2. Before doing this, I would like to know how to get back to the stable 
> version.

> Many thanks for your help!

> 

>> On 15 Jul 2024, at 21:27, John Ralls < <mailto:jra...@ceridwen.us> 
>> jra...@ceridwen.us> wrote:

>> 

>> 

>> 

>>>> On Jul 15, 2024, at 10:07 AM, John Ralls < <mailto:jra...@ceridwen.us> 
>>>> jra...@ceridwen.us> wrote:

>>>> 

>>>> 

>>>> 

>>>>> On Jul 15, 2024, at 06:48, rsbrux via gnucash-user < 
>>>>> <mailto:gnucash-user@gnucash.org> gnucash-user@gnucash.org> wrote:

>>>> 

>>>> When I create a new account in GC (v5.8 running in Flathub under Ubuntu 
>>>> Studio 22.04 LTS), it doesn't show up in the account tree.

>>>> 

>>>> Clicking "View - Refresh" does not help.  The ony way I have found to get 
>>>> the new account to show up is to use "Edit - Find Account".

>>>> 

>>>> The new account then shows up in the search results, but with a checkmark 
>>>> in the column "Not Used".

>>>> 

>>>> When I double-click on the entry in the search results list,  the new 
>>>> account appears in the account tree.

>>> 

>>> I think that has to do with the fix for bug 799347. There are some other 
>>> side effects. Bob Fewell and I are working on it, the discussion is at the 
>>> bottom of  <https://bugs.gnucash.org/show_bug.cgi?id=799370> 
>>> https://bugs.gnucash.org/show_bug.cgi?id=799370 
>>> https://bugs.gnucash.org/show_bug.cgi?id=799370>

>>> 

>> 

>> I confirmed that it was a side effect of the bug 799347 fix. I've now fixed 
>> that differently along with the rest of bug 799370. Please try tomorrow's 
>> nightly build, see  
>> <https://wiki.gnucash.org/wiki/Flatpak#Nightly_Test_Versions_at_gnucash.org> 
>> https://wiki.gnucash.org/wiki/Flatpak#Nightly_Test_Versions_at_gnucash.org 
>> for installation instructions.

>> 

>> Regards,

>> John Ralls

>> 

>> 

> 

 

___
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] New accounts don't show up in GC

[rsbrux via gnucash-user]

Thanks, but I am not hiding zero  balance accounts.

On 16.07.24 18:00, gnucash-user-requ...@gnucash.org wrote:

--

Message: 1
Date: Mon, 15 Jul 2024 16:06:54 +
From: dev...@asia.com
To: gnucash-user@gnucash.org
Subject: Re: [GNC] New accounts don't show up in GC
Message-ID:



Content-Type: text/plain; charset=UTF-8

New accounts you create won?t show on the account tree because by default 
View->Filter By option is set to hide zero balance accounts.

Try entering some transactions in the new account. Then it should show up with 
View->Refresh.

Cheers.
--

From: rsbrux 
To: gnucash-user@gnucash.org
Subject: [GNC] New accounts don't show up in GC 5.8 under Flathub
Message-ID: 
Content-Type: text/plain; charset=UTF-8; format=flowed

When I create a new account in GC (v5.8 running in Flathub under Ubuntu
Studio 22.04 LTS), it doesn't show up in the account tree.

Clicking "View - Refresh" does not help.? The ony way I have found to
get the new account to show up is to use "Edit - Find Account".

The new account then shows up in the search results, but with a
checkmark in the column "Not Used".

When I double-click on the entry in the search results list,? the new
account appears in the account tree.


___
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] New accounts don't show up in GC 5.8 under Flathub

[rsbrux via gnucash-user]

Thanks, but I am a bit unsure about the instructions.
1. It says they won’t work if I have the flathub repository configured, which I 
do.
2. Before doing this, I would like to know how to get back to the stable 
version.
Many thanks for your help!

> On 15 Jul 2024, at 21:27, John Ralls  wrote:
> 
> 
> 
>>> On Jul 15, 2024, at 10:07 AM, John Ralls  wrote:
>>> 
>>> 
>>> 
>>>> On Jul 15, 2024, at 06:48, rsbrux via gnucash-user 
>>>>  wrote:
>>> 
>>> When I create a new account in GC (v5.8 running in Flathub under Ubuntu 
>>> Studio 22.04 LTS), it doesn't show up in the account tree.
>>> 
>>> Clicking "View - Refresh" does not help.  The ony way I have found to get 
>>> the new account to show up is to use "Edit - Find Account".
>>> 
>>> The new account then shows up in the search results, but with a checkmark 
>>> in the column "Not Used".
>>> 
>>> When I double-click on the entry in the search results list,  the new 
>>> account appears in the account tree.
>> 
>> I think that has to do with the fix for bug 799347. There are some other 
>> side effects. Bob Fewell and I are working on it, the discussion is at the 
>> bottom of https://bugs.gnucash.org/show_bug.cgi?id=799370 
>> https://bugs.gnucash.org/show_bug.cgi?id=799370>
>> 
> 
> I confirmed that it was a side effect of the bug 799347 fix. I've now fixed 
> that differently along with the rest of bug 799370. Please try tomorrow's 
> nightly build, see 
> https://wiki.gnucash.org/wiki/Flatpak#Nightly_Test_Versions_at_gnucash.org 
> for installation instructions.
> 
> Regards,
> John Ralls
> 
> 

___
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] New accounts don't show up in GC 5.8 under Flathub

[rsbrux via gnucash-user]

When I create a new account in GC (v5.8 running in Flathub under Ubuntu 
Studio 22.04 LTS), it doesn't show up in the account tree.


Clicking "View - Refresh" does not help.  The ony way I have found to 
get the new account to show up is to use "Edit - Find Account".


The new account then shows up in the search results, but with a 
checkmark in the column "Not Used".


When I double-click on the entry in the search results list,  the new 
account appears in the account tree.


___
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] gnucash-user Digest, Vol 256, Issue 20

[rsbrux via gnucash-user]

@Adrien,

Thanks, this seems like the best solution.  It looks funny to leave the 
unbalanced amounts in all 3 accounts (2 credit card and one parent 
account), but reconciliation works and generates the correct payment 
from the bank account.


Thanks again to all who responded!

On 09.07.24 15:29, gnucash-user-requ...@gnucash.org wrote:

--
Message: 3
Date: Mon, 8 Jul 2024 14:14:41 -0500
From: Adrien Monteleone
To:gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Consolidated billing of two credit cards
Message-ID:
Content-Type: text/plain; charset=UTF-8; format=flowed

I'm in the camp that would just use a single split transaction payment
and leave the accounts as-is, if not for the very least, that the bank
still treats them as separate accounts. They can change how they present
the statement on a whim. (as they have clearly already done once)

I always attempt to model the real world in my accounting as closely as
possible.

If it helps with reconciliation, you can put them under a placeholder
parent account, and opt to include sub-accounts during reconciliation.

Regards,
Adrien

On 7/7/24 10:54 AM, rsbrux via gnucash-user wrote:

I have two credit cards from the same bank, which were previously
handled completely separately and are therefor represented by separate
accounts in GnuCash.

Now the bank has consolidated the statements, but not completely.? There
is now a sinlge statement, but the charges and balance due are listed
and summed up separateky for each card.

However, the total due for both cards is now applied as a single charge
to my bank account. Because of the separate totals on the statement, it
is still convenient to reconcile the two credit card accounts separately.

However, this results in two separate charges to the GnuCash bank
account, which I then have to mentally add together to reconcile the
bank account.

This has led me to consider merging the two credit card accounts in
GnuCash.? How easy is this?? Will this really make things easier, or am
I better off sticking with the status quo?

Thanks in advance for any tips!

___
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] Consolidated billing of two credit cards

[rsbrux via gnucash-user]

Many thanks for all the useful tips!

Just to  clarify:

We don't use checks where I live (Switzerland).

The credit card companies here tend to send the statements so close to 
the payment due date that one is likely to incur interest fees if one 
waits until the statement arrives to pay the balance.


I have therefore authorized the credit card issuer to request payment of 
the outstanding balance directly from the bank which has my current 
account (what Americans would call a checking account).


The bank is also authorized to pay the credit card balance on demand.

The two credit cards already have a parent account (corresponding to the 
issuer) in GnuCash.


The reconciliation process in GnuCash generates a separate transaction 
for each credit card, resulting in two charges to the current account in GC.


From the advice below, the obvious solution seems to be to combine the 
two payments in the GC current account into one payment with an extra split.


I like this idea better than merging the two credit card accounts, even 
though it still requires manual intervention.


Thanks again for your helpful advice!


--

Message: 1
Date: Sun, 7 Jul 2024 11:29:37 -0500
From: Mark at Lorimark
To:gnucash-user@gnucash.org
Subject: Re: [GNC] Consolidated billing of two credit cards
Message-ID:
<0129b913-c1d2-4782-b782-30c697878...@lorimarksolutions.com>
Content-Type: text/plain; charset=UTF-8; format=flowed

(not an accountant)

I think you can make your one (1) payment to the bank, and then split
the portions of that payment for each card;

account  DrCr
Bank   $1000
CC1 $400
CC2 $600

So you're writing out one check and paying it towards the two credit
cards... does that resolve your issue?

~mark petryk
~c:469-556-5075
~w:http://www.lorimarksolutions.com

On 7/7/24 10:54, rsbrux via gnucash-user wrote:

I have two credit cards from the same bank, which were previously
handled completely separately and are therefor represented by separate
accounts in GnuCash.

Now the bank has consolidated the statements, but not completely.? There
is now a sinlge statement, but the charges and balance due are listed
and summed up separateky for each card.

However, the total due for both cards is now applied as a single charge
to my bank account. Because of the separate totals on the statement, it
is still convenient to reconcile the two credit card accounts separately.

However, this results in two separate charges to the GnuCash bank
account, which I then have to mentally add together to reconcile the
bank account.

This has led me to consider merging the two credit card accounts in
GnuCash.? How easy is this?? Will this really make things easier, or am
I better off sticking with the status quo?

Thanks in advance for any tips!

___
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.


--

Message: 2
Date: Sun, 7 Jul 2024 09:41:50 -0700
From: Steve Butler
To: Mark at Lorimark
Cc: GnuCash Users
Subject: Re: [GNC] Consolidated billing of two credit cards
Message-ID:

Content-Type: text/plain; charset="UTF-8"

I presume the two CC accounts are in the Liabilities section.  My approach
depends on if I can download the transactions separately.  If so, I would
create a parent placeholder Liability account for that bank and move both
CC accounts under it.

At payment time write it against your checking account (asset) with the
total amount on that line of the transaction with the other side split
between the two CC liability accounts.



On Sun, Jul 7, 2024, 09:30 Mark at Lorimark
wrote:


(not an accountant)

I think you can make your one (1) payment to the bank, and then split
the portions of that payment for each card;

account  DrCr
Bank   $1000
CC1 $400
CC2 $600

So you're writing out one check and paying it towards the two credit
cards... does that resolve your issue?

~mark petryk
~c:469-556-5075
~w:http://www.lorimarksolutions.com

On 7/7/24 10:54, rsbrux via gnucash-user wrote:

I have two credit cards from the same bank, which were previously
handled completely separately and are therefor represented by separate
accounts in GnuCash.

Now the bank has consolidated the statements, but not completely.  There
is now a sinlge statement, but the charges and balance due are listed
and summed up separateky for each card.

However, the total due for both cards is now applied as a single charge
to my bank account. Because of the separate totals on the statement, it
is still convenient to reconcile the two credit card accounts separately

[GNC] Consolidated billing of two credit cards

[rsbrux via gnucash-user]

I have two credit cards from the same bank, which were previously 
handled completely separately and are therefor represented by separate 
accounts in GnuCash.


Now the bank has consolidated the statements, but not completely.  There 
is now a sinlge statement, but the charges and balance due are listed 
and summed up separateky for each card.


However, the total due for both cards is now applied as a single charge 
to my bank account. Because of the separate totals on the statement, it 
is still convenient to reconcile the two credit card accounts separately.


However, this results in two separate charges to the GnuCash bank 
account, which I then have to mentally add together to reconcile the 
bank account.


This has led me to consider merging the two credit card accounts in 
GnuCash.  How easy is this?  Will this really make things easier, or am 
I better off sticking with the status quo?


Thanks in advance for any tips!

___
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] How to handle recurring transactions with currency conversion

[rsbrux via gnucash-user]

We receive monthly payments from U.S. Social Security. These werre 
previously paid out in U.S. dollars (USD) but are now paid out in Swiss 
Francs (CHF).


I previously handled these with a scheduled transaction, since the 
amounts remained the same over at least a year, but this doesn't work 
anymore.


Since the income account is in USD, each deposit (to a CHF account) is 
now associated with a currency conversion rate determined ad hoc by the 
U.S. Social Security Administration.


Is there an elegant way to handle this, perhaps with a scheduled 
transaction having a constant USD amount and prompting for a conversion 
foctor, or should I just give up and create a corresponding income 
account in CHF and enter the transactions manually?


Is there an alternative solution that I haven't thought of?

Thanks in advance for any tips!


___
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] Fwd: Confusing GC update versions

[rsbrux via gnucash-user]

Perhaps this is a quirk of KDE Discover or Flatpak or both, but when I 
checked for updates in KDE Discover, it offered me an update to GnuCash 
5.6.2, even though GnuCash claimed to already be at that version.


Out of curiosity, I selected the update and ran it. Now GnuCash 
identifies itself as version 5.7.


The flatpak repository in Discover points at dl.flatpak.org.

Discover is version 5.24.7 running under Ubuntu Studio 22.04 LTS

___
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 Default Currency Module

[rsbrux via gnucash-user]

AlphaVantage still works for me since I am only fetching 5 currency conversion 
rates.
However, I would be happy for the default to change to yahoo_json in case I 
should need more. I am running GC in Flatpak under Ubuntu and environment 
variables are not so easy to handle in this setup.

> Date: Sun, 31 Mar 2024 16:46:44 -0700
> From: Jim DeLaHunt 
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Finance::Quote Default Currency Module
> Message-ID: <7d6933a4-0085-48b8-9511-c5df0b665...@jdlh.com>
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> Bruce:
> 
> I try to run GnuCash's "Get Quotes" feature every day, so every day I
> use your hard work on Finance::Quote and am grateful for it. Thank you.
> 
>> On 2024-03-30 15:09, Bruce Schuck wrote:
>> Hello all,
>> 
>> I'm getting ready to release Finance::Quote v1.60 to CPAN. It appears
>> that AlphaVantage has again changed how they deal with throttling for
>> requests using the free API keys/tokens. This has affected some users
>> that may have data that requires doing more than a handful of currency
>> exchange calculations.
>> 
>> While the currency module used can be changed using the FQ_CURRENCY
>> environment variable, I have been asked to change the default to
>> YahooJSON instead of AlphaVantage.
>> 
>> Before I make such a change I wanted to get a general consensus from
>> the GnuCash users.
> 
> Thank you for asking. But I'm afraid I don't understand what you are asking.
> 
> Is there any written description of what throttling behaviour F::Q
> observes from AlphaVantage?
> 
> I have an AlphaVantage API key registered in GnuCash's settings. I have
> about four currencies and 10-20 stocks, mutual funds, and ETFs which get
> price updates through my daily GnuCash "Get Quotes" regimen. Is this
> "more than a handful" of currency exchange calculations? Will I be one
> of the users affected by the throttling?
> 
> Is the proposed change only for looking up currency exchange rates, so
> does not affect lookup of securities prices?
> 
> What is the difference to a consumer like me of F::Q getting the data
> from YahooJSON rather than from AlphaVantage?
> 
> ??? ?Jim DeLaHunt

___
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] Update F::Q in flatpak GC?

[rsbrux via gnucash-user]

Thanks again for your prompt and informative response!

As it turns out, six.pm didn't help me.  Most of the securities I 
wanted, weren't even found on the six-group website.  The one I did find 
on the website wasn't uniquely identified by its Valora (it's available 
in USD and also hedged to CHF), so that gave six.pm indigestion.  I 
wound up getting that one from bloomberg.pm (which only knows the 
unhedged version) and the rest from morningstarch.pm. I look forward to 
the fully dynamic management of the source list(s) in GC. I'm probably 
not the only one who finds all those greyed-out sources confusing ;-)


On 21.08.23 22:56, john wrote:
The list of sources in the Security Edit dialog is hard coded and not 
often updated. Entries are grayed out if the item isn't found in the 
list of sources retrieved from F::Q at start up, which at preset is a 
lot of them. Sources that are in the F::Q list but don't have a 
hardcoded entry get added to the Unknown list at the bottom. I found 
`six` in that list.


1626.png
WIP: Incorporate new Finance::Quote get_features() to automatically 
configure quote sources by vincentl · Pull Request #1626 · 
Gnucash/gnucash <https://github.com/Gnucash/gnucash/pull/1626>

github.com <https://github.com/Gnucash/gnucash/pull/1626>

<https://github.com/Gnucash/gnucash/pull/1626>
 seeks to replace the hard-coded lists, but there are still a few 
details to work out and the contributor doesn't seem to have a lot of 
time to work on it.


Regards,
John Ralls

On Aug 21, 2023, at 05:12, rsbrux via gnucash-user 
 wrote:


Still one problem (perhaps better handled on the F::Q mailing list):
My main reason for wanting to update F::Q is that I saw that SIX.pm 
had been updated.


However, in GC (flatpak) 5.3+ with the updates to the PM scripts 
mentioned below, the Securities Editor still shows the obsolete 
SIXfunds and SIXshares as sources and no SIX. Furthermore. both 
SIXfunds and SIXshares are greyed out.


According to GitHub 
(https://github.com/finance-quote/finance-quote/commit/19962d29985549bfefef89891670dafb93e87f27) 
SIXfunds.pm and SIXshares.pm were merged into SIX.pm as of 19 Nov., 2020.


What do I need to do to get rid of the obsolete entries and get 
access to SIX as a source of securities pricing?


On 18.08.23 18:16, rsbrux wrote:

Spot on! Deleted the two lines, now working as expected.
Many thanks!

-Original Message-
From: John Ralls 
Sent: Thursday, August 17, 2023 11:23 PM
To: rsbrux 
Subject: Re: [GNC] Update F::Q in flatpak GC?

I meant go back to the 1.56 version of IndiaMutual.pm, leaving 
everything

else in place.

You don't need to delete it, just remove the two lines in Quote.pm that
refer to it.

Regards,
John Ralls




On Aug 17, 2023, at 12:21 PM, rsbrux  wrote:

I don’t need IndiaMutual.pm, but I don’t want to go back to 1.56 
because I

would like to try out the updated version of six.pm.  Can I just delete
IndaiMutual.pm?

Sent from my iPad


On 17 Aug 2023, at 19:30, john  wrote:

IndiaMutual.pm has a new perl dependency IO::String
(https://metacpan.org/pod/IO::String) as of F::Q 1.57. That 
dependency is
in the nightlies but not the release flatpak. It's pure perl and 
has no

dependencies so you have a couple of ways forward:

* Get the source code (there are links in the sidebar on the left on
the IO::String page) and install it in the flatpak's perl directory
as IO/String.pm
* Install a recent nightly build and apply the F::Q update to that
* If you don't need the IndiaMutual module you can restore the 1.56
version that doesn't need IO::String.

Regards,
John Ralls



On Aug 17, 2023, at 01:59, rsbrux  wrote:

Thanks for the further tips.  I was unable to find gnucash.trace in
either /tmp or /var/tmp (or their subdirectories.  Before trying 
to pipe

the logs to the console as described in
https://wiki.gnucash.org/wiki/Flatpak#Getting_Console_Output, I tried
running the quote retrieval from the command line, as you suggested.
This resulted in the following error message:

Price retrieval failed: Finance::Quote check returned error Can't
locate IO/String.pm in @INC (you may need to install the IO::String
module) (@INC contains: /app/lib/perl5/site_perl/5.32.0/x86_64-linux
/ap
p/lib/perl5/site_perl/5.32.0 /app/lib/perl5/5.32.0/x86_64-linux
/app/lib/perl5/5.32.0) at /app/lib/perl
5/site_perl/5.32.0/Finance/Quote/IndiaMutual.pm line 33.
BEGIN failed--compilation aborted at
/app/lib/perl5/site_perl/5.32.0/Finance/Quote/IndiaMutual.pm line 33.
Compilation failed in require at
/app/lib/perl5/site_perl/5.32.0/Module/Load.pm line 78.
Can't locate Finance/Quote/IndiaMutual in @INC (@INC contains:
/app/lib/perl5/site_perl/5.32.0/x86_64-l
inux /app/lib/perl5/site_perl/5.32.0
/app/lib/perl5/5.32.0/x86_64-linux /app/lib/perl5/5.32.0) at /app/
lib/perl5/site_perl/5.32.0/Module/Load.pm line 78.
at /app/bin/finance-quote-wrapper line 113.
Attempt to

Re: [GNC] Update F::Q in flatpak GC?

[rsbrux via gnucash-user]

n 15.08.23 14:48, rsbrux wrote:

Thanks for the tip, but I'm not sure I'm getting the right source.

https://github.com/finance-quote/finance-quote offers a zip download
of the code from master.  Is this the 1.58 release code or the
current development version?  If the latter, where should I be
looking for the release?

On 14.08.23 18:58, john wrote:

On Aug 14, 2023, at 04:33, rsbrux via gnucash-user
 wrote:

I am running GC 5.3+ as a flatpak under Ubuntu  Studio 22.04 LTS.

The included F::Q version is 1..56, which I have modified with the
Yahoo as JSON patch already published to this mailing list.

However, it looks as though the current F::Q release, 1.58,
includes quite a few fixes for various sources.

The last I heard,  it wasn't possible to update F::Q within a
flatpak installation of GC.  Is that still the case?

If so, when can a flatpak update of GC containing F::Q 1.58 be
expected?

If not, how can I update F::Q within my flatpak installation?

The update will be available when someone (probably I) have time to
update the F::Q module in gnucash-on-flatpak. That update will be
immediately available in nightly builds; it won't be available on
Flathub until the regular release at the end of September.

It's not possible to use CPAN, and consequently gnc-fq-update, in
the flatpak, but you can do it manually similarly to the way you
applied the yahoo_json patch: Download and untar the release
tarball or clone the repo then copy Quote.pm and the contents of
Quote/ into the right places in your flatpak.

Regards,
John Ralls

___
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] Update F::Q in flatpak GC?

[rsbrux via gnucash-user]

5.32.0/Finance/
>>>>>  with the files from the 1.58 release package, the "Get Quotes" button in 
>>>>> the Price Database tool is disabled. I already gave universal execute 
>>>>> privileges to  all of the newly copied files (and directory).  What else 
>>>>> might be the cause?
>>>>> 
>>>>> On 15.08.23 14:51, rsbrux wrote:
>>>>>> Sorry, dumb question.  I found the tarball here: 
>>>>>> https://sourceforge.net/projects/finance-quote/
>>>>>> 
>>>>>> On 15.08.23 14:48, rsbrux wrote:
>>>>>>> Thanks for the tip, but I'm not sure I'm getting the right source.
>>>>>>> 
>>>>>>> https://github.com/finance-quote/finance-quote offers a zip download of 
>>>>>>> the code from master.  Is this the 1.58 release code or the current 
>>>>>>> development version?  If the latter, where should I be looking for the 
>>>>>>> release?
>>>>>>> 
>>>>>>> On 14.08.23 18:58, john wrote:
>>>>>>>> 
>>>>>>>>> On Aug 14, 2023, at 04:33, rsbrux via gnucash-user 
>>>>>>>>>  wrote:
>>>>>>>>> 
>>>>>>>>> I am running GC 5.3+ as a flatpak under Ubuntu  Studio 22.04 LTS.
>>>>>>>>> 
>>>>>>>>> The included F::Q version is 1..56, which I have modified with the 
>>>>>>>>> Yahoo as JSON patch already published to this mailing list.
>>>>>>>>> 
>>>>>>>>> However, it looks as though the current F::Q release, 1.58, includes 
>>>>>>>>> quite a few fixes for various sources.
>>>>>>>>> 
>>>>>>>>> The last I heard,  it wasn't possible to update F::Q within a flatpak 
>>>>>>>>> installation of GC.  Is that still the case?
>>>>>>>>> 
>>>>>>>>> If so, when can a flatpak update of GC containing F::Q 1.58 be 
>>>>>>>>> expected?
>>>>>>>>> 
>>>>>>>>> If not, how can I update F::Q within my flatpak installation?
>>>>>>>> The update will be available when someone (probably I) have time to 
>>>>>>>> update the F::Q module in gnucash-on-flatpak. That update will be 
>>>>>>>> immediately available in nightly builds; it won't be available on 
>>>>>>>> Flathub until the regular release at the end of September.
>>>>>>>> 
>>>>>>>> It's not possible to use CPAN, and consequently gnc-fq-update, in the 
>>>>>>>> flatpak, but you can do it manually similarly to the way you applied 
>>>>>>>> the yahoo_json patch: Download and untar the release tarball or clone 
>>>>>>>> the repo then copy Quote.pm and the contents of Quote/ into the right 
>>>>>>>> places in your flatpak.
>>>>>>>> 
>>>>>>>> Regards,
>>>>>>>> John Ralls
>>>> 
>> 


___
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] Update F::Q in flatpak GC?

[rsbrux via gnucash-user]

   I don’t need IndiaMutual.pm, but I don’t want to go back to 1.56
   because I would like to try out the updated version of six.pm.  Can I
   just delete IndaiMutual.pm?

   Sent from my iPad

 On 17 Aug 2023, at 19:30, john  wrote:

   

 IndiaMutual.pm has a new perl dependency IO::String
 ([1]https://metacpan.org/pod/IO::String) as of F::Q 1.57. That
 dependency is in the nightlies but not the release flatpak. It's
 pure perl and has no dependencies so you have a couple of ways
 forward:

   * Get the source code (there are links in the sidebar on the left on
   the IO::String page) and install it in the flatpak's perl directory as
   IO/String.pm

   * Install a recent nightly build and apply the F::Q update to that

   * If you don't need the IndiaMutual module you can restore the 1.56
   version that doesn't need IO::String.

   Regards,

   John Ralls

   On Aug 17, 2023, at 01:59, rsbrux  wrote:

   Thanks for the further tips.  I was unable to find gnucash.trace in
   either /tmp or /var/tmp (or their subdirectories.  Before trying to
   pipe the logs to the console as described in
   [2]https://wiki.gnucash.org/wiki/Flatpak#Getting_Console_Output, I
   tried running the quote retrieval from the command line, as you
   suggested.  This resulted in the following error message:

   >>

   Price retrieval failed: Finance::Quote check returned error Can't
   locate IO/String.pm in @INC (you may
   need to install the IO::String module) (@INC contains:
   /app/lib/perl5/site_perl/5.32.0/x86_64-linux /ap
   p/lib/perl5/site_perl/5.32.0 /app/lib/perl5/5.32.0/x86_64-linux
   /app/lib/perl5/5.32.0) at /app/lib/perl
   5/site_perl/5.32.0/Finance/Quote/IndiaMutual.pm line 33.
   BEGIN failed--compilation aborted at
   /app/lib/perl5/site_perl/5.32.0/Finance/Quote/IndiaMutual.pm line
   33.
   Compilation failed in require at
   /app/lib/perl5/site_perl/5.32.0/Module/Load.pm line 78.
   Can't locate Finance/Quote/IndiaMutual in @INC (@INC contains:
   /app/lib/perl5/site_perl/5.32.0/x86_64-l
   inux /app/lib/perl5/site_perl/5.32.0 /app/lib/perl5/5.32.0/x86_64-linux
   /app/lib/perl5/5.32.0) at /app/
   lib/perl5/site_perl/5.32.0/Module/Load.pm line 78.
   at /app/bin/finance-quote-wrapper line 113.
   Attempt to reload Finance/Quote/IndiaMutual.pm aborted.
   Compilation failed in require at
   /app/lib/perl5/site_perl/5.32.0/Module/Load.pm line 78.
   Can't locate Finance/Quote/IndiaMutual in @INC (@INC contains:
   /app/lib/perl5/site_perl/5.32.0/x86_64-l
   inux /app/lib/perl5/site_perl/5.32.0 /app/lib/perl5/5.32.0/x86_64-linux
   /app/lib/perl5/5.32.0) at /app/
   lib/perl5/site_perl/5.32.0/Module/Load.pm line 78.
   at /app/bin/finance-quote-wrapper line 114.

   <<

   This suggests to me that the changes in the pm scripts depend on
   changes in the actual program code.

   Can I just copy the entire tarball extract into
   /var/lib/flatpak/app/org.gnucash.GnuCash/current/active/, or do I need
   to limit what I copy or keep any residual files in that directory tree?

   Thanks for your support!
   On 15.08.23 19:19, john wrote:

   Look in the tracefile ([3]https://wiki.gnucash.org/wiki/Tracefile) or
   run `gnucash-cli -Q info` (see
   [4]https://wiki.gnucash.org/wiki/Flatpak#Using_Command_Line_Tools for
   how to run that from a flatpak) to see what the errors are.
   Regards,
   John Ralls

   On Aug 15, 2023, at 08:26, rsbrux [5] wrote:

   Now that I copied over the Quote directory and the Quote.pm script in
   /var/lib/flatpak/app/org.gnucash.GnuCash/current/active/files/lib/perl5
   /site_perl/5.32.0/Finance/ with the files from the 1.58 release
   package, the "Get Quotes" button in the Price Database tool is
   disabled. I already gave universal execute privileges to  all of the
   newly copied files (and directory).  What else might be the cause?
   On 15.08.23 14:51, rsbrux wrote:

 Sorry, dumb question.  I found the tarball here:
 [6]https://sourceforge.net/projects/finance-quote/
 On 15.08.23 14:48, rsbrux wrote:

 Thanks for the tip, but I'm not sure I'm getting the right source.
 [7]https://github.com/finance-quote/finance-quote offers a zip
 download of the code from master.  Is this the 1.58 release code or
 the current development version?  If the latter, where should I be
 looking for the release?
     On 14.08.23 18:58, john wrote:

 On Aug 14, 2023, at 04:33, rsbrux via gnucash-user
 [8] wrote:
 I am running GC 5.3+ as a flatpak under Ubuntu  Studio 22.04 LTS.
 The included F::Q version is 1..56, which I have modified with the
 Yahoo as JSON patch already published to this mailing list.
 However, it looks as though the current F::Q release, 1.58, includes
 quite a few fixes for various sources.
 The last I heard,  it wasn't possible to update F::Q within a
 flatpak installation of GC.  Is that still the c

Re: [GNC] Update F::Q in flatpak GC?

[rsbrux via gnucash-user]

Thanks for the further tips.  I was unable to find gnucash.trace in 
either /tmp or /var/tmp (or their subdirectories.  Before trying to pipe 
the logs to the console as described in 
https://wiki.gnucash.org/wiki/Flatpak#Getting_Console_Output, I tried 
running the quote retrieval from the command line, as you suggested.  
This resulted in the following error message:


>>

Price retrieval failed: Finance::Quote check returned error Can't locate 
IO/String.pm in @INC (you may
need to install the IO::String module) (@INC contains: 
/app/lib/perl5/site_perl/5.32.0/x86_64-linux /ap
p/lib/perl5/site_perl/5.32.0 /app/lib/perl5/5.32.0/x86_64-linux 
/app/lib/perl5/5.32.0) at /app/lib/perl

5/site_perl/5.32.0/Finance/Quote/IndiaMutual.pm line 33.
BEGIN failed--compilation aborted at 
/app/lib/perl5/site_perl/5.32.0/Finance/Quote/IndiaMutual.pm line

33.
Compilation failed in require at 
/app/lib/perl5/site_perl/5.32.0/Module/Load.pm line 78.
Can't locate Finance/Quote/IndiaMutual in @INC (@INC contains: 
/app/lib/perl5/site_perl/5.32.0/x86_64-l
inux /app/lib/perl5/site_perl/5.32.0 /app/lib/perl5/5.32.0/x86_64-linux 
/app/lib/perl5/5.32.0) at /app/

lib/perl5/site_perl/5.32.0/Module/Load.pm line 78.
at /app/bin/finance-quote-wrapper line 113.
Attempt to reload Finance/Quote/IndiaMutual.pm aborted.
Compilation failed in require at 
/app/lib/perl5/site_perl/5.32.0/Module/Load.pm line 78.
Can't locate Finance/Quote/IndiaMutual in @INC (@INC contains: 
/app/lib/perl5/site_perl/5.32.0/x86_64-l
inux /app/lib/perl5/site_perl/5.32.0 /app/lib/perl5/5.32.0/x86_64-linux 
/app/lib/perl5/5.32.0) at /app/

lib/perl5/site_perl/5.32.0/Module/Load.pm line 78.
at /app/bin/finance-quote-wrapper line 114.

<<

This suggests to me that the changes in the pm scripts depend on changes 
in the actual program code.


Can I just copy the entire tarball extract into 
/var/lib/flatpak/app/org.gnucash.GnuCash/current/active/, or do I need 
to limit what I copy or keep any residual files in that directory tree?


Thanks for your support!

On 15.08.23 19:19, john wrote:
Look in the tracefile (https://wiki.gnucash.org/wiki/Tracefile) or run 
`gnucash-cli -Q info` (see 
https://wiki.gnucash.org/wiki/Flatpak#Using_Command_Line_Tools for how 
to run that from a flatpak) to see what the errors are.


Regards,
John Ralls



On Aug 15, 2023, at 08:26, rsbrux  wrote:

Now that I copied over the Quote directory and the Quote.pm script in 
/var/lib/flatpak/app/org.gnucash.GnuCash/current/active/files/lib/perl5/site_perl/5.32.0/Finance/ 
with the files from the 1.58 release package, the "Get Quotes" button 
in the Price Database tool is disabled. I already gave universal 
execute privileges to  all of the newly copied files (and 
directory).  What else might be the cause?


On 15.08.23 14:51, rsbrux wrote:
Sorry, dumb question.  I found the tarball here: 
https://sourceforge.net/projects/finance-quote/


On 15.08.23 14:48, rsbrux wrote:

Thanks for the tip, but I'm not sure I'm getting the right source.

https://github.com/finance-quote/finance-quote offers a zip 
download of the code from master.  Is this the 1.58 release code or 
the current development version?  If the latter, where should I be 
looking for the release?


On 14.08.23 18:58, john wrote:


On Aug 14, 2023, at 04:33, rsbrux via gnucash-user 
 wrote:


I am running GC 5.3+ as a flatpak under Ubuntu Studio 22.04 LTS.

The included F::Q version is 1..56, which I have modified with 
the Yahoo as JSON patch already published to this mailing list.


However, it looks as though the current F::Q release, 1.58, 
includes quite a few fixes for various sources.


The last I heard,  it wasn't possible to update F::Q within a 
flatpak installation of GC.  Is that still the case?


If so, when can a flatpak update of GC containing F::Q 1.58 be 
expected?


If not, how can I update F::Q within my flatpak installation?
The update will be available when someone (probably I) have time 
to update the F::Q module in gnucash-on-flatpak. That update will 
be immediately available in nightly builds; it won't be available 
on Flathub until the regular release at the end of September.


It's not possible to use CPAN, and consequently gnc-fq-update, in 
the flatpak, but you can do it manually similarly to the way you 
applied the yahoo_json patch: Download and untar the release 
tarball or clone the repo then copy Quote.pm and the contents of 
Quote/ into the right places in your flatpak.


Regards,
John Ralls



___
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] Update F::Q in flatpak GC?

[rsbrux via gnucash-user]

Now that I copied over the Quote directory and the Quote.pm script in 
/var/lib/flatpak/app/org.gnucash.GnuCash/current/active/files/lib/perl5/site_perl/5.32.0/Finance/ 
with the files from the 1.58 release package, the "Get Quotes" button in 
the Price Database tool is disabled. I already gave universal execute 
privileges to  all of the newly copied files (and directory).  What else 
might be the cause?


On 15.08.23 14:51, rsbrux wrote:
Sorry, dumb question.  I found the tarball here: 
https://sourceforge.net/projects/finance-quote/


On 15.08.23 14:48, rsbrux wrote:

Thanks for the tip, but I'm not sure I'm getting the right source.

https://github.com/finance-quote/finance-quote offers a zip download 
of the code from master.  Is this the 1.58 release code or the 
current development version?  If the latter, where should I be 
looking for the release?


On 14.08.23 18:58, john wrote:


On Aug 14, 2023, at 04:33, rsbrux via gnucash-user 
 wrote:


I am running GC 5.3+ as a flatpak under Ubuntu  Studio 22.04 LTS.

The included F::Q version is 1..56, which I have modified with the 
Yahoo as JSON patch already published to this mailing list.


However, it looks as though the current F::Q release, 1.58, 
includes quite a few fixes for various sources.


The last I heard,  it wasn't possible to update F::Q within a 
flatpak installation of GC.  Is that still the case?


If so, when can a flatpak update of GC containing F::Q 1.58 be 
expected?


If not, how can I update F::Q within my flatpak installation?
The update will be available when someone (probably I) have time to 
update the F::Q module in gnucash-on-flatpak. That update will be 
immediately available in nightly builds; it won't be available on 
Flathub until the regular release at the end of September.


It's not possible to use CPAN, and consequently gnc-fq-update, in 
the flatpak, but you can do it manually similarly to the way you 
applied the yahoo_json patch: Download and untar the release tarball 
or clone the repo then copy Quote.pm and the contents of Quote/ into 
the right places in your flatpak.


Regards,
John Ralls

___
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] Update F::Q in flatpak GC?

[rsbrux via gnucash-user]

Sorry, dumb question.  I found the tarball here: 
https://sourceforge.net/projects/finance-quote/


On 15.08.23 14:48, rsbrux wrote:

Thanks for the tip, but I'm not sure I'm getting the right source.

https://github.com/finance-quote/finance-quote offers a zip download 
of the code from master.  Is this the 1.58 release code or the current 
development version?  If the latter, where should I be looking for the 
release?


On 14.08.23 18:58, john wrote:


On Aug 14, 2023, at 04:33, rsbrux via gnucash-user 
 wrote:


I am running GC 5.3+ as a flatpak under Ubuntu  Studio 22.04 LTS.

The included F::Q version is 1..56, which I have modified with the 
Yahoo as JSON patch already published to this mailing list.


However, it looks as though the current F::Q release, 1.58, includes 
quite a few fixes for various sources.


The last I heard,  it wasn't possible to update F::Q within a 
flatpak installation of GC.  Is that still the case?


If so, when can a flatpak update of GC containing F::Q 1.58 be 
expected?


If not, how can I update F::Q within my flatpak installation?
The update will be available when someone (probably I) have time to 
update the F::Q module in gnucash-on-flatpak. That update will be 
immediately available in nightly builds; it won't be available on 
Flathub until the regular release at the end of September.


It's not possible to use CPAN, and consequently gnc-fq-update, in the 
flatpak, but you can do it manually similarly to the way you applied 
the yahoo_json patch: Download and untar the release tarball or clone 
the repo then copy Quote.pm and the contents of Quote/ into the right 
places in your flatpak.


Regards,
John Ralls

___
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] Update F::Q in flatpak GC?

[rsbrux via gnucash-user]

Thanks for the tip, but I'm not sure I'm getting the right source.

https://github.com/finance-quote/finance-quote offers a zip download of 
the code from master.  Is this the 1.58 release code or the current 
development version?  If the latter, where should I be looking for the 
release?


On 14.08.23 18:58, john wrote:



On Aug 14, 2023, at 04:33, rsbrux via gnucash-user  
wrote:

I am running GC 5.3+ as a flatpak under Ubuntu  Studio 22.04 LTS.

The included F::Q version is 1..56, which I have modified with the Yahoo as 
JSON patch already published to this mailing list.

However, it looks as though the current F::Q release, 1.58, includes quite a 
few fixes for various sources.

The last I heard,  it wasn't possible to update F::Q within a flatpak 
installation of GC.  Is that still the case?

If so, when can a flatpak update of GC containing F::Q 1.58 be expected?

If not, how can I update F::Q within my flatpak installation?

The update will be available when someone (probably I) have time to update the 
F::Q module in gnucash-on-flatpak. That update will be immediately available in 
nightly builds; it won't be available on Flathub until the regular release at 
the end of September.

It's not possible to use CPAN, and consequently gnc-fq-update, in the flatpak, 
but you can do it manually similarly to the way you applied the yahoo_json 
patch: Download and untar the release tarball or clone the repo then copy 
Quote.pm and the contents of Quote/ into the right places in your flatpak.

Regards,
John Ralls

___
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] Update F::Q in flatpak GC?

[rsbrux via gnucash-user]

I am running GC 5.3+ as a flatpak under Ubuntu  Studio 22.04 LTS.

The included F::Q version is 1..56, which I have modified with the Yahoo 
as JSON patch already published to this mailing list.


However, it looks as though the current F::Q release, 1.58, includes 
quite a few fixes for various sources.


The last I heard,  it wasn't possible to update F::Q within a flatpak 
installation of GC.  Is that still the case?


If so, when can a flatpak update of GC containing F::Q 1.58 be expected?

If not, how can I update F::Q within my flatpak installation?

___
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] Yahoo Closed the Door on Finance API

[rsbrux via gnucash-user]

Any suggestions as to what would be the next best currently available source in 
F::Q for a broad spectrum of securities, especially European stocks?

>>
Some of us suspected this would come, getting reports of the Yahoo URL 
https://query2.finance.yahoo.com/v11/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics
and
https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics
now returning a 404 (v11) or "Unauthorized" (v10).

Sorry to say this, but more than likely the YahooJSON module (aka
yahoo_json) is going to be removed from Finance::Quote in the next release. 
This is not to say that if someone can figure out a way to successfully access 
Yahoo's https://query2.finance.yahoo.com/v?... APIs, please pass on that info 
or better yet, have a go at reworking the current module.

There is already an issue raised on F::Q's GitHub, 
https://github.com/finance-quote/finance-quote/issues/318. Please refrain from 
"me too" comments. Unfortunately as I said in the previous paragraph, this 
issue will likely be resolved by removing the module.

Bruce S.
<<


___
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] Hard-Copy Report Output

[rsbrux via gnucash-user]

Thanks for  the tiüp, Vincent, but these things don't add up in the 
flatpak installation.


In the Help - About dialog, GNC_DATA is shown as "/app/share/gnucash", 
which is also the path used in the HTML file.


However, clicking on the link leads to 
"/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/511cf18127561c55b5999121c6b301ca1e90d6cc988a00701257606df7fae86f/files/share/gnucash/" 
which does, in fact, contain a sudirectory "chartjs", which in turn 
contains both "Chart.bundle.min.js" and "Chart.bundle.js".


Evidently the HTML generation doesn't take the possibility of a flatpak 
installation into account.  I suppose I should file a bug for this, but 
I wouldn't know where.


Thnaks for your help!

On 12.06.23 20:20, Vincent Dawans wrote:
Not that it might solve your underlying issue, but here is a reliable 
way to locate Chart.bundle.min.js assuming it was installed correctly 
with the rest of GC. This should work on any OS.


1. Open GC and go in menu Help - About
2. In that dialog window, look for the entry for GNC_DATA. It's the 
last one in the list. It should point to a directory path, for 
instance on Windows C:\Program Files (x86)\gnucash\share\gnucash but 
it will be different on ubuntu, etc.
3. Navigate to that directory using whatever means your OS gives you 
to do that (File Manager, console, etc). In that directory that 
GNC_DATA is pointing to, you should find a subdirectory called 
chartjs. That is where Chart.bundle.min.js should be located and if 
any html file is pointing to it that ia what the path should be.


On Mon, Jun 12, 2023 at 11:03 AM rsbrux via gnucash-user 
 wrote:


> On Jun 11, 2023, at 9:56 AM, Adrien Monteleone
 wrote:
>Is this a completely custom report or just a saved configuration?
If completely custom, you may want to try the -dev list.

This is a report I assembled from the options available in the GC
GUI (like the pie chart you successfully tested).
Unfortunately, I am not competent to use the programming
facilities behind GC's report generation.


> On Jun 11, 2023, John Ralls  wrote:
>It's most likely a javascript problem. Open the javascript
console in your browser and see if there's an error finding
Chart.bundle.min.js.
>The correct location is
/share/gnucash/chartjs/Chart.bundle.min.js where 
is where GnuCash is installed: /usr for a Linux package manager
installation, /Applications/Gnucash.app/Contents/Resources for a
macOS bundle, C:\Program Files (x86)\gnucash for Windows, etc.
>
>You can fix the link by editing the html file in your favorite
text editor.

I have tried opening the exported HTML reports in Firefox on
Ubuntu and in Edge and Firefox on Windows.  Although the browser
consoles show errors, I don't see any pertaining to "
Chart.bundle.min.js", nor do I find any critical errors pertinent
to the report content.
The new HTML reports are looking for Chart.bundle.min.js in
/app/share/gnucash/chartjs/, but no such directory exists on the
Ubuntu system where GnuCash is installed.  In fact, there isn't
even an /app/ directory.  Perhaps this is due to GC being
installed as a flatpak.
Chart.bundle.min.js does not seem to exist on either system, so I
edited the HTML as you suggested, replacing the local path with
"https://cdnjs.cloudflare.com/ajax/libs/Chart.js/4.3.0/chart.min.js";
but this did not improve matters.
However, my previously saved HTML reports from GC 2.xx also don't
display correctly, even though they contain no references to
Chart.bundle.min.js.  This suggests a more fundamental problem and
reveals my presumption that the HTML files could be used as
archives as naive.
I have a previously saved PDF file, which is, of course still
usable.  This will be my method going forward, although the lack
of a "scale to fit" option in the GC print dialog requires a bit
of trial and error to get a satisfactory PDF.

Many thanks to both of you for your support!

___
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.

[GNC] Hard-Copy Report Output

[rsbrux via gnucash-user]

> On Jun 11, 2023, at 9:56 AM, Adrien Monteleone 
>  wrote:
>Is this a completely custom report or just a saved configuration? If 
>completely custom, you may want to try the -dev list.

This is a report I assembled from the options available in the GC GUI (like the 
pie chart you successfully tested).
Unfortunately, I am not competent to use the programming facilities behind GC's 
report generation.


> On Jun 11, 2023, John Ralls  wrote:
>It's most likely a javascript problem. Open the javascript console in your 
>browser and see if there's an error finding Chart.bundle.min.js. 
>The correct location is /share/gnucash/chartjs/Chart.bundle.min.js 
>where  is where GnuCash is installed: /usr for a Linux package manager 
>installation, /Applications/Gnucash.app/Contents/Resources for a macOS bundle, 
>C:\Program Files (x86)\gnucash for Windows, etc.
>
>You can fix the link by editing the html file in your favorite text editor.

I have tried opening the exported HTML reports in Firefox on Ubuntu and in Edge 
and Firefox on Windows.  Although the browser consoles show errors, I don't see 
any pertaining to " Chart.bundle.min.js", nor do I find any critical errors 
pertinent to the report content.
The new HTML reports are looking for Chart.bundle.min.js in 
/app/share/gnucash/chartjs/, but no such directory exists on the Ubuntu system 
where GnuCash is installed.  In fact, there isn't even an /app/ directory.  
Perhaps this is due to GC being installed as a flatpak.
Chart.bundle.min.js does not seem to exist on either system, so I edited the 
HTML as you suggested, replacing the local path with 
"https://cdnjs.cloudflare.com/ajax/libs/Chart.js/4.3.0/chart.min.js"; but this 
did not improve matters.
However, my previously saved HTML reports from GC 2.xx also don't display 
correctly, even though they contain no references to Chart.bundle.min.js.  This 
suggests a more fundamental problem and reveals my presumption that the HTML 
files could be used as archives as naive.
I have a previously saved PDF file, which is, of course still usable.  This 
will be my method going forward, although the lack of a "scale to fit" option 
in the GC print dialog requires a bit of trial and error to get a satisfactory 
PDF.

Many thanks to both of you for your support!

___
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] Hard-Copy Report Output

[rsbrux via gnucash-user]

Thanks for the advice, but these (custom) reports consist of pie charts and an 
accompanying legend.
Without the graphics they are useless.
The Html export still included them as of GC 2.19.

--

Message: 1
Date: Fri, 9 Jun 2023 19:33:34 -0500
From: Adrien Monteleone 
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Hard-Copy Report Output
Message-ID: 
Content-Type: text/plain; charset=UTF-8; format=flowed

Have you tried exporting the report as HTML, opening in a *browser*, and then 
printing from there? (I see you say it doesn't include 'graphics' 
but which graphics are you referring to? Most reports, rather than charts, 
don't contain any graphics save for perhaps table borders which render just 
fine for me in exported reports where used.)

Also consider select-all/copy/paste when viewing a report to a spreadsheet app 
and printing from it.

Either of those should work. (but I agree, printing from GnuCash should work 
too) Last I recall, the issue with GnuCash printing has to do with webkit. The 
details, I forget.

Regards,
Adrien

On 6/7/23 4:09 AM, rsbrux via gnucash-user wrote:
> I have never been able to get a satisdactory hard-copy output of 
> reports directly from Gnucash (running under Ubuntu).
> 
> In GnuCash 2.19 I was at least able to? export to HTML which gave me 
> more control over the printing process, and even allowed me to edit 
> the HTML if needed and had the added benefit of giving me a digital 
> copy to archive.
> 
> However, in GC 4.14 under Ubuntu Studio 22.04 LTS, the exported HTML 
> no longer includes the graphics, making many of the exported reports useless.
> 
> I have therefore again tried printing directly from GC, but the 
> printout is always in portrait mode, resulting in truncation of the output.
> 
> I have tried setting landscape mode in both the GC "Page Setup" dialog 
> and in the "Page Setup" dialog of the "Print Report" dialog, but both 
> are ignored.
> 
> I have also tried "Any Printer", "Print to LPR" and "MFCJ5955DW" (my 
> printer, connected via LAN) in the GC "Page Setup" dialog, to no effect.
> 
> I also treid "Print to file", but the resulting PDF is also portrait 
> mode and truncated, even though I specifed landscape in both the GC 
> "Page Setup" dialog and the "Page Setup" tab of the "Print Report" dialog.
> 
> How can I get a usable hard-copy report?


___
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] Hard-Copy Report Output

[rsbrux via gnucash-user]

I have never been able to get a satisdactory hard-copy output of reports 
directly from Gnucash (running under Ubuntu).


In GnuCash 2.19 I was at least able to  export to HTML which gave me 
more control over the printing process, and even allowed me to edit the 
HTML if needed and had the added benefit of giving me a digital copy to 
archive.


However, in GC 4.14 under Ubuntu Studio 22.04 LTS, the exported HTML no 
longer includes the graphics, making many of the exported reports useless.


I have therefore again tried printing directly from GC, but the printout 
is always in portrait mode, resulting in truncation of the output.


I have tried setting landscape mode in both the GC "Page Setup" dialog 
and in the "Page Setup" dialog of the "Print Report" dialog, but both 
are ignored.


I have also tried "Any Printer", "Print to LPR" and "MFCJ5955DW" (my 
printer, connected via LAN) in the GC "Page Setup" dialog, to no effect.


I also treid "Print to file", but the resulting PDF is also portrait 
mode and truncated, even though I specifed landscape in both the GC 
"Page Setup" dialog and the "Page Setup" tab of the "Print Report" dialog.


How can I get a usable hard-copy report?

Thanks in advance for any tips!

___
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] Version Information in new Flatpak Release?

[rsbrux via gnucash-user]

Thanks for responding.  I didn‘t mean to apply any pressure, I just thought it 
appropriate to report something which might indicate an oversight in the 
packaging of the Flatpak release.  I have been perfectly happy with 4.13+ (and 
many previous releases) and am not in a hurry to upgrade.  Many thanks for your 
dedication to GnuCash!

Sent from my iPad

> On 26 Mar 2023, at 19:18, john  wrote:
> 
> Patience. This weekend's release is a double, both 4.13 and 5.0. Since I 
> haven't yet figured out how to do six things at once and anyway have to 
> manipulate several git repositories in the right order, it's taking time and 
> some things like flathub are getting pushed ahead of the announcements.
> 
> Tommy Trussell  reported a similar strange update prompt on Ubuntu 22.04 a 
> couple of weeks ago with a very tardy prompt to update to 4.13, which he 
> already had. I guess that's not a very reliable tool.
> 
> Regards,
> John Ralls
> 
>> On Mar 26, 2023, at 2:13 AM, rsbrux via gnucash-user 
>>  wrote:
>> 
>> For many months now I have been using GC 4.13+ installed as a flatpak under 
>> Ubuntu Studio 22.04 LTS.
>> Today KDE Discover offered to update GC "to version 4.13+ (Flathub 4.13) 
>> (stable)"
>> However, looking at the Flathub web page 
>> (https://flathub.org/apps/details/org.gnucash.GnuCash), I see:
>> Updated: March 25, 2023
>> Version: 4.14+ (Flathub 4.14)
>> 
>> After letting Discover perform the update, running:
>> flatpak run --command=sh org.gnucash.GnuCash
>> gnucash --version
>> as described here: 
>> https://wiki.gnucash.org/wiki/Flatpak#Using_Command_Line_Tools
>> yields:
>> GnuCash 4.14
>> Build ID: Flathub 4.14
>> 
>> so it looks as though some version information in the Flatpak repository for 
>> GC hasn't been updated properly.
>> ___
>> 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.

[GNC] Version Information in new Flatpak Release?

[rsbrux via gnucash-user]

For many months now I have been using GC 4.13+ installed as a flatpak 
under Ubuntu Studio 22.04 LTS.
Today KDE Discover offered to update GC "to version 4.13+ (Flathub 4.13) 
(stable)"
However, looking at the Flathub web page 
(https://flathub.org/apps/details/org.gnucash.GnuCash), I see:

Updated: March 25, 2023
Version: 4.14+ (Flathub 4.14)

After letting Discover perform the update, running:
flatpak run --command=sh org.gnucash.GnuCash
gnucash --version
as described here: 
https://wiki.gnucash.org/wiki/Flatpak#Using_Command_Line_Tools

yields:
GnuCash 4.14
Build ID: Flathub 4.14

so it looks as though some version information in the Flatpak repository 
for GC hasn't been updated properly.

___
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] Can't complete "To-Create" scheduled transaction in "Since Last Run"

[rsbrux via gnucash-user]

I have a scheduled transaction involving two currencies: a charge in EUR 
which is charged to  a CHF credit card.


This has worked in the past.

When the "Since Last Run" dialog appears, it lists this transaction 
under "To-Create" and shows:

EUR <-> CHF    (Need value)

When I click on "(Need value)", it turns into what appears to be a text 
edit field, where I usually enter an exchange rate.


However, today, no value was accepted, leaving me unable to close the 
"Since Last Run" dialog with "OK".


I couldn't find any relevant information in the online 
 help in 
the included help or on the wiki 
.


How is this supposed to work?

The exchange rate is one of those which is automatically updated each 
time the computer starts.


Why can't GnuCash simply use the most recent exchange rate from the 
Price Database?


BTW, the included help  has a self-reference in the topic "Since Last 
Run Assistant": the link "Scheduled Transactions " 
links back to the same topic.


According to KDE Discover, I am running GnuCash 4.13+ released on 
2022-12-17 as a flatpak under Ubuntu Studio 22.04 LTS.


Running:

>>

flatpak run --command=sh org.gnucash.GnuCash
[ org.gnucash.GnuCash ~]$ gnucash --version << as documented on the 
wiki  produces: >> GnuCash 4.13 
Build ID: Flathub 4.13 <<

___
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] Wacky idea

[rsbrux via gnucash-user]

As an alternative, you could export your reports as HTML.
This will give you better control over the formatting and the resulting reports 
can be navigated by hyperlinks.  I am not sure hyperlinks work in a PDF export.
Kind Regards, Roger
> 
> Hi,
> 
> Unless your accountant is familiar w/ GnuCash, they usually don't want to
> learn another program.
> However, you mentioned you give then your report on paper. Why not just get
> them a PDF copy? You eliminate the physical copy and they don't have to
> worry about loading GnuCash.
> 
> On Sat, Jan 28, 2023 at 3:38 PM Simon Roberts <
> si...@dancingcloudservices.com> wrote:
> 
>> I'm aware I could work this out for myself, but it could involve a lot of
>> wasted time if the answer is no, and this list might have a quick answer
>> either way.
>> 
>> At some point, I'll need to submit my books to my CPA. They'll take the
>> usual reports (general ledger, trial balance, stuff like that) on paper,
>> but is seems that GNC is not that hard to navigate around, and it might be
>> worth giving them, or offering them at least, a "live" set of books along
>> with GNC to interact with them.
>> 
>> I envisage burning a CDROM with the books, and a Windows distribution of
>> GNC, hopefully so they can simply put the disk in and click to run.
>> Obviously, the books will be read-only in that event, but they'd be
>> navigable.
>> 
>> Has anyone tried this? Is such an installation a possibility? (I'm a Linux
>> user, and it's not unusual to run software that's just "sitting around in a
>> directory tree", but such is not always possible in windows, so that alone
>> might prevent this.).
>> 
>> Anyway, if anyone has thoughts or relevant experience, I'd be pleased to
>> hear from you.
>> 
>> Cheers,
>> Simon
> 
>> I envisage burning a CDROM with the books, and a Windows distribution
>> of GNC, hopefully so they can simply put the disk in and click to run.
>> Obviously, the books will be read-only in that event, but they'd be
>> navigable.
>> 
>> Has anyone tried this? Is such an installation a possibility? (I'm a
>> Linux user, and it's not unusual to run software that's just "sitting
>> around in a directory tree", but such is not always possible in
>> windows, so that alone might prevent this.).
> 
> 
> I do it, and the year I didn't provide the .exe file I got asked for
> it. That was related to Covid lockdown and sending the files
> electronically, instead of my usual CD-ROM
> 
> 
> Liz
> 

___
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 Price Updates

[rsbrux via gnucash-user]

Meanwhile I have found a simpler solution, which should also continue to 
work with GnuCash 5.x.


I have created a script named "z-gnucash-update.sh" in 
"/etc/profile.d/", containing:
flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get to GnuCash data file>


The script name begins with "z" to ensure that it runs *after* all other 
scripts in "/etc/profile.d/".


It runs *for any user* at login *after* user authorization.  This is 
important in my case because my GnuCash data file is on a network file 
share needing user authorization.


The key advantage of doing it this way (as opposed e.g. to using cron or 
crontab) is that the script gets executed *before* the user's GUI 
session starts.


This means that there cannot be any competition between the update 
script and an interactive GnuCash session for access to the GnuCash data 
file.


I have only tested this in Ubuntu Studio 22.04 LTS, but see no reason 
why this approach shouldn't work in any Ubuntu variant.


If any of you can confirm that it works in other variants, I will add a 
decription to the wiki.


Thanks to all for your advice and support!

On 05.12.22 20:50, john wrote:
Get it working before worrying about the rest. First make sure that 
the hook is firing by adding a print statement to the lambda, 
something like

 (gnc-hook-add-scm-dangler HOOK-UI-POST-STARTUP
   (lambda ()
   (format #t "Retrieving Quotes~%")
   (gnc:book-add-quotes #f (gnc-get-current-book)))

You'll need to run GnuCash from a terminal session with `flatpak run 
org.gnucash.GnuCash` to see the output. You might want to add 
--logto=stderr to that so that you'll see the results of the perl and 
FQ checks to make sure that that's not the problem.


Regards,
John Ralls


On Dec 5, 2022, at 2:31 AM, rsbrux  wrote:

A little further study suggests that I should have placed 
config-user.scm in GNC_CONFIG_HOME (in my case 
$HOME/.var/app/org.gnucash.GnuCash/config/gnucash/) instead of 
GNC_DATA_HOME (see 
https://wiki.gnucash.org/wiki/Configuration_Locations#In_GNC_CONFIG_HOME).


However, moving it there still did not have the desired effect (i.e. 
no new prices appeared in GC's Price DB, even after leaving GC open 
for a quarter hour).  It occurred to me that this could be caused by 
inadequate privileges, but changing the privileges of config-user.scm 
to 775 (and restarting GC) still did not result in any new price quotes.


As previously mentioned I would like this behaviour to be 
user-independent.  It appears that I should be able to achieve this 
by redirecting GNC_CONFIG_HOME to a common direct by means of 
environment variable. However, the pages 
https://wiki.gnucash.org/wiki/Configuration_Locations and 
https://wiki.gnucash.org/wiki/Environment_Variables disagree on the 
names of the environment variables.


On 28.11.22 08:53, rsbrux wrote:

Of course.

Sent from my iPad


On 27 Nov 2022, at 22:41, John Ralls  wrote:

Did you restart GnuCash?

Regards,
John Ralls



On Nov 27, 2022, at 11:07 AM, rsbrux  wrote:

P.S. I created the file 
$HOME/.var/app/org.gnucash.GnuCash/data/gnucash/config-user.scm


with the contents:

 (gnc-hook-add-scm-dangler HOOK-UI-POST-STARTUP
   (lambda () (gnc:book-add-quotes #f (gnc-get-current-book)))

under my own Ubuntu login, but the price database does not show 
any new prices when I open GC and let it sit for half an hour.


Thanks for your help.


On 27.11.22 18:35, rsbrux wrote:
Thanks, that sounds very promising! My only problem is that I 
have a Flatpak installation under Ubuntu.


According to 
https://code.gnucash.org/wiki/Configuration_Locations#GNC_DATA_HOME, 
GNC_DATA_HOME is under $HOME.


However, I have installed GC for all users on the system and want 
the startup task to run regardless of who is running GC.


If I put config-user.scm in 
$HOME/.var/app/org.gnucash.GnuCash/data/gnucash, won't it be 
user-specific?


On 25.11.22 21:07, john wrote:
On Nov 25, 2022, at 12:56 AM, rsbrux via gnucash-user 


wrote:

I used to have a chron job set up to automatically fetch 
security prices on first login each day, but found this 
inconvenient because it locks the data file, and opening 
GnuCash is often the first thing I do upon logging in.


I have noticed that when I have GC open interactively, I can 
start an update in the price database window and let it run in 
the background while I continue to work in the registers.


Would there be some way to get GC to perform the Price Database 
automatically when GC is started (interactively), instead of 
performing the automatic price update in a separate session?



Yes, but only through 4.x because the quotes system won't be 
accessible from Scheme in GnuCash 5, it having been rewritten in 
C++.


Create if necessary $GNC_DATA_HOME/config-user.scm and edit it 
to add

 (gnc-hook-add-scm-dangler HOOK-UI-POST-STARTUP
   (lambda () (gnc:book-add-quotes #f (gnc-get-curr

Re: [GNC] Automatic Price Updates

[rsbrux via gnucash-user]

A little further study suggests that I should have placed 
config-user.scm in GNC_CONFIG_HOME (in my case 
$HOME/.var/app/org.gnucash.GnuCash/config/gnucash/) instead of 
GNC_DATA_HOME (see 
https://wiki.gnucash.org/wiki/Configuration_Locations#In_GNC_CONFIG_HOME).


However, moving it there still did not have the desired effect (i.e. no 
new prices appeared in GC's Price DB, even after leaving GC open for a 
quarter hour).  It occurred to me that this could be caused by 
inadequate privileges, but changing the privileges of config-user.scm to 
775 (and restarting GC) still did not result in any new price quotes.


As previously mentioned I would like this behaviour to be 
user-independent.  It appears that I should be able to achieve this by 
redirecting GNC_CONFIG_HOME to a common direct by means of environment 
variable.  However, the pages 
https://wiki.gnucash.org/wiki/Configuration_Locations and 
https://wiki.gnucash.org/wiki/Environment_Variables disagree on the 
names of the environment variables.


On 28.11.22 08:53, rsbrux wrote:

Of course.

Sent from my iPad


On 27 Nov 2022, at 22:41, John Ralls  wrote:

Did you restart GnuCash?

Regards,
John Ralls



On Nov 27, 2022, at 11:07 AM, rsbrux  wrote:

P.S. I created the file 
$HOME/.var/app/org.gnucash.GnuCash/data/gnucash/config-user.scm

with the contents:

  (gnc-hook-add-scm-dangler HOOK-UI-POST-STARTUP
(lambda () (gnc:book-add-quotes #f (gnc-get-current-book)))

under my own Ubuntu login, but the price database does not show any new prices 
when I open GC and let it sit for half an hour.

Thanks for your help.


On 27.11.22 18:35, rsbrux wrote:
Thanks, that sounds very promising! My only problem is that I have a Flatpak 
installation under Ubuntu.

According to 
https://code.gnucash.org/wiki/Configuration_Locations#GNC_DATA_HOME, 
GNC_DATA_HOME is under $HOME.

However, I have installed GC for all users on the system and want the startup 
task to run regardless of who is running GC.

If I put config-user.scm in $HOME/.var/app/org.gnucash.GnuCash/data/gnucash, 
won't it be user-specific?

On 25.11.22 21:07, john wrote:

On Nov 25, 2022, at 12:56 AM, rsbrux via gnucash-user 
wrote:

I used to have a chron job set up to automatically fetch security prices on 
first login each day, but found this inconvenient because it locks the data 
file, and opening GnuCash is often the first thing I do upon logging in.

I have noticed that when I have GC open interactively, I can start an update in 
the price database window and let it run in the background while I continue to 
work in the registers.

Would there be some way to get GC to perform the Price Database automatically 
when GC is started (interactively), instead of performing the automatic price 
update in a separate session?



Yes, but only through 4.x because the quotes system won't be accessible from 
Scheme in GnuCash 5, it having been rewritten in C++.

Create if necessary $GNC_DATA_HOME/config-user.scm and edit it to add
  (gnc-hook-add-scm-dangler HOOK-UI-POST-STARTUP
(lambda () (gnc:book-add-quotes #f (gnc-get-current-book)))

Regards,
John Ralls



___
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 Price Updates

[rsbrux via gnucash-user]

Of course.

Sent from my iPad

> On 27 Nov 2022, at 22:41, John Ralls  wrote:
> 
> Did you restart GnuCash?
> 
> Regards,
> John Ralls
> 
> 
>> On Nov 27, 2022, at 11:07 AM, rsbrux  wrote:
>> 
>> P.S. I created the file 
>> $HOME/.var/app/org.gnucash.GnuCash/data/gnucash/config-user.scm
>> 
>> with the contents:
>> 
>>  (gnc-hook-add-scm-dangler HOOK-UI-POST-STARTUP
>>(lambda () (gnc:book-add-quotes #f (gnc-get-current-book)))
>> 
>> under my own Ubuntu login, but the price database does not show any new 
>> prices when I open GC and let it sit for half an hour.
>> 
>> Thanks for your help.
>> 
>>> On 27.11.22 18:35, rsbrux wrote:
>>> Thanks, that sounds very promising! My only problem is that I have a 
>>> Flatpak installation under Ubuntu.
>>> 
>>> According to 
>>> https://code.gnucash.org/wiki/Configuration_Locations#GNC_DATA_HOME, 
>>> GNC_DATA_HOME is under $HOME.
>>> 
>>> However, I have installed GC for all users on the system and want the 
>>> startup task to run regardless of who is running GC.
>>> 
>>> If I put config-user.scm in 
>>> $HOME/.var/app/org.gnucash.GnuCash/data/gnucash, won't it be user-specific?
>>> 
>>> On 25.11.22 21:07, john wrote:
>>>>> On Nov 25, 2022, at 12:56 AM, rsbrux via gnucash-user 
>>>>> 
>>>>> wrote:
>>>>> 
>>>>> I used to have a chron job set up to automatically fetch security prices 
>>>>> on first login each day, but found this inconvenient because it locks the 
>>>>> data file, and opening GnuCash is often the first thing I do upon logging 
>>>>> in.
>>>>> 
>>>>> I have noticed that when I have GC open interactively, I can start an 
>>>>> update in the price database window and let it run in the background 
>>>>> while I continue to work in the registers.
>>>>> 
>>>>> Would there be some way to get GC to perform the Price Database 
>>>>> automatically when GC is started (interactively), instead of performing 
>>>>> the automatic price update in a separate session?
>>>>> 
>>>>> 
>>>> Yes, but only through 4.x because the quotes system won't be accessible 
>>>> from Scheme in GnuCash 5, it having been rewritten in C++.
>>>> 
>>>> Create if necessary $GNC_DATA_HOME/config-user.scm and edit it to add
>>>>  (gnc-hook-add-scm-dangler HOOK-UI-POST-STARTUP
>>>>(lambda () (gnc:book-add-quotes #f (gnc-get-current-book)))
>>>> 
>>>> Regards,
>>>> John Ralls
>>>> 
>>>> 
> 

___
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 Price Updates

[rsbrux via gnucash-user]

P.S. I created the file $HOME 
<https://code.gnucash.org/wiki/Configuration_Locations#HOME>/.var/app/org.gnucash.GnuCash/data/gnucash/config-user.scm


with the contents:

  (gnc-hook-add-scm-dangler HOOK-UI-POST-STARTUP
(lambda () (gnc:book-add-quotes #f (gnc-get-current-book)))

under my own Ubuntu login, but the price database does not show any new prices 
when I open GC and let it sit for half an hour.

Thanks for your help.

On 27.11.22 18:35, rsbrux wrote:


Thanks, that sounds very promising! My only problem is that I have a 
Flatpak installation under Ubuntu.


According to 
https://code.gnucash.org/wiki/Configuration_Locations#GNC_DATA_HOME, 
GNC_DATA_HOME is under $HOME.


However, I have installed GC for all users on the system and want the 
startup task to run regardless of who is running GC.


If I put config-user.scm in $HOME 
<https://code.gnucash.org/wiki/Configuration_Locations#HOME>/.var/app/org.gnucash.GnuCash/data/gnucash, 
won't it be user-specific?


On 25.11.22 21:07, john wrote:

On Nov 25, 2022, at 12:56 AM, rsbrux via gnucash-user 
 wrote:

I used to have a chron job set up to automatically fetch security prices on 
first login each day, but found this inconvenient because it locks the data 
file, and opening GnuCash is often the first thing I do upon logging in.

I have noticed that when I have GC open interactively, I can start an update in 
the price database window and let it run in the background while I continue to 
work in the registers.

Would there be some way to get GC to perform the Price Database automatically 
when GC is started (interactively), instead of performing the automatic price 
update in a separate session?


Yes, but only through 4.x because the quotes system won't be accessible from 
Scheme in GnuCash 5, it having been rewritten in C++.

Create if necessary $GNC_DATA_HOME/config-user.scm and edit it to add
   (gnc-hook-add-scm-dangler HOOK-UI-POST-STARTUP
 (lambda () (gnc:book-add-quotes #f (gnc-get-current-book)))

Regards,
John Ralls


___
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 Price Updates

[rsbrux via gnucash-user]

Thanks, that sounds very promising! My only problem is that I have a 
Flatpak installation under Ubuntu.


According to 
https://code.gnucash.org/wiki/Configuration_Locations#GNC_DATA_HOME, 
GNC_DATA_HOME is under $HOME.


However, I have installed GC for all users on the system and want the 
startup task to run regardless of who is running GC.


If I put config-user.scm in $HOME 
<https://code.gnucash.org/wiki/Configuration_Locations#HOME>/.var/app/org.gnucash.GnuCash/data/gnucash, 
won't it be user-specific?


On 25.11.22 21:07, john wrote:



On Nov 25, 2022, at 12:56 AM, rsbrux via gnucash-user 
 wrote:

I used to have a chron job set up to automatically fetch security prices on 
first login each day, but found this inconvenient because it locks the data 
file, and opening GnuCash is often the first thing I do upon logging in.

I have noticed that when I have GC open interactively, I can start an update in 
the price database window and let it run in the background while I continue to 
work in the registers.

Would there be some way to get GC to perform the Price Database automatically 
when GC is started (interactively), instead of performing the automatic price 
update in a separate session?


Yes, but only through 4.x because the quotes system won't be accessible from 
Scheme in GnuCash 5, it having been rewritten in C++.

Create if necessary $GNC_DATA_HOME/config-user.scm and edit it to add
   (gnc-hook-add-scm-dangler HOOK-UI-POST-STARTUP
 (lambda () (gnc:book-add-quotes #f (gnc-get-current-book)))

Regards,
John Ralls


___
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 Price Updates

[rsbrux via gnucash-user]

I used to have a chron job set up to automatically fetch security prices 
on first login each day, but found this inconvenient because it locks 
the data file, and opening GnuCash is often the first thing I do upon 
logging in.


I have noticed that when I have GC open interactively, I can start an 
update in the price database window and let it run in the background 
while I continue to work in the registers.


Would there be some way to get GC to perform the Price Database 
automatically when GC is started (interactively), instead of performing 
the automatic price update in a separate session?


___
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 in GC 4.11 Flatpak

[rsbrux via gnucash-user]

Since gnc-fq-update dcidn't work from inside the Flatpak sandbox, I 
copied the entire .../lib/Finance directory from the current master 
branch (presumably version 1.53 alpha) into my Flatpak installation. Now 
quote retrieval seems to work satisfactorily, including currency 
exchange rates.


On 29.09.22 11:46, rsbrux wrote:

RSBrux:

I use a Mac, not a Flatpak on Linux, but one detail of this thread caught my
eye. You say, "for the one [file named AlphaVantage.pm]? in my Flatpak
installation". On the Mac, Finance::Quote installs not one, but two files
named AlphaVantage.pm . When I run the "find" command below, I get two
results:

/Library/Perl/5.30/Finance/Quote/AlphaVantage.pm
/Library/Perl/5.30/Finance/Quote/CurrencyRates/AlphaVantage.pm

It is the second file, within the directory CurrencyRates/, which must be
updated. Does Flatpack contain two such files? Did you update the correct
one?

The first file was 12527 bytes, the second (inside CurrencyRates/) is
3938 bytes as updated.

Now the situation may be different on Flatpak, in which case this comment is
of no use to you. My apologies.

Best regards,
  ??? ?Jim DeLaHunt
<<

Thanks for pointing that out!
The directory  .../Perl/5.30/Finance/Quote/ in my Flatpak installation has
no subdirectories, but I see that the fixed AlphaVantage.pm is in the
CurrencyRates subdirectory of the master branch on github
(https://github.com/finance-quote/finance-quote/tree/master/lib/Finance/Quote/CurrencyRates).
I therefore restored the original AlphaVantage.pm in
.../Perl/5.30/Finance/Quote/, downloaded the master branch of F::Q and
copied the CurrencyRates subdirectory into my Flatpak installation.
Unfortunately, "Get Quotes" still takes 15 minutes and then returns the same
"Unable to retrieve" message.
Kdiff identifies 70 changed files between F::Q 1.49 and the current master
branch, so I guess I will either have to install the entire master branch or
install 1.52 and replace the appropriate AlphaVantage.pm
What really puzzles me is why F::Q insists on getting currency exchange
rates from AlphaVantage, when it's so complicated.  In the course of my
research, I noticed that F::Q retrieves a currency list from Yahoo (in
"Currencies.pm").   It seems that Yahoo also offers FX rates
(https://finance.yahoo.com/currencies).  Wouldn't it be easier to retrieve
the rates from Yahoo as well?

___
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 in GC 4.11 Flatpak

[rsbrux via gnucash-user]

>>
RSBrux:

I use a Mac, not a Flatpak on Linux, but one detail of this thread caught my 
eye. You say, "for the one [file named AlphaVantage.pm]? in my Flatpak 
installation". On the Mac, Finance::Quote installs not one, but two files named 
AlphaVantage.pm . When I run the "find" command below, I get two results:

/Library/Perl/5.30/Finance/Quote/AlphaVantage.pm
/Library/Perl/5.30/Finance/Quote/CurrencyRates/AlphaVantage.pm

It is the second file, within the directory CurrencyRates/, which must be 
updated. Does Flatpack contain two such files? Did you update the correct one?

The first file was 12527 bytes, the second (inside CurrencyRates/) is
3938 bytes as updated.

Now the situation may be different on Flatpak, in which case this comment is of 
no use to you. My apologies.

Best regards,
 ??? ?Jim DeLaHunt
<<

Thanks for pointing that out!
The directory  .../Perl/5.30/Finance/Quote/ in my Flatpak installation has no 
subdirectories, but I see that the fixed AlphaVantage.pm is in the 
CurrencyRates subdirectory of the master branch on github 
(https://github.com/finance-quote/finance-quote/tree/master/lib/Finance/Quote/CurrencyRates).
I therefore restored the original AlphaVantage.pm in 
.../Perl/5.30/Finance/Quote/, downloaded the master branch of F::Q and copied 
the CurrencyRates subdirectory into my Flatpak installation. Unfortunately, 
"Get Quotes" still takes 15 minutes and then returns the same "Unable to 
retrieve" message.
Kdiff identifies 70 changed files between F::Q 1.49 and the current master 
branch, so I guess I will either have to install the entire master branch or 
install 1.52 and replace the appropriate AlphaVantage.pm
What really puzzles me is why F::Q insists on getting currency exchange rates 
from AlphaVantage, when it's so complicated.  In the course of my research, I 
noticed that F::Q retrieves a currency list from Yahoo (in "Currencies.pm").   
It seems that Yahoo also offers FX rates 
(https://finance.yahoo.com/currencies).  Wouldn't it be easier to retrieve the 
rates from Yahoo as well?

___
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 in GC 4.11 Flatpak

[rsbrux via gnucash-user]

The file I got from Geoff’s link below was only 3.8 kB.  I downloaded a 12.2 kB 
version from 
https://raw.githubusercontent.com/finance-quote/finance-quote/master/lib/Finance/Quote/AlphaVantage.pm.

After copying it into the Flatpack installation, “Get Quotes” is no longer 
disabled, but it took around 15 minutes and still displayed “Unable to retrieve 
quotes …” for all 5 of my currencies.

 

From: rsbrux  
Sent: Monday, September 26, 2022 5:44 PM
To: 'gnucash-user@gnucash.org' 
Subject: Finance::Quote in GC 4.11 Flatpak

 

I have installed my free AlphaVantage API key in /etc/environment, but when I 
try to "Get Quotes", I get the well-known message "Unable to retrieve quotes 
for these items:, CURRENCY:  ...".  I presume that this is due to the problem 
reported on the page 
https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US:

>>
GnuCash stopped being able to retrieve currency exchange rates using a free 
AlphaVantage API key from about Aug 15 2022 because AlphaVantage made the 
method F::Q used to obtain exchange rates unavailable for free API keys.

F::Q has been modified to work with free API keys and the fix should be 
available in the next F::Q version (1.53).
<<

By running "gnc-fq-check" in a console running "flatpak run --command=sh 
org.gnucash.GnuCash" I found that the F::Q version in my Flatpak installation 
is 1.49.  Obviously, I would like to update F::Q to version 1.53.   I tried 
running "gnc-fq-update" from within "flatpak run --command=sh 
org.gnucash.GnuCash", but it fails from a normal account (presumably due to 
inadequate priveleges), and "sudo flatpak run --command=sh org.gnucash.GnuCash" 
doesn't work either, nor does running "flatpak run --command=sh 
org.gnucash.GnuCash" after having used "su " to invoke it with 
higher privileges.

1. How can I update F::Q in my Flatpak installation?

2. Will this solve the problem? V1.53 isn't listed in either SourceForge or 
metacpan.

3. I looked at the workaround 
(https://github.com/finance-quote/finance-quote/pull/230), but it isn't clear 
to me:

a. How to obtain the updated AlphaVantage.pm from github pull #230?

b. How to apply it to the flatpak environment?

 

___
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 in GC 4.11 Flatpak

[rsbrux via gnucash-user]

Unfortunately, this didn’t wotk for me.  After substituting the version of 
AlphaVantage.pm linked below for the one in my Flatpak installation, “Get 
Quotes” was completely disabled.  I suspect that I don’t have the correct file, 
because the new version is much smaller than the original AlphaVantage.pm fron 
F::Q 1.49.

Sent from my iPad

> On 27 Sep 2022, at 03:28, Murugan Muruganandam  
> wrote:
> 
> 
> Geoff
> 
> thanks so much, it works perfectly for me in windows, i replaced the 
> AlphaVantage.pm file with the FX_Daily code
> 
> 
> 
> 
> 
> Saludos Cordiales
> 
> 
> 
> Murugan
> 
> From: gnucash-user 
>  on behalf of 
> Geoff 
> Sent: Monday, September 26, 2022 9:48 PM
> To: rsbrux ; gnucash-user@gnucash.org 
> 
> Subject: Re: [GNC] Finance::Quote in GC 4.11 Flatpak
>  
> CAVEAT:- I am not familiar with FlatPak.
> 
> 1. See 3b.
> 
> 2. I personally have no idea, but discussion on the pull request you 
> cited says YES.
> 
> 3a. 
> https://raw.githubusercontent.com/shirayu/finance-quote/9aee4b6d06da8a0e689b751d0e926160fb99d71b/lib/Finance/Quote/CurrencyRates/AlphaVantage.pm
> 
> 3b.  Follow these steps to locate and replace your current 
> AlphaVantage.pm file:-
> 
> 3b.1  Save the file from 3a (plain text) as AlphaVantage.pm in a 
> temporary location.
> 
> 3b.2  Find the current copy of AlphaVantage.pm on your machine - run 
> something like this command:
>sudo find / -name AlphaVantage.pm -print
> 
> 3b.3  Rename the current copy of AlphaVantage.pm in that location to 
> something like AlphaVantage.pm.BACKUP
> 
> 3b.4   Copy the AlphaVantage.pm file from 3b.1 to that location.
> 
> 4.  If the above makes things worse, simply delete the new file and 
> rename the backup file.
> 
> Good luck!
> 
> Geoff
> =
> 
> 
> On 27/09/2022 1:43 am, rsbrux via gnucash-user wrote:
> > I have installed my free AlphaVantage API key in /etc/environment, but when 
> > I try to "Get Quotes", I get the well-known message "Unable to retrieve 
> > quotes for these items:, CURRENCY:  ...".  I presume that this is due to 
> > the problem reported on the page 
> > https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US:
> > 
> >>>
> > GnuCash stopped being able to retrieve currency exchange rates using a free 
> > AlphaVantage API key from about Aug 15 2022 because AlphaVantage made the 
> > method F::Q used to obtain exchange rates unavailable for free API keys.
> > 
> > F::Q has been modified to work with free API keys and the fix should be 
> > available in the next F::Q version (1.53).
> > <<
> > 
> > By running "gnc-fq-check" in a console running "flatpak run --command=sh 
> > org.gnucash.GnuCash" I found that the F::Q version in my Flatpak 
> > installation is 1.49.  Obviously, I would like to update F::Q to version 
> > 1.53.   I tried running "gnc-fq-update" from within "flatpak run 
> > --command=sh org.gnucash.GnuCash", but it fails from a normal account 
> > (presumably due to inadequate priveleges), and "sudo flatpak run 
> > --command=sh org.gnucash.GnuCash" doesn't work either, nor does running 
> > "flatpak run --command=sh org.gnucash.GnuCash" after having used "su 
> > " to invoke it with higher privileges.
> > 
> > 1. How can I update F::Q in my Flatpak installation?
> > 
> > 2. Will this solve the problem? V1.53 isn't listed in either SourceForge or 
> > metacpan.
> > 
> > 3. I looked at the workaround 
> > (https://github.com/finance-quote/finance-quote/pull/230), but it isn't 
> > clear to me:
> > 
> > a. How to obtain the updated AlphaVantage.pm from github pull #230?
> > 
> > b. How to apply it to the flatpak environment?
> > 
> >   
> > 
> > ___
> > 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.

[GNC] Finance::Quote in GC 4.11 Flatpak

[rsbrux via gnucash-user]

I have installed my free AlphaVantage API key in /etc/environment, but when I 
try to "Get Quotes", I get the well-known message "Unable to retrieve quotes 
for these items:, CURRENCY:  ...".  I presume that this is due to the problem 
reported on the page 
https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US:

>>
GnuCash stopped being able to retrieve currency exchange rates using a free 
AlphaVantage API key from about Aug 15 2022 because AlphaVantage made the 
method F::Q used to obtain exchange rates unavailable for free API keys.

F::Q has been modified to work with free API keys and the fix should be 
available in the next F::Q version (1.53).
<<

By running "gnc-fq-check" in a console running "flatpak run --command=sh 
org.gnucash.GnuCash" I found that the F::Q version in my Flatpak installation 
is 1.49.  Obviously, I would like to update F::Q to version 1.53.   I tried 
running "gnc-fq-update" from within "flatpak run --command=sh 
org.gnucash.GnuCash", but it fails from a normal account (presumably due to 
inadequate priveleges), and "sudo flatpak run --command=sh org.gnucash.GnuCash" 
doesn't work either, nor does running "flatpak run --command=sh 
org.gnucash.GnuCash" after having used "su " to invoke it with 
higher privileges.

1. How can I update F::Q in my Flatpak installation?

2. Will this solve the problem? V1.53 isn't listed in either SourceForge or 
metacpan.

3. I looked at the workaround 
(https://github.com/finance-quote/finance-quote/pull/230), but it isn't clear 
to me:

a. How to obtain the updated AlphaVantage.pm from github pull #230?

b. How to apply it to the flatpak environment?

 

___
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] gnucash 4.11 truncates trailing zeroes in Price Database

[rsbrux via gnucash-user]

Meanwhile I have upgraded to GC 4.11 running as a Flatpak under Ubuntu 
Studio 22.04.1. The reported problem with truncation of trailing zeroes 
after the decimal point in the Reconcile dialog appears to be fixed in 
this version. However, I now have a similar problem with the Price 
Database dialog, as reported by David below. I liked it better when all 
price entries displayed with the same number of places after the decimal 
point. Is there a way to get this behaviour back?


-Original Message-
From: rsbrux 
Sent: Sunday, September 4, 2022 7:38 AM
To: 'gnucash-user@gnucash.org' 
Subject: Re: gnucash reconcile doesn't respect "Decimal places"

Thanks to all who responded!

@Adrien



3.11 or 4.11? 4.11 is the current version.
<<
3.11. I realize that 4.11 is the current version, but I have just 
migrated from 2.6.19 and want to make sure everything is working 
correctly before taking the next step.
The GC wiki gave me the impression that 3.11 is still supported, but I 
can live with this until I upgrade to 4.11.


Do you happen to have Preferences > Numbers, Date, Time > Numbers > 
'Automatic Decimal Point' checked by any chance? If so, it might be 
dropping '.00'

<<
I have tried both settings; it doesn't make a difference.

@David


This seems to be similar to the behaviour of displayed prices in the 
Price Database - dp doesn't line up as it always truncates prices on the 
right of the decimal point to the last non zero digit regardless of the 
? Currently running 4.11 but it's been like this for as long as I can 
remember.

<<
Odd: my price database always shows 6 figures after the decimal point in 
3.11, even if the last 4 are zeroes. IIRC, this was also the case in 2.6.19.


@Geoff


That is not my experience with version 4.8 on Windows 10 - see attached 
screenshot.

<<
Your screenshot looks like what I used to get in 2.6.19. I guess the 
next step is to upgrade to 4.x


___
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] gnucash reconcile doesn't respect "Decimal places"

[rsbrux via gnucash-user]

Thanks to all who responded!

@Adrien
>>
3.11 or 4.11? 4.11 is the current version.
<<
3.11.  I realize that 4.11 is the current version, but I have just migrated 
from 2.6.19 and want to make sure everything is working correctly before taking 
the next step.
The GC wiki gave me the impression that 3.11 is still supported, but I can live 
with this until I upgrade to 4.11.
>>
Do you happen to have Preferences > Numbers, Date, Time > Numbers > 'Automatic 
Decimal Point' checked by any chance? If so, it might be dropping '.00'
<<
I have tried both settings; it doesn't make a difference.

@David
>>
This seems to be similar to the behaviour of displayed prices in the Price 
Database - dp doesn't line up as it always truncates prices on the right of the 
decimal point to the last non zero digit regardless of the ?  Currently running 
4.11 but it's been like this for as long as I can remember.
<<
Odd: my price database always shows 6 figures after the decimal point in 3.11, 
even if the last 4 are zeroes.  IIRC, this was also the case in 2.6.19.

@Geoff
>>
That is not my experience with version 4.8 on Windows 10 - see attached 
screenshot.
<<
Your screenshot looks like what I used to get in 2.6.19.  I guess the next step 
is to upgrade to 4.x


___
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] gnucash reconcile doesn't respect "Decimal places"

[rsbrux via gnucash-user]

In version 3.11 running under Windows 10 21H2, the reconcile window only 
displays non-zero figures after the decimal point.

For example, 25.00 displays as “25”.  I would like Reconcile to display all 
numbers with two digits after the decimal point, as I have configured in the 
“Numbers” section of the General Preferences.

This is the way it behaved in GC 2.6.19 running under Ubuntu Studio 18.04, 
before I migrated my data file.

How can I get back the desired display?

___
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] GC 3.11 crashes during "Check & Repair"

[rsbrux via gnucash-user]

Thanks Kalpesh,
My problem is that the Ubuntu Studio 22.04 repositories only have GC 4.8, and I 
don't feel competent to install a Flatpak.
Is there a repository I can add to my Software Sources to install later GC 
versions?
If not, how about a snap?  I would feel more comfortable with that than with a 
Flatpak, because snap is already baked in to Ubuntu Studio 22.04.

-Original Message-
From: Kalpesh Patel  
Sent: Monday, August 29, 2022 10:45 PM
To: rsb...@yahoo.com
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] GC 3.11 crashes during "Check & Repair"

4.11 is the current official release so it won't hurt to go to that version 
instead of 4.8. 

I use compressed XML version of file running on Windows 11 and frankly speaking 
I never had to revert back to previous version of data file for being corrupt. 
This history goes back to since 3.x version days. 
 
I do reconcile my accounts, including brokerage, on 6 to 7 month cycles and 
have found to match transactions downloaded so corruption is least of worries 
with GNC.

--

Message: 9
Date: Mon, 29 Aug 2022 16:25:23 +0200
From: "rsbrux" 
To: 
Subject: Re: [GNC] GC 3.11 crashes during "Check & Repair"
Message-ID:



Content-Type: text/plain;   charset="UTF-8"

Many thanks to all who have offered help and advice.  The following evidence 
strongly suggests a memory management problem to me:
1. I was able to perform "Check & Repair" on all accounts and subaccounts by 
dividing them up into smaller groups, saving, exiting and restarting GC in 
between.
2. If I tried to "Check & Repair" too much at once, GUI response would slow 
dramatically and GC would forget how to do things it had already done 
successful in the same session, e.g. saving, which, when attempted, produced 
messages like:
>>
* 22:08:34  WARN  [gnc_builder_connect_full_func()] ggaff: could not 
find signal handler 'gnc_ui_file_access_response_cb'.
<<
I now have what I think is a working and fully checked file in GC 3.11 for 
Windows and will now try upgrading it to 4.8 in Ubuntu Studio.
My file does include Trading accounts, so Kalpesh's suspicions may be right.
However, this raises the question of whether I need a newer version than 4.8 in 
Ubuntu Studio.



--


___
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] GC 3.11 crashes during "Check & Repair"

[rsbrux via gnucash-user]

Many thanks to all who have offered help and advice.  The following evidence 
strongly suggests a memory management problem to me:
1. I was able to perform "Check & Repair" on all accounts and subaccounts by 
dividing them up into smaller groups, saving, exiting and restarting GC in 
between.
2. If I tried to "Check & Repair" too much at once, GUI response would slow 
dramatically and GC would forget how to do things it had already done 
successful in the same session, e.g. saving, which, when attempted, produced 
messages like:
>>
* 22:08:34  WARN  [gnc_builder_connect_full_func()] ggaff: could not 
find signal handler 'gnc_ui_file_access_response_cb'.
<<
I now have what I think is a working and fully checked file in GC 3.11 for 
Windows and will now try upgrading it to 4.8 in Ubuntu Studio.
My file does include Trading accounts, so Kalpesh's suspicions may be right.  
However, this raises the question of whether I need a newer version than 4.8 in 
Ubuntu Studio.

___
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] GC 3.11 crashes during "Check & Repair"

[rsbrux via gnucash-user]

Thanks for all the references, particularly for reminding me to check the trace 
file.  Unfortunately, the only error messages logged in the trace file were at 
the beginning of the process:
* 09:31:56 ERROR  gnc_process_get_fd: assertion 'proc' failed
* 09:31:56 ERROR  gnc_detach_process: assertion 'proc && 
proc->pid' failed
I am reluctant to venture into gdb, much less compiling GC myself, but perhaps 
these lines at the end of the trace file give a hint to which part of the XML 
file is giving "Check & Repair" indigestion:
* 10:07:41  INFO  [xaccAccountScrubImbalance] Finished 
processing split 113 of 304
* 10:07:41  INFO  [xaccAccountScrubImbalance] Start 
processing split 114 of 304
Is there any way for me to identify what part of the XML file "split 114 of 
304" corresponds to?
Given that GC was started several times by mistake when price update were 
running on the same file, I suspect that the bad records are in the price 
history part of the DB.
I can readily do without the price history if there is some way of migrating 
all of the transactions to the new file version.

Of course I ran 3.11 on a copy.

--

Message: 2
Date: Sun, 28 Aug 2022 11:27:05 +1000
From: David Cousens 
To: gnucash-user@gnucash.org
Subject: Re: [GNC] GC 3.11 crashes during "Check & Repair"
Message-ID: 
Content-Type: text/plain; charset="UTF-8"

Try the following to get more information.
https://wiki.gnucash.org/wiki/Logging
https://wiki.gnucash.org/wiki/Tracefile
https://wiki.gnucash.org/wiki/Windows_Debugging
https://wiki.gnucash.org/wiki/Stack_Trace
Without more information no-one is going to be able to help much. Also search
the archive from around the 3.0 release date. 

Hopefully you kept a backup of your original file before running 3.8 and only
ran 3.8 on a copy?

David Cousens


On Sat, 2022-08-27 at 21:00 +0200, rsbrux via gnucash-user wrote:
> I installed GC 3.11 on a PC running Windows 10 21H2 and ran "Check & Repair
> All" on my GC 2.6.19 XML file (twice).
> Each time, GnuCash crashed after about half an hour.
> The log files do not contain any warnings or error messages.
> What now?
> 
> -Original Message-
> From: rsbrux  
> Sent: Saturday, August 27, 2022 7:06 PM
> To: 'gnucash-user@gnucash.org' 
> Subject: Re: [GNC] GnuCash 3 for Ubuntu Studio 22.04 LTS
> 
> > > 
> Message: 3
> Date: Fri, 26 Aug 2022 15:41:33 -0500
> From: Adrien Monteleone 
> To: gnucash-u...@lists.gnucash.org
> Subject: Re: [GNC] GnuCash 3 for Ubuntu Studio 22.04 LTS
> Message-ID: 
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> Interesting question.
> 
> Perhaps try a 3.x flatpak?
> 
> Otherwise, if you haven't yet jumped from 18.04 to 22.04 maybe an interim stop
> at 20.04 will get you GnuCash 3.x.
> 
> (Can you even go directly from 18.04 to 22.04? I didn't think it would even
> give you the option)
> 
> Be sure to review the Wiki about upgrading. You'll need to run Actions > Check
> & Repair > Check & Repair All at each upgrade of a major version.
> 
> Regards,
> Adrien
> <<
> Thanks for the tips! I came across the Flatpak possibility, but was dissuaded
> by the apparent complexity of the description at:
> https://wiki.gnucash.org/wiki/Flatpak
> 
> David's suggestion:
> > > 
> Another approach to consider is using the 20.04 (focal) live ISO. Just put the
> ISO on a USB and boot from that, then install gnucash in the live environment,
> and using that to convert your gnucash data to version 3. That way you don't
> have to try to install different versions on either 18.04 or 22.04.
> <<
> sounded easier since I had already made a boot disk for Ubuntu Studio 20.04
> LTS.
> Unfortunately, that didn't work.? I was able to boot from the live DVD and
> install GC 3.8.? However, when I tried to run Check & Repair All, following
> your suggestion, it never finished. Check & Repair gives no indication of its
> progress in either 2.16.9 or in 3.8.? The menu bar and toolbar flash
> occasionally while Check & Repair is running, but the only indication that it
> isn't done is that the menu cannot be operated and there is no indication of
> it having finished.? In the live Ubuntu Studio 20.04 environment, the GUI
> would become unresponsive if inactive for as little as 15 minutes, even after
> I disabled all suspend, screen lock and screen saver features, making it
> difficult to just let Check & Repair run as long as necessary.? After that the
> DVD would start working overtime.? I have had a similar problem with the GUI
> becoming unresponsive in my freshly installed US 22.04, but only if I leave it
> idle on the login scr

Re: [GNC] GC 3.11 crashes during "Check & Repair"

[rsbrux via gnucash-user]

I ran GC 3.11 under Windows again, this time with the --debug argument, and 
then ran "Check & Repair All"  in the hope of getting some useful information 
in the logfile.
Again, GC crashed after about half an hour, but the logfile contains neither 
errors nor warnings. The Windows event log show the following:
>>
Faulting application name: gnucash.exe, version: 3.11.0.0, time stamp: 
0x5ef7bbc2
Faulting module name: libglib-2.0-0.dll, version: 2.64.3.0, time stamp: 
0x
Exception code: 0x4015
Fault offset: 0x00057e1d
Faulting process id: 0x275c
Faulting application start time: 0x01d8bab03bae87f8
Faulting application path: C:\Program Files (x86)\gnucash\bin\gnucash.exe
Faulting module path: C:\Program Files (x86)\gnucash\bin\libglib-2.0-0.dll
Report Id: 91583241-2b39-4a20-b312-faa33c724463
Faulting package full name: 
Faulting package-relative application ID:
<<
Each of the files on which I have run "Check & Repair All" in GC 3.x had 
already been run through "Check & Repair All" in GC 2.6.19 under Ubuntu Studio 
18.04.

-Original Message-
From: rsbrux  
Sent: Sunday, August 28, 2022 10:00 AM
To: gnucash-user@gnucash.org
Subject: RE: GC 3.11 crashes during "Check & Repair"

It only just occurred to me to check the Windows Event logs.  Here is what I 
found:
1st error, corresponding (I think) to the first start of GC 3.11
>>
Faulting application name: gnucash.exe, version: 3.11.0.0, time stamp: 
0x5ef7bbc2 Faulting module name: libgncmod-engine.dll, version: 0.0.0.0, time 
stamp: 0x5ef7ba76 Exception code: 0xc005 Fault offset: 0x0003cf84 Faulting 
process id: 0x1990 Faulting application start time: 0x01d8ba3868850898 Faulting 
application path: C:\Program Files (x86)\gnucash\bin\gnucash.exe Faulting 
module path: C:\Program Files (x86)\gnucash\bin\libgncmod-engine.dll
Report Id: 222a2745-380e-4d4d-bd73-e27f653fd9c8
Faulting package full name: 
Faulting package-relative application ID:
<<
2nd error, corresponding to the 1st crash of GC 3.11 during "Check & Repair 
All":
>>
Faulting application name: gnucash.exe, version: 3.11.0.0, time stamp: 
0x5ef7bbc2 Faulting module name: libglib-2.0-0.dll, version: 2.64.3.0, time 
stamp: 0x Exception code: 0x4015 Fault offset: 0x00057e1d Faulting 
process id: 0xb6c Faulting application start time: 0x01d8ba3a485a7065 Faulting 
application path: C:\Program Files (x86)\gnucash\bin\gnucash.exe Faulting 
module path: C:\Program Files (x86)\gnucash\bin\libglib-2.0-0.dll
Report Id: 1edde4ec-9eb9-451c-abd6-3662f227bcbd
Faulting package full name: 
Faulting package-relative application ID:
<<
3rd error, corresponding to the 2nd crash of GC 3.11 during "Check & Repair 
All":
>>
Faulting application name: gnucash.exe, version: 3.11.0.0, time stamp: 
0x5ef7bbc2 Faulting module name: libglib-2.0-0.dll, version: 2.64.3.0, time 
stamp: 0x Exception code: 0x4015 Fault offset: 0x00057e1d Faulting 
process id: 0x46c Faulting application start time: 0x01d8ba3f44557642 Faulting 
application path: C:\Program Files (x86)\gnucash\bin\gnucash.exe Faulting 
module path: C:\Program Files (x86)\gnucash\bin\libglib-2.0-0.dll
Report Id: 10b979f3-9283-4ded-9504-7daf9be1e3de
Faulting package full name: 
Faulting package-relative application ID:
<<

Since "Check & Repair" only appears to use the GUI to select accounts for 
partial checks, it would be nice to have a command line option (like the one to 
update prices) to perform "Check & Repair All" then save & exit, e.g.:
gnucash --repairall [datafile]

-Original Message-
From: rsbrux
Sent: Saturday, August 27, 2022 9:00 PM
To: 'gnucash-user@gnucash.org' 
Subject: GC 3.11 crashes during "Check & Repair"

I installed GC 3.11 on a PC running Windows 10 21H2 and ran "Check & Repair 
All" on my GC 2.6.19 XML file (twice).
Each time, GnuCash crashed after about half an hour.
The log files do not contain any warnings or error messages.
What now?

-Original Message-
From: rsbrux 
Sent: Saturday, August 27, 2022 7:06 PM
To: 'gnucash-user@gnucash.org' 
Subject: Re: [GNC] GnuCash 3 for Ubuntu Studio 22.04 LTS

>>
Message: 3
Date: Fri, 26 Aug 2022 15:41:33 -0500
From: Adrien Monteleone 
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] GnuCash 3 for Ubuntu Studio 22.04 LTS
Message-ID: 
Content-Type: text/plain; charset=UTF-8; format=flowed

Interesting question.

Perhaps try a 3.x flatpak?

Otherwise, if you haven't yet jumped from 18.04 to 22.04 maybe an interim stop 
at 20.04 will get you GnuCash 3.x.

(Can you even go directly from 18.04 to 22.04? I didn't think it would even 
give you the option)

Be sure to review the Wiki about upgrading. You'll need to run Actions > Check 
& Repair > Check & Repair All at each upgrade of a major version.

Regards,
Adrien
<<
Thanks for the tips! I came across the Flatpak possibility, but was dissuaded 
by the apparent complexity of the description at:
https://wiki.gnucash.org/wiki/Flatpak

David's suggestion:
>>
Another approach to consider is using the 20.

Re: [GNC] GC 3.11 crashes during "Check & Repair"

[rsbrux via gnucash-user]

It only just occurred to me to check the Windows Event logs.  Here is what I 
found:
1st error, corresponding (I think) to the first start of GC 3.11
>>
Faulting application name: gnucash.exe, version: 3.11.0.0, time stamp: 
0x5ef7bbc2
Faulting module name: libgncmod-engine.dll, version: 0.0.0.0, time stamp: 
0x5ef7ba76
Exception code: 0xc005
Fault offset: 0x0003cf84
Faulting process id: 0x1990
Faulting application start time: 0x01d8ba3868850898
Faulting application path: C:\Program Files (x86)\gnucash\bin\gnucash.exe
Faulting module path: C:\Program Files (x86)\gnucash\bin\libgncmod-engine.dll
Report Id: 222a2745-380e-4d4d-bd73-e27f653fd9c8
Faulting package full name: 
Faulting package-relative application ID:
<<
2nd error, corresponding to the 1st crash of GC 3.11 during "Check & Repair 
All":
>>
Faulting application name: gnucash.exe, version: 3.11.0.0, time stamp: 
0x5ef7bbc2
Faulting module name: libglib-2.0-0.dll, version: 2.64.3.0, time stamp: 
0x
Exception code: 0x4015
Fault offset: 0x00057e1d
Faulting process id: 0xb6c
Faulting application start time: 0x01d8ba3a485a7065
Faulting application path: C:\Program Files (x86)\gnucash\bin\gnucash.exe
Faulting module path: C:\Program Files (x86)\gnucash\bin\libglib-2.0-0.dll
Report Id: 1edde4ec-9eb9-451c-abd6-3662f227bcbd
Faulting package full name: 
Faulting package-relative application ID:
<<
3rd error, corresponding to the 2nd crash of GC 3.11 during "Check & Repair 
All":
>>
Faulting application name: gnucash.exe, version: 3.11.0.0, time stamp: 
0x5ef7bbc2
Faulting module name: libglib-2.0-0.dll, version: 2.64.3.0, time stamp: 
0x
Exception code: 0x4015
Fault offset: 0x00057e1d
Faulting process id: 0x46c
Faulting application start time: 0x01d8ba3f44557642
Faulting application path: C:\Program Files (x86)\gnucash\bin\gnucash.exe
Faulting module path: C:\Program Files (x86)\gnucash\bin\libglib-2.0-0.dll
Report Id: 10b979f3-9283-4ded-9504-7daf9be1e3de
Faulting package full name: 
Faulting package-relative application ID:
<<

Since "Check & Repair" only appears to use the GUI to select accounts for 
partial checks, it would be nice to have a command line option (like the one to 
update prices) to perform "Check & Repair All" then save & exit, e.g.:
gnucash --repairall [datafile]

-Original Message-
From: rsbrux 
Sent: Saturday, August 27, 2022 9:00 PM
To: 'gnucash-user@gnucash.org' 
Subject: GC 3.11 crashes during "Check & Repair"

I installed GC 3.11 on a PC running Windows 10 21H2 and ran "Check & Repair 
All" on my GC 2.6.19 XML file (twice).
Each time, GnuCash crashed after about half an hour.
The log files do not contain any warnings or error messages.
What now?

-Original Message-
From: rsbrux  
Sent: Saturday, August 27, 2022 7:06 PM
To: 'gnucash-user@gnucash.org' 
Subject: Re: [GNC] GnuCash 3 for Ubuntu Studio 22.04 LTS

>>
Message: 3
Date: Fri, 26 Aug 2022 15:41:33 -0500
From: Adrien Monteleone 
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] GnuCash 3 for Ubuntu Studio 22.04 LTS
Message-ID: 
Content-Type: text/plain; charset=UTF-8; format=flowed

Interesting question.

Perhaps try a 3.x flatpak?

Otherwise, if you haven't yet jumped from 18.04 to 22.04 maybe an interim stop 
at 20.04 will get you GnuCash 3.x.

(Can you even go directly from 18.04 to 22.04? I didn't think it would even 
give you the option)

Be sure to review the Wiki about upgrading. You'll need to run Actions > Check 
& Repair > Check & Repair All at each upgrade of a major version.

Regards,
Adrien
<<
Thanks for the tips! I came across the Flatpak possibility, but was dissuaded 
by the apparent complexity of the description at:
https://wiki.gnucash.org/wiki/Flatpak

David's suggestion:
>>
Another approach to consider is using the 20.04 (focal) live ISO. Just put the 
ISO on a USB and boot from that, then install gnucash in the live environment, 
and using that to convert your gnucash data to version 3. That way you don't 
have to try to install different versions on either 18.04 or 22.04.
<<
sounded easier since I had already made a boot disk for Ubuntu Studio 20.04 LTS.
Unfortunately, that didn't work.  I was able to boot from the live DVD and 
install GC 3.8.  However, when I tried to run Check & Repair All, following 
your suggestion, it never finished. Check & Repair gives no indication of its 
progress in either 2.16.9 or in 3.8.  The menu bar and toolbar flash 
occasionally while Check & Repair is running, but the only indication that it 
isn't done is that the menu cannot be operated and there is no indication of it 
having finished.  In the live Ubuntu Studio 20.04 environment, the GUI would 
become unresponsive if inactive for as little as 15 minutes, even after I 
disabled all suspend, screen lock and screen saver features, making it 
difficult to just let Check & Repair run as long as necessary.  After that the 
DVD would start working overtime.  I have had a similar problem with the GUI 
becoming unresponsive in my f

[GNC] GC 3.11 crashes during "Check & Repair"

[rsbrux via gnucash-user]

I installed GC 3.11 on a PC running Windows 10 21H2 and ran "Check & Repair 
All" on my GC 2.6.19 XML file (twice).
Each time, GnuCash crashed after about half an hour.
The log files do not contain any warnings or error messages.
What now?

-Original Message-
From: rsbrux  
Sent: Saturday, August 27, 2022 7:06 PM
To: 'gnucash-user@gnucash.org' 
Subject: Re: [GNC] GnuCash 3 for Ubuntu Studio 22.04 LTS

>>
Message: 3
Date: Fri, 26 Aug 2022 15:41:33 -0500
From: Adrien Monteleone 
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] GnuCash 3 for Ubuntu Studio 22.04 LTS
Message-ID: 
Content-Type: text/plain; charset=UTF-8; format=flowed

Interesting question.

Perhaps try a 3.x flatpak?

Otherwise, if you haven't yet jumped from 18.04 to 22.04 maybe an interim stop 
at 20.04 will get you GnuCash 3.x.

(Can you even go directly from 18.04 to 22.04? I didn't think it would even 
give you the option)

Be sure to review the Wiki about upgrading. You'll need to run Actions > Check 
& Repair > Check & Repair All at each upgrade of a major version.

Regards,
Adrien
<<
Thanks for the tips! I came across the Flatpak possibility, but was dissuaded 
by the apparent complexity of the description at:
https://wiki.gnucash.org/wiki/Flatpak

David's suggestion:
>>
Another approach to consider is using the 20.04 (focal) live ISO. Just put the 
ISO on a USB and boot from that, then install gnucash in the live environment, 
and using that to convert your gnucash data to version 3. That way you don't 
have to try to install different versions on either 18.04 or 22.04.
<<
sounded easier since I had already made a boot disk for Ubuntu Studio 20.04 LTS.
Unfortunately, that didn't work.  I was able to boot from the live DVD and 
install GC 3.8.  However, when I tried to run Check & Repair All, following 
your suggestion, it never finished. Check & Repair gives no indication of its 
progress in either 2.16.9 or in 3.8.  The menu bar and toolbar flash 
occasionally while Check & Repair is running, but the only indication that it 
isn't done is that the menu cannot be operated and there is no indication of it 
having finished.  In the live Ubuntu Studio 20.04 environment, the GUI would 
become unresponsive if inactive for as little as 15 minutes, even after I 
disabled all suspend, screen lock and screen saver features, making it 
difficult to just let Check & Repair run as long as necessary.  After that the 
DVD would start working overtime.  I have had a similar problem with the GUI 
becoming unresponsive in my freshly installed US 22.04, but only if I leave it 
idle on the login screen.
At this point I plan to try installing GC 3.8 on a Windows PC to do the file 
conversion.  Wish me luck!

--
>>
Message: 5
Date: Fri, 26 Aug 2022 16:19:43 -0500
From: David Carlson 
To: Adrien Monteleone 
Cc: GnuCash List 
Subject: Re: [GNC] GnuCash 3 for Ubuntu Studio 22.04 LTS
Message-ID:

Content-Type: text/plain; charset="UTF-8"

It's not me, But if it were, I might do a fresh install rather than upgrade 
twice to get to 22.04.

On Fri, Aug 26, 2022, 3:43 PM Adrien Monteleone < 
adrien.montele...@lusfiber.net> wrote:
<<
Great minds think alike 😉 That's exactly what I had done!

--
>>
Message: 9
Date: Sat, 27 Aug 2022 10:54:30 +0200
From: "rsbrux" 
To: 
Subject: Re: [GNC] GnuCash 3 for Ubuntu Studio 22.04 LTS
Message-ID:



Content-Type: text/plain;   charset="utf-8"

P.S. I still have a working Ubuntu 18.04 installation, so I thought I might 
find GnuCash 3.8 in a backport repository.

However, I have only found it in focal (1:3.8b-1build4) and focal-updates 
(1:3.8b-1ubuntu1).

What is the difference between 3.8b-1build4 and 3.8b-1ubuntu1?

Would it be safe to install either of these GC versions in either Ubuntu 18.04 
or 22.04?

 

 

From: rsbrux  
Sent: Friday, August 26, 2022 12:03 PM
To: 'gnucash-user@gnucash.org' 
Subject: GnuCash 3 for Ubuntu Studio 22.04 LTS

 

According to https://wiki.gnucash.org/wiki/Ubuntu, ?GnuCash 4.8 is included in 
Ubuntu 22.04, released April 2022 https://packages.ubuntu.com/jammy/gnucash?.

I was running GC 2.6.19 under Ubuntu Studio 18.04 and I have read on this 
mailing list that I will need to migrate to GC v 3.x before I can migrate to GC 
4.

I would therefore like to install GC 3.8b. What is the easiest way to do this?

Is there a repository I can add to Discover that I can pull it (or at least 
some stable 3.x version) from?
<<

___
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] GnuCash 3 for Ubuntu Studio 22.04 LTS

[rsbrux via gnucash-user]

>>
Message: 3
Date: Fri, 26 Aug 2022 15:41:33 -0500
From: Adrien Monteleone 
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] GnuCash 3 for Ubuntu Studio 22.04 LTS
Message-ID: 
Content-Type: text/plain; charset=UTF-8; format=flowed

Interesting question.

Perhaps try a 3.x flatpak?

Otherwise, if you haven't yet jumped from 18.04 to 22.04 maybe an interim
stop at 20.04 will get you GnuCash 3.x.

(Can you even go directly from 18.04 to 22.04? I didn't think it would even
give you the option)

Be sure to review the Wiki about upgrading. You'll need to run Actions >
Check & Repair > Check & Repair All at each upgrade of a major version.

Regards,
Adrien
<<
Thanks for the tips! I came across the Flatpak possibility, but was
dissuaded by the apparent complexity of the description at:
https://wiki.gnucash.org/wiki/Flatpak

David's suggestion:
>>
Another approach to consider is using the 20.04 (focal) live ISO. Just put
the ISO on a USB and boot from that, then install gnucash in the live
environment, and using that to convert your gnucash data to version 3. That
way you don't have to try to install different versions on either 18.04 or
22.04.
<<
sounded easier since I had already made a boot disk for Ubuntu Studio 20.04
LTS.
Unfortunately, that didn't work.  I was able to boot from the live DVD and
install GC 3.8.  However, when I tried to run Check & Repair All, following
your suggestion, it never finished. Check & Repair gives no indication of
its progress in either 2.16.9 or in 3.8.  The menu bar and toolbar flash
occasionally while Check & Repair is running, but the only indication that
it isn't done is that the menu cannot be operated and there is no indication
of it having finished.  In the live Ubuntu Studio 20.04 environment, the GUI
would become unresponsive if inactive for as little as 15 minutes, even
after I disabled all suspend, screen lock and screen saver features, making
it difficult to just let Check & Repair run as long as necessary.  After
that the DVD would start working overtime.  I have had a similar problem
with the GUI becoming unresponsive in my freshly installed US 22.04, but
only if I leave it idle on the login screen.
At this point I plan to try installing GC 3.8 on a Windows PC to do the
file conversion.  Wish me luck!

--
>>
Message: 5
Date: Fri, 26 Aug 2022 16:19:43 -0500
From: David Carlson 
To: Adrien Monteleone 
Cc: GnuCash List 
Subject: Re: [GNC] GnuCash 3 for Ubuntu Studio 22.04 LTS
Message-ID:

Content-Type: text/plain; charset="UTF-8"

It's not me, But if it were, I might do a fresh install rather than upgrade
twice to get to 22.04.

On Fri, Aug 26, 2022, 3:43 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
<<
Great minds think alike 😉 That's exactly what I had done!

--
>>
Message: 9
Date: Sat, 27 Aug 2022 10:54:30 +0200
From: "rsbrux" 
To: 
Subject: Re: [GNC] GnuCash 3 for Ubuntu Studio 22.04 LTS
Message-ID:



Content-Type: text/plain;   charset="utf-8"

P.S. I still have a working Ubuntu 18.04 installation, so I thought I might
find GnuCash 3.8 in a backport repository.

However, I have only found it in focal (1:3.8b-1build4) and focal-updates
(1:3.8b-1ubuntu1).

What is the difference between 3.8b-1build4 and 3.8b-1ubuntu1?

Would it be safe to install either of these GC versions in either Ubuntu
18.04 or 22.04?

 

 

From: rsbrux  
Sent: Friday, August 26, 2022 12:03 PM
To: 'gnucash-user@gnucash.org' 
Subject: GnuCash 3 for Ubuntu Studio 22.04 LTS

 

According to https://wiki.gnucash.org/wiki/Ubuntu, ?GnuCash 4.8 is included
in Ubuntu 22.04, released April 2022
https://packages.ubuntu.com/jammy/gnucash?.

I was running GC 2.6.19 under Ubuntu Studio 18.04 and I have read on this
mailing list that I will need to migrate to GC v 3.x before I can migrate to
GC 4.

I would therefore like to install GC 3.8b. What is the easiest way to do
this?

Is there a repository I can add to Discover that I can pull it (or at least
some stable 3.x version) from?
<<
<>___
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] GnuCash 3 for Ubuntu Studio 22.04 LTS

[rsbrux via gnucash-user]

P.S. I still have a working Ubuntu 18.04 installation, so I thought I might 
find GnuCash 3.8 in a backport repository.

However, I have only found it in focal (1:3.8b-1build4) and focal-updates 
(1:3.8b-1ubuntu1).

What is the difference between 3.8b-1build4 and 3.8b-1ubuntu1?

Would it be safe to install either of these GC versions in either Ubuntu 18.04 
or 22.04?

 

 

From: rsbrux  
Sent: Friday, August 26, 2022 12:03 PM
To: 'gnucash-user@gnucash.org' 
Subject: GnuCash 3 for Ubuntu Studio 22.04 LTS

 

According to https://wiki.gnucash.org/wiki/Ubuntu, “GnuCash 4.8 is included in 
Ubuntu 22.04, released April 2022 https://packages.ubuntu.com/jammy/gnucash”.

I was running GC 2.6.19 under Ubuntu Studio 18.04 and I have read on this 
mailing list that I will need to migrate to GC v 3.x before I can migrate to GC 
4.

I would therefore like to install GC 3.8b. What is the easiest way to do this?

Is there a repository I can add to Discover that I can pull it (or at least 
some stable 3.x version) from?

___
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] Could Not Obtain Lock

[rsbrux via gnucash-user]

This is an old topic, but I finally figured out what's wrong.
On the Ubuntu desktop system where I run GnuCash (and little else), I set up a 
cron job to update prices at first logon each day, as described here:
https://wiki.gnucash.org/wiki/Online_Quotes#Updating_enabled_Quotes_from_outside_GnuCash
Unfortunately, starting GnuCash is often the first thing I want to do when I 
start up the system and I obviously haven't been waiting long enough for the 
cron job to finish.
Is there a smarter way to make sure prices are collected online without having 
to wait and check that GC has finished the price update before I try to use it 
interactively?

-Original Message-
From: rsbrux 
Sent: Monday, June 27, 2022 10:23 AM
To: gnucash-user@gnucash.org
Subject: Re: Could Not Obtain Lock 

I am still on GC v 2.6.19 under Ubuntu 18.04, and experience this problem 
frequently, even when I am *absolutely sure* that GnuCash was correctly closed 
after the last use.  At least in GC 2.6.19 it appears that GC does not allow 
for possible delays in mounting volumes in Ubuntu.  The problem has gotten 
worse since I offloaded the GC data file to my NAS.  If I wait to start GC for 
a few minutes after logging in, or start some other applications first, the 
problem does not occur.
--

Message: 2
Date: Sun, 26 Jun 2022 19:53:04 +
From: Gyle McCollam 
To: Abe Sternberg , Glenn Fowler

Cc: GnuCash users group 
Subject: Re: [GNC] Could Not Obtain Lock
Message-ID:



Content-Type: text/plain; charset="us-ascii"

Abe,
I have had this issue as well.  It usually occurs when I forgot to save before 
closing.  It asks if I want to save, but no matter the reply, it doesn't save 
and doesn't close properly.  I was told it was fixed and i am waiting the 4.11 
update as well.  Hope this solves your issue when released.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Abe Sternberg 
Sent: Sunday, June 26, 2022 3:22 PM
To: Glenn Fowler 
Cc: GnuCash users group 
Subject: Re: [GNC] Could Not Obtain Lock

I am using Windows 11.  I try to close GnuCash properly, though there have been 
times when I may not have.  Also, I have had some Windows updates while GnuCash 
was left open.  I will look for the update and advise if the error continues.

Thanks,
Abe

On Sun, Jun 26, 2022 at 2:30 PM Glenn Fowler  wrote:

> Hi Abe,
>
> Are you on Windows and how are you closing GnuCash? There was a bug 
> that would cause this that is fixed in v4.11 being released today
>
> On Sun, Jun 26, 2022 at 2:00 PM Abe Sternberg 
> 
> wrote:
>
>> I get this message every time I open GnuCash. It doesn't seem to 
>> cause any damage but is an annoyance.  Does anyone know what causes 
>> this and how to correct it?
>>  [image: image.png]
>>
>> Abe
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--

Message: 3
Date: Sun, 26 Jun 2022 16:39:36 -0400
From: Michael or Penny Novack 
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Could Not Obtain Lock
Message-ID: 
Content-Type: text/plain; charset=UTF-8; format=flowed

On 6/26/2022 3:22 PM, Abe Sternberg wrote:
> I am using Windows 11.  I try to close GnuCash properly, though there 
> have been times when I may not have.  Also, I have had some Windows 
> updates while GnuCash was left open.  I will look for the update and 
> advise if the error continues.
>
> Thanks,
> Abe
>
a) "file in use" << that's what "cannot obtain lock file" means >> if CORRECT 
if you have not closed gnucash properly. This is not unique to gnucash but 
normal for any application using the "lock file" method of preventing multiple 
access to data.

 ??? IF you are certain the file is not in use (by another instance of
gnucash) you can override if/when the application provides an easy way to do 
that. Or you can go into the directory (file folder) where the data file lives 
and delete the lock file -- it will always be in the same directory.

b) Do NOT proceed with an operating system update

[GNC] GnuCash 3 for Ubuntu Studio 22.04 LTS

[rsbrux via gnucash-user]

According to https://wiki.gnucash.org/wiki/Ubuntu, “GnuCash 4.8 is included in 
Ubuntu 22.04, released April 2022 https://packages.ubuntu.com/jammy/gnucash”.

I was running GC 2.6.19 under Ubuntu Studio 18.04 and I have read on this 
mailing list that I will need to migrate to GC v 3.x before I can migrate to GC 
4.

I would therefore like to install GC 3.8b. What is the easiest way to do this?

Is there a repository I can add to Discover that I can pull it (or at least 
some stable 3.x version) from?

___
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] Could Not Obtain Lock

[rsbrux via gnucash-user]

I am still on GC v 2.6.19 under Ubuntu 18.04, and experience this problem 
frequently, even when I am *absolutely sure* that GnuCash was correctly closed 
after the last use.  At least in GC 2.6.19 it appears that GC does not allow 
for possible delays in mounting volumes in Ubuntu.  The problem has gotten 
worse since I offloaded the GC data file to my NAS.  If I wait to start GC for 
a few minutes after logging in, or start some other applications first, the 
problem does not occur.
--

Message: 2
Date: Sun, 26 Jun 2022 19:53:04 +
From: Gyle McCollam 
To: Abe Sternberg , Glenn Fowler

Cc: GnuCash users group 
Subject: Re: [GNC] Could Not Obtain Lock
Message-ID:



Content-Type: text/plain; charset="us-ascii"

Abe,
I have had this issue as well.  It usually occurs when I forgot to save before 
closing.  It asks if I want to save, but no matter the reply, it doesn't save 
and doesn't close properly.  I was told it was fixed and i am waiting the 4.11 
update as well.  Hope this solves your issue when released.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Abe Sternberg 
Sent: Sunday, June 26, 2022 3:22 PM
To: Glenn Fowler 
Cc: GnuCash users group 
Subject: Re: [GNC] Could Not Obtain Lock

I am using Windows 11.  I try to close GnuCash properly, though there have been 
times when I may not have.  Also, I have had some Windows updates while GnuCash 
was left open.  I will look for the update and advise if the error continues.

Thanks,
Abe

On Sun, Jun 26, 2022 at 2:30 PM Glenn Fowler  wrote:

> Hi Abe,
>
> Are you on Windows and how are you closing GnuCash? There was a bug 
> that would cause this that is fixed in v4.11 being released today
>
> On Sun, Jun 26, 2022 at 2:00 PM Abe Sternberg 
> 
> wrote:
>
>> I get this message every time I open GnuCash. It doesn't seem to 
>> cause any damage but is an annoyance.  Does anyone know what causes 
>> this and how to correct it?
>>  [image: image.png]
>>
>> Abe
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--

Message: 3
Date: Sun, 26 Jun 2022 16:39:36 -0400
From: Michael or Penny Novack 
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Could Not Obtain Lock
Message-ID: 
Content-Type: text/plain; charset=UTF-8; format=flowed

On 6/26/2022 3:22 PM, Abe Sternberg wrote:
> I am using Windows 11.  I try to close GnuCash properly, though there 
> have been times when I may not have.  Also, I have had some Windows 
> updates while GnuCash was left open.  I will look for the update and 
> advise if the error continues.
>
> Thanks,
> Abe
>
a) "file in use" << that's what "cannot obtain lock file" means >> if CORRECT 
if you have not closed gnucash properly. This is not unique to gnucash but 
normal for any application using the "lock file" method of preventing multiple 
access to data.

 ??? IF you are certain the file is not in use (by another instance of
gnucash) you can override if/when the application provides an easy way to do 
that. Or you can go into the directory (file folder) where the data file lives 
and delete the lock file -- it will always be in the same directory.

b) Do NOT proceed with an operating system update while you have application 
open. Again, this is not specific to gnucash. You should have settings related 
to how updates happen that will allow you to do this. Safest if to have the 
option of doing the updates wit the shutdown process.

Michael D Novack

PS -- The "file lock" is a method to allow multiple sequential access while 
preventing multiple simultaneous access. When you ask gnucash (or any other 
application using this method) to open a data file, the program looks in the 
same directory for the corresponding lock file. If NOT found, it creates that 
file and proceeds. When gnucash (or any other application using this method) 
closes, the? last thing it does is delete the lock file. So if the program does 
not get to close properly, the lock file is left behind,




---

Re: [GNC] Stock data export to Portfolio Performance

[rsbrux via gnucash-user]

Dear Thomas,
Thanks for pointing out Portfolio Performance; I have been looking for a way to 
extract such reporting from GC, but perhaps I would be better off using an 
external tool like PP.
If you succeed in finding or creating such a bridge between GC and PP, please 
post back here, as I am sure others (including myself) would be interested.

Date: Fri, 10 Dec 2021 08:03:56 -0500
From: D 
To: Thomas 
Cc: Christopher Lam , "D. via gnucash-user"

Subject: Re: [GNC] Stock data export to Portfolio Performance
Message-ID: <277c927d-12ba-4270-a874-35bf5666c...@yahoo.com>
Content-Type: text/plain; charset=UTF-8

The answer really is embedded in what format Portfolio Performance needs for 
its input. I didn't see anything leap out at me in their website about that in 
my brief scan. Most likely, you'd use a gnucash report to output data to a 
spreadsheet and import to PP from there. 

On Dec 10, 2021, 06:15, at 06:15, Thomas  
wrote:
>Hi Christopher,
>thanks for your reply!
>With "Portfolio Performance", I was referring to specific (external) 
>tool with that name. I forgot to mention that explicitly.
>My hope was that I could record all the data and changes in GnuCash and 
>just regularly export the required information about my current stock 
>portfolio to have additional tooling and visualizations in "Portfolio 
>Performance".
>
>The website of "Portfolio Performance":
>https://www.portfolio-performance.info/en/
>
>Best,
>Thomas
>
>On Fri, 10 Dec 2021 at 12:09, Christopher Lam 
> wrote:
>>
>> Imnsho, portfolio "performance" is a popular term, and I'm not sure
>it has an official definition.
>>
>> There's an IFRS report in the experimental menu to analyse a single
>stock activity. It aims to calculate a mathematical average cost price 
>of the stock. You can then compare it with the stock latest price to 
>generate a performance metric.
>>
>>  (Not an accountant).
>>
>> On Fri, 10 Dec 2021, 6:53 pm Thomas,
> wrote:
>>>
>>> Hello everybody,
>>>
>>> in order to have a detailed and interactive overview of all my stock 
>>> portfolio, I would like to export the data I have in gnucash (e.g., 
>>> when I bought how many stocks at what price) and import it into 
>>> Portfolio Performance. It is a rather stock-focused tool, which is
>why
>>> I want to stick with gnucash, but would love to have some of the 
>>> visualization and calculation tools of Portfolio Performance.
>>>
>>> Does anybody do this in any way already or could give a hint how
>that
>>> could be doable?
>>> If there are other (more compatible) tools of the type of Portfolio 
>>> Performance that are freely available, I'd also be interested in 
>>> hearing about how you do it with these tools.
>>>
>>> Thanks a lot in advance!
>>>
>>> Best,
>>> Thomas
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see 
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.


--

Subject: Digest Footer

___

gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--

End of gnucash-user Digest, Vol 225, Issue 19
*

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Credit Card Rewards Refund

[rsbrux via gnucash-user]

I have a credit card which, like a few others, accrues a small 
percentage (1-2%) of the amounts spent as a rebate.  The rebate isn't 
subtracted from each charge, but accumulates in the card account as 
"Reward Points" until I cash them in.  The amount is then credited to 
the card account as a payment.  Should such payments be recorded as 
income or as a negative expense?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to account for insurance policy profit participation?

[rsbrux via gnucash-user]

We have an insurance policy with a guaranteed return at maturity as well 
as profit participation (Überschussbeteiligung) which is calculated 
annually.  Presumably both are some kind of investment income, but it is 
unclear to me how to account for them.  I suspect that the guaranteed 
return should be classified as interest, but should I record it in 
GnuCash annually or only at maturity?


The profit participation is a complete mystery to me.  This is a share 
of the insurer's profits which accrues to the policies in years when the 
insurer achieves haigher returns on its (capital) investments than a 
predetermined threshold.  Is this a capital gain?  How should I record 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] gnucash inoperable in Windows 10

[rsbrux via gnucash-user]

Perhaps GnuCash is on a different virtual desktop.  If so, Ctrl-Win-Left or 
Ctrl-Win-Right should switch the display to the previous or next virtual 
desktop.
If not, and you can get focus on GnuCash  with the tip below, there are some 
other keyboard shortcuts in Windows 10 which may help:
If the GnuCash window is too small,  Win-Up (or Alt-Space followed by X) should 
maximize it.
If it is on another monitor, Shift-Win-Right or Shift-Win-Left should move it 
between monitors.
Hope this helps! 

> Date: Mon, 4 Jan 2021 06:15:51 -0800
> From: Greg Feneis 
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] arrggghhh - happening again!
> Message-ID:
>
> Content-Type: text/plain; charset="UTF-8"
> 
> Happy New Year, All,
> 
> If an application window is opening out of reach on a Windows machine, the
> user can right click on its icon in the taskbar and select Move.  This
> attaches the mouse cursor to wherever the window is. The user may
> manipulate their mouse to try to drag it back into view, or use keyboard
> arrow keys to bring the window back to view.  Might take some
> experimentation.
> 
> 
> 
> 
> Kind regards,
> 
> Greg Feneis
> 
> 
> 
> 
> On Sun, Jan 3, 2021 at 5:17 PM D. via gnucash-user 
> wrote:
> 
>> It is more likely that the OP has or had a second monitor upon which
>> gnucash is placing its window, as the other response mentioned. This has
>> happened to others in the past.
>> 
>> David
>> 
>> 
>>  Original Message 
>> From: py...@cox.net
>> Sent: Sun Jan 03 20:06:11 EST 2021
>> To: 'alessandra derniat' <4san...@live.com>, gnucash-user@gnucash.org
>> Subject: Re: [GNC] arrggghhh - happening again!
>> 
>> I am assuming you are on Windows 10 (based upon your "sent from mail"
>> message.  If not, ignore my message and let us know what OS you are using.
>> 
>> If you are Windows 10 - this does not sound like a Gnucash issue - this
>> sounds like a windows issue in that your program is losing focus or is
>> never
>> getting focus.  I have seen this with other web-based apps happen -- the
>> app
>> is open, it shows on the task bar yet it is unresponsive.  The  reason for
>> the unresponsive-ness is because the focus is on another app that is either
>> running and you don't know -- or is running and you can't see it.
>> 
>> To determine if this is the case, open TASK Manger and look at the active
>> tasks running.  If you see an active task that you don't know or that you
>> are positive should not be running, do a right mouse click on it and END
>> the
>> task.  Now if you are pretty sure all the running tasks are valid,  leave
>> task manager and see (if Gnucash is still open) if when you click on
>> Gnucash
>> if it now has focus (i.e., you can work it).  If Gnucash is not open, open
>> and see if it exhibits the same behavior before when the offending task was
>> open.   If all is good -- that task was the offending task that had focus
>> and was taking it away from Gnucash.  If all is still not good -- it is a
>> different issue.
>> 
>> If you are still exhibiting issues, try de-installing and re-installing
>> Gnucash and see if that works.  Don't worry, when you de-install, you will
>> not lose your data files.  Hopefully one of these two items will correct
>> your problem.  If neither of these two work -- let us know and maybe
>> someone
>> will have another solution.
>> 
>> Ken
>> 
>> -Original Message-
>> From: gnucash-user  On
>> Behalf Of alessandra derniat
>> Sent: Sunday, January 3, 2021 4:37 PM
>> To: gnucash-user@gnucash.org
>> Subject: [GNC] arrggghhh - happening again!
>> 
>> I go to open GnuCash and it shows as open in my task bar but when clicked
>> will not expand to allow me to actually work with it. So I see the program
>> open in my taskbar and when I scroll over it I can see my books but I can't
>> work on them. This happened a few months ago but before I could implement
>> any suggested fixes it starting working again without me doing anything.
>> 
>> What's the problem? What's going on? Am I doing something wrong? All I did
>> was open the program!
>> Thanks to anyone who can help me.
>> Sandy
>> 
>> Sent from Mail for Windows
>> 10
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.

Re: [GNC] Inconsistency Between Balance of Stock Account and Display in Accounts, File Integrity Check

[rsbrux via gnucash-user]

1. My so-called discrepancy was an optical illusion, What I read as 
0.982352 shares was really 0 shares of (valora number) 982352. ;-}


2. I found the file check in the "Actions" menu, under "Check & Repair". ;-}

Boy, do I feel stupid!

On 16.08.20 11:47, rsbrux wrote:
ISTR that GC has a built-in file integrity checker, but I can no 
longer find out how to invoke it.


Perhaps the peculiarity mentioned below is caused by some 
inconsistency in the file.


Can someone please refresh my memory on how to perform a file 
integrity check?


On 13.08.20 19:31, rsbrux wrote:
I am still running GC 2.6.19 under Ubuntu Studio 18.04, but plan to 
update to Ubuntu Studio 20.04 soon and will then get a newer version 
of GC.


Meanwhile, I have a problem which I find very hard to understand:
I purchased 600 shares of a stock last year and sold them again this 
year.


When I open the ledger of the stock account, it displays the balance 
correctly as 0.


However, in the Accounts list, the stock account still shows a 
balance of 0.982352 shares


What could account for this discrepancy?

How likely is it that a newer version of GC will correct this 
misrepresentation?


Is there some way of troubleshooting it, or should I just hide the 
(now empty) account and forget about it?


Thanks for any advice!


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Inconsistency Between Balance of Stock Account and Display in Accounts, File Integrity Check

[rsbrux via gnucash-user]

ISTR that GC has a built-in file integrity checker, but I can no longer 
find out how to invoke it.


Perhaps the peculiarity mentioned below is caused by some inconsistency 
in the file.


Can someone please refresh my memory on how to perform a file integrity 
check?


On 13.08.20 19:31, rsbrux wrote:
I am still running GC 2.6.19 under Ubuntu Studio 18.04, but plan to 
update to Ubuntu Studio 20.04 soon and will then get a newer version 
of GC.


Meanwhile, I have a problem which I find very hard to understand:
I purchased 600 shares of a stock last year and sold them again this 
year.


When I open the ledger of the stock account, it displays the balance 
correctly as 0.


However, in the Accounts list, the stock account still shows a balance 
of 0.982352 shares


What could account for this discrepancy?

How likely is it that a newer version of GC will correct this 
misrepresentation?


Is there some way of troubleshooting it, or should I just hide the 
(now empty) account and forget about it?


Thanks for any advice!


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to treat managed accounts or funds with fixed price

[rsbrux via gnucash-user]

Thanks, but I think you have misunderstood. There is neither a price nor a 
symbol; instead I have the total value of the managed portfolio in my reference 
currency. That's why I drew the analogy to a money market fund. 

 Ursprüngliche Nachricht Von: David Carlson 
 Datum: 14.08.20  22:19  (GMT+01:00) An: rsbrux 
 Cc: GnuCash List  Betreff: 
Re: [GNC] How to treat managed accounts or funds with fixed price Some managed 
accounts not only have a registered symbol but are also price reported .  If 
yours is not reported you could make up a symbol and still call it a mutual 
fund.  Then, of course, you would enter prices manually.On Fri, Aug 14, 2020, 
1:13 PM rsbrux  wrote:Thanks David.  The reason I wanted to 
use the Portfolio reports was to show ROI. From: David Carlson 
 Sent: Friday, August 14, 2020 7:42 PMTo: rsbrux 
Cc: GnuCash List Subject: Re: 
[GNC] How to treat managed accounts or funds with fixed price Portfolio reports 
only show security accounts, not generic asset accounts.  Use a different 
report to show asset balances. On Fri, Aug 14, 2020, 11:35 AM rsbrux via 
gnucash-user  wrote:Based on advice received 
previously on this list, I have stopped following the individual equities in my 
managed investment accounts and instead adjust the total value of the account 
periodically. The accounts are represented in GC as generic "Asset" 
accounts.However, at least in GC 2.6.19, this results in the accounts being 
excluded from portfolio reports, even if I check "Include accounts with no 
shares" on the general tab of the report configuration. If I seect the managed 
accounts, they are unselected as soon as I click "Apply".Do later versions of 
GC handle this differently, or do I need to find a workaround?  IF so, what 
approach is recommended?The situation is somewhat similar to investing in funds 
with a fixed share price (such as money market funds, whose price is usually 
fixed at USD 1).  In this case the fluctuation in value is reflected in the 
number of shares.The advice I have seen on handling money market funds in GC is 
to simply treat money market funds as bank accounts, but this will also prevent 
them from appearing in portfolio reports.Do I need to create a fictitious 
equity to represent each managed account?  If so, which equity type should I 
use?Thanks in advance for any 
advice.___gnucash-user mailing 
listgnucash-user@gnucash.orgTo update your subscription preferences or to 
unsubscribe:https://lists.gnucash.org/mailman/listinfo/gnucash-userIf you are 
using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists 
for more information.-Please remember to CC this list on all your 
replies.You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to treat managed accounts or funds with fixed price

[rsbrux via gnucash-user]

Thanks David.  The reason I wanted to use the Portfolio reports was to show ROI.

 

From: David Carlson  
Sent: Friday, August 14, 2020 7:42 PM
To: rsbrux 
Cc: GnuCash List 
Subject: Re: [GNC] How to treat managed accounts or funds with fixed price

 

Portfolio reports only show security accounts, not generic asset accounts.  Use 
a different report to show asset balances.

 

On Fri, Aug 14, 2020, 11:35 AM rsbrux via gnucash-user 
mailto:gnucash-user@gnucash.org> > wrote:

Based on advice received previously on this list, I have stopped 
following the individual equities in my managed investment accounts and 
instead adjust the total value of the account periodically. The accounts 
are represented in GC as generic "Asset" accounts.

However, at least in GC 2.6.19, this results in the accounts being 
excluded from portfolio reports, even if I check "Include accounts with 
no shares" on the general tab of the report configuration. If I seect 
the managed accounts, they are unselected as soon as I click "Apply".

Do later versions of GC handle this differently, or do I need to find a 
workaround?  IF so, what approach is recommended?

The situation is somewhat similar to investing in funds with a fixed 
share price (such as money market funds, whose price is usually fixed at 
USD 1).  In this case the fluctuation in value is reflected in the 
number of shares.

The advice I have seen on handling money market funds in GC is to simply 
treat money market funds as bank accounts, but this will also prevent 
them from appearing in portfolio reports.

Do I need to create a fictitious equity to represent each managed 
account?  If so, which equity type should I use?

Thanks in advance for any advice.

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to treat managed accounts or funds with fixed price

[rsbrux via gnucash-user]

Based on advice received previously on this list, I have stopped 
following the individual equities in my managed investment accounts and 
instead adjust the total value of the account periodically. The accounts 
are represented in GC as generic "Asset" accounts.


However, at least in GC 2.6.19, this results in the accounts being 
excluded from portfolio reports, even if I check "Include accounts with 
no shares" on the general tab of the report configuration. If I seect 
the managed accounts, they are unselected as soon as I click "Apply".


Do later versions of GC handle this differently, or do I need to find a 
workaround?  IF so, what approach is recommended?


The situation is somewhat similar to investing in funds with a fixed 
share price (such as money market funds, whose price is usually fixed at 
USD 1).  In this case the fluctuation in value is reflected in the 
number of shares.


The advice I have seen on handling money market funds in GC is to simply 
treat money market funds as bank accounts, but this will also prevent 
them from appearing in portfolio reports.


Do I need to create a fictitious equity to represent each managed 
account?  If so, which equity type should I use?


Thanks in advance for any advice.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Inconsistency Between Balance of Stock Account and Display in Accounts

[rsbrux via gnucash-user]

I am still running GC 2.6.19 under Ubuntu Studio 18.04, but plan to 
update to Ubuntu Studio 20.04 soon and will then get a newer version of GC.


Meanwhile, I have a problem which I find very hard to understand:
I purchased 600 shares of a stock last year and sold them again this year.

When I open the ledger of the stock account, it displays the balance 
correctly as 0.


However, in the Accounts list, the stock account still shows a balance 
of 0.982352 shares


What could account for this discrepancy?

How likely is it that a newer version of GC will correct this 
misrepresentation?


Is there some way of troubleshooting it, or should I just hide the (now 
empty) account and forget about it?


Thanks for any advice!

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Automatic Price Retrieval

[rsbrux via gnucash-user]

I would like GnuCah to retrieve prices automatically each time I open it.

The documentation describes the "Get Quotes" feature as "automatic", but 
I still have to remember to open the Price Editor and click "Get Quotes".


Is there a way to make price retrieval fully automatic?

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Investment Portfolio Reporting, GC w/SQL DB

[rsbrux via gnucash-user]

As usual, this turns out to be more complicated than I expected. My 
Ubuntu Studio 18.04 installation doesn' (yet) have any SQL DB installed.


gnucash-portfolio (http://portfolio.alensiljak.tk/) say it supports 
SQLite. The GC features page (https://gnucash.org/features.phtml) says 
that this is still experimental.  Is this still the case?  I am still 
using GC 2.6.19.  Do I need a newer GC version to use SQLite reliably?


Furthermore,some sourcess say that I will need to migrate the data 
myself, e.g.

https://stackoverflow.com/questions/25736571/gnucash-migrate-from-file-to-mysql

Is this also still the case? If not, what version of GC do I need to be 
able to just "Save As" to an SQL DB?


All of the posts I have found refer to MySQL rather than SQLite. Can I 
use the MySQL scripts in SQLite?


My NAS provides MariaDB instead of MySQL.  Would I be able to use this 
instead?



On 02.03.20 09:43, rsbrux wrote:


The Assets Bar Chart is indeed close to what I need, but it doesn't 
account for transfers into and out of the accounts in question.


I am still on Ubunto Studio 18.04 LTS.  Is there an easy way to get GC 
3.x on this platform?  If not which Version do I need to get GC 3.x 
from the official Ubuntu repository?


Otherwise, I will give gnucash-portfolio a try.  I don't think I am 
competent to figure out how to do what I need in Excel.


Thanks for your help!

On 02.03.20 00:12, David Carlson wrote:
You won't get much out of GnuCash unless you had it collecting 
security prices at the appropriate times to use in your desired 
reports.  If you did, try the assets over time reports.  There may be 
some better reports in the 3.x family of releases.


Otherwise, third party software or spreadsheets or a combination will 
work better.


David Carlson


On Sun, Mar 1, 2020, 10:53 AM rsbrux via gnucash-user 
mailto:gnucash-user@gnucash.org>> wrote:


I need some reports which show the performance of various investment
accounts over the past year.  I don't find anything suitable in GC
2.6.19 and don't have the chops (neither in accounting nor in
guile) to
write my own.  Surely I am not the first GC user with this need. 
The
only thing I found which looks useful is gnucash-portfolio:

http://portfolio.alensiljak.tk/

https://github.com/MisterY/gnucash-portfolio

However, as ignorant as I am about Python, I am not even sure how to
install it.  Furthermore, it appears to require the GC DB stored in
SQLite, whereas mine is still in (compressed) XML.

Does anyone have experience with gnucash-portfolio?

What other approach could I use?

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Investment Portfolio Reporting

[rsbrux via gnucash-user]

The Assets Bar Chart is indeed close to what I need, but it doesn't 
account for transfers into and out of the accounts in question.


I am still on Ubunto Studio 18.04 LTS.  Is there an easy way to get GC 
3.x on this platform?  If not which Version do I need to get GC 3.x from 
the official Ubuntu repository?


Otherwise, I will give gnucash-portfolio a try.  I don't think I am 
competent to figure out how to do what I need in Excel.


Thanks for your help!

On 02.03.20 00:12, David Carlson wrote:
You won't get much out of GnuCash unless you had it collecting 
security prices at the appropriate times to use in your desired 
reports.  If you did, try the assets over time reports.  There may be 
some better reports in the 3.x family of releases.


Otherwise, third party software or spreadsheets or a combination will 
work better.


David Carlson


On Sun, Mar 1, 2020, 10:53 AM rsbrux via gnucash-user 
mailto:gnucash-user@gnucash.org>> wrote:


I need some reports which show the performance of various investment
accounts over the past year.  I don't find anything suitable in GC
2.6.19 and don't have the chops (neither in accounting nor in
guile) to
write my own.  Surely I am not the first GC user with this need.  The
only thing I found which looks useful is gnucash-portfolio:

http://portfolio.alensiljak.tk/

https://github.com/MisterY/gnucash-portfolio

However, as ignorant as I am about Python, I am not even sure how to
install it.  Furthermore, it appears to require the GC DB stored in
SQLite, whereas mine is still in (compressed) XML.

Does anyone have experience with gnucash-portfolio?

What other approach could I use?

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Investment Portfolio Reporting

[rsbrux via gnucash-user]

I have indeed tried the Advanced Portfolio report, but have a few 
problems with it:


1. It gives performance per currently owned security, but I am looking
   for overall performance of each securities account, including cash
   positions and securities which have been sold. In particular, I
   would like to compare the performance of self-managed accounts with
   those managed by banks.
2. The indicated return figures are presuably for the duration of
   ownership, whereas I would like to have figures for the past
   calendar year
3. It automatically selects all individual securities and won't let me
   select other asset accounts.  To minimize the accounting effort, I
   have configured my bank-managed accounts as generic asset accounts.
   To achieve the desired performance comparison, I need to be able to
   select the appropriate asset accounts myself.
4. Not critical, but it would be nice to have a graphic, such as those
   provided by the Asset Bar Chart or the Net Worth Line Chart.

Thanks for your help!

On 02.03.20 01:32, Mike Alexander wrote:


On 1 Mar 2020, at 11:51, rsbrux via gnucash-user wrote:

I need some reports which show the performance of various
investment accounts over the past year.  I don't find anything
suitable in GC 2.6.19 and don't have the chops (neither in
accounting nor in guile) to write my own.  Surely I am not the
first GC user with this need. The only thing I found which looks
useful is gnucash-portfolio:

Have you tried the Advanced Portfolio report? I think it works pretty 
well in 2.6.19. Depending on what you want it might do the trick.


|Mike |

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Investment Portfolio Reporting

[rsbrux via gnucash-user]

I need some reports which show the performance of various investment 
accounts over the past year.  I don't find anything suitable in GC 
2.6.19 and don't have the chops (neither in accounting nor in guile) to 
write my own.  Surely I am not the first GC user with this need.  The 
only thing I found which looks useful is gnucash-portfolio:


http://portfolio.alensiljak.tk/

https://github.com/MisterY/gnucash-portfolio

However, as ignorant as I am about Python, I am not even sure how to 
install it.  Furthermore, it appears to require the GC DB stored in 
SQLite, whereas mine is still in (compressed) XML.


Does anyone have experience with gnucash-portfolio?

What other approach could I use?

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to Handle Managed Securities Accounts in GnuCash

[rsbrux via gnucash-user]

Thanks for the explanation. The accounts were already set up and funded 
from a (cash) bank account under Assets:Current Assets. I have set up 
the gains in income accounts as you suggest, but they are generic income 
accounts (in different currencies under 
Income:Common:Investment:Capital), not specific to the managed 
securities account.  The tax considerations don't affect my accounting, 
since our tax authorities use data provided by the bank.  What does 
concern me is whether the portfolio reporting is accurate.  Do I need an 
income account specific to the managed securities account to ensure 
that, or is it enough that there is a split entry for the securities 
account in each of the relevant transactions?


Also, should I record losses as expense or as negative income?


If your managed funds were in existence at the opening of your GnuCash books,
the the appropriate account will be an Equity account and Opening Balances
is an appropriate subaccount. If not then whatever account the funds came
from to setup the investment. You will need to account for any fees etc at
setup.

If the balance of the investment account increases through investment
returns, then an income account will be appropriate as you suggested.  Where
it resides in your account heirarchy though depends on the tax status and
reporting requirements for such gains and losses. You really need the advice
of a local accountant when dealing with the investment gains and losses. It
will depend a lot on your local tax rules and the extent to which investment
losses can be offset against other gains and losses and whether losses can
be carried forward etc.

David Cousens


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to Handle Managed Securities Accounts in GnuCash

[rsbrux via gnucash-user]

Thanks for the tip!  Indeed, the tax authorities here ar not interested in my 
accounting and insist on data directly from the bank.

I have set up asset accounts now for two managed accounts, but I don't know 
what to use as the counter-account for the value adjustments.

Should it be an income account (assuming that I have capital gains), an expense 
account (in the event that I have losses) or an equity account?

 

From: David Carlson  
Sent: Tuesday, January 7, 2020 3:32 PM
To: rsbrux 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] How to Handle Managed Securities Accounts in GnuCash

 

There used to be a section in one of the help manuals  about tracking the value 
of fixed investments such as art.  I am not near my computer so I am working 
from memory.

 

You could create such an asset for that account and then update it's value 
quarterly or less as you please, following the statements you receive.  
Obviously, this would not provide tax information, but you are probably already 
using the tax info from your investment manager.

 

David Carlson 

 

On Tue, Jan 7, 2020, 5:00 AM rsbrux via gnucash-user mailto:gnucash-user@gnucash.org> > wrote:

I have a couple of managed securities accounts which typically have a lot of
transactions involving switching in and out of proprietary ETFs for which
public quotes are not readily available.
I am tired of trying to keep track of all of these transactions in GnuCash.
I would be grateful for any suggestions as to handle these accounts with
less (manual) effort.

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Account Currency Screwed Up Again!

[rsbrux via gnucash-user]

Thanks to all for your patient explanations and help.

@Adrien,

For the time being I have just inserted currency account levels in my 
existing tree as recommended here:


https://wiki.gnucash.org/wiki/Stocks/add_stock#Stocks_noted_in_foreign_currency

You have raised some interesting considerations which might move me to 
adopt a different structure, but I couldn't find the part of the guide 
you were referring to.  Can you provide a link?



Date: Tue, 11 Feb 2020 14:39:01 -0600
From: Adrien Monteleone 
To: Gnucash Users 
Subject: Re: [GNC] Account Currency Screwed Up Again!
Message-ID: 
Content-Type: text/plain;   charset=us-ascii

Thanks for the explanation.

Regards,
Adrien


On Feb 11, 2020 w7d42, at 1:20 PM, John Ralls 

wrote:

The transaction currency in which the value field of every split is

denominated is determined by the account in whose register one creates the
transaction. If that account is in a non-currency commodity then the
currency of first parent account denominated in a currency is used. So in
rsbrux's case where he had a stock XYZ under a CHF parent and bought using
AUD, the stock split will have an amount in XYZ and a value in CHF and the
cash split will have an amount in AUD and a value in CHF. That's a
three-way transaction with two prices: XYZ->CHF and AUD->CHF. Both should
be recorded in the price database. If he used basic view or was careless
about entering the price and values the AUD->CHF price might be 1 and the
XYZ->CHF price might have the value of XYZ's price in AUD.

Had he instead had the parent of the XYZ account in AUD as he should

have or if had created the transaction starting in the cash account then
the transaction currency would be AUD and only the stock split would have
a price.

Regards,
John Ralls



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Account Currency Screwed Up Again!

[rsbrux via gnucash-user]

It was probabably due to my placing the securities accounts under 
accounts in CHF and entering the first transactions in the securities 
accounts instead of in the associated accounts for purchase & sale (see 
my reply to John Rails).  Stock quotes retrieved from Yahoo as json do 
show the correct currency, but my AUD investments have been in bonds and 
ETFs, for which I haven't found any online quote sources,  The price 
editor does in fact have a currency settting, however, it doesn't have 
any effect on prices which were taken from transactions.  I can edit 
such a price and change the currency in the dialog, but when I click 
"Apply" and "Close", nothing is changed.  Going through the price 
database has uncovered several other cases where securities transactions 
were entered with incorrect currencies.  To prevent future occurences I 
have now inserted additonal account levels for currencies where they 
were previously missing, even though the resulting account structure is 
even unwieldier than before:


Assets - Investments -  -  -  - 

where dispense with the  level.


I did find one price in CHF for a security under a GBP account, but it 
is possible that I had entered the purchase transaction before 
introducing the currency-specific subaccount structure.


Our tax authorities insist on reporting produced by the banks (which 
costs us extra), so the mistakes in my accounting are irrelevant for tax 
purposes.  We do have a well-versed Swiss tax accountant and don't have 
to worry about foreign taxes because they are reported in the bank data 
and generally deducted at the origin.


Unfortunately for us, dividends are taxed as income in Switzerland, 
unless they are paid out of corporate reserves as "return of capital".


On 10.02.20 22:09, David Cousens wrote:

Not sure, but I don't understand why the prices of the securites were in CHF. 
Since you have AUD income and expense
accounts associated with the securities and you record their purchase/sale 
against an AUD foreign currency account I
would have thought the securities would have been in AUD if traded on the ASX.

A lot will depend upon what you are required to supply to your tax authorities, 
where tax is paid, and what rules apply
on timing of conversion from AUD to CHF for tax recording purposes. For that 
sort of info you will need a Swiss tax
accountant with foreign tax experience.

In Australia companies operate under a company tax regime where tax paid on 
company profits is not normally taxed again
as a dividend in the hands of a shareholder. The shareholder receives a 
franking credit for the tax paid in the hands of
the company to offset against their income tax. Not all share dividends are 
franked however. This of course only applies
to Australian shareholders who pay income tax in Australia unless  some sort of 
reciprocal tax agreement between
countries exists covering these taxes.


On Mon, 2020-02-10 at 14:21 +0100, rsbrux via gnucash-user wrote:

Many thanks to both of you for your suggestions!

@Adrien,

The accounts in question already had the correct currency (AUD)
assigned.  The accounts in question are a foreign currency account in
AUD, three accounts for AUD-denominated securities (which I bought/sold
in the above-mentioned foreign currency account), various expense
accounts in AUD and an income account in AUD for interest.  The
transactions between the foreign currency account and the expense
accounts were recoreded in AUD as expected.  All other transactions were
recorded with CHF exchange rates, although no currency conversions were
called for.  The prices of two of the three securities were also
recorded in CHF.  SInce the GC UI shows all accounts in AUD (except for
the securities accounts, which IIRC, do not have a currency) it was
unclear to me which account(s) I should duplicate.

@David,

My default currency is CHF; I live in Switzerland.  Trading accounts are
turned on.  I have tried to fix this in the XML based on the information
you provided.  I tried to look up more information about the file
structure, but the guide
<https://www.gnucash.org/viewdoc.phtml?rev=2.6&lang=C&doc=guide> wasn't
much help, and the wiki <https://wiki.gnucash.org/wiki/> appears to be down.

IAC, I edited the price records for the two securities which had
incorrect price currencies, as well as all transactions which refenenced
any of the three securities accounts, changing the currencies from CHF
to AUD.  This appears to have fixed the problems, but I am keeping a
couple of pre-edit backups, as you recommend.

Am I the only one to encounter problems like this?

SInce the problem seems to have been with the (implicitly determined)
currencies of the prices and the transactions, would it be possible to
add an option to the price editor dialog for each price and to the
exchange rate editor for each transaction to change or select the
currency?  From what I ha

Re: [GNC] Account Currency Screwed Up Again!

[rsbrux via gnucash-user]

There were two different parent accounts, both in CHF.  I guess that is 
the source of my problems, although I had previously managed to have 
securities with different currencies under them. ISTR reading somewhere 
that securities in GC take their currency from the account in which the 
first transaction is entered.  In that case, my problems are probably 
due to entering the initial transactions in the securities account 
(which presumably takes its currency from the parent account) instead of 
in the account from which the money comes (which would have the correct 
currency). Because of the columns and labels provided, securities 
transactions are easier to enter in a securities account.


To me, the resulting confusion still argues in favor of explicitly 
associating a currency with each security, something which is apparently 
not foreseen in the data structure.


Thanks for your help!

On 11.02.20 05:43, John Ralls wrote:

What is the parent account of the three stock accounts and what is the 
commodity of that parent account?

Regards,
John Ralls



On Feb 10, 2020, at 5:21 AM, rsbrux via gnucash-user  
wrote:

Many thanks to both of you for your suggestions!

@Adrien,

The accounts in question already had the correct currency (AUD) assigned.  The 
accounts in question are a foreign currency account in AUD, three accounts for 
AUD-denominated securities (which I bought/sold in the above-mentioned foreign 
currency account), various expense accounts in AUD and an income account in AUD 
for interest.  The transactions between the foreign currency account and the 
expense accounts were recoreded in AUD as expected.  All other transactions 
were recorded with CHF exchange rates, although no currency conversions were 
called for.  The prices of two of the three securities were also recorded in 
CHF.  SInce the GC UI shows all accounts in AUD (except for the securities 
accounts, which IIRC, do not have a currency) it was unclear to me which 
account(s) I should duplicate.

@David,

My default currency is CHF; I live in Switzerland.  Trading accounts are turned on.  I have tried 
to fix this in the XML based on the information you provided.  I tried to look up more information 
about the file structure, but the guide 
<https://www.gnucash.org/viewdoc.phtml?rev=2.6&lang=C&doc=guide> wasn't much help, 
and the wiki <https://wiki.gnucash.org/wiki/> appears to be down.

IAC, I edited the price records for the two securities which had incorrect 
price currencies, as well as all transactions which refenenced any of the three 
securities accounts, changing the currencies from CHF to AUD.  This appears to 
have fixed the problems, but I am keeping a couple of pre-edit backups, as you 
recommend.

Am I the only one to encounter problems like this?

SInce the problem seems to have been with the (implicitly determined) 
currencies of the prices and the transactions, would it be possible to add an 
option to the price editor dialog for each price and to the exchange rate 
editor for each transaction to change or select the currency?  From what I have 
learned about the data structure, this looks like the easiest way to provide a 
less dangerous way to fix such problems.


Date: Mon, 3 Feb 2020 10:31:58 -0600
From: Adrien Monteleone 
To: Gnucash Users 
Subject: Re: [GNC] Account Currency Screwed Up Again!
Message-ID: <821d9637-24ee-4c33-a1bf-792fe55e8...@lusfiber.net>
Content-Type: text/plain;   charset=utf-8

Would creating a new duplicate account with the proper assigned currency, then 
deleting the old account and choosing to transfer all transactions to the new 
currency work?

That would be significantly easier than manual editing.

I?m not sure how the use of Trading Accounts affects this, or if it should or 
should not be turned on.


Regards,
Adrien


On Feb 3, 2020 w6d34, at 4:45 AM, David Cousens  
wrote:

Have you checked the default currency used Edit->Preferences, Accounts tab,
Default Currency. It is normally set to locale. I guess you are in Australia
so it should be AUD. If not, diid you possibly create the book originally
while overseas or the locale on your computer was not set to Australia.
AFAIK it is not possible to edit the currency of an account once it is
created in the Edit Account dialog only in the New Account dialog.

It should be possible to edit the file this but fraught with possible
problems.  Work on a copy of your original file and don't save it over the
original until you are really sure that the problem is fixed and other
problems haven't been created. I would keep a copy of the original even
after you reach this point just to be sure.

Your XML file will have to be uncompressed Edit ->Preferences General Tab
and uncheck the box which says compress files. You may then have to force a
Save. I did this by creating a dummy transaction in a register then hitting
the Save button in the toolbar, deleting the dummy transaction and clickin

Re: [GNC] Account Currency Screwed Up Again!

[rsbrux via gnucash-user]

Many thanks to both of you for your suggestions!

@Adrien,

The accounts in question already had the correct currency (AUD) 
assigned.  The accounts in question are a foreign currency account in 
AUD, three accounts for AUD-denominated securities (which I bought/sold 
in the above-mentioned foreign currency account), various expense 
accounts in AUD and an income account in AUD for interest.  The 
transactions between the foreign currency account and the expense 
accounts were recoreded in AUD as expected.  All other transactions were 
recorded with CHF exchange rates, although no currency conversions were 
called for.  The prices of two of the three securities were also 
recorded in CHF.  SInce the GC UI shows all accounts in AUD (except for 
the securities accounts, which IIRC, do not have a currency) it was 
unclear to me which account(s) I should duplicate.


@David,

My default currency is CHF; I live in Switzerland.  Trading accounts are 
turned on.  I have tried to fix this in the XML based on the information 
you provided.  I tried to look up more information about the file 
structure, but the guide 
 wasn't 
much help, and the wiki  appears to be down.


IAC, I edited the price records for the two securities which had 
incorrect price currencies, as well as all transactions which refenenced 
any of the three securities accounts, changing the currencies from CHF 
to AUD.  This appears to have fixed the problems, but I am keeping a 
couple of pre-edit backups, as you recommend.


Am I the only one to encounter problems like this?

SInce the problem seems to have been with the (implicitly determined) 
currencies of the prices and the transactions, would it be possible to 
add an option to the price editor dialog for each price and to the 
exchange rate editor for each transaction to change or select the 
currency?  From what I have learned about the data structure, this looks 
like the easiest way to provide a less dangerous way to fix such problems.



Date: Mon, 3 Feb 2020 10:31:58 -0600
From: Adrien Monteleone 
To: Gnucash Users 
Subject: Re: [GNC] Account Currency Screwed Up Again!
Message-ID: <821d9637-24ee-4c33-a1bf-792fe55e8...@lusfiber.net>
Content-Type: text/plain;   charset=utf-8

Would creating a new duplicate account with the proper assigned currency, then 
deleting the old account and choosing to transfer all transactions to the new 
currency work?

That would be significantly easier than manual editing.

I?m not sure how the use of Trading Accounts affects this, or if it should or 
should not be turned on.


Regards,
Adrien


On Feb 3, 2020 w6d34, at 4:45 AM, David Cousens  
wrote:

Have you checked the default currency used Edit->Preferences, Accounts tab,
Default Currency. It is normally set to locale. I guess you are in Australia
so it should be AUD. If not, diid you possibly create the book originally
while overseas or the locale on your computer was not set to Australia.
AFAIK it is not possible to edit the currency of an account once it is
created in the Edit Account dialog only in the New Account dialog.

It should be possible to edit the file this but fraught with possible
problems.  Work on a copy of your original file and don't save it over the
original until you are really sure that the problem is fixed and other
problems haven't been created. I would keep a copy of the original even
after you reach this point just to be sure.

Your XML file will have to be uncompressed Edit ->Preferences General Tab
and uncheck the box which says compress files. You may then have to force a
Save. I did this by creating a dummy transaction in a register then hitting
the Save button in the toolbar, deleting the dummy transaction and clicking
Save again.

The section of the XMLfile which contains the commodity information for an
account is reproduced below for a SGD account I have.

  TravelMoney_CC_SGD
  *7db63ffa514d478191dea006748d7bd6*
  LIABILITY
  
CURRENCY
*SGD*
  

You will have to have the commodity you wish to change the account to
specified earlier in the file in a section like

  CURRENCY
  SGD
  
  currency
  


Each transaction to the account will have the commodity specified in a
 tag set. You would need to find all of these and change the
commodity similarly

  4ec8a9416b31469bb1eeaf79c5557092
  
CURRENCY
SGD
  
  
2019-03-17 10:59:00 +
  
  
2019-05-14 03:25:18 +
  
  XX 1897  BP-BOOKSACTUALLY
  

  date-posted
  
2019-03-17
  

  
  

  2bf944df822042849e1cbd5a2b6db3c8
  n
  6100/100
  6654/100
  7be97b5f738386fd2272881dc33a0272


  4ef42d767cc748f79ce09d6d8f2d3043
  y
  
2019-05-14 13:59:59 +
  
  -6100/100
  -6100/100
  *7db63ffa514d478191dea006748d7bd6*

  


Make sure the guid for the account matches up (bolded in the above examples)
in the

Re: [GNC] Account Currency Screwed Up Again!

[rsbrux via gnucash-user]

I haven't see an answer to this on the distribution list, nor on Nabble 
. 


Can I fix this by editing the XML file?
I am using GC v2.6.19 under Ubuntu Studio 18.04.  Is there a function to 
change the currency of transactions in a newer version of GC?
If not, is there any hope that such a function might be provided in the 
future?


On 27.01.20 10:24, rsbrux wrote:
Many years ago I set up in GC a bank account denominated in AUD to buy 
and sell securities in that currency.  While reconciling my 
end-of-year statements I only just noticed while attempting to enter a 
new price for one of the securities that all transactions in that 
account (not just securities, but also transactions with other 
accounts denominated in AUD, such as the income account I use for 
recording interest paid in AUD) are recorderd in CHF and are converted 
to CHF instead of AUD!!!  How could this happen? More important (since 
it is unlikely that the cause can be reconstructed at this late date) 
how can I correct this without having to manually recreate all 
transactions in the account going back to 2013?


Based on previous experience with such problems, I will also have to 
recreate the AUD-denominated securities (fortunately there are only 
two) and their transactions in order to correct the erroneous currency 
(CHF) attached to them.  Please say it ain't so!



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Account Currency Screwed Up Again!

[rsbrux via gnucash-user]

Many years ago I set up in GC a bank account denominated in AUD to buy 
and sell securities in that currency.  While reconciling my end-of-year 
statements I only just noticed while attempting to enter a new price for 
one of the securities that all transactions in that account (not just 
securities, but also transactions with other accounts denominated in 
AUD, such as the income account I use for recording interest paid in 
AUD) are recorderd in CHF and are converted to CHF instead of AUD!!!  
How could this happen? More important (since it is unlikely that the 
cause can be reconstructed at this late date) how can I correct this 
without having to manually recreate all transactions in the account 
going back to 2013?


Based on previous experience with such problems, I will also have to 
recreate the AUD-denominated securities (fortunately there are only two) 
and their transactions in order to correct the erroneous currency (CHF) 
attached to them.  Please say it ain't so!


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to change default book/file to open in GC 2.6 under

[rsbrux via gnucash-user]

Dear Peter,

Thanks for the tip; that fixed starting GC from the Whisker menu.  
However, I had also setup Windows-like shortcuts (Launcher items on the 
xfce desktop) which included the file name, so I had to change those as 
well.


On 10.01.20 12:14, Peter West wrote:

What happens if you move the old file?

Peter
--
Peter West
p...@pbw.id.au <mailto:p...@pbw.id.au>
But immediately he spoke to them and said, “Take heart; it is I. Do 
not be afraid.”


On 10 Jan 2020, at 8:48 pm, rsbrux via gnucash-user 
mailto:gnucash-user@gnucash.org>> wrote:


P.S.  The new file appears in the recently opened files list in GC, 
but in

position 2.
The old file is in position 1.

-Original Message-
From: rsbrux mailto:rsb...@yahoo.com>>
Sent: Friday, January 10, 2020 11:46 AM
To: 'gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>' 
mailto:gnucash-user@gnucash.org>>

Subject: Re: How to change default book/file to open in GC 2.6 under

Dear Adrien,
Thanks for the tip, but I already tried that (several times).  GC still
opens the old book/file
Regards, rsbrux

Date: Fri, 10 Jan 2020 03:03:02 -0600
From: Adrien Monteleone <mailto:adrien.montele...@lusfiber.net>>
To: Gnucash Users <mailto:gnucash-user@gnucash.org>>

Subject: Re: [GNC] How to change default book/file to open in GC 2.6
under Ubuntu Linux?
Message-ID: <61e290aa-a213-4544-b103-764ed0d01...@lusfiber.net 
<mailto:61e290aa-a213-4544-b103-764ed0d01...@lusfiber.net>>

Content-Type: text/plain;charset=us-ascii

Open Gnucash, it will open the last used book.

If it is the old one, then go to File > Open, and choose the new book.

Close Gnucash.

When you re-open Gnucash, it should still open the last used book, 
but this

time, that will be the new one.

Regards,
Adrien


On Jan 10, 2020 w2d10, at 2:59 AM, rsbrux via gnucash-user

mailto:gnucash-user@gnucash.org>> wrote:


I am using GC 2.6.19 (the standard version) under Ubuntu Studio 18.4.

I have just created a new GC book/file, but when I close it and 
reopen GC,

it opens the old book/file.


ISTR having to set up something in some config file to get GC to start

with a particular book/file open, somthing I only did because I couldn't
find a way to do this with a shortcut containing a command-line 
argument, as

I would normally do under Windows.


I don't find any documentation or help describing how to specify a

book/file to open on GC start.


How can I make GC open my ne book/file instead of the old one


___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to change default book/file to open in GC 2.6 under

[rsbrux via gnucash-user]

P.S.  The new file appears in the recently opened files list in GC, but in
position 2.
The old file is in position 1.

-Original Message-
From: rsbrux  
Sent: Friday, January 10, 2020 11:46 AM
To: 'gnucash-user@gnucash.org' 
Subject: Re: How to change default book/file to open in GC 2.6 under

Dear Adrien,
Thanks for the tip, but I already tried that (several times).  GC still
opens the old book/file 
Regards, rsbrux

Date: Fri, 10 Jan 2020 03:03:02 -0600
From: Adrien Monteleone 
To: Gnucash Users 
Subject: Re: [GNC] How to change default book/file to open in GC 2.6
under Ubuntu Linux?
Message-ID: <61e290aa-a213-4544-b103-764ed0d01...@lusfiber.net>
Content-Type: text/plain;   charset=us-ascii

Open Gnucash, it will open the last used book.

If it is the old one, then go to File > Open, and choose the new book.

Close Gnucash.

When you re-open Gnucash, it should still open the last used book, but this
time, that will be the new one.

Regards,
Adrien

> On Jan 10, 2020 w2d10, at 2:59 AM, rsbrux via gnucash-user
 wrote:
> 
> I am using GC 2.6.19 (the standard version) under Ubuntu Studio 18.4.
> 
> I have just created a new GC book/file, but when I close it and reopen GC,
it opens the old book/file.
> 
> ISTR having to set up something in some config file to get GC to start
with a particular book/file open, somthing I only did because I couldn't
find a way to do this with a shortcut containing a command-line argument, as
I would normally do under Windows.
> 
> I don't find any documentation or help describing how to specify a
book/file to open on GC start.
> 
> How can I make GC open my ne book/file instead of the old one

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to change default book/file to open in GC 2.6 under

[rsbrux via gnucash-user]

Dear Adrien,
Thanks for the tip, but I already tried that (several times).  GC still
opens the old book/file
Regards,
rsbrux

Date: Fri, 10 Jan 2020 03:03:02 -0600
From: Adrien Monteleone 
To: Gnucash Users 
Subject: Re: [GNC] How to change default book/file to open in GC 2.6
under Ubuntu Linux?
Message-ID: <61e290aa-a213-4544-b103-764ed0d01...@lusfiber.net>
Content-Type: text/plain;   charset=us-ascii

Open Gnucash, it will open the last used book.

If it is the old one, then go to File > Open, and choose the new book.

Close Gnucash.

When you re-open Gnucash, it should still open the last used book, but this
time, that will be the new one.

Regards,
Adrien

> On Jan 10, 2020 w2d10, at 2:59 AM, rsbrux via gnucash-user
 wrote:
> 
> I am using GC 2.6.19 (the standard version) under Ubuntu Studio 18.4.
> 
> I have just created a new GC book/file, but when I close it and reopen GC,
it opens the old book/file.
> 
> ISTR having to set up something in some config file to get GC to start
with a particular book/file open, somthing I only did because I couldn't
find a way to do this with a shortcut containing a command-line argument, as
I would normally do under Windows.
> 
> I don't find any documentation or help describing how to specify a
book/file to open on GC start.
> 
> How can I make GC open my ne book/file instead of the old one

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to change default book/file to open in GC 2.6 under Ubuntu Linux?

[rsbrux via gnucash-user]

I am using GC 2.6.19 (the standard version) under Ubuntu Studio 18.4.

I have just created a new GC book/file, but when I close it and reopen 
GC, it opens the old book/file.


ISTR having to set up something in some config file to get GC to start 
with a particular book/file open, somthing I only did because I couldn't 
find a way to do this with a shortcut containing a command-line 
argument, as I would normally do under Windows.


I don't find any documentation or help describing how to specify a 
book/file to open on GC start.


How can I make GC open my ne book/file instead of the old one

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to Handle Managed Securities Accounts in GnuCash

[rsbrux via gnucash-user]

I have a couple of managed securities accounts which typically have a lot of
transactions involving switching in and out of proprietary ETFs for which
public quotes are not readily available.
I am tired of trying to keep track of all of these transactions in GnuCash.
I would be grateful for any suggestions as to handle these accounts with
less (manual) 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to Report Asset Allocation by Currency

[rsbrux via gnucash-user]

>>
I don't think we actually have such a report!  One could be written, of
course, but it would require scheme hacking.

I don't know if the portfolio report would be helpful?
<<
The portfolio report is quite useful; I have used it a lot.  However, I have
been unable to figure out how to adapt it to group accounts by currency.
Scheme hacking is beyond me (at least at present ;-)

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to Report Asset Allocation by Currency

[rsbrux via gnucash-user]

I have many accounts in several different currencies.?? I would like to 
have a pie chart showing what percentage of assets are held in each 
currency, but haven't found a way to do this.


I am using GnuCash v2.6.19 running under Ubuntu Studio 18.04. Any tips 
would be most welcome!


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to update Finance::Quote, F::Q 1.49 still limited to 5 AlphaVantage quotes?

[rsbrux via gnucash-user]

Thanks for the tips.?? I ran cpan interactive as su, then installed 
CPAN::DistnameInfo and Finance::Quote.?? Now running:


>>
cpan -D Finance::Quote

<<

from my regular user account reports F::Q version 1.49.
My previous list of prices still updates successfully in GnuCash 2.6.19.
I had previously limited currency price quote to 5 currencies because of the 
known problem with AlphaVantage.
Perhaps I have misunderstood, but I was expecting the new version to avoid this 
limitation.  Instead, adding more currencies to quote results in the well-known 
error message:



Unable to retrieve quotes for these items:
...
Continue using only the good quotes?
<<
Did I misunderstand?
Is there something I need to configure?

On 09.07.19 18:04, Frank H. Ellenberger wrote:

I see 2 potential issues:

Am 08.07.19 um 15:16 schrieb rsbrux via gnucash-user:

If this is the wrong venue for this question, please refer me to the
correct one.

I am try to update my FInanace::Quote installation (under Ubuntu Studio
18.04) to the latest version (1.49).

First I performed:

cpan -D Finance::Quote

as recommended in https://wiki.gnucash.org/wiki/CPAN.

It indicated that my CPAN was also out of date, so I first updated CPAN.

I then ran "upgrade Finance::Quote" from the cpan interactive prompt.??
This appears to have failed, as the cpan command above still shows F::Q
1.47

The output of the upgrade attempt was quite long and the beginning
scrolled out of the terminal window.

Unfortunately, I am too ignorant to understand most of it.?? I have
posted below the tail-end, which appear to reflect the installation of
F::Q; preceeding parts appear to deal with (equally futile) attempts to
install or upgrade other modules.

I intentionally ran cpan with normal privileges from my normal user
account becaue I have read that suprivileges should only be needed to
install or update CPAN and can otherwise be dangerous.

Must I install as su??? Is there something else I am missing here?

1. Yes, either
   sudo cpan
   
or
   su
   
   cpan


?? You may have to su to root to install the package
?? (Or you may want to run something like
?? o conf make_install_make_command 'sudo make'
?? to raise your permissions.?? ECOCODE/Finance-Quote-1.49.tar.gz
?? Has already been unwrapped into directory
/home/rbrooks/.cpan/build/Finance-Quote-1.49-0
?? ECOCODE/Finance-Quote-1.49.tar.gz

:
2.

The current configuration of allow_installing_outdated_dists is
'ask/yes', but for this option we would need 'CPAN::DistnameInfo'
installed. Please install 'CPAN::DistnameInfo' as soon as possible. As
long as we are not equipped with 'CPAN::DistnameInfo' this option does
not take effect

:

HTH

Frank

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] How to update Finance::Quote

[rsbrux via gnucash-user]

If this is the wrong venue for this question, please refer me to the 
correct one.


I am try to update my FInanace::Quote installation (under Ubuntu Studio 
18.04) to the latest version (1.49).


First I performed:

cpan -D Finance::Quote

as recommended in https://wiki.gnucash.org/wiki/CPAN.

It indicated that my CPAN was also out of date, so I first updated CPAN.

I then ran "upgrade Finance::Quote" from the cpan interactive prompt.?? 
This appears to have failed, as the cpan command above still shows F::Q 1.47


The output of the upgrade attempt was quite long and the beginning 
scrolled out of the terminal window.


Unfortunately, I am too ignorant to understand most of it.?? I have 
posted below the tail-end, which appear to reflect the installation of 
F::Q; preceeding parts appear to deal with (equally futile) attempts to 
install or upgrade other modules.


I intentionally ran cpan with normal privileges from my normal user 
account becaue I have read that suprivileges should only be needed to 
install or update CPAN and can otherwise be dangerous.


Must I install as su??? Is there something else I am missing here?

>>

?? You may have to su to root to install the package
?? (Or you may want to run something like
?? o conf make_install_make_command 'sudo make'
?? to raise your permissions.?? ECOCODE/Finance-Quote-1.49.tar.gz
?? Has already been unwrapped into directory 
/home/rbrooks/.cpan/build/Finance-Quote-1.49-0

?? ECOCODE/Finance-Quote-1.49.tar.gz
?? Has already been prepared
Running make for E/EC/ECOCODE/Finance-Quote-1.49.tar.gz
cp lib/Finance/Quote/NZX.pm blib/lib/Finance/Quote/NZX.pm
cp lib/Finance/Quote/MorningstarJP.pm 
blib/lib/Finance/Quote/MorningstarJP.pm
cp lib/Finance/Quote/Cdnfundlibrary.pm 
blib/lib/Finance/Quote/Cdnfundlibrary.pm

cp lib/Finance/Quote/IEXCloud.pm blib/lib/Finance/Quote/IEXCloud.pm
cp lib/Finance/Quote/Currencies.pm blib/lib/Finance/Quote/Currencies.pm
cp lib/Finance/Quote/DWS.pm blib/lib/Finance/Quote/DWS.pm
cp lib/Finance/Quote/Bourso.pm blib/lib/Finance/Quote/Bourso.pm
cp lib/Finance/Quote/IndiaMutual.pm blib/lib/Finance/Quote/IndiaMutual.pm
cp lib/Finance/Quote/FTPortfolios.pm blib/lib/Finance/Quote/FTPortfolios.pm
cp lib/Finance/Quote/ManInvestments.pm 
blib/lib/Finance/Quote/ManInvestments.pm

cp lib/Finance/Quote/Citywire.pm blib/lib/Finance/Quote/Citywire.pm
cp lib/Finance/Quote/Finanzpartner.pm 
blib/lib/Finance/Quote/Finanzpartner.pm

cp lib/Finance/Quote.pm blib/lib/Finance/Quote.pm
cp lib/Finance/Quote/Fidelity.pm blib/lib/Finance/Quote/Fidelity.pm
cp lib/Finance/Quote/BMONesbittBurns.pm 
blib/lib/Finance/Quote/BMONesbittBurns.pm

cp lib/Finance/Quote/LeRevenu.pm blib/lib/Finance/Quote/LeRevenu.pm
cp lib/Finance/Quote/HU.pm blib/lib/Finance/Quote/HU.pm
cp lib/Finance/Quote/AIAHK.pm blib/lib/Finance/Quote/AIAHK.pm
cp lib/Finance/Quote/Deka.pm blib/lib/Finance/Quote/Deka.pm
cp lib/Finance/Quote/Morningstar.pm blib/lib/Finance/Quote/Morningstar.pm
cp lib/Finance/Quote/ASEGR.pm blib/lib/Finance/Quote/ASEGR.pm
cp lib/Finance/Quote/MorningstarAU.pm 
blib/lib/Finance/Quote/MorningstarAU.pm
cp lib/Finance/Quote/FidelityFixed.pm 
blib/lib/Finance/Quote/FidelityFixed.pm

cp lib/Finance/Quote/BSERO.pm blib/lib/Finance/Quote/BSERO.pm
cp lib/Finance/Quote/HEX.pm blib/lib/Finance/Quote/HEX.pm
cp lib/Finance/Quote/Platinum.pm blib/lib/Finance/Quote/Platinum.pm
cp lib/Finance/Quote/CSE.pm blib/lib/Finance/Quote/CSE.pm
cp lib/Finance/Quote/MStaruk.pm blib/lib/Finance/Quote/MStaruk.pm
cp lib/Finance/Quote/GoldMoney.pm blib/lib/Finance/Quote/GoldMoney.pm
cp lib/Finance/Quote/FinanceCanada.pm 
blib/lib/Finance/Quote/FinanceCanada.pm
cp lib/Finance/Quote/MorningstarCH.pm 
blib/lib/Finance/Quote/MorningstarCH.pm

cp lib/Finance/Quote/ASX.pm blib/lib/Finance/Quote/ASX.pm
cp lib/Finance/Quote/AlphaVantage.pm blib/lib/Finance/Quote/AlphaVantage.pm
cp lib/Finance/Quote/FTfunds.pm blib/lib/Finance/Quote/FTfunds.pm
cp lib/Finance/Quote/Fool.pm blib/lib/Finance/Quote/Fool.pm
cp lib/Finance/Quote/AEX.pm blib/lib/Finance/Quote/AEX.pm
cp lib/Finance/Quote/Cominvest.pm blib/lib/Finance/Quote/Cominvest.pm
cp lib/Finance/Quote/VWD.pm blib/lib/Finance/Quote/VWD.pm
cp lib/Finance/Quote/Trustnet.pm blib/lib/Finance/Quote/Trustnet.pm
cp lib/Finance/Quote/SIXshares.pm blib/lib/Finance/Quote/SIXshares.pm
cp lib/Finance/Quote/YahooJSON.pm blib/lib/Finance/Quote/YahooJSON.pm
cp lib/Finance/Quote/StockHouseCanada.pm 
blib/lib/Finance/Quote/StockHouseCanada.pm

cp lib/Finance/Quote/Tdefunds.pm blib/lib/Finance/Quote/Tdefunds.pm
cp lib/Finance/Quote/UserAgent.pm blib/lib/Finance/Quote/UserAgent.pm
cp lib/GRTAGS blib/lib/GRTAGS
cp lib/Finance/Quote/TSP.pm blib/lib/Finance/Quote/TSP.pm
cp lib/Finance/Quote/ZA_UnitTrusts.pm 
blib/lib/Finance/Quote/ZA_UnitTrusts.pm

cp lib/Finance/Quote/USFedBonds.pm blib/lib/Finance/Quote/USFedBonds.pm
cp lib/Finance/Quote/SEB.pm blib/lib/Finance/Quote/SEB.pm
cp lib/Finance/Quote/SIXfunds.pm blib/lib/Finance/Quote/SIXfunds.pm
cp lib/GPATH blib/lib/GPATH
cp li

[GNC] Pension Fund

[rsbrux via gnucash-user]

I had created a couple of accounts to track the capital of (and 
contributions to) pension funds for myself and my wife.  Now we are 
drawing pensions from those funds, but cannot calculate our benefits as 
a simple draw-down of the capital.  I don't want or need the capital to 
appear in our accounting any longer.  The only information I could find 
in the GC documentation about pensions pertains to U.S. tax reporting, 
but this is not relevant for me. What is the correct way to handle (i.e. 
zero out) these accounts?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Security Currencies

[rsbrux via gnucash-user]

On 14.02.19 02:33, John Ralls wrote:

Securities don't have currencies.

Had I only known, I could have fixed my problem much more easily! ;-)

Accounts denominated in securities (or more generally in non-currency commodities) have 
an association with the nearest parent account denominated in a currency, so perhaps the 
solution to your problem is to create a "US Investments" Asset placeholder 
account somewhere and move the account that's giving you trouble under it.


This is good advice, which I should have followed all along.  To 
simplify the account structure I have been attempting to use the second 
alternative mentioned in 
https://wiki.gnucash.org/wiki/Stocks/add_stock#Stocks_noted_in_foreign_currency, 
instead of the first, which you recommend above.  However, I often 
forget to start my security transactions in a bank account.  It seems 
much more natural to start them in a securities account, where the 
fields for quantity and price are visible.  I have therefore reorganized 
my accounts per your suggestion and expect that I will have no further 
problems with this


Thanks for the tip!
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Security Currencies

[rsbrux via gnucash-user]

I am still having problems with security currencies.  I have a security 
with several transactions entered, which I only now realized has the 
wrong currency (CHF instead of USD).


This was really annoying as I had to first devise a report to extract 
the needed information from the security before deleting it, all 
relevant prices, transactions and accounts.


The first price entry was from F::Q in USD, but apparently the security 
nonetheless acquired my default currency (CHF) because I entered the 
first transaction in the security's account instead of a USD account.


Can't GC at least take a security's currency from the Price Editor?

This could:
1. support more intuitive operation

2. reduce the incidence of such errors

3. provide a means of correcting them


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Can't delete security

[rsbrux via gnucash-user]

Thanks for the tip(s)!  I had forgotten that GC automatically creates a 
"Trading" account.  After deleting that and the inital price ntry 
created by the first transaction, I could delete the security.


On 12.02.19 18:30, Maf. King wrote:

On Tuesday, 12 February 2019 17:27:20 GMT rsbrux via gnucash-user wrote:


@anyone,
How can I find out which account GnuCash thinks is using this security?
It occurred to me that I might be able to find out by doing a text
search of the GnuCash file, as I have understood that it is XML.
However, I cannot open it in mousepad, as it complains that the encoding
is not UTF-8.
Any hints as to how to proceed would be most welcome.


the data file is probably zip-compressed.  Either untick the GC pref to save as
compressed, or run it through gunzip (you probably need to change the
extension first)

HTH,
Maf




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Can't delete security

[rsbrux via gnucash-user]

@Derek,
Many thanks for your advice. Believe me, I've tried. Unfortunately, it 
is a mystery to me why any account should still be using this security. 
As mentioned below, I have deleted both the initial transaction and the 
investment account I created for the security.  I don't know why any 
other account should reference it.


@anyone,
How can I find out which account GnuCash thinks is using this security? 
It occurred to me that I might be able to find out by doing a text 
search of the GnuCash file, as I have understood that it is XML. 
However, I cannot open it in mousepad, as it complains that the encoding 
is not UTF-8.

Any hints as to how to proceed would be most welcome.

-Original Message-
From: Derek Atkins 
Sent: Tuesday, February 12, 2019 4:46 PM
To: rsbrux via gnucash-user 
Cc: rsbrux 
Subject: Re: [GNC] Can't delete security

Hi,

rsbrux via gnucash-user  writes:


Because of the well-known difficulties associated with assigning the
correct currency to a security, I need to delete and recreate a
security.  I have deleted the initial transaction I created for this
security, as well as the investment account I created for the
transaction.  Nonetheless, when I try to "Remove" the security from
the "Security Editor", I get the message:

"That commodity is currently used by at least one of your accounts.
You may not delete it."

I am using GnuCash 2.6.19 running under Ubuntu Studio 18.04

How can I correct this?


Do what it's telling you.  Delete the account that is using the commodity.

GnuCash wont let you delete something that is referenced by another object.


Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


-derek

--
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Can't delete security

[rsbrux via gnucash-user]

Because of the well-known difficulties associated with assigning the 
correct currency to a security, I need to delete and recreate a 
security.  I have deleted the initial transaction I created for this 
security, as well as the investment account I created for the 
transaction.  Nonetheless, when I try to "Remove" the security from the 
"Security Editor", I get the message:


"That commodity is currently used by at least one of your accounts. You 
may not delete it."


I am using GnuCash 2.6.19 running under Ubuntu Studio 18.04

How can I correct this?

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Feature request: Stock currency setting

[rsbrux via gnucash-user]

@Wm
Thanks for your patient explanation!

>>
Don't use the orphans for long, *always* move the tx to an appropriate account 
unless you are the sort of person that throws all their financial documents in 
a drawer and sorts them out only when they have to.
<<
I was unable to use (e.g. move) the transactions which I orphaned, because they 
were in the wrong currency.  I used the orphaned transactions as models from 
which to manually transcribe the needed information into new transactions in 
the correct currency.  Once this was done, I deleted the orphans.

>>
gnc rewards building a good CoA, it is all to do with double entry and good 
practice, if you come from a single entry finance world it can be more formal 
than you expect.
<<
As a layperson, I have no doubt oversimplified.  My securities accounts are 
directly under Assets:Inversments:Bank  presumably I should have added a 
currency layer in between.

>>
Anyway, in the real world stock ABCD bought in two currencies is almost 
certainly actually two holdings of that stock not one *unless* there was a 
currency exchange before the purchase, in which case why not reflect that in 
your accounts?
<<
In my case, it was simply an incorrect interpretation on the part of GnuCash, 
because the security was linked to the wrong currency.  How it could have 
changed is beyond me.

>>
A parallel is people owning stock ABCD in a retirement account and an 
investment account, same stock, two separate holdings, gnc recognizes the 
separation even though you may not acknowledge it.
<<
Provided the account hierarchy is properly set up ;-)

>>
In general, use a CASH or BANK type account of CURRENCY CCC to buy a commodity 
priced in that currency, I do something like this.

ASSET mixed stuff below GBP <-- or whatever your book currency is
\ USD account
\ shares, etc in USD
\ EUR account
\ shares, etc in EUR

It isn't really limiting, all you have to do is put a "plain" account on top of 
the more complex underlying asset, that way most transactions and reports will 
work as expected.
<<
Indeed, this is what I learned from the wiki article which I cited in another 
post.

>>
And if you think about it, gnc is reflecting reality, when you buy a RUB asset 
using CHF there are two exchanges, CHF => RUB => commodity.
<<
Indeed, this was the source of my problems, because the bank started out by 
buying the (USD-denominated) security in CHF, then corrected the transaction 
after I asked them to make future purchases out of my USD account.  Instead 
they retroactively changed the first transaction, which I had already entered 
in CHF, instead of making the conversion explicit, as you suggest.  Your 
approach would have saved me a lot of pain, as it took me over a year to figure 
out how to do it right ;-}












___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.