Hmmmm I think I may have just about run out of ideas.
If the GUI is just as slow as the CLI we have ruled that variable out.
Perhaps you could try using "Yahoo as JSON" as the Quote Source in the
Securities Editor. It won't take you very long to swap over your 18
securities, and this will eliminate Alpha Vantage as the cause, although
if gnc-fq-dump is fast then this is unlikely to make a difference.
As a last resort, you can try running GnuCash in debug mode and see if
anything useful emerges. I don't know how to do this, but Google is
probably your friend.
Good luck!
Geoff
=====
On 10/10/2022 3:48 pm, R Losey wrote:
I'm not fetching that many -- maybe around 18 or so (I didn't count). In
the "old" days from the GUI, it would only take seconds (that was
pre-Alpha Vantage)
I'm not sure how busy their servers are... but when I run the
gnc-fq-dump program using Alpha Vantage and getting four quotes, it
returns in 1-2 seconds. I ran the full gnucash-cli program using "time",
and it shows over 7 minutes to complete.
I doubt very much that my ISP is throttling me... I'm running Linux
(Ubuntu) and it is mostly idle.
Now the data file may be an idea... it's about 1.5M... it's on a NAS, so
it has to go through the home network, so that is slower... and I don't
know how much parsing the gnucash-cli program has to do.
The GnuCash GUI is also very, very slow using "multiple" (which uses
Alpha Vantage first). I didn't time it, but it was minutes.
I don't think this is network, but it may be... nothing else seems to be
slow... and the gnc-fq-dump is very fast.
On Sat, Oct 8, 2022 at 5:11 AM Geoff <cleanoutmys...@gmail.com
<mailto:cleanoutmys...@gmail.com>> wrote:
Hi Richard
Glad to hear you can now fetch prices.
> It is supposed to take so long? There is a long (7 minute) delay
before
> the update finishes... I've been using the gnucash-cli command line.
That does seem a long time, but how long is a piece of string? (as my
father used to say ;--)
How many prices are you fetching?
How busy are Alpha Vantage's servers?
Are Alpha Vantage throttling you?
Is your ISP throttling you?
How fast, and how busy, is your machine?
How long does it take to fetch a single price manually from the command
line?
How long does it take to open and save your GnuCash data file?
Have you tried using the GnuCash GUI instead of the gnucash-cli command
line?
As a benchmark, my 13 year old Windows 10 desktop consistently
retrieves
prices for 30 odd securities in about 3 seconds using the GnuCash GUI,
but in my case Finance Quote pulls them directly from the local stock
exchange and doesn't use Alpha Vantage.
I did a few command line tests for a single security using Alpha
Vantage
and it averages around 2.2 seconds from the other side of the world -
see attached screenshot.
[Technically it is slightly quicker than this which includes invoking
the Python interpreter to measure the elapsed time.]
Perhaps others on this list who do use Alpha Vantage can relate their
own experiences?
Finally, if you do know your way around Linux, Wire Shark is your go to
friend for network troubleshooting:
https://www.wireshark.org/ <https://www.wireshark.org/>
Good luck!
Regards
Geoff
=====
On 8/10/2022 6:29 pm, R Losey wrote:
> Hi... yes, I did not have al ALPHAVANTAGE_API_KEY and that was the
> issue. Things now seem to be updating properly.
>
> It is supposed to take so long? There is a long (7 minute) delay
before
> the update finishes... I've been using the gnucash-cli command line.
>
> On Sat, Oct 8, 2022 at 1:03 AM Geoff <cleanoutmys...@gmail.com
<mailto:cleanoutmys...@gmail.com>
> <mailto:cleanoutmys...@gmail.com
<mailto:cleanoutmys...@gmail.com>>> wrote:
>
> Hi Richard
>
> If you have configured your GnuCash securities to retrieve
their prices
> using AlphaVantage then you need to make sure that you have
entered
> your
> API Key in GnuCash preferences.
>
> Also, depending on the problem, it may help if you upgrade to
a later
> version of of Finance Quote:-
>
>
https://github.com/finance-quote/finance-quote/releases/tag/v1.53-rc.2
<https://github.com/finance-quote/finance-quote/releases/tag/v1.53-rc.2>
<https://github.com/finance-quote/finance-quote/releases/tag/v1.53-rc.2
<https://github.com/finance-quote/finance-quote/releases/tag/v1.53-rc.2>>
>
https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.52_02.tar.gz
<https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.52_02.tar.gz>
<https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.52_02.tar.gz
<https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.52_02.tar.gz>>
>
> Hope this helps.
>
> Regards
>
> Geoff
> =====
>
>
> On 8/10/2022 4:58 pm, R Losey wrote:
> > I just installed GnuCash on Ubuntu 22.04LTS (it is version 4.8
> from the
> > Ubuntu Software area).
> >
> > On a different Ubuntu, I had an older version running, and
back
> then, price
> > updates were working. I managed to mess up that gnucash Linux
> install, so I
> > haven't been updating quotes - I've been using GnuCash on
other
> operating
> > systems, and since it is a pain to get the quotes working
on them, I
> > haven't bothered.
> >
> > But now that I have a nice shiny Ubuntu, I have installed
gnucash and
> > thought I'd attempt to update prices. I merely get :
> >
> > "ERROR <gnc.scm> There was an unknown error while
retrieving the
> price
> >> quotes."
> >
> >
> > I have Finance::Quote version 1.51 - it was installed
along with
> GnuCash 4.8
> >
> > Notes:
> > - The reason I mentioned running updates some time ago (pre
> version 4.0, I
> > think) is that perhaps I need to do something in the
securities
> editor? I
> > think that I no longer own some of securities tagged to get
> updates, but I
> > wouldn't think that would be a problem...
> >
> > - I remember reading something about ALPHAVANTAGE_API_KEY
- the
> debug text
> > prints it as empty (for what that's worth)
> >
>
>
>
> --
> _________________________________
> Richard Losey
> rlo...@gmail.com <mailto:rlo...@gmail.com>
<mailto:rlo...@gmail.com <mailto:rlo...@gmail.com>>
> Micah 6:8
--
_________________________________
Richard Losey
rlo...@gmail.com <mailto:rlo...@gmail.com>
Micah 6:8
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
