Re: [GNC] Printing Chart of Accounts WITHOUT balances

[Adrien Monteleone]

Either export/save the report and then open with a spreadsheet and 
remove the balances, then print, (to PDF using a virtual printer if desired)


or

Select-All while viewing the report, then copy/paste into a spreadsheet, 
etc.


Neither of those options require hand-editing the HTML.

And in the spreadsheet, might be accomplished by simply deleting one or 
more columns. (depending on how many are occupied by balance figures)


Regards,
Adrien

On 6/30/22 3:57 PM, Stan Brown wrote:

I have GC 2.6.19 in Widows 10. I'm attempting to print a chart of
accounts, showing account code and account title. I'm using the Account
Summary report, because there does not seem to be a Cart of Accounts
report. But I don't want account balances to show on this report.

In report options, there's a tick box for Account Balance, and I have
unticked it. I click on Apply to rewrite the report, but the account
balances still appear.

I'm attaching my selected report options. (I have not changed anything
on the Commodities tab, because I don't have any commodity accounts.)

I know I'm using an old version, so maybe GC 2.6.19 just has a bug that
causes it to display account balances even though they're un-requested.
But also I wonder if some option I selected has the side effect of
showing balances. (On the Display tab, I did try changing Parent Account
Balances to "Do not show". That suppressed the parent account balances,
but all the other accounts showed balances.)

Is there something I can do to get a chart of accounts without balances,
apart from exporting HTML and hand editing? Thanks!


___
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] Multiple currencies in split tx

[list+gnucash]

Hello, HSC:

Welcome to GnuCash.

On 2022-06-30 13:30, HSC wrote:

...Is it possible to account in one GC split entry for a tx in which a payment 
processor simultaneously makes a payment to two different vendors in two 
different local currencies?...


In my experience, yes. I have made some transactions like this.


We see it on the statement as one payment in source currency and two in 
destination currencies, without any details regarding conversion rates.

Do we have to calculate all that manually, and enter in GC as two separate txs?


My suggestions:

1. Read the "Multiple Currencies" section of the GnuCash Tutorial and 
Concepts Guide 



2. Enable trading accounts (see 12.3 Automatically Recording Currency 
Transactions…). I have always used trading accounts in GnuCash, so I 
have no experience without trading accounts.


3. Know that each transaction has a default currency, but GnuCash does 
not easily show you which currency that is. GnuCash sets the default 
currency to be the currency of whichever account you were in when you 
created the transaction.  If you have three currencies, $AA, $BB, and 
$CC, and you want the transaction's default currency to be $CC, then go 
to an account register which has $CC as its currency, and create the 
transaction there.


4. You will have to establish an exchange rate between the currency of 
each split of the transaction, and the default currency of the 
transaction. For each split, if the account for that split uses the 
transaction's default currency, GnuCash will accept the amount you type 
in for that transaction. If the account for that split uses a different 
currency, then GnuCash will display a "Transfer Funds" dialogue (See 
12.3.2.2. Transfer of Funds to a Foreign Currency). You will have to 
determine an amount of the transaction's default currency which 
corresponds to the split amount, in the split account's currency.


4.example. Suppose you have a transaction where you pay $AA 4.00, and 
the payment processor pays out $BB 2.00 and $CC 1.00. Go to the source 
account, which uses $AA. Enter a split for that account with the amount 
4.00. Add a split with an account which receives the $BB 2.00. Enter the 
amount 2.00. A "Transfer Funds" dialogue appears. Enter the amount of 
$AA which corresponds to $BB 2.00. (You need to determine this yourself, 
if the payment processor does not document it for you.) Then add another 
split with an account which receives the $CC 1.00. Enter the amount 
1.00. In a similar way, fill out the Transfer Funds dialogue to set up 
an exchange rate between $AA and $CC.


5. GnuCash enforces a rule that, within every transaction, the sum of 
all splits using a currency sum to zero. This includes splits with 
trading accounts, which GnuCash creates based on what you entered in the 
"Transfer Funds" dialogue.


5.example. In the transaction with a source payment of $AA 4.00, there 
will be one split involving the source account, with a value of $AA 
4.00, and one or two splits involving the TRADING:$AA account, summing 
to -$4.00. The sum for all the splits in $AA is zero.


6. Note that you can use GnuCash as a calculator, by entering 
expressions in amount fields. See GnuCash Guide, 2.9.2.4. Using Entry 
Shortcuts. I use this for splitting the calculating a fraction of the 
total for individual splits.


This is complicated to describe in words. I recommend doing some trial 
and error to experiment, and learn it that way.  Save a copy of your 
Book file as another name. Open that copy, and make some test 
transactions. When you understand what you want to do, open your 
original Book file, and enter the transaction.


Does that help?

Best regards,
  —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
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] Printing Chart of Accounts WITHOUT balances

[David H]

Stan,

If it's available in 2.6.19 you could try File >> Export >> Export Account
tree to CSV as a work around.  Then open in your spreadsheet program,
remove columns (balances not included) you don't want and print from there ?

Cheers David H.


On Fri, 1 Jul 2022 at 06:58, Stan Brown  wrote:

> I have GC 2.6.19 in Widows 10. I'm attempting to print a chart of
> accounts, showing account code and account title. I'm using the Account
> Summary report, because there does not seem to be a Cart of Accounts
> report. But I don't want account balances to show on this report.
>
> In report options, there's a tick box for Account Balance, and I have
> unticked it. I click on Apply to rewrite the report, but the account
> balances still appear.
>
> I'm attaching my selected report options. (I have not changed anything
> on the Commodities tab, because I don't have any commodity accounts.)
>
> I know I'm using an old version, so maybe GC 2.6.19 just has a bug that
> causes it to display account balances even though they're un-requested.
> But also I wonder if some option I selected has the side effect of
> showing balances. (On the Display tab, I did try changing Parent Account
> Balances to "Do not show". That suppressed the parent account balances,
> but all the other accounts showed balances.)
>
> Is there something I can do to get a chart of accounts without balances,
> apart from exporting HTML and hand editing? Thanks!
>
> --
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 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] Printing Chart of Accounts WITHOUT balances

[David H]

Stan,

Forget the previous email this setting has no effect on your requirements
and the behavior seems consistent with version 4.11.

Cheers David H.


On Fri, 1 Jul 2022 at 07:04, David H  wrote:

> Maybe you need to check "Omit Zero Balance Figures" - you don't seem to
> have it checked on in pic 2 ?
>
> Cheers David H.
>
> On Fri, 1 Jul 2022 at 06:58, Stan Brown 
> wrote:
>
>> I have GC 2.6.19 in Widows 10. I'm attempting to print a chart of
>> accounts, showing account code and account title. I'm using the Account
>> Summary report, because there does not seem to be a Cart of Accounts
>> report. But I don't want account balances to show on this report.
>>
>> In report options, there's a tick box for Account Balance, and I have
>> unticked it. I click on Apply to rewrite the report, but the account
>> balances still appear.
>>
>> I'm attaching my selected report options. (I have not changed anything
>> on the Commodities tab, because I don't have any commodity accounts.)
>>
>> I know I'm using an old version, so maybe GC 2.6.19 just has a bug that
>> causes it to display account balances even though they're un-requested.
>> But also I wonder if some option I selected has the side effect of
>> showing balances. (On the Display tab, I did try changing Parent Account
>> Balances to "Do not show". That suppressed the parent account balances,
>> but all the other accounts showed balances.)
>>
>> Is there something I can do to get a chart of accounts without balances,
>> apart from exporting HTML and hand editing? Thanks!
>>
>> --
>> Stan Brown
>> Tehachapi, CA, USA
>> https://BrownMath.com
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> 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] Printing Chart of Accounts WITHOUT balances

[David H]

Maybe you need to check "Omit Zero Balance Figures" - you don't seem to
have it checked on in pic 2 ?

Cheers David H.

On Fri, 1 Jul 2022 at 06:58, Stan Brown  wrote:

> I have GC 2.6.19 in Widows 10. I'm attempting to print a chart of
> accounts, showing account code and account title. I'm using the Account
> Summary report, because there does not seem to be a Cart of Accounts
> report. But I don't want account balances to show on this report.
>
> In report options, there's a tick box for Account Balance, and I have
> unticked it. I click on Apply to rewrite the report, but the account
> balances still appear.
>
> I'm attaching my selected report options. (I have not changed anything
> on the Commodities tab, because I don't have any commodity accounts.)
>
> I know I'm using an old version, so maybe GC 2.6.19 just has a bug that
> causes it to display account balances even though they're un-requested.
> But also I wonder if some option I selected has the side effect of
> showing balances. (On the Display tab, I did try changing Parent Account
> Balances to "Do not show". That suppressed the parent account balances,
> but all the other accounts showed balances.)
>
> Is there something I can do to get a chart of accounts without balances,
> apart from exporting HTML and hand editing? Thanks!
>
> --
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 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] ASX Online quotes problem

[David H]

https://wiki.gnucash.org/wiki/Flatpak#Using_Command_Line_Tools is probably
a worthwhile read :-)

Cheers David H.


On Fri, 1 Jul 2022 at 00:16, Richard Spinney  wrote:

> Ok, I found a solution, helped by Geoff, which I describe here in case it
> is of any use to others.
>
> Note: This solution is relevant to the Flatpak distribution of Gnucash on
> Linux.
>
> So, Geoff rightly pointed out that my command line quotes were working
> using my system version of Perl, not the sandbox Flatpak version, which is
> what Gnucash uses.
>
> My attempts to run the quote scripts/gnucash-cli from a terminal failed as
> they were trying to be run outside of the Flatpak sandbox so were not
> dynamically linking with the appropriate, bundled, dynamic libraries.
>
> To use them you need to enter the sandbox for the Gnucash app as a command
> line interface by typing
>
> flatpak run --command=sh org.gnucash.GnuCash
>
> This enters a shell in the Flatpak sandbox.
>
> In this environment you can then update the relevant perl modules using
> "gnc-fq-update".
>
> This was a lengthy procedure and it didn't completely succeed. For
> instance, within the sandbox shell after the update, the command
> "gnc-fq-dump asx vgs" still did not work, even though it worked using by
> system's version of Perl.
>
> However, using Yahoo as JSON as a source did work, i.e. "gnc-fq-dump
> yahoo_json VGS.AX".
>
> Consequently, reloading Gnucash, and setting the stock details in the
> security editor to:
>
> Symbol: VGS.AX
> Source: Yahoo as JSON
>
> allowed the ASX stocks to get online quotes.
>
>
>
> On Thu, Jun 30, 2022 at 5:44 PM Richard Spinney 
> wrote:
>
> > Hi All,
> >
> > I'm having some trouble fetching online quotes for Australian stocks in
> > Gnucash.
> >
> > My versions are:
> >
> > Gnucash Version: 4.11
> > Build ID: Flathub 4.11
> > Finance::Quote: 1.49
> >
> > running on Linux.
> >
> > Every other security price fetch seems to work fine. For instance, this
> > works for US stocks when input into the security editor:
> >
> > Symbol: AAPL
> > Source: alphavantage
> >
> > as do currency quotes.
> >
> > However, I get the following error message:
> >
> > "Unable to retrieve quotes for these items ASX:VGS ..."
> >
> > where ASX is just my "type" categorisation", if I try any ASX stock/etf
> > (here using VGS as an example) with any permutation of
> >
> > Symbol: VGS, VGS.AX, ASX:VGS, ASX.VGS
> > Source: Alphavantage US, Australian Stock Exchange AU,Yahoo as JSON
> >
> > For reference, I have got the underlying command line scripts working and
> > I *can* get Australian quotes using them (in addition to currency and US
> > stock quotes that *do* work in Gnucash). For instance the following
> > commands all return sensible quotes
> >
> >
> > perl gnc-fq-dump -v asx vgs
> > perl gnc-fq-dump -v yahoo_json VGS.ax
> > perl gnc-fq-dump -v australia vgs
> >
> > I'm unclear if this is because of something I am doing wrong with the
> > details in the security editor or if there is something else I'm missing.
> >
> > Thanks in advance,
> >
> > R.
> >
> ___
> 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.

[GNC] Multiple currencies in split tx

[HSC]

Hello,

Found some related previous discussion in archive, but not yet the same.

Is it possible to account in one GC split entry for a tx in which a payment 
processor simultaneously makes a payment to two different vendors in two 
different local currencies?

We see it on the statement as one payment in source currency and two in 
destination currencies, without any details regarding conversion rates.

Do we have to calculate all that manually, and enter in GC as two separate txs?

HSC


signature.asc
Description: OpenPGP digital signature
___
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] Description list

[Adrien Monteleone]

Another approach idea:

1. Find a previous transaction for which you want to repeat a 
description. (this can be done from the CoA, or from a particular 
account, such as an expense account)


2. Right-click & Duplicate Transaction

3. Edit the new transaction as desired.


Yet another approach:

1. I use 'Description' for people/companies I pay money to, or recieve 
money from *only*.


2. I put 'description' information in the Notes field. (you need View> 
Double-Line turned on to see it)


3. I put line-item descriptions in the Memo fields for each split. (use 
View > Auto-Split or View > Transaction Journal, or the Split button to 
see them)


4. Now you're 'Descriptions' are much more limited to just 
Payors/Payees. Your detailed info, still can use auto-complete, but will 
come up as you type. Additionally, repeating a Payor/Payee, can 
auto-complete the entire last transaction with them, so some 
descriptions may carry through automatically. This is particularly 
helpful for regular transactions that don't change often save maybe for 
amounts.



Regards,
Adrien

p.s. I agree, it would be nice to see a pull-down to choose from, 
similar to the account list. Feel free to file an RFE (Request for 
Enhancement) on Bugzilla. Someone who can code it may agree and 
implement it.


On 6/29/22 6:21 PM, Steve Elstad wrote:

Hi, is there a way to create a list of all the items I have used in the
Description field?  The autocompletion works if I remember the description
correctly.  Would like to see a list for those rarely used ones.


___
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-user Digest, Vol 231, Issue 70

[Adrien Monteleone]

I'm pretty certain the Help or the Guide has instructions on starting a 
fresh book with the same set of accounts.


Customers/Vendors/Employees however, I'm not sure about. I don't think 
there is a way to export/import them in any case.


Regards,
Adrien

On 6/29/22 7:00 PM, Eric Hammond wrote:

Resending to proper group

I set up GnuCash as best possible by extracting what I could from my crashed 
Quicken, and many Excel spreadsheets. And 6 months of work.
I got all the info in, but not working properly.
I want to start fresh, almost.
I have created clean CSV files for the AR and AP; and transaction files to fill 
in the bank ledgers.
What I need is to clean GnuCash of everything Except the account tree, vendor 
and customer database.
(Maybe I missed something, but the exported version of vendor and customer data 
has only name and ID number.)

Any ideas on how to do this, or how to not need to do this are appreciated.

Thanks,
Eric


___
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-user Digest, Vol 231, Issue 73

[Richard Spinney]

Hi Kalpesh,

So I found a solution which I detail here:
https://lists.gnucash.org/pipermail/gnucash-user/2022-June/101721.html

Basically, it was all to do with the fact that I was using a Flatpak
version of Gnucash (on Linux) - so yes there technically are two versions
of Perl, but the one used by Gnucash is the one bundled into the Flatpak
app sandbox (i.e. only Gnucash uses it).

The problems were then that:

1. The version of Perl on my computer (not in the Flatpak) was working with
the Quotes feature for AU stocks straight out of the box - the packaged
version didn't.
2. How to update the packaged version wasn't immediately obvious

However, I found out how -to update it, though it didn't update perfectly -
the bundled Perl version still can't get info from the ASX, but it now can
from Yahoo (JSON). So ultimately it now does work.

Cheers,

Richard.

On Fri, Jul 1, 2022 at 1:23 AM Kalpesh Patel  wrote:

> Richard, can you do some digging around to see if you have multiple version
> of Perl or not. Assuming you are NOT on a Windows OS (will work ok within
> WSL service in Windows - ignore if you do not know what that is), execute
> following command in a shell prompt:
>
>
> find / -name perl -type f -executable -print
>
>
> When above command finishes, it will have returned full path to all Perl
> that are available on that system. The number of lines returned back is
> number of locations where Perl is installed on that system. If it returns
> back only one line than you only have one Perl installed on that system --
> that is good. If it is more than one then now you need to decide whether up
> to upgrade the Finance::Quote on all of them or you have to find where it
> is
> not working correctly, which will be more complex undertaking. You can
> install/upgrade Finance::Quote in all Perl as follows:
>
> Take first full line from the above command and append following to it:
> -MCPAN -e 'install Finance::Quote'
>
> For example, when I run the 'find" command, my output looks like this (one
> line returned which means I have only one Perl installed on my system):
>
>
> root@my-desktop:~# find / -name perl -type f -executable -print
> /usr/bin/perl
> root@my-desktop:~#
>
>
> Now I take the first entry (/usr/bin/perl) and append second part (-MCPAN
> -e
> 'install Finance::Quote') to get following full command to run in a shell:
>
>
> /usr/bin/perl -MCPAN -e 'install Finance::Quote'
>
>
> If you are running it for first time then it may ask few question for
> initial configuration - feel free to accept default answers for all
> questions as they are sane enough to work properly. Now you can do same
> thing for the next entry until all different entries has the module
> installed. I hope that it doesn't have more than two or three printed
> entries as that would be the norm on the extreme case.
>
> Now BIG DISCLAIMER: this will install or upgrade Finance::Quote module for
> all the different locations where Perl is installed. Alternative is for you
> to pick and choose in which Perl location to install but that seems to be
> more vexing question which is probably out of scope of GNC needs. Make sure
> you take backup of the system as if something else get broken then you can
> recover back by restoring back from backup should it be necessary.
>
> Hope this helps.
>
>
> --
>
> Message: 4
> Date: Thu, 30 Jun 2022 19:40:45 +1000
> From: Richard Spinney 
> To: Geoff 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] ASX Online quotes problem
> Message-ID:
>  e9bdnpy1+u+-fh7zs4v9...@mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> As a note, it might be relevant that I am using a Flatpak distribution of
> Gnucash, possibly explaining the "two versions" situation. Running the
> Flatpak from the command line confirms that it is detecting Finance::Quotes
> v1.49 even though the command line version I am using is v1.51.
>
> On Thu, Jun 30, 2022 at 6:43 PM Geoff  wrote:
>
> > Hi Richard
> >
> > Yes, that is confusing.  It is possible that this discrepancy in
> > behaviour may be due to you having two instances of Perl installed -
> > the later one is seen by your command line scripts and the earlier
> > (out of
> > date) one is seen by your GnuCash GUI.  I make this suggestion as I
> > recall seeing other GnuCash problems being reported due to this.  I am
> > mainly a Windows user so I can't really help you to trouble shoot.
> >
> > Anyway, to upgrade, you can try the "gnc-fq-update" Perl script, which
> > should get the latest version (1.51) from CPAN:
> > https://metacpan.org/pod/Finance::Quote
> >
> > Finally, I have attached a screenshot of my setup to retrieve prices
> > for ASX securities.
> >
> > Hope this helps.
> >
> > Regards
> >
> > Geoff
> > =
> >
> > On 30/06/2022 6:26 pm, Richard Spinney wrote:
> > > Hi Geoff,
> > >
> > > Thanks for this.
> > >
> > > I am little bit confused though, the command line perl scripts I am
> > > using with the ASX as 

Re: [GNC] gnucash-user Digest, Vol 231, Issue 73

[Kalpesh Patel]

Richard, can you do some digging around to see if you have multiple version
of Perl or not. Assuming you are NOT on a Windows OS (will work ok within
WSL service in Windows - ignore if you do not know what that is), execute
following command in a shell prompt:


find / -name perl -type f -executable -print


When above command finishes, it will have returned full path to all Perl
that are available on that system. The number of lines returned back is
number of locations where Perl is installed on that system. If it returns
back only one line than you only have one Perl installed on that system --
that is good. If it is more than one then now you need to decide whether up
to upgrade the Finance::Quote on all of them or you have to find where it is
not working correctly, which will be more complex undertaking. You can
install/upgrade Finance::Quote in all Perl as follows: 

Take first full line from the above command and append following to it:
-MCPAN -e 'install Finance::Quote'

For example, when I run the 'find" command, my output looks like this (one
line returned which means I have only one Perl installed on my system):


root@my-desktop:~# find / -name perl -type f -executable -print
/usr/bin/perl
root@my-desktop:~#


Now I take the first entry (/usr/bin/perl) and append second part (-MCPAN -e
'install Finance::Quote') to get following full command to run in a shell:


/usr/bin/perl -MCPAN -e 'install Finance::Quote'


If you are running it for first time then it may ask few question for
initial configuration - feel free to accept default answers for all
questions as they are sane enough to work properly. Now you can do same
thing for the next entry until all different entries has the module
installed. I hope that it doesn't have more than two or three printed
entries as that would be the norm on the extreme case.

Now BIG DISCLAIMER: this will install or upgrade Finance::Quote module for
all the different locations where Perl is installed. Alternative is for you
to pick and choose in which Perl location to install but that seems to be
more vexing question which is probably out of scope of GNC needs. Make sure
you take backup of the system as if something else get broken then you can
recover back by restoring back from backup should it be necessary.

Hope this helps.


--

Message: 4
Date: Thu, 30 Jun 2022 19:40:45 +1000
From: Richard Spinney 
To: Geoff 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] ASX Online quotes problem
Message-ID:

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

As a note, it might be relevant that I am using a Flatpak distribution of
Gnucash, possibly explaining the "two versions" situation. Running the
Flatpak from the command line confirms that it is detecting Finance::Quotes
v1.49 even though the command line version I am using is v1.51.

On Thu, Jun 30, 2022 at 6:43 PM Geoff  wrote:

> Hi Richard
>
> Yes, that is confusing.  It is possible that this discrepancy in 
> behaviour may be due to you having two instances of Perl installed - 
> the later one is seen by your command line scripts and the earlier 
> (out of
> date) one is seen by your GnuCash GUI.  I make this suggestion as I 
> recall seeing other GnuCash problems being reported due to this.  I am 
> mainly a Windows user so I can't really help you to trouble shoot.
>
> Anyway, to upgrade, you can try the "gnc-fq-update" Perl script, which 
> should get the latest version (1.51) from CPAN:
> https://metacpan.org/pod/Finance::Quote
>
> Finally, I have attached a screenshot of my setup to retrieve prices 
> for ASX securities.
>
> Hope this helps.
>
> Regards
>
> Geoff
> =
>
> On 30/06/2022 6:26 pm, Richard Spinney wrote:
> > Hi Geoff,
> >
> > Thanks for this.
> >
> > I am little bit confused though, the command line perl scripts I am 
> > using with the ASX as a source work fine. But moreover, they work 
> > when I use *different* sources (e.g. yahoo as JSON), but then they 
> > don't work in gnucash itself - I.e. the issue is there when I 
> > specifically avoid the ASX as a source. Or have I missed something?
> >
> > If I do have to update that module do you have any links or similar 
> > you could point me to?
> >
> > Thanks,
> >
> > R.
> >
> > On Thu, 30 June 2022, 18:21 Geoff,  > > wrote:
> >
> > Hi Richard
> >
> > The ASX did a major web upgrade back in 2020 that broke Version 
> > 1.49
> of
> > Finance::Quote.  If you want to use the ASX as your data source for
> > Australian listed securities then you will need to upgrade that Perl
> > module.
> >
> >
> > Regards
> >
> > Geoff
> > =
> >
> > On 30/06/2022 5:44 pm, Richard Spinney wrote:
> >  > Hi All,
> >  >
> >  > I'm having some trouble fetching online quotes for Australian
> > stocks in
> >  > Gnucash.
> >  >
> >  > My versions are:
> >  >
> >  > Gnucash Version: 4.11
> >  > Build ID: Flathub 4.11
> >  > 

Re: [GNC] ASX Online quotes problem

[Richard Spinney]

Ok, I found a solution, helped by Geoff, which I describe here in case it
is of any use to others.

Note: This solution is relevant to the Flatpak distribution of Gnucash on
Linux.

So, Geoff rightly pointed out that my command line quotes were working
using my system version of Perl, not the sandbox Flatpak version, which is
what Gnucash uses.

My attempts to run the quote scripts/gnucash-cli from a terminal failed as
they were trying to be run outside of the Flatpak sandbox so were not
dynamically linking with the appropriate, bundled, dynamic libraries.

To use them you need to enter the sandbox for the Gnucash app as a command
line interface by typing

flatpak run --command=sh org.gnucash.GnuCash

This enters a shell in the Flatpak sandbox.

In this environment you can then update the relevant perl modules using
"gnc-fq-update".

This was a lengthy procedure and it didn't completely succeed. For
instance, within the sandbox shell after the update, the command
"gnc-fq-dump asx vgs" still did not work, even though it worked using by
system's version of Perl.

However, using Yahoo as JSON as a source did work, i.e. "gnc-fq-dump
yahoo_json VGS.AX".

Consequently, reloading Gnucash, and setting the stock details in the
security editor to:

Symbol: VGS.AX
Source: Yahoo as JSON

allowed the ASX stocks to get online quotes.



On Thu, Jun 30, 2022 at 5:44 PM Richard Spinney 
wrote:

> Hi All,
>
> I'm having some trouble fetching online quotes for Australian stocks in
> Gnucash.
>
> My versions are:
>
> Gnucash Version: 4.11
> Build ID: Flathub 4.11
> Finance::Quote: 1.49
>
> running on Linux.
>
> Every other security price fetch seems to work fine. For instance, this
> works for US stocks when input into the security editor:
>
> Symbol: AAPL
> Source: alphavantage
>
> as do currency quotes.
>
> However, I get the following error message:
>
> "Unable to retrieve quotes for these items ASX:VGS ..."
>
> where ASX is just my "type" categorisation", if I try any ASX stock/etf
> (here using VGS as an example) with any permutation of
>
> Symbol: VGS, VGS.AX, ASX:VGS, ASX.VGS
> Source: Alphavantage US, Australian Stock Exchange AU,Yahoo as JSON
>
> For reference, I have got the underlying command line scripts working and
> I *can* get Australian quotes using them (in addition to currency and US
> stock quotes that *do* work in Gnucash). For instance the following
> commands all return sensible quotes
>
>
> perl gnc-fq-dump -v asx vgs
> perl gnc-fq-dump -v yahoo_json VGS.ax
> perl gnc-fq-dump -v australia vgs
>
> I'm unclear if this is because of something I am doing wrong with the
> details in the security editor or if there is something else I'm missing.
>
> Thanks in advance,
>
> R.
>
___
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] Description list

[Greg Feneis]

I suspect what collects in the autocomplete list is generated live as you
type, and once you've entered the text in that field, the list is
essentially discarded.

 It's probably not presented to you as an excerpt from a preexisting data
file of sequential terms that could be presented to a user in a text file.

However, it might be a cool feature to have a certain character sequence
the user could type that makes the autocomplete function simply list all
possible suggestions in alphabetical order for the user to browse instead
of listing the most likely suggestions.

Kind regards, Greg Feneis
(Pixel 3)


On Wed, Jun 29, 2022, 17:37 Steve Elstad  wrote:

> In my simple mind, to do autocomplete you are looking up the entered values
> in a list for a closest match.  Seems you could export that list?
>
> Steve
>
> -Original Message-
> From: gnucash-user On Behalf Of Jeff
> Sent: Wednesday, June 29, 2022 5:16 PM
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Description list
>
> Hi Steve,
>
> That's a great idea, and one that I wish was there, as it's always those
> seldom used ones that you can't remember what you typed it as.
>
> It may not be possible to generate the list from within GnuCash, but you
> could always export the register to Excel and remove the duplicate entries
> to create your own list.
>
> Regards,
> Jeff.
>
> On 30/6/22 10:05, Steve Elstad wrote:
> > Thanks for that.  Is there a way to produce a list of all those
> descriptions that I have used before?  Autocomplete is great if I am close
> to spelling the description I want.  Otherwise I am just guessing and would
> like to reuse a previously used description.
> >
> >
> >
> > Steve
> >
> >
> >
> > From: Glenn Fowler
> > Sent: Wednesday, June 29, 2022 4:38 PM
> > To: Steve Elstad 
> > Cc: GnuCash users group 
> > Subject: Re: [GNC] Description list
> >
> >
> >
> > Hi Steve,
> >
> >
> >
> > Your register *is* your list. Auto-complete just matches previous entries
> as type.
> >
> >
> >
> > On Wed, Jun 29, 2022 at 7:21 PM Steve Elstad   > wrote:
> >
> > Hi, is there a way to create a list of all the items I have used in
> > the Description field?  The autocompletion works if I remember the
> > description correctly.  Would like to see a list for those rarely used
> ones.
> >
> >
> >
> > In the Transfer field there is a pull down list of accounts.
> >
> >
> >
> > Thanks,
> >
> >
> >
> > Steve
> >
> > ___
> > 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.
> >
>
> ___
> 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.
>
___
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] ASX Online quotes problem

[Geoff]

Hi Richard

If you trawl through the mailing lists you might find some flatpak 
related solutions.


For example "gnucash finance quote not installed properly":-

https://lists.gnucash.org/pipermail/gnucash-user/2021-March/095643.html

Good luck!

Geoff
=

On 30/06/2022 7:56 pm, Richard Spinney wrote:

Apologies for the spam - just trying to make the necessary info visible.

So I have found a separate perl executable bundled with the Flatpak 
installation. The issue now appears to be that I can't run the update 
script with it as these executables are designed to be run independently 
of Flatpak.


I.e. in this bundled folder is "perl", "gnucash", "gnucash-cli", 
"gnc-fq-dump" etc.


But I can't "run" any of them - I get a runtime linking error. I was 
able to run the gnc-fq-* scripts as I was invoking my system version of 
perl to do so. I open the gnucash GUI itself with the entry to the 
flatpak, "org.gnucash.GnuCash".


I.e. there appear to be a few issues with distributing Gnucash as a 
flatpak here:


These quite important scripts (gnc-fq-*, gnucash-cli) are:
1. Hidden away in some horrible hidden file structure e.g. 
"~/.local/share/flatpak/app/org.gnucash.GnuCash/x86_64/stable/de789f62d67a6ed3ae7fd898b9d1e05cf57cb26fc7f7743262608dfefc81bd0b/files/bin"
2. Even when you do find them, they can't simply be run - the only one 
that can be run is "gnucash" (i.e. the GUI), because that is the one 
that is hardlinked to in the Flapak run command "flatpak run 
org.gnucash.Gnucash"


Thanks,

R.

On Thu, Jun 30, 2022 at 6:43 PM Geoff > wrote:


Hi Richard

Yes, that is confusing.  It is possible that this discrepancy in
behaviour may be due to you having two instances of Perl installed -
the
later one is seen by your command line scripts and the earlier (out of
date) one is seen by your GnuCash GUI.  I make this suggestion as I
recall seeing other GnuCash problems being reported due to this.  I am
mainly a Windows user so I can't really help you to trouble shoot.

Anyway, to upgrade, you can try the "gnc-fq-update" Perl script, which
should get the latest version (1.51) from CPAN:
https://metacpan.org/pod/Finance::Quote


Finally, I have attached a screenshot of my setup to retrieve prices
for
ASX securities.

Hope this helps.

Regards

Geoff
=

On 30/06/2022 6:26 pm, Richard Spinney wrote:
 > Hi Geoff,
 >
 > Thanks for this.
 >
 > I am little bit confused though, the command line perl scripts I am
 > using with the ASX as a source work fine. But moreover, they work
when I
 > use *different* sources (e.g. yahoo as JSON), but then they don't
work
 > in gnucash itself - I.e. the issue is there when I specifically
avoid
 > the ASX as a source. Or have I missed something?
 >
 > If I do have to update that module do you have any links or
similar you
 > could point me to?
 >
 > Thanks,
 >
 > R.
 >
 > On Thu, 30 June 2022, 18:21 Geoff, mailto:cleanoutmys...@gmail.com>
 > >> wrote:
 >
 >     Hi Richard
 >
 >     The ASX did a major web upgrade back in 2020 that broke
Version 1.49 of
 >     Finance::Quote.  If you want to use the ASX as your data
source for
 >     Australian listed securities then you will need to upgrade
that Perl
 >     module.
 >
 >
 >     Regards
 >
 >     Geoff
 >     =
 >
 >     On 30/06/2022 5:44 pm, Richard Spinney wrote:
 >      > Hi All,
 >      >
 >      > I'm having some trouble fetching online quotes for Australian
 >     stocks in
 >      > Gnucash.
 >      >
 >      > My versions are:
 >      >
 >      > Gnucash Version: 4.11
 >      > Build ID: Flathub 4.11
 >      > Finance::Quote: 1.49
 >      >
 >      > running on Linux.
 >      >
 >      > Every other security price fetch seems to work fine. For
 >     instance, this
 >      > works for US stocks when input into the security editor:
 >      >
 >      > Symbol: AAPL
 >      > Source: alphavantage
 >      >
 >      > as do currency quotes.
 >      >
 >      > However, I get the following error message:
 >      >
 >      > "Unable to retrieve quotes for these items ASX:VGS ..."
 >      >
 >      > where ASX is just my "type" categorisation", if I try any ASX
 >     stock/etf
 >      > (here using VGS as an example) with any permutation of
 >      >
 >      > Symbol: VGS, VGS.AX  >, ASX:VGS, ASX.VGS
 >      > Source: Alphavantage US, Australian Stock Exchange
AU,Yahoo as JSON
 >      >
 >      > For reference, I have got the underlying command line 

Re: [GNC] ASX Online quotes problem

[Richard Spinney]

Apologies for the spam - just trying to make the necessary info visible.

So I have found a separate perl executable bundled with the Flatpak
installation. The issue now appears to be that I can't run the update
script with it as these executables are designed to be run independently of
Flatpak.

I.e. in this bundled folder is "perl", "gnucash", "gnucash-cli",
"gnc-fq-dump" etc.

But I can't "run" any of them - I get a runtime linking error. I was able
to run the gnc-fq-* scripts as I was invoking my system version of perl to
do so. I open the gnucash GUI itself with the entry to the flatpak,
"org.gnucash.GnuCash".

I.e. there appear to be a few issues with distributing Gnucash as a flatpak
here:

These quite important scripts (gnc-fq-*, gnucash-cli) are:
1. Hidden away in some horrible hidden file structure e.g.
"~/.local/share/flatpak/app/org.gnucash.GnuCash/x86_64/stable/de789f62d67a6ed3ae7fd898b9d1e05cf57cb26fc7f7743262608dfefc81bd0b/files/bin"
2. Even when you do find them, they can't simply be run - the only one that
can be run is "gnucash" (i.e. the GUI), because that is the one that is
hardlinked to in the Flapak run command "flatpak run org.gnucash.Gnucash"

Thanks,

R.

On Thu, Jun 30, 2022 at 6:43 PM Geoff  wrote:

> Hi Richard
>
> Yes, that is confusing.  It is possible that this discrepancy in
> behaviour may be due to you having two instances of Perl installed - the
> later one is seen by your command line scripts and the earlier (out of
> date) one is seen by your GnuCash GUI.  I make this suggestion as I
> recall seeing other GnuCash problems being reported due to this.  I am
> mainly a Windows user so I can't really help you to trouble shoot.
>
> Anyway, to upgrade, you can try the "gnc-fq-update" Perl script, which
> should get the latest version (1.51) from CPAN:
> https://metacpan.org/pod/Finance::Quote
>
> Finally, I have attached a screenshot of my setup to retrieve prices for
> ASX securities.
>
> Hope this helps.
>
> Regards
>
> Geoff
> =
>
> On 30/06/2022 6:26 pm, Richard Spinney wrote:
> > Hi Geoff,
> >
> > Thanks for this.
> >
> > I am little bit confused though, the command line perl scripts I am
> > using with the ASX as a source work fine. But moreover, they work when I
> > use *different* sources (e.g. yahoo as JSON), but then they don't work
> > in gnucash itself - I.e. the issue is there when I specifically avoid
> > the ASX as a source. Or have I missed something?
> >
> > If I do have to update that module do you have any links or similar you
> > could point me to?
> >
> > Thanks,
> >
> > R.
> >
> > On Thu, 30 June 2022, 18:21 Geoff,  > > wrote:
> >
> > Hi Richard
> >
> > The ASX did a major web upgrade back in 2020 that broke Version 1.49
> of
> > Finance::Quote.  If you want to use the ASX as your data source for
> > Australian listed securities then you will need to upgrade that Perl
> > module.
> >
> >
> > Regards
> >
> > Geoff
> > =
> >
> > On 30/06/2022 5:44 pm, Richard Spinney wrote:
> >  > Hi All,
> >  >
> >  > I'm having some trouble fetching online quotes for Australian
> > stocks in
> >  > Gnucash.
> >  >
> >  > My versions are:
> >  >
> >  > Gnucash Version: 4.11
> >  > Build ID: Flathub 4.11
> >  > Finance::Quote: 1.49
> >  >
> >  > running on Linux.
> >  >
> >  > Every other security price fetch seems to work fine. For
> > instance, this
> >  > works for US stocks when input into the security editor:
> >  >
> >  > Symbol: AAPL
> >  > Source: alphavantage
> >  >
> >  > as do currency quotes.
> >  >
> >  > However, I get the following error message:
> >  >
> >  > "Unable to retrieve quotes for these items ASX:VGS ..."
> >  >
> >  > where ASX is just my "type" categorisation", if I try any ASX
> > stock/etf
> >  > (here using VGS as an example) with any permutation of
> >  >
> >  > Symbol: VGS, VGS.AX , ASX:VGS, ASX.VGS
> >  > Source: Alphavantage US, Australian Stock Exchange AU,Yahoo as
> JSON
> >  >
> >  > For reference, I have got the underlying command line scripts
> > working and I
> >  > *can* get Australian quotes using them (in addition to currency
> > and US
> >  > stock quotes that *do* work in Gnucash). For instance the
> following
> >  > commands all return sensible quotes
> >  >
> >  >
> >  > perl gnc-fq-dump -v asx vgs
> >  > perl gnc-fq-dump -v yahoo_json VGS.ax
> >  > perl gnc-fq-dump -v australia vgs
> >  >
> >  > I'm unclear if this is because of something I am doing wrong with
> the
> >  > details in the security editor or if there is something else I'm
> > missing.
> >  >
> >  > Thanks in advance,
> >  >
> >  > R.
> >  > ___
> >  > gnucash-user mailing list
> >  > 

Re: [GNC] ASX Online quotes problem

[Richard Spinney]

As a note, it might be relevant that I am using a Flatpak distribution of
Gnucash, possibly explaining the "two versions" situation. Running the
Flatpak from the command line confirms that it is detecting Finance::Quotes
v1.49 even though the command line version I am using is v1.51.

On Thu, Jun 30, 2022 at 6:43 PM Geoff  wrote:

> Hi Richard
>
> Yes, that is confusing.  It is possible that this discrepancy in
> behaviour may be due to you having two instances of Perl installed - the
> later one is seen by your command line scripts and the earlier (out of
> date) one is seen by your GnuCash GUI.  I make this suggestion as I
> recall seeing other GnuCash problems being reported due to this.  I am
> mainly a Windows user so I can't really help you to trouble shoot.
>
> Anyway, to upgrade, you can try the "gnc-fq-update" Perl script, which
> should get the latest version (1.51) from CPAN:
> https://metacpan.org/pod/Finance::Quote
>
> Finally, I have attached a screenshot of my setup to retrieve prices for
> ASX securities.
>
> Hope this helps.
>
> Regards
>
> Geoff
> =
>
> On 30/06/2022 6:26 pm, Richard Spinney wrote:
> > Hi Geoff,
> >
> > Thanks for this.
> >
> > I am little bit confused though, the command line perl scripts I am
> > using with the ASX as a source work fine. But moreover, they work when I
> > use *different* sources (e.g. yahoo as JSON), but then they don't work
> > in gnucash itself - I.e. the issue is there when I specifically avoid
> > the ASX as a source. Or have I missed something?
> >
> > If I do have to update that module do you have any links or similar you
> > could point me to?
> >
> > Thanks,
> >
> > R.
> >
> > On Thu, 30 June 2022, 18:21 Geoff,  > > wrote:
> >
> > Hi Richard
> >
> > The ASX did a major web upgrade back in 2020 that broke Version 1.49
> of
> > Finance::Quote.  If you want to use the ASX as your data source for
> > Australian listed securities then you will need to upgrade that Perl
> > module.
> >
> >
> > Regards
> >
> > Geoff
> > =
> >
> > On 30/06/2022 5:44 pm, Richard Spinney wrote:
> >  > Hi All,
> >  >
> >  > I'm having some trouble fetching online quotes for Australian
> > stocks in
> >  > Gnucash.
> >  >
> >  > My versions are:
> >  >
> >  > Gnucash Version: 4.11
> >  > Build ID: Flathub 4.11
> >  > Finance::Quote: 1.49
> >  >
> >  > running on Linux.
> >  >
> >  > Every other security price fetch seems to work fine. For
> > instance, this
> >  > works for US stocks when input into the security editor:
> >  >
> >  > Symbol: AAPL
> >  > Source: alphavantage
> >  >
> >  > as do currency quotes.
> >  >
> >  > However, I get the following error message:
> >  >
> >  > "Unable to retrieve quotes for these items ASX:VGS ..."
> >  >
> >  > where ASX is just my "type" categorisation", if I try any ASX
> > stock/etf
> >  > (here using VGS as an example) with any permutation of
> >  >
> >  > Symbol: VGS, VGS.AX , ASX:VGS, ASX.VGS
> >  > Source: Alphavantage US, Australian Stock Exchange AU,Yahoo as
> JSON
> >  >
> >  > For reference, I have got the underlying command line scripts
> > working and I
> >  > *can* get Australian quotes using them (in addition to currency
> > and US
> >  > stock quotes that *do* work in Gnucash). For instance the
> following
> >  > commands all return sensible quotes
> >  >
> >  >
> >  > perl gnc-fq-dump -v asx vgs
> >  > perl gnc-fq-dump -v yahoo_json VGS.ax
> >  > perl gnc-fq-dump -v australia vgs
> >  >
> >  > I'm unclear if this is because of something I am doing wrong with
> the
> >  > details in the security editor or if there is something else I'm
> > missing.
> >  >
> >  > Thanks in advance,
> >  >
> >  > R.
> >  > ___
> >  > 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 

Re: [GNC] ASX Online quotes problem

[Richard Spinney]

Hi Geoff,

Yes, I see, that would explain the behaviour.

I followed your advice and upgraded with that script to v 1.51.
Unfortunately, that hasn't solved the issue, and the version reported in
Help->About in Gnucash remains at 1.49, aligning with your suggestion that
two versions are acting independently here.

I think I might be waiting for someone who is familiar with how Gnucash
plays in Linux to weigh in on how to manage the "GUI version".

Thanks for your help,

R.

On Thu, Jun 30, 2022 at 6:43 PM Geoff  wrote:

> Hi Richard
>
> Yes, that is confusing.  It is possible that this discrepancy in
> behaviour may be due to you having two instances of Perl installed - the
> later one is seen by your command line scripts and the earlier (out of
> date) one is seen by your GnuCash GUI.  I make this suggestion as I
> recall seeing other GnuCash problems being reported due to this.  I am
> mainly a Windows user so I can't really help you to trouble shoot.
>
> Anyway, to upgrade, you can try the "gnc-fq-update" Perl script, which
> should get the latest version (1.51) from CPAN:
> https://metacpan.org/pod/Finance::Quote
>
> Finally, I have attached a screenshot of my setup to retrieve prices for
> ASX securities.
>
> Hope this helps.
>
> Regards
>
> Geoff
> =
>
> On 30/06/2022 6:26 pm, Richard Spinney wrote:
> > Hi Geoff,
> >
> > Thanks for this.
> >
> > I am little bit confused though, the command line perl scripts I am
> > using with the ASX as a source work fine. But moreover, they work when I
> > use *different* sources (e.g. yahoo as JSON), but then they don't work
> > in gnucash itself - I.e. the issue is there when I specifically avoid
> > the ASX as a source. Or have I missed something?
> >
> > If I do have to update that module do you have any links or similar you
> > could point me to?
> >
> > Thanks,
> >
> > R.
> >
> > On Thu, 30 June 2022, 18:21 Geoff,  > > wrote:
> >
> > Hi Richard
> >
> > The ASX did a major web upgrade back in 2020 that broke Version 1.49
> of
> > Finance::Quote.  If you want to use the ASX as your data source for
> > Australian listed securities then you will need to upgrade that Perl
> > module.
> >
> >
> > Regards
> >
> > Geoff
> > =
> >
> > On 30/06/2022 5:44 pm, Richard Spinney wrote:
> >  > Hi All,
> >  >
> >  > I'm having some trouble fetching online quotes for Australian
> > stocks in
> >  > Gnucash.
> >  >
> >  > My versions are:
> >  >
> >  > Gnucash Version: 4.11
> >  > Build ID: Flathub 4.11
> >  > Finance::Quote: 1.49
> >  >
> >  > running on Linux.
> >  >
> >  > Every other security price fetch seems to work fine. For
> > instance, this
> >  > works for US stocks when input into the security editor:
> >  >
> >  > Symbol: AAPL
> >  > Source: alphavantage
> >  >
> >  > as do currency quotes.
> >  >
> >  > However, I get the following error message:
> >  >
> >  > "Unable to retrieve quotes for these items ASX:VGS ..."
> >  >
> >  > where ASX is just my "type" categorisation", if I try any ASX
> > stock/etf
> >  > (here using VGS as an example) with any permutation of
> >  >
> >  > Symbol: VGS, VGS.AX , ASX:VGS, ASX.VGS
> >  > Source: Alphavantage US, Australian Stock Exchange AU,Yahoo as
> JSON
> >  >
> >  > For reference, I have got the underlying command line scripts
> > working and I
> >  > *can* get Australian quotes using them (in addition to currency
> > and US
> >  > stock quotes that *do* work in Gnucash). For instance the
> following
> >  > commands all return sensible quotes
> >  >
> >  >
> >  > perl gnc-fq-dump -v asx vgs
> >  > perl gnc-fq-dump -v yahoo_json VGS.ax
> >  > perl gnc-fq-dump -v australia vgs
> >  >
> >  > I'm unclear if this is because of something I am doing wrong with
> the
> >  > details in the security editor or if there is something else I'm
> > missing.
> >  >
> >  > Thanks in advance,
> >  >
> >  > R.
> >  > ___
> >  > 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 

Re: [GNC] ASX Online quotes problem

[Geoff]

Hi Richard

Yes, that is confusing.  It is possible that this discrepancy in 
behaviour may be due to you having two instances of Perl installed - the 
later one is seen by your command line scripts and the earlier (out of 
date) one is seen by your GnuCash GUI.  I make this suggestion as I 
recall seeing other GnuCash problems being reported due to this.  I am 
mainly a Windows user so I can't really help you to trouble shoot.


Anyway, to upgrade, you can try the "gnc-fq-update" Perl script, which 
should get the latest version (1.51) from CPAN:

https://metacpan.org/pod/Finance::Quote

Finally, I have attached a screenshot of my setup to retrieve prices for 
ASX securities.


Hope this helps.

Regards

Geoff
=

On 30/06/2022 6:26 pm, Richard Spinney wrote:

Hi Geoff,

Thanks for this.

I am little bit confused though, the command line perl scripts I am 
using with the ASX as a source work fine. But moreover, they work when I 
use *different* sources (e.g. yahoo as JSON), but then they don't work 
in gnucash itself - I.e. the issue is there when I specifically avoid 
the ASX as a source. Or have I missed something?


If I do have to update that module do you have any links or similar you 
could point me to?


Thanks,

R.

On Thu, 30 June 2022, 18:21 Geoff, > wrote:


Hi Richard

The ASX did a major web upgrade back in 2020 that broke Version 1.49 of
Finance::Quote.  If you want to use the ASX as your data source for
Australian listed securities then you will need to upgrade that Perl
module.


Regards

Geoff
=

On 30/06/2022 5:44 pm, Richard Spinney wrote:
 > Hi All,
 >
 > I'm having some trouble fetching online quotes for Australian
stocks in
 > Gnucash.
 >
 > My versions are:
 >
 > Gnucash Version: 4.11
 > Build ID: Flathub 4.11
 > Finance::Quote: 1.49
 >
 > running on Linux.
 >
 > Every other security price fetch seems to work fine. For
instance, this
 > works for US stocks when input into the security editor:
 >
 > Symbol: AAPL
 > Source: alphavantage
 >
 > as do currency quotes.
 >
 > However, I get the following error message:
 >
 > "Unable to retrieve quotes for these items ASX:VGS ..."
 >
 > where ASX is just my "type" categorisation", if I try any ASX
stock/etf
 > (here using VGS as an example) with any permutation of
 >
 > Symbol: VGS, VGS.AX , ASX:VGS, ASX.VGS
 > Source: Alphavantage US, Australian Stock Exchange AU,Yahoo as JSON
 >
 > For reference, I have got the underlying command line scripts
working and I
 > *can* get Australian quotes using them (in addition to currency
and US
 > stock quotes that *do* work in Gnucash). For instance the following
 > commands all return sensible quotes
 >
 >
 > perl gnc-fq-dump -v asx vgs
 > perl gnc-fq-dump -v yahoo_json VGS.ax
 > perl gnc-fq-dump -v australia vgs
 >
 > I'm unclear if this is because of something I am doing wrong with the
 > details in the security editor or if there is something else I'm
missing.
 >
 > Thanks in advance,
 >
 > R.
 > ___
 > 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.

Re: [GNC] ASX Online quotes problem

[Richard Spinney]

Hi Geoff,

Thanks for this.

I am little bit confused though, the command line perl scripts I am using
with the ASX as a source work fine. But moreover, they work when I use
*different* sources (e.g. yahoo as JSON), but then they don't work in
gnucash itself - I.e. the issue is there when I specifically avoid the ASX
as a source. Or have I missed something?

If I do have to update that module do you have any links or similar you
could point me to?

Thanks,

R.

On Thu, 30 June 2022, 18:21 Geoff,  wrote:

> Hi Richard
>
> The ASX did a major web upgrade back in 2020 that broke Version 1.49 of
> Finance::Quote.  If you want to use the ASX as your data source for
> Australian listed securities then you will need to upgrade that Perl
> module.
>
>
> Regards
>
> Geoff
> =
>
> On 30/06/2022 5:44 pm, Richard Spinney wrote:
> > Hi All,
> >
> > I'm having some trouble fetching online quotes for Australian stocks in
> > Gnucash.
> >
> > My versions are:
> >
> > Gnucash Version: 4.11
> > Build ID: Flathub 4.11
> > Finance::Quote: 1.49
> >
> > running on Linux.
> >
> > Every other security price fetch seems to work fine. For instance, this
> > works for US stocks when input into the security editor:
> >
> > Symbol: AAPL
> > Source: alphavantage
> >
> > as do currency quotes.
> >
> > However, I get the following error message:
> >
> > "Unable to retrieve quotes for these items ASX:VGS ..."
> >
> > where ASX is just my "type" categorisation", if I try any ASX stock/etf
> > (here using VGS as an example) with any permutation of
> >
> > Symbol: VGS, VGS.AX, ASX:VGS, ASX.VGS
> > Source: Alphavantage US, Australian Stock Exchange AU,Yahoo as JSON
> >
> > For reference, I have got the underlying command line scripts working
> and I
> > *can* get Australian quotes using them (in addition to currency and US
> > stock quotes that *do* work in Gnucash). For instance the following
> > commands all return sensible quotes
> >
> >
> > perl gnc-fq-dump -v asx vgs
> > perl gnc-fq-dump -v yahoo_json VGS.ax
> > perl gnc-fq-dump -v australia vgs
> >
> > I'm unclear if this is because of something I am doing wrong with the
> > details in the security editor or if there is something else I'm missing.
> >
> > Thanks in advance,
> >
> > R.
> > ___
> > 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.

Re: [GNC] ASX Online quotes problem

[Geoff]

Hi Richard

The ASX did a major web upgrade back in 2020 that broke Version 1.49 of 
Finance::Quote.  If you want to use the ASX as your data source for 
Australian listed securities then you will need to upgrade that Perl module.



Regards

Geoff
=

On 30/06/2022 5:44 pm, Richard Spinney wrote:

Hi All,

I'm having some trouble fetching online quotes for Australian stocks in
Gnucash.

My versions are:

Gnucash Version: 4.11
Build ID: Flathub 4.11
Finance::Quote: 1.49

running on Linux.

Every other security price fetch seems to work fine. For instance, this
works for US stocks when input into the security editor:

Symbol: AAPL
Source: alphavantage

as do currency quotes.

However, I get the following error message:

"Unable to retrieve quotes for these items ASX:VGS ..."

where ASX is just my "type" categorisation", if I try any ASX stock/etf
(here using VGS as an example) with any permutation of

Symbol: VGS, VGS.AX, ASX:VGS, ASX.VGS
Source: Alphavantage US, Australian Stock Exchange AU,Yahoo as JSON

For reference, I have got the underlying command line scripts working and I
*can* get Australian quotes using them (in addition to currency and US
stock quotes that *do* work in Gnucash). For instance the following
commands all return sensible quotes


perl gnc-fq-dump -v asx vgs
perl gnc-fq-dump -v yahoo_json VGS.ax
perl gnc-fq-dump -v australia vgs

I'm unclear if this is because of something I am doing wrong with the
details in the security editor or if there is something else I'm missing.

Thanks in advance,

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

[GNC] ASX Online quotes problem

[Richard Spinney]

Hi All,

I'm having some trouble fetching online quotes for Australian stocks in
Gnucash.

My versions are:

Gnucash Version: 4.11
Build ID: Flathub 4.11
Finance::Quote: 1.49

running on Linux.

Every other security price fetch seems to work fine. For instance, this
works for US stocks when input into the security editor:

Symbol: AAPL
Source: alphavantage

as do currency quotes.

However, I get the following error message:

"Unable to retrieve quotes for these items ASX:VGS ..."

where ASX is just my "type" categorisation", if I try any ASX stock/etf
(here using VGS as an example) with any permutation of

Symbol: VGS, VGS.AX, ASX:VGS, ASX.VGS
Source: Alphavantage US, Australian Stock Exchange AU,Yahoo as JSON

For reference, I have got the underlying command line scripts working and I
*can* get Australian quotes using them (in addition to currency and US
stock quotes that *do* work in Gnucash). For instance the following
commands all return sensible quotes


perl gnc-fq-dump -v asx vgs
perl gnc-fq-dump -v yahoo_json VGS.ax
perl gnc-fq-dump -v australia vgs

I'm unclear if this is because of something I am doing wrong with the
details in the security editor or if there is something else I'm missing.

Thanks in advance,

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