FYI - 1.55 version of F::Q module is installed, which has the yahoo_json fix.
-Original Message-
From: Murugan Muruganandam
Sent: Monday, May 22, 2023 12:11 PM
To: Bob Atwell
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Finance::Quotes stopped working
before uninstalling perl, from
ou can download from
> >>> https://strawberryperl.com/
> >>>
> >>>
> >>>
> >>> Saludos Cordiales
> >>>
> >>>
> >>> Murugan
> >>> --
> >>> *From:* Bob Atwell
they must charge for it which is what is being referred to as premium
end-point.
-Original Message-
From: Murugan Muruganandam
Sent: Monday, May 22, 2023 10:51 AM
To: Bob Atwell ; gnucash-user@gnucash.org
Subject: Re: [GNC] Finance::Quotes stopped working
Bob
please detail your operating
ry perl you can download from
>>> https://strawberryperl.com/
>>>
>>>
>>>
>>> Saludos Cordiales
>>>
>>>
>>> Murugan
>>> --
>>> *From:* Bob Atwell
>>> *
- Program Features
>>
>> for the latest strawberry perl you can download from
>> https://strawberryperl.com/
>>
>>
>>
>> Saludos Cordiales
>>
>>
>> Murugan
>> ------
>> *From:* Bob Atwell
>> *Sent:* Monday,
ob Atwell
> *Sent:* Monday, May 22, 2023 11:55 AM
> *To:* Murugan Muruganandam
> *Cc:* gnucash-user@gnucash.org
> *Subject:* Re: [GNC] Finance::Quotes stopped working
>
> I am on Windows 11 and I think I will need to uninstall and reinstall
> Perl. What is the right proced
M
To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
mailto:gnucash-user@gnucash.org>>
Subject: [GNC] Finance::Quotes stopped working
A couple of weeks ago I started getting an error message when I tried to
get quotes. (Everything worked fine prior to that.)
After updating to
17 PM
> *To:* gnucash-user@gnucash.org
> *Subject:* [GNC] Finance::Quotes stopped working
>
> A couple of weeks ago I started getting an error message when I tried to
> get quotes. (Everything worked fine prior to that.)
> After updating to 5.1 I got the same o
@gnucash.org
Subject: [GNC] Finance::Quotes stopped working
A couple of weeks ago I started getting an error message when I tried to
get quotes. (Everything worked fine prior to that.)
After updating to 5.1 I got the same or similar message saying I needed an
AlphaVantage API
I got one and put
A couple of weeks ago I started getting an error message when I tried to
get quotes. (Everything worked fine prior to that.)
After updating to 5.1 I got the same or similar message saying I needed an
AlphaVantage API
I got one and put it into the preferences but then I got a different error
Thanks David,
I am a retired Physicist - so likely even further from solving this ;-(
My use is similar, trying to update quotes weekly - for now forcedly connecting
to my neighbors network..
Gnucash is phantastic SW and well maintained and supported (THANKS to John and
others !!!), even if so
Bruno,
I am a retired Electrical Engineer with no formal training in modern
programming languages but I am passionate about safe use of the Internet
and environmental stewardship. I also use GnuCash for personal financial
record keeping.
With that background I depend on the GnuCash developers
Thanks David,
Does the corresponding curl command work from your other computers as well?
Any suggestions what “coercing” involved in your case?
Best, Bruno
> On Apr 22, 2019, at 6:48 PM, David Carlson
> wrote:
>
> I too use ATT Uverse as my ISP and i know they do have some strange
>
I too use ATT Uverse as my ISP and i know they do have some strange
settings in their router, but the basic firewall and TCP port settings out
of the box are fine for most users without tinkering with pinholes or other
firewall settings. In my neighborhood they now set IPV6 as preferred
Wow, thanks all for your thoughts, although unfortunately this remains an
unsolved mystery to me!
Tools/"Price Editor"/"Get Quotes" still works smoothly when I disconnect the
ethernet cable to my router (standard ATT Uverse DSL router and configuration
with DNS 68.94.156.1 and ..157.1) and use
It doesn’t make any sense to me either. But curl works, perl doesn’t. What does
that perl script actually do when it tries to pull that URL?
Regards,
Adrien
> On Apr 13, 2019, at 9:17 AM, John Ralls wrote:
>
> The URL is given several times in the thread, it's http, port 80. That aside,
>
LWP apparently will also self report a 500 status if the connection
fails for any reason. The first suggestion would be to add lots of
debugging to the perl script to dump its internal state at various
points and also snoop on the connection.
I would also check to see if the malfunctioning
There must be something else going on that hasn't been found yet.
David Carlson
On Sat, Apr 13, 2019, 9:18 AM John Ralls wrote:
> The URL is given several times in the thread, it's http, port 80. That
> aside, get real: A firewall that blocks a port when perl's LWP is the agent
> but not when
The URL is given several times in the thread, it's http, port 80. That aside,
get real: A firewall that blocks a port when perl's LWP is the agent but not
when curl or a web browser is?
Besides, the request isn't blocked, it's munged so that Yahoo! returns a
500--server error response. So we
More likely a blocked port though since the OP said curl works to retrieve the
same URL, but not perl. A look at the perl script will probably expose the
issue.
Regards,
Adrien
> On Apr 13, 2019, at 4:29 AM, David Carlson
> wrote:
>
> A different router could also mean a different ISP, a
A different router could also mean a different ISP, a different DNS, and
that is just the starting point...
David Carlson
On Fri, Apr 12, 2019 at 11:58 PM Ronal B Morse wrote:
> Maybe a firewall configuration issue? Bruno's router might be blocking a
> required port where his neighbor's is
Maybe a firewall configuration issue? Bruno's router might be blocking a
required port where his neighbor's is not.
RBM
On 4/12/19 9:54 PM, John Ralls wrote:
Bruno,
That's weird. No, I can't think of anything associated with your mac's
networking config that would cause perl and only perl
Bruno,
That's weird. No, I can't think of anything associated with your mac's
networking config that would cause perl and only perl to fail when using your
router/modem and not your neighbors.
Regards,
John Ralls
> On Apr 12, 2019, at 8:35 PM, Bruno Acklin wrote:
>
> Hi John,
>
> Thanks,
Hi John,
Thanks, confirmed that it’s nothing to do with Perl and gnucash / financequote.
I connected to my neighbors Wifi and finance quote works like a charm. When I
go back through my router I times out again.
Any suggestion if it is a DNS or a TCP, or UDP poor I should look for and
Stockdump.pl isn't misinterpreting anything. You can pass it multiple symbols
and it prepends the symbol to each message so that you know which message goes
with which symbol.
It seems unlikely that it's a DNS issue, but you could take the laptop
somewhere where there's public wifi and try
John,
Thanks for your help and patience!
I did just that and updated Net::HTTP, as well as LWP, Date::Manip and
Finance::Quote again. All of them are confirmed up to date now.
But calling …/stockdump.pl still yields an "internal server error” 500:
Brunos-MacBook-Pro:~ backlin$
Bruno,
Please remember to copy the list on all replies.
Well, you upgrade Net::HTTP the same way as everything else,
sudo cpan -i Net::HTTP
You thought gnc-fq-dump but typed gnc-fq-helper. The latter works a bit
differently, expecting a scheme list on stdin rather than command line args:
Brian,
It points to something getting borked with perl. After all, Safari and curl
both successfully fetch the URI, so it's not a networking problem.
Date::Manip installed successfully, ergo ExtUtils::MakeMaker is now happy.
The Extras/5.18 folder where DateTime and LWP live is in
Hi John,
Sorry if I was unclear: the sudo cpan -i Finance::Quote install seemed to have
succeeded without error messages, but execution still fails as before.
I upgraded Xcode to 10.2 and there seems no longer an option to add command
line tools from Preferences.
My Library/Developer only
Bruno,
It turns out that Apple decided to put the perl headers exclusively in the
Xcode SDK but their perl patch doesn't quite work. Gory details may be read at
https://rt.cpan.org/Public/Bug/Display.html?id=127028.
The work-around in the last post to that bug, installing command-line tools
Hi John,
I was referring to MacHD/Library/Perl, so proceeded following your suggestions.
The rm commands worked.
Tried installing Date::Manip, as you suggested, which generated a long log
(attached in full), but seems to have failed for the following reasons (I
noticed):
'YAML' not installed,
Bruno,
No, there's no reason to install a fake-linux package manager.
You said "Library/Perl", does that mean /Users/backlin/Library/Perl or
/Library/Perl? It should be the latter. If it's the former, what's in
/Library/Perl?
Assuming that it *is* /Library/Perl, there are several packages
Hi John,
Sorry for the omission and delay.
No, I have none of these “fake-Linux package managers”(?) installed - should I?
The reply to backlin$ which perl is
/usr/bin/perl
In usr/bin I find two entries:
perl and
perl5.18
The directory Library/Perl contains
/5.18
Please remember to copy the list on all replies.
Curl and your browser working exonerates your router.
*Re*-installing perl would I think be challenging; it's provided as part of
MacOS so I'd think that the only safe way to do it would be to reinstall the OS.
That said, do you have any of the
No, Yahoo-JSON is a normal restful API over https, as you observed earlier with
your browser.
Do you get the http 500 error if you try
curl https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl
from the command line?
Regards,
John Ralls
> On Mar 22, 2019, at 11:47 AM, Bruno Acklin
Thanks John,
I deleted Library/Perl/Finance and reinstalled finance::quote using the sudo
command.
Installed ok, but no change on errors and messages.
The only change I made between finance::Quote running and now failing was
replacing my router from an old Apple TimeCapsule to a U-verse PACE
Probably not. What would change is the Perl version and consequently what
folders @INC points to, but that hasn't changed in the last 5 versions, it's
been 5.18 since Yosemite.
gnc-fq-dump doesn't use Date::Manip, but if your Date::Manip is broken it's
quite possible that your Finance::Quote
Hi John,
Thanks so much for all the work you do supporting us and your diligent test of
the Yahoo_json script!
I have restarted my Mac and Gnucash. The price quote keeps failing on my
desktop and laptop test systems.
I keep getting the 500 server error when I use the Terminal command:
Bruno,
I just tested, works fine for me:
$ Argus:/Users/john> gnc-fq-dump yahoo_json AAPL
Finance::Quote fields Gnucash uses:
symbol: AAPL <=== required
date: 03/20/2019 <=== recommended
currency: USD <=== required
last: 188.16
Hi John, et all,
I am adding to this string as I experience a similar, possibly related problem:
I am using Gnucash on OSX Mojave 10.14.3. Alphavantage never really worked for
me and importantly, crashed Gnucash instead of reporting stocks that could not
be retrieved.
Then in February I
> On Feb 20, 2019, at 7:06 AM, GB wrote:
>
> Thank you John Ralls, I think I've narrowed down the problem.
>
> I unchecked all of the securities that had source of "tsp" and I was able to
> get all the quotes from yahoo_json. Then I used a terminal window to run
> "./gnc-fq-dump -v tsp c"
Thank you John Ralls, I think I've narrowed down the problem.
I unchecked all of the securities that had source of "tsp" and I was able to
get all the quotes from yahoo_json. Then I used a terminal window to run
"./gnc-fq-dump -v tsp c" and received response of:
"No results found for stock C."
> On Feb 17, 2019, at 5:58 PM, GB wrote:
>
> Hello,
>
> I have two problems, one bigger than the other. I am running OSX Mojave
> (10.14.3) Dark which was upgraded about half a year ago
>
> F::Q stopped working for me, it worked last week and a couple days ago. No
> change to OSX, just
Hello,
I have two problems, one bigger than the other. I am running OSX Mojave
(10.14.3) Dark which was upgraded about half a year ago
F::Q stopped working for me, it worked last week and a couple days ago. No
change to OSX, just all of a sudden got this error: "There was an unknown
error
44 matches
Mail list logo
