RE: Unable to download stock quotes

[Chris Good]

Hi Steven,

 

Type into Google: how to run a command prompt

 

Sorry to seem unhelpful but the GnuCash Users email list is not the place to 
teach basic computer usage.

Google is your friend.. or perhaps you have a friend who is computer savvy?

 

Regards, Chris Good

 

From: Steven Anter  
Sent: Wednesday, 21 March 2018 3:43 PM
To: Chris Good 
Cc: gnucash-user@gnucash.org
Subject: RE: Unable to download stock quotes

 

How do I run the test from command prompt

___
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: Refund invoice

[DaveC49]

and 

https://www.gnucash.org/docs/v2.6/C/gnucash-help/busnss-ar-invoices1.html
David



-
David Cousens
--
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: Refund invoice

[DaveC49]

Check out 

https://wiki.gnucash.org/wiki/Credit_Notes

David



-
David Cousens
--
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: Export transactions to CSV

[GT-I9070 H]

 Stan Brown,

You can use XLSM2QIF to pass your xml file from GnuCash to MS Excel and
then export to CSV as you wish.

See: https://wiki.gnucash.org/wiki/Published_tools

Regards
GTI

2018-03-18 18:16 GMT-03:00 Adrien Monteleone :

> Unfortunately, you can only export one of those hierarchies at a time.
> (I’m not sure of the rhyme or reason for that)
>
> If you regularly need to read GnuCash data outside of GnuCash, might I
> suggest investigating either PiCash, or using one of the SQL backends.
>
> Regards,
> Adrien
>
> > On Mar 18, 2018, at 12:48 PM, Stan Brown 
> wrote:
> >
> > Good day!
> >
> > In the dialog for Export Transactions to CSV, I can't figure out how to
> > tell it to do transactions for all accounts. I had to go through the
> > whole dialog process four times, selecting accounts and re-selecting
> > dates and having my archived transactions split into four files.
> >
> > That's so obviously cumbersome that I must somehow just not be seeing
> > the way to export transactions for all accounts at once. Can some kind
> > person point out what I'm missing, please?  Thanks!
> >
> > --
> > Regards,
> > Stan Brown
> > Tompkins County, New York, USA
> > http://BrownMath.com
> > http://OakRoadSystems.com
> >
> > ___
> > 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.
___
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: Unable to download stock quotes

[Chris Good]

Hi Steven,

 

You don’t need to restart GnuCash.

Oh and of course now that I think about it, as you were previously using Yahoo 
JSON, you don’t need to change the Symbol suffixes.

As your stocks are US stocks, you don’t need to use any Symbol suffix, unless 
you need to use info from a non US exchange.

 

Don’t forget to do the test as per my email in the nabble link and check you 
don’t get any warnings, to ensure you have actually installed the fix properly.

 

Regards, Chris Good

 

From: Steven Anter  
Sent: Wednesday, 21 March 2018 12:55 PM
To: Chris Good 
Cc: gnucash-user@gnucash.org
Subject: Re: Unable to download stock quotes

 

Chris,

 

Just installed your patch. I'm running finance::quote to see if it works.  
Still slow. Did I need to restart gnucash after copying your code?

 


 

 

Virus-free.  

 www.avast.com 

 

On Tue, Mar 20, 2018 at 6:42 PM, Chris Good  > wrote:

Hi Steven,

 

Nabble is a web site (unrelated to GnuCash) that archives many mailing lists 
including GnuCash.

I included this link to Nabble:

http://gnucash.1415818.n4.nabble.com/Fix-for-yahoo-json-for-Windows-users-tt4697837.html
in a previous email to you as it includes instructions for getting and 
installing my fixed YahooJSON.pm.

I have found using links to Nabble to be an easy way of linking to previous 
GnuCash emails.

 

Regards, Chris Good

 

From: Steven Anter  > 
Sent: Wednesday, 21 March 2018 12:32 PM
To: Chris Good  >
Cc: gnucash-user@gnucash.org  
Subject: RE: Unable to download stock quotes

 

Chris,

I'm using Windows 10. What is nabble?

 

 

On Mar 20, 2018 6:18 PM, "Chris Good"  > wrote:

Hi Steven,

 

Are you using Windows? My fix only helps for Windows.

In Security Editor, Select Type of quote source  SingleYahoo as JSON

 

My fix hasn’t yet been incorporated into CPAN Finance::Quote so the only way to 
get it now is to follow instructions in the nabble link. That is the latest 
version.

 

You haven’t said from what exchange you are getting prices for, but similar to 
using suffix .AX on the symbol for Australian exchange, you will have to add 
the appropriate suffix to your Symbol if not US.

 

I see you haven’t copied gnucash-user@gnucash.org 
  on your reply.

I assume that is because you understandably didn’t want to share how many 
stocks you have with the world.

I would appreciate it if you share your experience with 
gnucash-user@gnucash.org   when it is 
resolved, however it turns out.

 

Regards, Chris Good

 

From: Steven Anter <  ante...@gmail.com> 
Sent: Wednesday, 21 March 2018 11:27 AM
To: Chris Good <  goodchri...@gmail.com>
Subject: Re: Unable to download stock quotes

 

Chris,

 

Yahoo JSON was working fine until recently.  Last time I tried it, it hung for 
a while then came back with a long list of securities it couldn't process. I'm 
trying to get quotes for about 50 tickers. 

 

How do I use  YahooJSON.pm?  It's not one of the listed sites, should I enter 
it manually as "unknown?"  How do I know I have your latest version?

 


 

 

Virus-free.  

 www.avast.com 

 

On Tue, Mar 20, 2018 at 4:31 PM, Chris Good  > wrote:

> Message: 5
> Date: Mon, 19 Mar 2018 20:56:40 -0700
> From: John Ralls  >
> To: santer  >
> Cc: gnucash-user@gnucash.org  
> Subject: Re: Unable to download stock quotes
> Message-ID:   >
> Content-Type: text/plain; charset=utf-8
>
> > On Mar 19, 2018, at 7:53 PM, santer  >  > wrote:
> >
> > The ability to download stock quotes has been a critical feature of
gnucash.
> > The yahoo resource stopped working over the last few months. A work
> > around for me has been yahoo json, which is now so slow it's unusable.
> >
> > Does anyone know if something is being done to resolve this problem.
> > What are some other work around options?
>
> The only general workaround besides 

Re: Unable to download stock quotes

[Steven Anter]

Chris,

Just installed your patch. I'm running finance::quote to see if it works.
Still slow. Did I need to restart gnucash after copying your code?


Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Tue, Mar 20, 2018 at 6:42 PM, Chris Good  wrote:

> Hi Steven,
>
>
>
> Nabble is a web site (unrelated to GnuCash) that archives many mailing
> lists including GnuCash.
>
> I included this link to Nabble:
>
> http://gnucash.1415818.n4.nabble.com/Fix-for-yahoo-json-
> for-Windows-users-tt4697837.html
> in a previous email to you as it includes instructions for getting and
> installing my fixed YahooJSON.pm.
>
> I have found using links to Nabble to be an easy way of linking to
> previous GnuCash emails.
>
>
>
> Regards, Chris Good
>
>
>
> *From:* Steven Anter 
> *Sent:* Wednesday, 21 March 2018 12:32 PM
> *To:* Chris Good 
> *Cc:* gnucash-user@gnucash.org
> *Subject:* RE: Unable to download stock quotes
>
>
>
> Chris,
>
> I'm using Windows 10. What is nabble?
>
>
>
>
>
> On Mar 20, 2018 6:18 PM, "Chris Good"  wrote:
>
> Hi Steven,
>
>
>
> Are you using Windows? My fix only helps for Windows.
>
> In Security Editor, Select Type of quote source  SingleYahoo as
> JSON
>
>
>
> My fix hasn’t yet been incorporated into CPAN Finance::Quote so the only
> way to get it now is to follow instructions in the nabble link. That is the
> latest version.
>
>
>
> You haven’t said from what exchange you are getting prices for, but
> similar to using suffix .AX on the symbol for Australian exchange, you will
> have to add the appropriate suffix to your Symbol if not US.
>
>
>
> I see you haven’t copied gnucash-user@gnucash.org on your reply.
>
> I assume that is because you understandably didn’t want to share how many
> stocks you have with the world.
>
> I would appreciate it if you share your experience with
> gnucash-user@gnucash.org when it is resolved, however it turns out.
>
>
>
> Regards, Chris Good
>
>
>
> *From:* Steven Anter 
> *Sent:* Wednesday, 21 March 2018 11:27 AM
> *To:* Chris Good 
> *Subject:* Re: Unable to download stock quotes
>
>
>
> Chris,
>
>
>
> Yahoo JSON was working fine until recently.  Last time I tried it, it hung
> for a while then came back with a long list of securities it couldn't
> process. I'm trying to get quotes for about 50 tickers.
>
>
>
> How do I use  YahooJSON.pm?  It's not one of the listed sites, should I
> enter it manually as "unknown?"  How do I know I have your latest version?
>
>
>
> [image:
> https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif]
> 
>
> Virus-free. www.avast.com
> 
>
>
>
> On Tue, Mar 20, 2018 at 4:31 PM, Chris Good  wrote:
>
> > Message: 5
> > Date: Mon, 19 Mar 2018 20:56:40 -0700
> > From: John Ralls 
> > To: santer 
> > Cc: gnucash-user@gnucash.org
> > Subject: Re: Unable to download stock quotes
> > Message-ID: 
> > Content-Type: text/plain; charset=utf-8
> >
> > > On Mar 19, 2018, at 7:53 PM, santer  wrote:
> > >
> > > The ability to download stock quotes has been a critical feature of
> gnucash.
> > > The yahoo resource stopped working over the last few months. A work
> > > around for me has been yahoo json, which is now so slow it's unusable.
> > >
> > > Does anyone know if something is being done to resolve this problem.
> > > What are some other work around options?
> >
> > The only general workaround besides yahoo-json that we know of is
> > Alphavantage, as explained at
> > https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3
> > F
> >  > 3F>. It is also quite slow compared to the former Yahoo! service.
> >
> > Another alternative might be Google Finance, but there?s some concern
> about
> > their terms of service vis-a-vis screen-scraping.
> >
> > GnuCash 3.0 includes a new importer for stock prices in CSV format. If
> you
> can
> > arrange to download quotes from a financial institution with which you do
> > business you may be able to format those downloads for import.
> >
> > Beyond that, we?re pretty much stuck. Neither we nor Erik Colson, the
> > maintainer of Finance::Quote, can do much about retrieving quotes without
> a
> > service to retrieve from.
> >
> > Regards,
> > John Ralls
>
> Hi Santer,
>
> I 

Re: Refund invoice

[Adrien Monteleone]

Same way you would an invoice, but when the new invoice dialog pops up, at the 
top there are radio buttons to choose between ‘invoice’ (default) or ‘credit 
memo’.

The rest works just like an invoice, however the debits and credit will be 
reversed in the final transaction so effectively subtracting the entered 
amounts as a type of ‘reversing’ transaction.

Read the Tutorial & Concepts Guide concerning Business Features for more info.

Regards,
Adrien

> On Mar 20, 2018, at 6:22 PM, Martijn Heuts  wrote:
> 
> Hello, I missed it! Thanks for the notification and reply.
> 
> How would I make that credit memo?
> 
> Thanks again!!
> 
> Martijn Heuts
> 
> 
> On Tue, 3/20/18, Adrien Monteleone  wrote:
> 
> Subject: Re: Refund invoice
> To: "Martijn Heuts" 
> Cc: "gnucash-user@gnucash.org" 
> Date: Tuesday, March 20, 2018, 3:57 PM
> 
> Martijn,
> 
> You posted this exact message on March 15th.
> 
> You received 2 replies. (one
> of them from me)
> 
> Did you
> not see them?
> 
> Note, many
> people do not reply back to the original author but only to
> the mailing list. This way, you don’t get 2 copies of the
> reply. (one directly and one from the list) Ideally, you
> should subscribe to the list so you see when people
> reply.
> 
> Here is a link to
> your original thread:  
> https://lists.gnucash.org/pipermail/gnucash-user/2018-March/075498.html
> 
> Click the “Next Message by
> Thread” link(s) at the top or bottom of each screen to
> advance to the next reply.
> 
> Let us know if these 2 options don’t answer
> your question.
> 
> 
> Regards,
> Adrien
> 
>> On Mar 20, 2018, at 10:27 AM, Martijn
> Heuts 
> wrote:
>> 
>> Hello, I
> am running GNU cash for my business.
>> I
> created and posted an invoice, which was paid in
> full.However a day later the client returns the item.The
> client also paid sales tax on this invoice.
>> What is the proper way to process this
> refund in GNU?I tried via the REFUND field which doesn't
> seem to process correctly.Also I need to make sure the sales
> tax is taken care of.
>> Please help.
> Thanks and I appreciate it!
>> Martijn heutsusadutch...@bellsouth.net
>> 
> ___
>> 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.

RE: Unable to download stock quotes

[Steven Anter]

I think most of my securities are with nyse.
Also nasdaq.

On Mar 20, 2018 6:18 PM, "Chris Good"  wrote:

> Hi Steven,
>
>
>
> Are you using Windows? My fix only helps for Windows.
>
> In Security Editor, Select Type of quote source  SingleYahoo as
> JSON
>
>
>
> My fix hasn’t yet been incorporated into CPAN Finance::Quote so the only
> way to get it now is to follow instructions in the nabble link. That is the
> latest version.
>
>
>
> You haven’t said from what exchange you are getting prices for, but
> similar to using suffix .AX on the symbol for Australian exchange, you will
> have to add the appropriate suffix to your Symbol if not US.
>
>
>
> I see you haven’t copied gnucash-user@gnucash.org on your reply.
>
> I assume that is because you understandably didn’t want to share how many
> stocks you have with the world.
>
> I would appreciate it if you share your experience with
> gnucash-user@gnucash.org when it is resolved, however it turns out.
>
>
>
> Regards, Chris Good
>
>
>
> *From:* Steven Anter 
> *Sent:* Wednesday, 21 March 2018 11:27 AM
> *To:* Chris Good 
> *Subject:* Re: Unable to download stock quotes
>
>
>
> Chris,
>
>
>
> Yahoo JSON was working fine until recently.  Last time I tried it, it hung
> for a while then came back with a long list of securities it couldn't
> process. I'm trying to get quotes for about 50 tickers.
>
>
>
> How do I use  YahooJSON.pm?  It's not one of the listed sites, should I
> enter it manually as "unknown?"  How do I know I have your latest version?
>
>
>
>
> 
>
> Virus-free. www.avast.com
> 
>
>
>
> On Tue, Mar 20, 2018 at 4:31 PM, Chris Good  wrote:
>
> > Message: 5
> > Date: Mon, 19 Mar 2018 20:56:40 -0700
> > From: John Ralls 
> > To: santer 
> > Cc: gnucash-user@gnucash.org
> > Subject: Re: Unable to download stock quotes
> > Message-ID: 
> > Content-Type: text/plain; charset=utf-8
> >
> > > On Mar 19, 2018, at 7:53 PM, santer  wrote:
> > >
> > > The ability to download stock quotes has been a critical feature of
> gnucash.
> > > The yahoo resource stopped working over the last few months. A work
> > > around for me has been yahoo json, which is now so slow it's unusable.
> > >
> > > Does anyone know if something is being done to resolve this problem.
> > > What are some other work around options?
> >
> > The only general workaround besides yahoo-json that we know of is
> > Alphavantage, as explained at
> > https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3
> > F
> >  > 3F>. It is also quite slow compared to the former Yahoo! service.
> >
> > Another alternative might be Google Finance, but there?s some concern
> about
> > their terms of service vis-a-vis screen-scraping.
> >
> > GnuCash 3.0 includes a new importer for stock prices in CSV format. If
> you
> can
> > arrange to download quotes from a financial institution with which you do
> > business you may be able to format those downloads for import.
> >
> > Beyond that, we?re pretty much stuck. Neither we nor Erik Colson, the
> > maintainer of Finance::Quote, can do much about retrieving quotes without
> a
> > service to retrieve from.
> >
> > Regards,
> > John Ralls
>
> Hi Santer,
>
> I don't think I have heard of Yahoo JSON being slow before.
> I just did a test and for my 16 stocks it took approx. 15 seconds.
> Is it just slow for you or does it actually hang?
> If you don't mind telling us, how many stocks do you have using Yahoo JSON?
>
> If you are using Windows, have you tried using my new YahooJSON.pm that has
> the warning messages fixed?
> See
> http://gnucash.1415818.n4.nabble.com/Fix-for-yahoo-json-
> for-Windows-users-tt
> 4697837.html
>
> Regards, Chris Good
>
>
>
___
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: Unable to download stock quotes

[Steven Anter]

Chris,
I'm using Windows 10. What is nabble?


On Mar 20, 2018 6:18 PM, "Chris Good"  wrote:

> Hi Steven,
>
>
>
> Are you using Windows? My fix only helps for Windows.
>
> In Security Editor, Select Type of quote source  SingleYahoo as
> JSON
>
>
>
> My fix hasn’t yet been incorporated into CPAN Finance::Quote so the only
> way to get it now is to follow instructions in the nabble link. That is the
> latest version.
>
>
>
> You haven’t said from what exchange you are getting prices for, but
> similar to using suffix .AX on the symbol for Australian exchange, you will
> have to add the appropriate suffix to your Symbol if not US.
>
>
>
> I see you haven’t copied gnucash-user@gnucash.org on your reply.
>
> I assume that is because you understandably didn’t want to share how many
> stocks you have with the world.
>
> I would appreciate it if you share your experience with
> gnucash-user@gnucash.org when it is resolved, however it turns out.
>
>
>
> Regards, Chris Good
>
>
>
> *From:* Steven Anter 
> *Sent:* Wednesday, 21 March 2018 11:27 AM
> *To:* Chris Good 
> *Subject:* Re: Unable to download stock quotes
>
>
>
> Chris,
>
>
>
> Yahoo JSON was working fine until recently.  Last time I tried it, it hung
> for a while then came back with a long list of securities it couldn't
> process. I'm trying to get quotes for about 50 tickers.
>
>
>
> How do I use  YahooJSON.pm?  It's not one of the listed sites, should I
> enter it manually as "unknown?"  How do I know I have your latest version?
>
>
>
>
> 
>
> Virus-free. www.avast.com
> 
>
>
>
> On Tue, Mar 20, 2018 at 4:31 PM, Chris Good  wrote:
>
> > Message: 5
> > Date: Mon, 19 Mar 2018 20:56:40 -0700
> > From: John Ralls 
> > To: santer 
> > Cc: gnucash-user@gnucash.org
> > Subject: Re: Unable to download stock quotes
> > Message-ID: 
> > Content-Type: text/plain; charset=utf-8
> >
> > > On Mar 19, 2018, at 7:53 PM, santer  wrote:
> > >
> > > The ability to download stock quotes has been a critical feature of
> gnucash.
> > > The yahoo resource stopped working over the last few months. A work
> > > around for me has been yahoo json, which is now so slow it's unusable.
> > >
> > > Does anyone know if something is being done to resolve this problem.
> > > What are some other work around options?
> >
> > The only general workaround besides yahoo-json that we know of is
> > Alphavantage, as explained at
> > https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3
> > F
> >  > 3F>. It is also quite slow compared to the former Yahoo! service.
> >
> > Another alternative might be Google Finance, but there?s some concern
> about
> > their terms of service vis-a-vis screen-scraping.
> >
> > GnuCash 3.0 includes a new importer for stock prices in CSV format. If
> you
> can
> > arrange to download quotes from a financial institution with which you do
> > business you may be able to format those downloads for import.
> >
> > Beyond that, we?re pretty much stuck. Neither we nor Erik Colson, the
> > maintainer of Finance::Quote, can do much about retrieving quotes without
> a
> > service to retrieve from.
> >
> > Regards,
> > John Ralls
>
> Hi Santer,
>
> I don't think I have heard of Yahoo JSON being slow before.
> I just did a test and for my 16 stocks it took approx. 15 seconds.
> Is it just slow for you or does it actually hang?
> If you don't mind telling us, how many stocks do you have using Yahoo JSON?
>
> If you are using Windows, have you tried using my new YahooJSON.pm that has
> the warning messages fixed?
> See
> http://gnucash.1415818.n4.nabble.com/Fix-for-yahoo-json-
> for-Windows-users-tt
> 4697837.html
>
> Regards, Chris Good
>
>
>
___
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: Unable to download stock quotes

[Chris Good]

> Message: 5
> Date: Mon, 19 Mar 2018 20:56:40 -0700
> From: John Ralls 
> To: santer 
> Cc: gnucash-user@gnucash.org
> Subject: Re: Unable to download stock quotes
> Message-ID: 
> Content-Type: text/plain; charset=utf-8
> 
> > On Mar 19, 2018, at 7:53 PM, santer  wrote:
> >
> > The ability to download stock quotes has been a critical feature of
gnucash.
> > The yahoo resource stopped working over the last few months. A work
> > around for me has been yahoo json, which is now so slow it's unusable.
> >
> > Does anyone know if something is being done to resolve this problem.
> > What are some other work around options?
> 
> The only general workaround besides yahoo-json that we know of is
> Alphavantage, as explained at
> https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3
> F
>  3F>. It is also quite slow compared to the former Yahoo! service.
> 
> Another alternative might be Google Finance, but there?s some concern
about
> their terms of service vis-a-vis screen-scraping.
> 
> GnuCash 3.0 includes a new importer for stock prices in CSV format. If you
can
> arrange to download quotes from a financial institution with which you do
> business you may be able to format those downloads for import.
> 
> Beyond that, we?re pretty much stuck. Neither we nor Erik Colson, the
> maintainer of Finance::Quote, can do much about retrieving quotes without
a
> service to retrieve from.
> 
> Regards,
> John Ralls

Hi Santer,

I don't think I have heard of Yahoo JSON being slow before.
I just did a test and for my 16 stocks it took approx. 15 seconds.
Is it just slow for you or does it actually hang?
If you don't mind telling us, how many stocks do you have using Yahoo JSON?

If you are using Windows, have you tried using my new YahooJSON.pm that has
the warning messages fixed?
See
http://gnucash.1415818.n4.nabble.com/Fix-for-yahoo-json-for-Windows-users-tt
4697837.html

Regards, Chris Good


___
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: Gnucash backends

[Colin Law]

On 20 March 2018 at 19:05, Jonathan Silvey  wrote:
> I have been using GnuCash on Linux Mint for several years. As they were
> getting full, I decided to start a new file and this has been running
> successfully for three weeks. When I try to run the old data, the relevant
> files are there but when I click on them, I get 'No suitable back-end found

That error may mean you are trying to open a file that is not a
gnucash accounts file.
What is the name of the file you are trying to open?  It will normally
be something.gnucash

Colin
___
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: Refund invoice

[Adrien Monteleone]

Martijn,

You posted this exact message on March 15th.

You received 2 replies. (one of them from me)

Did you not see them?

Note, many people do not reply back to the original author but only to the 
mailing list. This way, you don’t get 2 copies of the reply. (one directly and 
one from the list) Ideally, you should subscribe to the list so you see when 
people reply.

Here is a link to your original thread:  
https://lists.gnucash.org/pipermail/gnucash-user/2018-March/075498.html

Click the “Next Message by Thread” link(s) at the top or bottom of each screen 
to advance to the next reply.

Let us know if these 2 options don’t answer your question.


Regards,
Adrien

> On Mar 20, 2018, at 10:27 AM, Martijn Heuts  wrote:
> 
> Hello, I am running GNU cash for my business.
> I created and posted an invoice, which was paid in full.However a day later 
> the client returns the item.The client also paid sales tax on this invoice.
> What is the proper way to process this refund in GNU?I tried via the REFUND 
> field which doesn't seem to process correctly.Also I need to make sure the 
> sales tax is taken care of.
> Please help. Thanks and I appreciate it!
> Martijn heutsusadutch...@bellsouth.net
> ___
> 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.

Re: Gnucash backends

[David Carlson]

You must have made some other change in addition to using a new filename
when you started your new file.

No suitable  back end error usually means that the data file is not in the
expected format.  Gnucash expects an xml-like format or certain database
formats.  Database formats need corresponding database programs to read
them.

Read the FAQ about files for more info.

If this doesn't help come back with more details about the file format you
thought you were using, whether you are storing files in a different folder
and anything else that may seem significant.

David C

On Tue, Mar 20, 2018, 2:08 PM Jonathan Silvey 
wrote:

> I have been using GnuCash on Linux Mint for several years. As they were
> getting full, I decided to start a new file and this has been running
> successfully for three weeks. When I try to run the old data, the relevant
> files are there but when I click on them, I get 'No suitable back-end found
>  ...'
>
>   I can't find out on Google what a backend is and I don't know how to load
> a
>  file. Can you help, please?
>
>  Jonathan
> ___
> 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.

Gnucash backends

[Jonathan Silvey]

I have been using GnuCash on Linux Mint for several years. As they were
getting full, I decided to start a new file and this has been running
successfully for three weeks. When I try to run the old data, the relevant
files are there but when I click on them, I get 'No suitable back-end found
 ...'

  I can't find out on Google what a backend is and I don't know how to load
a
 file. Can you help, please?

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

Refund invoice

[Martijn Heuts]

Hello, I am running GNU cash for my business.
I created and posted an invoice, which was paid in full.However a day later the 
client returns the item.The client also paid sales tax on this invoice.
What is the proper way to process this refund in GNU?I tried via the REFUND 
field which doesn't seem to process correctly.Also I need to make sure the 
sales tax is taken care of.
Please help. Thanks and I appreciate it!
Martijn heutsusadutch...@bellsouth.net
___
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.