Re: [GNC] getting price quotes
Hi Alan, To update F::Q on windows You would go to start menu and then to gnucash menu, in there you should find update online quotes, this will update F::Q However, I would recommend you update GC now to the latest version 4.12. regards, Martin On Wed, 2022-11-30 at 16:07 +, aeg 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 > 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 > 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 > > > 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@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@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.
Re: [GNC] getting price quotes
Interesting; I just attempted to set this up a few weeks ago... I went to their web site and signed up for the free ID code. Maybe they check the IP address and it is not available in the UK? I hope you will hear from others... On Wed, Nov 30, 2022 at 2:39 AM aeg via gnucash-user < gnucash-user@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 > > ___ 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.
Re: [GNC] getting price quotes
Hi David, Thank you for your detailed response, which is very helpful.I've tried updating the Finance::Quote as you suggested, but it appears that some prerequisites are missing, so I need to investigate how to install those, and will try again tomorrow if I have time. I've downloaded the latest version of Perl, and feeling my way with this. You're right when you say that I ought to upgrade GC to the latest version, and I would normally have done that routinely through the versions, but I experienced substantial interface changes when I upgraded from 2.6 to 3.5, which took a significant amount of time and effort to resolve, so I've feared further trauma with subsequent updates and resisted installing them while the software has been working well. I will update as soon as I find the time to deal with any undesirable consequences! Regards,Alan On Wednesday, 30 November 2022 at 20:12:08 GMT, David H wrote: 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. ___ 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.
Re: [GNC] getting price quotes
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 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.bo...@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@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 > neede
Re: [GNC] getting price quotes
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 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 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 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@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@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.
Re: [GNC] getting price quotes
I believe that AlphaVantage is the "default" simply because it is alphabetically first in the list. And it is included because it is still possible for users to use it, albeit with significant restrictions (that have been imposed after the original implementation). It is not wise to read significance into these circumstances. David T. On Nov 30, 2022, 11:40 AM, at 11:40 AM, aeg via gnucash-user 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 > > >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@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@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.
Re: [GNC] getting price quotes
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 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 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@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@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.
Re: [GNC] getting price quotes
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 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@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.
Re: [GNC] getting price quotes
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. On Mon, Nov 28, 2022 at 9:57 AM David Carlson wrote: > For securities traded on U. S. Exchanges it usually works well to use Yahoo > as JSON as your source. > > On Mon, Nov 28, 2022, 8:17 AM James Baxter via gnucash-user < > gnucash-user@gnucash.org> wrote: > > > When I go for the stock prices, I get a, Cant get stock prices. I when > to > > the where the stock/tickers are. As I edited three of them. As I notice > > they are going/looking at Alphavantage, US. so I did something wrong or > > not. > > ThanksJames baxterkangaro...@yahoo.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 > > - > > 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 > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- _ Richard Losey 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.
Re: [GNC] getting price quotes
For securities traded on U. S. Exchanges it usually works well to use Yahoo as JSON as your source. On Mon, Nov 28, 2022, 8:17 AM James Baxter via gnucash-user < gnucash-user@gnucash.org> wrote: > When I go for the stock prices, I get a, Cant get stock prices. I when to > the where the stock/tickers are. As I edited three of them. As I notice > they are going/looking at Alphavantage, US. so I did something wrong or > not. > ThanksJames baxterkangaro...@yahoo.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 > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] getting price quotes
When I go for the stock prices, I get a, Cant get stock prices. I when to the where the stock/tickers are. As I edited three of them. As I notice they are going/looking at Alphavantage, US. so I did something wrong or not. ThanksJames baxterkangaro...@yahoo.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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.