[GNC] getting price quotes

Wed Nov 30 15:11:55 EST 2022

You should find some Finance Quote Perl scripts (gnc-fq-check/update/etc)
in "C:\Program Files (x86)\gnucash\bin". You can run these using Perl by
opening a command prompt and entering for example perl "C:\Program Files
(x86)\gnucash\bin\gnc-fq-check" - you need the quotes around the
C:\..........check as the path contains a space.  You can read all about it
at https://wiki.gnucash.org/wiki/Online_Quotes.  If your setup is good this
will display something along the following lines  including the version -
1.5301 in my case...

perl "C:\Program Files (x86)\gnucash\bin\gnc-fq-check"
("1.5301" "aex" "alphavantage" "amfiindia" "asegr" "asx" "aufunds"
"australia" "bamosz" "bet" "bloomberg" "bourso" "bse" "bseindia" "canada"
"canadamutual" "comdirect" "cse" "deka" "dutch" "dwsfunds" "europe"
"fetch_live_currencies" "fidelity" "fidelity_direct" "finanzpartner"
"fondsweb" "fool" "france" "ftfunds" "fundata" "fundlibrary" "goldmoney"
"greece" "hu" "hufund" "hungary" "hustock" "iexcloud" "india" "indiamutual"
"known_currencies" "morningstarau" "morningstarch" "morningstarjp"
"mstaruk" "nasdaq" "nseindia" "nyse" "nzx" "onvista" "oslobors" "romania"
"seb_funds" "six" "tesouro_direto" "tiaacref" "tmx" "tradeville"
"treasurydirect" "troweprice" "troweprice_direct" "tsp" "ukfunds"
"unionfunds" "usa" "yahoo_json" "za")

You can also run perl "C:\Program Files (x86)\gnucash\bin\gnc-fq-update" to
update your Finance Quote - this can take a few minutes, like 5 - 10, and
quite a bit of scrolling :-)

Check your perl version by running "perl -v" in a command prompt - eg...

perl -v

This is perl 5, version 32, subversion 1 (v5.32.1) built for
MSWin32-x86-multi-thread-64int

Copyright 1987-2021, Larry Wall

Perl may be copied only under the terms of either the Artistic License or
the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl".  If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.

You also mention you're running Gnucash 3.5 - this was released in April
2019 by the look of things so is well out of date and we are now up to 4.12
with lots of bug fixes and enhancements in that time so I suggest the first
thing you should be looking at is upgrading to the current version 4.12.
I'm not sure but you may have to download 4.0 first and install that before
you install 4.12 as from memory there were some significant changes in 4.0
and it takes a little while on first opening your gnucash file with this
version while it does things initially and can even look like it's hung? Do
a google search on "site:lists.gnucash.org upgrade" if you want to research
the upgrade details.

Cheers David H.

On Thu, 1 Dec 2022 at 02:08, aeg via gnucash-user <gnucash-user at gnucash.org>
wrote:

>  Hi Martin,
> Thank you for your very helpful response.
> I can confirm that I have a free Alpha Vantage API key setup in
> Preferences, which I assume is valid because when I tried to obtain a new
> one, (just in case that was the problem), Alpha Vantage confirmed that I
> already have one.
> I'm using OS Windows 10 and GnuCash version 3.5.I haven't been aware of a
> Finance::Quote version, and didn't know where to look for it, but I've just
> discovered that it's 1.47 and presumably the problem, as you've indicated.
> Is that something I can update separately, or will I have to update to the
> current GC version?
> The online quotes have previously been set to retrieve from Alphavantage,
> US, which worked without any hitches until early November (my last
> successful download was 4 November), so I guess that's around the time the
> rules changed. I've tried changing to Yahoo as JSON, but without success.
> Regards,Alan
>
>
>     On Wednesday, 30 November 2022 at 09:05:01 GMT, Martin Booth <
> mdj.booth at yahoo.co.uk> wrote:
>
>   Hi Alan,I am also UK based and you need to check the following.
> You have a valid free Alpha Vantage API key setup in preferences for
> on-line quotes
> You have the latest on-line stock retrieval at least Finance::Quote: 1.53
> otherwise your quotes will not download (this is probably the issue as
> Alpha Vantage changed the retrieval requirements and the F::Q needed an
> update.)
>
> Check you have set your on-line quotes to retrieve from Yahoo as JSON in
> Security Editor for stock quotes. This works fine for me.
>
> Then you should be fine.
> You did not say which OS you are running or the GNU Cash version with F::Q
> version, therefore depending upon OS the updates to F::Q are different.
> I hope this helps.
>
> regards,Martin
>
>     On Wednesday, 30 November 2022 at 08:40:48 GMT, aeg via gnucash-user <
> gnucash-user at gnucash.org> wrote:
>
>   It's interesting to note that Alpha Vantage is still recommended to
> GnuCash users and is available to some, as it stopped working for me a few
> weeks ago. When I contacted the Alpha Vantage Team, I was told that I
> needed to contribute to the premium plan, at a minimum cost of 49.99 USD
> per month, despite the fact that I've only been using the service once per
> week to retrieve 5 stock price updates. How are others still able to use
> the service free of charge?
> I'm based in the UK, so I'd be interested to know how other UK users
> obtain updates to their stock prices.
> Regards,AlanG
>
>
>
>
> Date: Mon, 28 Nov 2022 15:24:16 -0600
> From: R Losey <rlosey at gmail.com>
>
>
> Alphavantage is now the default, and you have to get a free ID to use the
> service (there is information regarding how to acquire an ID).
>
> Be aware, though -- Alphavantage adds a one-minute delay for each set of
> five stocks you update. (That is, five stocks will take seconds, but six
> stocks will take over a minute).
>
> I changed to what David suggested for my stock updates. I would prefer to
> have Multiple, but not use Alphavantage, but that doesn't seem to be an
> option at present.
>
>
> _______________________________________________
> 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
> -----
> 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 at 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.
>