[GNC] Stock & Mutual Fund Quotes Fail
Dan Nelms
dan99nelms at gmail.com
Sat Sep 8 16:20:54 EDT 2018
Ameet,
Your suggestion to edit the AlphaVantage.pm file worked great for me. I
have 13 securities, so I waited about 4 minutes, but I got quotes on all
the securities. Since I only do this a couple of times a week it will
work fine for me until Finance:Quote comes up with a better solution.
Thanks for posting this workaround!
Dan
On 9/8/2018 11:59 AM, Ameet Sengar wrote:
> Edit AlphaVantage.pm in your finance::quote folder. Eg. On my system
> C:\strawberry\perl\site\lib\Finance\Quote\AlphaVantage.pm
>
> I'm using fq-1.47.
>
> Add sleep(15) as the last line in the 'foreach' loop. This addresses what
> David has suggested below. It adds 15 seconds between each quote as
> AlphaVantage has asked free users to limit quotes to 4 per minute. If you
> have a lot of symbols, you will hate this suggestion but for a dozen it
> isn't terrible and remains cost effective.
>
> If you're new to this sort of thing, just open your file in a text editor (I
> use notepad++) and go down to the end. With sleep added, the last lines
> should now look like this:
>
> $quantity--;
> select(undef, undef, undef, .7) if ($quantity);
> sleep(15);
> }
> return wantarray() ? %info : \%info;
> }
>
> Best,
> Ameet
>
> -------------
>
> Hello,
>
> On September 1, 2018, at 2:59 AM, Rob <rg2junk at gmail.com
> <https://lists.gnucash.org/mailman/listinfo/gnucash-user> > wrote:
>
>> Hi All:
>> I've added multiple stocks and mutual funds into the security editor of
>> gnuCash. Using AlphaVantage, I have also tested the retrieval of quotes
>> using the command line tool gnc-fq-dump. I've noticed a few things:
>> 1. If I use the GUI to request price quotes, I get an error saying
>> "Unable to retrieve quotes for these items"
>> 2. Running gnuCash in debug mode doesn't give me any extra info
>> 3. If I check the quotes using gnc-fq-dump, I can request 4, but then
>> the quotes begin to fail - unless I wait 30 or seconds or so, at which
>> point I can suddenly request information on more stocks/funds.
>> So my question is "Is this a bug in Finance::Quote" or GnuCash?
>
> The answer is, "Neither." It is apparently a part of Alphavantage's API to
> limit the number of requests in a given time period. There are numerous
> discussions on the lists of this over the last several months. I believe
> that there is a newer version of Finance:: Quote that will attempt to work
> around this limitation (by spreading the requests out over time).
>
> David
>
>
>
> _______________________________________________
> 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.
More information about the gnucash-user
mailing list