Sorry, Chris. I should have mentioned the OS, etc. I am running Linux
Mint 18.2 and GC 2.6.17.
If I understand, all I have to to do is reinstall F::Q?
Thanks,
Les
On 04/02/2018 07:00 PM, Chris Good wrote:
Message: 5
Date: Mon, 2 Apr 2018 17:59:28 -0500
From: Les <lellio...@gmail.com>
To: gnucash-user@gnucash.org
Subject: Re: Finance::Quote Yahoo_JSON Alpha Vantage
Message-ID: <2fde53e2-985e-0030-9b87-68b6f5f0f...@gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
I followed the instructions on adding modes for quote.pm and
alphavantage.pm as described.? However, I am no longer able to update
any my stocks now.? I have obviously done something wrong. Is there any
way to undo these modes and revert back to my previous files?
Thanks.
Les
On 04/01/2018 08:51 PM, Chris Good wrote:
Hi,
I have no problems using Yahoo_JSON as a quote source for my 16 stocks
for
which I download prices only weekly.
However, I have been working with another user and it seems Yahoo_JSON
fails
when there are many stocks and/or prices for them are requested often.
I suggest people who run into Yahoo _JSON problems use Alpha Vantage as
the
quote source.
See
https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3
F
Alpha Vantage purposefully fails quote requests if it detects a user
hogging
their web server resources by returning an Information message that
says:
Please consider optimizing your API call frequency
and pausing for approx. 20 seconds.
If you use Alpha Vantage, there have been mods made to Finance::Quote so
that usage complies with the Alpha Vantage recommendations that only 1
price
request per second is made in order to ensure that the webserver
resources
are shared amongst all users.
If the information message is detected for a particular stock (or
currency
conversion thanks Mike Alexander), then Finance::Quote also pauses for
20
seconds, then retries up to 4 times.
As this means you should not have to retry getting prices for all stocks
or
currencies if you have a failure, and this will minimise usage of the
Alpha
Vantage web server, I suggest people install the modified perl programs.
The modified Finance::Quote perl programs are currently not yet
incorporated
into the latest version of Finance::Quote (1.47), and as the
Finance::Quote
maintainers are, like everyone else, busy, it may be a long time (it has
been over a year in the past) before these mods are included in the next
release of Finance::Quote.
To install these mods without waiting for them to be incorporated in
Finance::Quote:
1. Make sure the standard Quote.pm and AlphaVantage.pm files are
writable.
For Windows 10 these files are usually:
C:\strawberry\perl\site\lib\Finance\Quote.pm
C:\strawberry\perl\site\lib\Finance\Quote\AlphaVantage.pm
Using File Manager, right click on the file, Properties, Untick 'Read
Only',
then OK
For Ubuntu Linux, these files are usually:
/usr/local/share/perl/5.22.1/Finance/Quote.pm
/usr/local/share/perl/5.22.1/Finance/Quote/AlphaVantage.pm
From a terminal:
cd /usr/local/share/perl/5.22.1/Finance
sudo chmod 666 Quote.pm Quote/AlphaVantage.pm
2. To install the modified Quote.pm:
Open
https://raw.githubusercontent.com/mtalexander/finance-
quote/6ee43ea08b504617
142139fda41ae45be865fa38/lib/Finance/Quote.pm
in a browser, click in the code, then use Control-A to highlight it
all,
then paste it into a text editor
(say Notepad for Windows, or gedit for Linux), then 'Save As' over the
top
of the existing
Quote.pm.
3. To install the modified AlphaVantage.pm:
Open
https://github.com/mtalexander/finance-
quote/blob/6ee43ea08b504617142139fda4
1ae45be865fa38/lib/Finance/Quote/AlphaVantage.pm
in a browser, click in the code, then use Control-A to highlight it
all,
then paste it into a text editor
(say Notepad for Windows, or gedit for Linux), then 'Save As' over the
top
of the existing
AlphaVantage.pm.
Sorry, I don't have a Mac so I cannot provide instructions.
If you want to check on the progress of the Pull Request to incorporate
these changes in Finance::Quote, please see:
https://github.com/finance-quote/finance-quote/pull/85
Regards, Chris Good
Hi Les,
Sorry you had problems following my instructions.
The quickest way to reinstall the standard files over the modified files is:
From a command prompt (Windows) or Terminal (Linux):
cpan
install Finance::Quote
quit
However, if you wish to tell me what your operating system is, and try to
run the gnc-fq-helper command as per
https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_fix_a_.22system_error.22_or_.2
2unknown_error.22_when_getting_stock_quotes.3F
and tell me the response, I will try to help you.
I.e.
Windows from a command prompt:
cd \Program Files\gnucash\bin
echo (yahoo "CSCO") | perl gnc-fq-helper
Linux, from a terminal:
echo '(yahoo "CSCO")' | gnc-fq-helper
Regards, Chris Good
_______________________________________________
gnucash-user mailing list
gnucash-user@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.
