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

Richard Spinney rspinney20 at gmail.com
Thu Jun 30 12:22:45 EDT 2022 

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 <kalpesh.patel at usa.net> 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 at my-desktop:~# find / -name perl -type f -executable -print
> /usr/bin/perl
> root at 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 <rspinney20 at gmail.com>
> To: Geoff <cleanoutmyshed at gmail.com>
> Cc: gnucash-user at gnucash.org
> Subject: Re: [GNC] ASX Online quotes problem
> Message-ID:
>         <CACyLq=5gF+hykYQ5Egs=LdUOto=
> e9BdNpy1+U+-Fh7Zs4v9xUg at 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 <cleanoutmyshed at gmail.com> 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, <cleanoutmyshed at gmail.com
> > > <mailto:cleanoutmyshed at 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 <http://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 at gnucash.org <mailto:gnucash-user at gnucash.org>
> > >      > To update your subscription preferences or to unsubscribe:
> > >      > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > >     <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> > >      > If you are using Nabble or Gmane, please see
> > >     https://wiki.gnucash.org/wiki/Mailing_Lists
> > >     <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 at 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 231, Issue 73
> *********************************************
>
>

More information about the gnucash-user mailing list