Unfortunately, the Finance::Quote module is entirely broken by the Yahoo API
removal. There must be something about the Yahoo source that is mandatorily
required or hardwired into the module. You can change all your securities to
check alternate sources with none of them querying the Yahoo source and the
module still fails.
From: "gnucash-user-requ...@gnucash.org"
<gnucash-user-requ...@gnucash.org>
To: gnucash-user@gnucash.org
Sent: Friday, November 3, 2017 6:11 PM
Subject: gnucash-user Digest, Vol 176, Issue 6
Send gnucash-user mailing list submissions to
gnucash-user@gnucash.org
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
gnucash-user-requ...@gnucash.org
You can reach the person managing the list at
gnucash-user-ow...@gnucash.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of gnucash-user digest..."
Today's Topics:
1. Re: finance-quote error (DGPickett)
2. Re: finance-quote error (brad)
3. Re: finance-quote error (Keith Myers)
4. Re: finance-quote error (Maf. King)
5. Re: finance-quote error (David)
6. Finance::Quote version 1.38, still can't fetch prices. (tom)
7. Re: Finance::Quote version 1.38, still can't fetch prices.
(Derek Atkins)
8. Categorized credit card spend report (Tj Junior)
9. Re: Finance::Quote version 1.38, still can't fetch prices.
(David Carlson)
10. Re: Categorized credit card spend report (Maf. King)
11. Re: Categorized credit card spend report (Tj Junior)
12. RE: Categorized credit card spend report (Christopher Lam)
13. RE: finance-quote error (? ??)
----------------------------------------------------------------------
Message: 1
Date: Fri, 3 Nov 2017 09:08:39 -0700 (MST)
From: DGPickett <dgpick...@aol.com>
To: gnucash-user@gnucash.org
Subject: Re: finance-quote error
Message-ID: <1509725319165-0.p...@n4.nabble.com>
Content-Type: text/plain; charset=us-ascii
Yahoo sells advertising and provides quotes to their user community that
reads their ads. We must be missing some interface bit to say what our
yahoo email is. Someone in the development chain should investigate this at
Yahoo. Maybe they will relent until they can support such an id.
Quotes from other sources is fine, but what is the source. A lot of
companies sell this sort of data in various forms, so we need to be careful
before depending on a transient free source.
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
------------------------------
Message: 2
Date: Fri, 3 Nov 2017 10:29:01 -0600
From: brad <bradha...@fastmail.us>
To: gnucash-user@gnucash.org
Subject: Re: finance-quote error
Message-ID: <22bc9e88-a1e9-b1a8-8aa1-8d0cb2060...@fastmail.us>
Content-Type: text/plain; charset=utf-8; format=flowed
Running gnc-fq-check on the cmd line lists the sources that fq can use.?
I've tried a bunch of those sources, but none work.?? If anyone finds
one that works for US funds or stocks plz let us know.
I looked at the fq developers email list & they're aware of the problem,
one guy said that he'd look at it this weekend.? I wonder if google
finance might be an option?
On the yahoo forum someone found this, which doesn't directly solve our
problem:
https://www.vertex42.com/ExcelTemplates/excel-stock-quotes.html
------------------------------
Message: 3
Date: Fri, 3 Nov 2017 16:34:12 +0000 (UTC)
From: Keith Myers <keith.my...@att.net>
To: Geert Janssens <geert.gnuc...@kobaltwit.be>
Cc: "gnucash-user@gnucash.org" <gnucash-user@gnucash.org>
Subject: Re: finance-quote error
Message-ID: <201865998.2251973.1509726852...@mail.yahoo.com>
Content-Type: text/plain; charset=UTF-8
I understand that the loss of the Price::Quote module is only indirectly
related to what the Gnucash developers work on.? But the loss has now
diminished the Gnucash ability to function as a investment tracker.? The
product is now lesser in function than it has been historically.
I would think the developers would want to at least maintain its functions and
preferably keep improving on them. From: Geert Janssens
<geert.gnuc...@kobaltwit.be>
To: gnucash-user@gnucash.org
Cc: Colin Law <clan...@gmail.com>; Keith Myers <keith.my...@att.net>
Sent: Friday, November 3, 2017 2:18 AM
Subject: Re: finance-quote error
Op vrijdag 3 november 2017 09:56:24 CET schreef Colin Law:
> On 3 November 2017 at 04:46, Keith Myers <keith.my...@att.net> wrote:
> > Confused why the Price Quote worked up till Nov. 1 when all my Google
> > searches indicate the API was pulled back in July.? Why was it still
> > working till yesterday?
> >
> > What are the Gnucash developers going to do to remedy the problem?
>
> Remember that you have no inalienable right to expect the developers
> to do anything about it (or any right at all to expect that for that
> matter). They are all unpaid volunteers doing the work for the benefit
> of all of us and deserve our undying gratitude for their efforts.
>
> Colin
> _______________________________________________
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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.
While I understand this affects many gnucash users, it is not something that
can or should be solved in gnucash directly. Gnucash doesn't directly use the
Yahoo! service. Gnucash uses the finance::quote tool which manages several
price sources, one of which being Yahoo!.
I think we'll have to wait until the dust settles down before we can take
sensible action. Clearly the people accessing the service directly are
discussing with Yahoo! itself. I also don't know what finance::quote will
decide to do from here. Will they grab quotes from another service or not ?
This should all be cleared first IMO.
I'm sorry this brings such an inconvenience in the mean time.
Geert
------------------------------
Message: 4
Date: Fri, 03 Nov 2017 16:36:45 +0000
From: "Maf. King" <m...@chilwell.net>
To: gnucash-user@gnucash.org, DGPickett <dgpick...@aol.com>
Subject: Re: finance-quote error
Message-ID: <1796471.fTKXXJ1oPI@janus>
Content-Type: text/plain; charset="UTF-8"
On Friday, 3 November 2017 16:08:39 GMT DGPickett via gnucash-user wrote:
> Yahoo sells advertising and provides quotes to their user community that
> reads their ads. We must be missing some interface bit to say what our
> yahoo email is. Someone in the development chain should investigate this at
> Yahoo. Maybe they will relent until they can support such an id.
Hi,
it seems to me from reading around a bit, Yahoo! have completely disabled a
part of their service - even bits of the Yahoo! website that use the affected
API have been reportedly broken by this. Left hand & right hand at Yahoo!,
don't seem to know what each other is doing....
I know it doesn't seem this way when the program suddenly stops working, but
this is also fundamentally not a GC problem - in the sense that when a user
clicks to get a quote, an external tool is used, called Finance::Quote, which
grabs data from somewhere on the web (Yahoo isn't the only place that F::Q can
look, although it was a very good place), processes it and feeds it back to
GC. F::Q is used by many more projects than just GC.
The fix (if there is one) needs to be in the PERL Finance::Quote module, not GC
itself. Of course, all the users of GC (who seek external price info from
Yahoo!) are affected by this, me included. But there are others, too, who
don't use GC that do use F::Q, who are just as affected.
The issue has been reported on the F::Q list/forum, so the relevant
developers are in the loop.
What would be really nice of Yahoo! to do is give out some (any!) info about
the use-case they have taken exception to, which has led to this sudden
decision to cause many, many people some considerable frustration.
All told, I'm getting the service from Yahoo! that I paid for. :-(
I think, as Geert said earlier, once the dust has settled, IMHO, Erik & the
F::Q team will outline a plan eventually. In the meantime, as unfortunate as
it is, we are where we are, and a bit of level-headed patience is called for.
0.02
Maf.
------------------------------
Message: 5
Date: Fri, 3 Nov 2017 13:06:22 -0400
From: David <dgpick...@aol.com>
To: m...@chilwell.net, gnucash-user@gnucash.org
Subject: Re: finance-quote error
Message-ID: <15f82d9086d-c10-3...@webjas-vac113.srv.aolmail.net>
Content-Type: text/plain; charset=utf-8
Any F:Q gurus out there that can tell us a different place to go, how to swithc?
-----Original Message-----
From: Maf. King <m...@chilwell.net>
To: gnucash-user <gnucash-user@gnucash.org>; DGPickett <dgpick...@aol.com>
Sent: Fri, Nov 3, 2017 12:36 pm
Subject: Re: finance-quote error
On Friday, 3 November 2017 16:08:39 GMT DGPickett via gnucash-user wrote:
> Yahoo sells advertising and provides quotes to their user community that
> reads their ads. We must be missing some interface bit to say what our
> yahoo email is. Someone in the development chain should investigate this at
> Yahoo. Maybe they will relent until they can support such an id.
Hi,
....
I know it doesn't seem this way when the program suddenly stops working, but
this is also fundamentally not a GC problem - in the sense that when a user
clicks to get a quote, an external tool is used, called Finance::Quote, which
grabs data from somewhere on the web (Yahoo isn't the only place that F::Q can
look, although it was a very good place), processes it and feeds it back to
GC. F::Q is used by many more projects than just GC.
...
0.02
Maf.
------------------------------
Message: 6
Date: Fri, 3 Nov 2017 13:46:01 -0500
From: tom <spa...@gmail.com>
To: gnucash-user@gnucash.org
Subject: Finance::Quote version 1.38, still can't fetch prices.
Message-ID: <7ca45c39-49c6-9488-48b1-8572793d1...@gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Hello all,
I'm on Debian testing and had just recently updated my system, to which
I get the message:
"There was an unknown error while retrieving the price quotes"
$ gnucash --debug
Found Finance::Quote version 1.38
$ gnucash -v
GnuCash 2.6.15
This copy was built from rev 1ef17e6+ on 2016-12-21.
$gnc-fq-dump -v yahoo GILD
No results found for stock GILD.
$ gnc-fq-dump morningstar GILD
Finance::Quote fields Gnucash uses:
??? symbol: GILD (deduced)?????? <=== required
????? date: ** missing **??????? <=== recommended
? currency: ** missing **??????? <=== required
????? last:????????????????????? <=\
?????? nav:????????????????????? <=== one of these
???? price:????????????????????? <=/
? timezone:????????????????????? <=== optional
** This stock quote cannot be used by GnuCash!
Any advice for a fix would be much appreciated.
Thanks !
------------------------------
Message: 7
Date: Fri, 3 Nov 2017 14:51:02 -0400
From: "Derek Atkins" <de...@ihtfp.com>
To: "tom" <spa...@gmail.com>
Cc: gnucash-user@gnucash.org
Subject: Re: Finance::Quote version 1.38, still can't fetch prices.
Message-ID:
<c54b0af9c513c3b67e672cf6cfe45e2b.squir...@mail2.ihtfp.org>
Content-Type: text/plain;charset=utf-8
Hi,
This is a known error that just started 2 days ago when Yahoo discontinued
their quote service.
There is no current workaround except finding another quote source for
your stocks.
Moreover, this is an F::Q issue, not a gnucash issue.
Thanks,
-derek
On Fri, November 3, 2017 2:46 pm, tom wrote:
> Hello all,
>
> I'm on Debian testing and had just recently updated my system, to which
> I get the message:
> "There was an unknown error while retrieving the price quotes"
>
> $ gnucash --debug
> Found Finance::Quote version 1.38
>
> $ gnucash -v
> GnuCash 2.6.15
> This copy was built from rev 1ef17e6+ on 2016-12-21.
>
> $gnc-fq-dump -v yahoo GILD
> No results found for stock GILD.
>
> $ gnc-fq-dump morningstar GILD
> Finance::Quote fields Gnucash uses:
> ??? symbol: GILD (deduced)?????? <=== required
> ????? date: ** missing **??????? <=== recommended
> ? currency: ** missing **??????? <=== required
> ????? last:????????????????????? <=\
> ?????? nav:????????????????????? <=== one of these
> ???? price:????????????????????? <=/
> ? timezone:????????????????????? <=== optional
>
> ** This stock quote cannot be used by GnuCash!
>
> Any advice for a fix would be much appreciated.
>
> Thanks !
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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.
--
Derek Atkins 617-623-3745
de...@ihtfp.com www.ihtfp.com
Computer and Internet Security Consultant
------------------------------
Message: 8
Date: Fri, 3 Nov 2017 12:09:22 -0700
From: Tj Junior <tjjunior...@gmail.com>
To: gnucash-user@gnucash.org
Subject: Categorized credit card spend report
Message-ID:
<CAP35cT-xr5oNUL7yL3c6XvRc8539GgCV2aapimQ=m5wtjvk...@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
I always seem to have a difficult time figuring out which report to use.
For this instance, I'm looking to see what I've spent by category, but
restricted to just what's paid by a credit card. For instance, I want
groceries purchased on Visa rather than just all grocery purchases. So all
expenses that are in a specific liability account.
Current month
Visa:
* Groceries total spend
* Clothing total spend
* Restaurants total spend
etc
Mastercard:
* Groceries total spend
* Clothing total spend
* Restaurants total spend
Any suggestions? I've tried 10 different report options so far with no
luck. Thanks!
------------------------------
Message: 9
Date: Fri, 3 Nov 2017 14:19:08 -0500
From: David Carlson <david.carlson....@gmail.com>
To: Derek Atkins <de...@ihtfp.com>
Cc: tom <spa...@gmail.com>, "gnucash-user@gnucash.org"
<gnucash-user@gnucash.org>
Subject: Re: Finance::Quote version 1.38, still can't fetch prices.
Message-ID:
<CADYgSbnk2SaxWRnWdOjMNRy24acw5B=hy8wvbkisfwc4zz0...@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
If you check the other thread on this user maillist, you will find more
information.
In the meantime the simplest work-around is to log in to your favorite
finance website, get the prices that you need and manually enter them in to
GnuCash.
I am not happy about that either.
David C
On Fri, Nov 3, 2017 at 1:51 PM, Derek Atkins <de...@ihtfp.com> wrote:
> Hi,
> This is a known error that just started 2 days ago when Yahoo discontinued
> their quote service.
> There is no current workaround except finding another quote source for
> your stocks.
> Moreover, this is an F::Q issue, not a gnucash issue.
> Thanks,
>
> -derek
>
> On Fri, November 3, 2017 2:46 pm, tom wrote:
> > Hello all,
> >
> > I'm on Debian testing and had just recently updated my system, to which
> > I get the message:
> > "There was an unknown error while retrieving the price quotes"
> >
> > $ gnucash --debug
> > Found Finance::Quote version 1.38
> >
> > $ gnucash -v
> > GnuCash 2.6.15
> > This copy was built from rev 1ef17e6+ on 2016-12-21.
> >
> > $gnc-fq-dump -v yahoo GILD
> > No results found for stock GILD.
> >
> > $ gnc-fq-dump morningstar GILD
> > Finance::Quote fields Gnucash uses:
> > symbol: GILD (deduced) <=== required
> > date: ** missing ** <=== recommended
> > currency: ** missing ** <=== required
> > last: <=\
> > nav: <=== one of these
> > price: <=/
> > timezone: <=== optional
> >
> > ** This stock quote cannot be used by GnuCash!
> >
> > Any advice for a fix would be much appreciated.
> >
> > Thanks !
> >
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > 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.
>
>
> --
> Derek Atkins 617-623-3745
> de...@ihtfp.com www.ihtfp.com
> Computer and Internet Security Consultant
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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.
>
------------------------------
Message: 10
Date: Fri, 03 Nov 2017 20:06:34 +0000
From: "Maf. King" <m...@chilwell.net>
To: gnucash-user@gnucash.org
Cc: Tj Junior <tjjunior...@gmail.com>
Subject: Re: Categorized credit card spend report
Message-ID: <4657672.1fot7RAIIP@janus>
Content-Type: text/plain; charset="UTF-8"
On Friday, 3 November 2017 19:09:22 GMT Tj Junior wrote:
> I always seem to have a difficult time figuring out which report to use.
> For this instance, I'm looking to see what I've spent by category, but
> restricted to just what's paid by a credit card. For instance, I want
> groceries purchased on Visa rather than just all grocery purchases. So all
> expenses that are in a specific liability account.
>
> Current month
> Visa:
> * Groceries total spend
> * Clothing total spend
> * Restaurants total spend
> etc
> Mastercard:
> * Groceries total spend
> * Clothing total spend
> * Restaurants total spend
>
> Any suggestions? I've tried 10 different report options so far with no
> luck. Thanks!
Without looking at specific options, how about the Transaction report, run on
the CCard account and sorted using "Other Account" as the primary key?
might get close to waht you are after?
HTH,
Maf.
------------------------------
Message: 11
Date: Fri, 3 Nov 2017 13:58:18 -0700
From: Tj Junior <tjjunior...@gmail.com>
To: "Maf. King" <m...@chilwell.net>
Cc: gnucash-user@gnucash.org
Subject: Re: Categorized credit card spend report
Message-ID:
<CAP35cT9mz=mwa01u8gwfyxh3hf6jxzzuxzgzjx83uo8qfol...@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Took a bit of manipulating outside of gnucash, but that did the trick thank
you! I dumped the data table into excel, aggregated by month and by
account using some lookups and a pivot table, and got exactly what I
needed, thank you! I earn different cash back amounts on my credit cards
based on the category of spend, so wanted to match the gnucash data up
against the credit card summaries to see how closely they match.
On Fri, Nov 3, 2017 at 1:06 PM, Maf. King <m...@chilwell.net> wrote:
> On Friday, 3 November 2017 19:09:22 GMT Tj Junior wrote:
> > I always seem to have a difficult time figuring out which report to use.
> > For this instance, I'm looking to see what I've spent by category, but
> > restricted to just what's paid by a credit card. For instance, I want
> > groceries purchased on Visa rather than just all grocery purchases. So
> all
> > expenses that are in a specific liability account.
> >
> > Current month
> > Visa:
> > * Groceries total spend
> > * Clothing total spend
> > * Restaurants total spend
> > etc
> > Mastercard:
> > * Groceries total spend
> > * Clothing total spend
> > * Restaurants total spend
> >
> > Any suggestions? I've tried 10 different report options so far with no
> > luck. Thanks!
>
> Without looking at specific options, how about the Transaction report, run
> on
> the CCard account and sorted using "Other Account" as the primary key?
>
> might get close to waht you are after?
>
> HTH,
> Maf.
>
>
>
>
>
------------------------------
Message: 12
Date: Sat, 4 Nov 2017 06:12:42 +0800
From: Christopher Lam <christopher....@gmail.com>
To: Tj Junior <tjjunior...@gmail.com>, "gnucash-user@gnucash.org"
<gnucash-user@gnucash.org>
Subject: RE: Categorized credit card spend report
Message-ID: <59fce9cb.1307620a.59c2e.f...@mx.google.com>
Content-Type: text/plain; charset="utf-8"
The report you wish does exist. From transaction report:
Account/Account ? choose Expenses placeholder, click ?Select Children?
Account/Filter By... ? choose your creditcard(s) (either, or both)
Account/Filter Type ? include transactions to/from filter account
HTH
From: Tj Junior
Sent: Saturday, 4 November 2017 3:22 AM
To: gnucash-user@gnucash.org
Subject: Categorized credit card spend report
I always seem to have a difficult time figuring out which report to use.
For this instance, I'm looking to see what I've spent by category, but
restricted to just what's paid by a credit card. For instance, I want
groceries purchased on Visa rather than just all grocery purchases. So all
expenses that are in a specific liability account.
Current month
Visa:
* Groceries total spend
* Clothing total spend
* Restaurants total spend
etc
Mastercard:
* Groceries total spend
* Clothing total spend
* Restaurants total spend
Any suggestions? I've tried 10 different report options so far with no
luck. Thanks!
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
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.
------------------------------
Message: 13
Date: Sat, 4 Nov 2017 01:09:29 +0000
From: ? ?? <jctc...@outlook.com>
To: brad <bradha...@fastmail.us>, "gnucash-user@gnucash.org"
<gnucash-user@gnucash.org>
Subject: RE: finance-quote error
Message-ID:
<cy4pr0601mb3716e7322c1a3e7afa23d05fa1...@cy4pr0601mb3716.namprd06.prod.outlook.com>
Content-Type: text/plain; charset="utf-8"
For the mutual funds, source of "Morningstar, GB" is still working good to me.
But I tried lots of source options for my stocks, none is working now.
Hope it could be fixed soon...... thanks for F:Q team in advance.
jctchen
-----Original Message-----
From: gnucash-user
[mailto:gnucash-user-bounces+jctchen=outlook....@gnucash.org] On Behalf Of brad
Sent: Saturday, November 4, 2017 12:29 AM
To: gnucash-user@gnucash.org
Subject: Re: finance-quote error
Running gnc-fq-check on the cmd line lists the sources that fq can use. I've
tried a bunch of those sources, but none work.?? If anyone finds one that works
for US funds or stocks plz let us know.
I looked at the fq developers email list & they're aware of the problem, one
guy said that he'd look at it this weekend.? I wonder if google finance might
be an option?
On the yahoo forum someone found this, which doesn't directly solve our
problem:
https://www.vertex42.com/ExcelTemplates/excel-stock-quotes.html
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
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.
------------------------------
Subject: Digest Footer
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
------------------------------
End of gnucash-user Digest, Vol 176, Issue 6
********************************************
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
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.
