gnucash-user Digest, Vol 176, Issue 6

Keith Myers keith.myers at att.net
Fri Nov 3 22:01:05 EDT 2017


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-request at gnucash.org" <gnucash-user-request at gnucash.org>
 To: gnucash-user at 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 at 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-request at gnucash.org

You can reach the person managing the list at
    gnucash-user-owner at 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 <dgpickett at aol.com>
To: gnucash-user at gnucash.org
Subject: Re: finance-quote error
Message-ID: <1509725319165-0.post at 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 <bradhaack at fastmail.us>
To: gnucash-user at gnucash.org
Subject: Re: finance-quote error
Message-ID: <22bc9e88-a1e9-b1a8-8aa1-8d0cb2060719 at 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.myers at att.net>
To: Geert Janssens <geert.gnucash at kobaltwit.be>
Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
Subject: Re: finance-quote error
Message-ID: <201865998.2251973.1509726852147 at 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.gnucash at kobaltwit.be>
 To: gnucash-user at gnucash.org 
Cc: Colin Law <clanlaw at gmail.com>; Keith Myers <keith.myers at 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.myers at 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 at 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" <maf at chilwell.net>
To: gnucash-user at gnucash.org, DGPickett <dgpickett at aol.com>
Subject: Re: finance-quote error
Message-ID: <1796471.fTKXXJ1oPI at 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 <dgpickett at aol.com>
To: maf at chilwell.net, gnucash-user at gnucash.org
Subject: Re: finance-quote error
Message-ID: <15f82d9086d-c10-3925 at 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 <maf at chilwell.net>
To: gnucash-user <gnucash-user at gnucash.org>; DGPickett <dgpickett at 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 <spalf0 at gmail.com>
To: gnucash-user at gnucash.org
Subject: Finance::Quote version 1.38, still can't fetch prices.
Message-ID: <7ca45c39-49c6-9488-48b1-8572793d1b6f at 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" <derek at ihtfp.com>
To: "tom" <spalf0 at gmail.com>
Cc: gnucash-user at gnucash.org
Subject: Re: Finance::Quote version 1.38, still can't fetch prices.
Message-ID:
    <c54b0af9c513c3b67e672cf6cfe45e2b.squirrel at 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 at 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
      derek at ihtfp.com            www.ihtfp.com
      Computer and Internet Security Consultant



------------------------------

Message: 8
Date: Fri, 3 Nov 2017 12:09:22 -0700
From: Tj Junior <tjjunior222 at gmail.com>
To: gnucash-user at gnucash.org
Subject: Categorized credit card spend report
Message-ID:
    <CAP35cT-xr5oNUL7yL3c6XvRc8539GgCV2aapimQ=m5WTJvK6PQ at 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.417 at gmail.com>
To: Derek Atkins <derek at ihtfp.com>
Cc: tom <spalf0 at gmail.com>, "gnucash-user at gnucash.org"
    <gnucash-user at gnucash.org>
Subject: Re: Finance::Quote version 1.38, still can't fetch prices.
Message-ID:
    <CADYgSbnk2SaxWRnWdOjMNRy24acw5B=HY8WvBKisfwc4zZ0WoQ at 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 <derek at 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 at 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
>        derek at ihtfp.com            www.ihtfp.com
>        Computer and Internet Security Consultant
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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" <maf at chilwell.net>
To: gnucash-user at gnucash.org
Cc: Tj Junior <tjjunior222 at gmail.com>
Subject: Re: Categorized credit card spend report
Message-ID: <4657672.1fot7RAIIP at 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 <tjjunior222 at gmail.com>
To: "Maf. King" <maf at chilwell.net>
Cc: gnucash-user at gnucash.org
Subject: Re: Categorized credit card spend report
Message-ID:
    <CAP35cT9mz=mWa01U8GWfYxH3hF6JXzzuxzgzjX83Uo8QfoLZjQ at 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 <maf at 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.lck at gmail.com>
To: Tj Junior <tjjunior222 at gmail.com>,  "gnucash-user at gnucash.org"
    <gnucash-user at gnucash.org>
Subject: RE: Categorized credit card spend report
Message-ID: <59fce9cb.1307620a.59c2e.f292 at 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 at 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 at 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: ? ?? <jctchen at outlook.com>
To: brad <bradhaack at fastmail.us>, "gnucash-user at gnucash.org"
    <gnucash-user at gnucash.org>
Subject: RE: finance-quote error
Message-ID:
    <CY4PR0601MB3716E7322C1A3E7AFA23D05FA1520 at 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.com at gnucash.org] On Behalf Of brad
Sent: Saturday, November 4, 2017 12:29 AM
To: gnucash-user at 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 at 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 at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user


------------------------------

End of gnucash-user Digest, Vol 176, Issue 6
********************************************


   


More information about the gnucash-user mailing list