Re: [GNC] Cannot retrieve quotes for some securities

2019-04-16 Thread wendiallen via gnucash-user
Renaming wperl.exe worked.  Thank you for the help.  Incidentally...  I tried
running exetype.bat (as an administrator), but I got an error concerning not
having permission to open perl.exe.  I'm guessing it was referring to
exetype not having the right privilege, but I didn't investigate further.  I
just switched to trying the renaming, which was successful.  Thanks again.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.


Re: [GNC] Cannot retrieve quotes for some securities

2019-04-16 Thread John Ralls



> On Apr 15, 2019, at 9:37 PM, wendiallen via gnucash-user 
>  wrote:
> 
> Yahoo as JSON works.  Thank you.  One related question...  Since installing
> the additional software for online quotes, a command window pops up for a
> few seconds when GnuCash starts, as well as when I click "get quotes."  It's
> quite annoying.  Is there any way to suppress it?

Unfortunately it's built in to the way Perl--or any other command-line 
executable--works on Windows. To fix it you need to change perl.exe's 
"subsystem type" from "console" to "windows".

I'm not sure if Strawberry Perl has the code for that; look in C:\Strawberry 
Perl\bin for either perlw.exe, wperl.exe, or exetype.bat. if either of the 
first two are present just rename perl.exe to cperl.exe and (e.g.) wperl.exe to 
perl.exe. If not but exetype.bat is, then run:
  exetype.bat perl.exe windows.

If there's no exetype.bat you can get an exetype.pl that will do the same thing 
from CPAN,
  https://metacpan.org/pod/distribution/perl/win32/bin/exetype.pl

Regards,
John Ralls

___
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.


Re: [GNC] Cannot retrieve quotes for some securities

2019-04-16 Thread Erik Colson


David T. via gnucash-user  writes:

> Alphavantage implemented limits on the number of quotes that can be retrieved 
> at a time. This was discussed some months back, with suggestions on different 
> remedies.
>
> Changing the source to "Yahoo as json" is one of those solutions. Editing the 
> perl in Finance::Quote to add a time delay was another. YMMV.

Or using Finance::Quote from the master branch on github where
Alphavantage module has been updated to follow limits imposed by the
site.

--
erik colson
___
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.


Re: [GNC] Cannot retrieve quotes for some securities

2019-04-15 Thread wendiallen via gnucash-user
Yahoo as JSON works.  Thank you.  One related question...  Since installing
the additional software for online quotes, a command window pops up for a
few seconds when GnuCash starts, as well as when I click "get quotes."  It's
quite annoying.  Is there any way to suppress it?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.


Re: [GNC] Cannot retrieve quotes for some securities

2019-04-15 Thread David T. via gnucash-user
Alphavantage implemented limits on the number of quotes that can be retrieved 
at a time. This was discussed some months back, with suggestions on different 
remedies. 

Changing the source to "Yahoo as json" is one of those solutions. Editing the 
perl in Finance::Quote to add a time delay was another. YMMV.
David

 
 
  On Tue, Apr 16, 2019 at 7:19, wendiallen via 
gnucash-user wrote:   GnuCash 3.5; Win10Pro64.  I've 
set up the scripts to get quotes from Alpha
Vantage, and edited my securities to "get online quotes."  Every time I
click "get quotes", I get a message that quotes for some of my securities
cannot be retrieved.  They are different each time, and the number varies
from most (~12) to only one or two.  Immediately re-clicking results in a
different subset of securities.  Can anyone assist with fixing this issue?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.
  
___
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.