[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 <rspinney20 at gmail.com>
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.
>