Re: [GNC] Reconcile also opens Interest Payment box?

2020-07-08 Thread jean laroche

There's a Preference for that under Register, Reconciling
Jean

On 7/8/2020 2:54 PM, lj wrote:

Using GnuCash-3.10 on Linux, self-compiled (soon to upgrade to 3.11)

For just one of my accounts, the following odd thing started happening 
this month. I open the register and click Reconcile.  The expected 
Reconcile Information dialog box opens, but on top of that I get an 
Interest Payment box. Why would this pop up over Reconcile? Why only for 
one account? It started this month. What did I do to cause this?


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


[GNC] Reconcile also opens Interest Payment box?

2020-07-08 Thread lj

Using GnuCash-3.10 on Linux, self-compiled (soon to upgrade to 3.11)

For just one of my accounts, the following odd thing started happening this 
month. I open the register and click Reconcile.  The expected Reconcile 
Information dialog box opens, but on top of that I get an Interest Payment 
box. Why would this pop up over Reconcile? Why only for one account? It 
started this month. What did I do to cause this?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Gnucash - user

2020-07-08 Thread flywire
I understand it is a word-picture.


The wheel is a big technological improvement to reduce the work of moving a
sled, a flat device for moving an irregularly shaped object across the
ground.
btw, almost no snow in Australia.

>> mailman3 would put wheels on the sled.
> >
> >I must admit I don't know exactly what you mean by this.  :-)
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] GnuCash list

2020-07-08 Thread Adrien Monteleone


> On Jul 8, 2020 w28d190, at 7:02 AM, Bruce Irving via gnucash-user 
>  wrote:
> 
> From: Robert Heller 
> 
> Most people in recent times are using a webmail client (eg GMail, Yahoo, AOL, 
> Hotmail, etc.), so they are reading E-Mail in a webbrowser, just as they 
> would 
> be reading postings in an actual webforum.  The idea of an "E-Mail List" as 
> something separate from a forum is actually foreign to these people.  And yes 
> many people would prefer a web-forum (not me -- I hate web forums and avoid 
> them whenever possible).
> 
> Thank you, Robert.  Yes, it is foreign to me.
> Unfortunately, I do not save the messages.  I needed to reinstall my OS and 
> all my applications.  They do offer gnucash version 1:2.6.19-1.  They also 
> offer flatpak which is currently 4.0-3.
> After reading the difficulties, I was going to wait until it smoothed out 
> before installing but, in this case, had no choice but to upgrade.  Now, I 
> have a couple of nits to pick:  
> 
> I started bookkeeping BC (before computer) so I'm familiar with debits and 
> credits.  Unfortunately. I couldn't find where to use formal accounting rules.


Preferences > Accounts > Labels > Use Formal Accounting Labels

The ‘rules’ of GnuCash are double-entry.

You still have to know how to structure your transactions though. It won’t do 
that for you. (the ‘business features’ can handle this somewhat)


>  I recently made an entry, (I work in the general ledger.) and, as usual 
> double checked it in the account register where it looked wrong.  So I 
> corrected it and looked at it in the other account where it again looked 
> wrong.  After 3 corrections, I finally realized the the accounts were 
> different from what I was used to.

What were you seeing that you think looked wrong and what are you used to?


> I had heard several express difficulty with column widths.  

The Help manual covers this. It is a matter of dragging the header separator as 
needed. For the moment, this has to be done per account, though Invoices/Bills 
can now (as of 4.0) have a layout ‘remembered’.


> I usually work with two or more windows open at once.  But now, GNC requires 
> me to use full screen.

No it does not. I don’t use it full screen. And while opening two instances 
with two different books side-by-side isn’t ‘usual’, it can be done. Each OS 
may be a bit different in how you accomplish it though. You can also specify 
Preferences > Register Defaults > Other Defaults > Register opens in a new 
window.


> In both of those cases, I had read there was a solution.  With a mailing 
> list, I can't browse through the previous posts to find the answers to my 
> issues.

There is an archive of the list here: 
https://lists.gnucash.org/pipermail/gnucash-user/

The search feature is currently broken, but you can use ’site:lists.gnucash.org 
search terms’ in your favorite search engine to search only the mailing list 
server for ’search terms’

Regards,
Adrien
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Gnucash - user

2020-07-08 Thread David T. via gnucash-user
I think it means that GnuCash-user will ride on highways as well 
as it runs on ski slopes. 


On 7/8/2020 11:01 AM, Derek Atkins wrote:

flywire  writes:


This will change when (if) we migrate to mailman3, which includes the
"hyperkitty" forum-like interface, but at this point in time we do not
have a timeline for when this will happen.

mailman3 would put wheels on the sled.

I must admit I don't know exactly what you mean by this.  :-)


Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

-derek


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Gnucash - user

2020-07-08 Thread Derek Atkins
flywire  writes:

>> This will change when (if) we migrate to mailman3, which includes the
>> "hyperkitty" forum-like interface, but at this point in time we do not
>> have a timeline for when this will happen.
>
> mailman3 would put wheels on the sled.

I must admit I don't know exactly what you mean by this.  :-)

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Gnucash - user: Google result

2020-07-08 Thread Derek Atkins
Adrien Monteleone  writes:

> Maybe so!
>
> Maybe retitle the Mailman page that way?

That would be harder to do and maintain over system upgrades.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] 'entries' table content - link with taxtables

2020-07-08 Thread Derek Atkins
"finf...@gmail.com"  writes:

> Hello All,
>
> Is it normal that there is a link to taxtable
> entries(entries.b_taxtable = taxtables.guid) instead of NULL in
> invoice entries which are not taxable?
>
> It makes a lot of confusions when building SQL queries...

If you have a default taxtable set then yes.
If the "taxable" flag isn't set then it's not used.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] GnuCash list

2020-07-08 Thread Michael or Penny Novack

On 7/8/2020 8:02 AM, Bruce Irving via gnucash-user wrote:

From: Robert Heller 

Most people in recent times are using a webmail client (eg GMail, Yahoo, AOL,
Hotmail, etc.), so they are reading E-Mail in a webbrowser, just as they would
be reading postings in an actual webforum.  The idea of an "E-Mail List" as
something separate from a forum is actually foreign to these people.  And yes
many people would prefer a web-forum (not me -- I hate web forums and avoid
them whenever possible).


However -- I belong to a number of forums. They are all structured (at 
least the ones to which I belong). Depending on the the webmail client, 
it might be possible to have some structure, write rules to send 
incoming mail from an elist to a dedicated subfolder so not just in 
inbox. But further separation by topic as would be in a forum? So I 
would consider forums quite different and question the actual experience 
(with forums) of any users who would find elist => webmail at all similar.


A forum (instead of elist) might be an idea. Many forum clients allow 
users to set notification by email when a topic has a new posting.


Michael D Novack



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] GnuCash list

2020-07-08 Thread Bruce Irving via gnucash-user
From: Robert Heller 

Most people in recent times are using a webmail client (eg GMail, Yahoo, AOL, 
Hotmail, etc.), so they are reading E-Mail in a webbrowser, just as they would 
be reading postings in an actual webforum.  The idea of an "E-Mail List" as 
something separate from a forum is actually foreign to these people.  And yes 
many people would prefer a web-forum (not me -- I hate web forums and avoid 
them whenever possible).

Thank you, Robert.  Yes, it is foreign to me.
Unfortunately, I do not save the messages.  I needed to reinstall my OS and all 
my applications.  They do offer gnucash version 1:2.6.19-1.  They also offer 
flatpak which is currently 4.0-3.
After reading the difficulties, I was going to wait until it smoothed out 
before installing but, in this case, had no choice but to upgrade.  Now, I have 
a couple of nits to pick:  

I started bookkeeping BC (before computer) so I'm familiar with debits and 
credits.  Unfortunately. I couldn't find where to use formal accounting rules.  
I recently made an entry, (I work in the general ledger.) and, as usual double 
checked it in the account register where it looked wrong.  So I corrected it 
and looked at it in the other account where it again looked wrong.  After 3 
corrections, I finally realized the the accounts were different from what I was 
used to.
I had heard several express difficulty with column widths.  I usually work with 
two or more windows open at once.  But now, GNC requires me to use full screen.
In both of those cases, I had read there was a solution.  With a mailing list, 
I can't browse through the previous posts to find the answers to my issues.
The first post in this collection referred to Gmane.  I'll install Thunderbird 
and see if I can figure out how to find it.
Thank you to all of you that work on this project.  It is awesome.
Bruce


Bruce
 Preach the Gospel wherever you go.
 If necessary, use words.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Alpha Vantage problems

2020-07-08 Thread Robert Dean

Hi Chris,

Lloyds Bank (LLOY.L) and Banco Santander (BNC.L). Neither have worked 
since 24th June and didn't as of 5 minutes ago.


Regards,
Bob Dean

On 08/07/2020 09:12, Chris Good wrote:

Hi Bob,

Good to know. Can you give an example of a stock and the symbol you used
that used to work please?

Regards, Chris Good

Message: 9
Date: Tue, 7 Jul 2020 13:06:11 +0100
From: Robert Dean 
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Alpha Vantage problems
Message-ID:

Content-Type: text/plain; charset=utf-8; format=flowed

Hi,

I have also lost access to Alphavantage stocks on LSE. It last worked on
24 June, but failed on the 25th. I have checked both my stocks with
gnc-fq-dump and neither work, so I have changed to Yahoo-json.

I'm using Gnucash 3.10 on Fedora 32.

Regards
Bob Dean

On 07/07/2020 12:01, Chris Good wrote:

Hi Adrian, how are you getting quotes from excel? Have you got your
alphavantage API key specified in GnuCash preferences?

I suggest the next stage would be to test each of the stocks you want
to use Alphavantage for, with gnc-fq-dump.

Regards, Chris Good

On Tue., 7 Jul. 2020, 7:39 pm Adrian Holbrook,

wrote:


Thanks Chris, I think my installation of Finance;;Quote is working
fine as I get quotes from other sources such as Morningstar and Yahoo
JSON without any problem. I think it must be an Alphavantage problem
and the next stage is to try and get quotes using excel and see if
that works.  In the short term I have changed my source to Yahoo JSON
and that is working. I would just like to be able to get Alphavantage
working as well so that if one fails I have a backup source.

Regards

Adrian



On Tue, Jul 7, 2020 at 9:10 AM Chris Good  wrote:


Message: 3
Date: Tue, 7 Jul 2020 07:58:33 +0100
From: Adrian Holbrook 
To: gnucash-user@gnucash.org
Subject: [GNC] Alpha Vantage problems
Message-ID:
  
Content-Type: text/plain; charset="UTF-8"

I have been using Alphvantage for about a year now to get quotes
without any problems - I had to add in the 15 second delay that was
suggested to stop it failing - but since then it has been 100%
reliable. I normally download around 50 prices at a time about once
a week. The last successful download was on June 12th and since then
all attempts have failed.

All my shares are on the LSE. I have not checked trying to get
quotes from NYSE but that would be my next test.
I am using Gnucash 4.0 and Finance::Quote 1.49

Regards

Adrian

Hi Adrian,

Please follow instructions at
https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting

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: [GNC] Alpha Vantage problems

2020-07-08 Thread Adrian Holbrook
I have a list of about 50 stocks that used to work and do not work now - a
small selection

AAL.L
AV.L
AZN.L
BATS.L
BBY.L
BDEV.L
BEZ.L
BILN.L
BKG.L
BME.L
BP.L
BRBY.L
BT-A.L
BVIC.L
BWY.L

Regards

Adrian
Adrian Holbrook
Tel: +44 (0)1564 230038
Mob: +44 (0)777 238 3299
Skype: megagrumpy
Web: www.megagrumpy.com
email: adrian.holbr...@gmail.com


On Wed, Jul 8, 2020 at 9:12 AM Chris Good  wrote:

> Hi Bob,
>
> Good to know. Can you give an example of a stock and the symbol you used
> that used to work please?
>
> Regards, Chris Good
>
> Message: 9
> Date: Tue, 7 Jul 2020 13:06:11 +0100
> From: Robert Dean 
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Alpha Vantage problems
> Message-ID:
> 
> Content-Type: text/plain; charset=utf-8; format=flowed
>
> Hi,
>
> I have also lost access to Alphavantage stocks on LSE. It last worked on
> 24 June, but failed on the 25th. I have checked both my stocks with
> gnc-fq-dump and neither work, so I have changed to Yahoo-json.
>
> I'm using Gnucash 3.10 on Fedora 32.
>
> Regards
> Bob Dean
>
> On 07/07/2020 12:01, Chris Good wrote:
> > Hi Adrian, how are you getting quotes from excel? Have you got your
> > alphavantage API key specified in GnuCash preferences?
> >
> > I suggest the next stage would be to test each of the stocks you want
> > to use Alphavantage for, with gnc-fq-dump.
> >
> > Regards, Chris Good
> >
> > On Tue., 7 Jul. 2020, 7:39 pm Adrian Holbrook,
> > 
> > wrote:
> >
> >> Thanks Chris, I think my installation of Finance;;Quote is working
> >> fine as I get quotes from other sources such as Morningstar and Yahoo
> >> JSON without any problem. I think it must be an Alphavantage problem
> >> and the next stage is to try and get quotes using excel and see if
> >> that works.  In the short term I have changed my source to Yahoo JSON
> >> and that is working. I would just like to be able to get Alphavantage
> >> working as well so that if one fails I have a backup source.
> >>
> >> Regards
> >>
> >> Adrian
> >>
> >>
> >>
> >> On Tue, Jul 7, 2020 at 9:10 AM Chris Good 
> wrote:
> >>
> >>> Message: 3
> >>> Date: Tue, 7 Jul 2020 07:58:33 +0100
> >>> From: Adrian Holbrook 
> >>> To: gnucash-user@gnucash.org
> >>> Subject: [GNC] Alpha Vantage problems
> >>> Message-ID:
> >>>   >>> a...@mail.gmail.com>
> >>> Content-Type: text/plain; charset="UTF-8"
> >>>
> >>> I have been using Alphvantage for about a year now to get quotes
> >>> without any problems - I had to add in the 15 second delay that was
> >>> suggested to stop it failing - but since then it has been 100%
> >>> reliable. I normally download around 50 prices at a time about once
> >>> a week. The last successful download was on June 12th and since then
> >>> all attempts have failed.
> >>>
> >>> All my shares are on the LSE. I have not checked trying to get
> >>> quotes from NYSE but that would be my next test.
> >>> I am using Gnucash 4.0 and Finance::Quote 1.49
> >>>
> >>> Regards
> >>>
> >>> Adrian
> >>>
> >>> Hi Adrian,
> >>>
> >>> Please follow instructions at
> >>> https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting
> >>>
> >>> 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: [GNC] Alpha Vantage problems

2020-07-08 Thread Chris Good
Hi Bob,

Good to know. Can you give an example of a stock and the symbol you used
that used to work please?

Regards, Chris Good

Message: 9
Date: Tue, 7 Jul 2020 13:06:11 +0100
From: Robert Dean 
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Alpha Vantage problems
Message-ID:

Content-Type: text/plain; charset=utf-8; format=flowed

Hi,

I have also lost access to Alphavantage stocks on LSE. It last worked on
24 June, but failed on the 25th. I have checked both my stocks with
gnc-fq-dump and neither work, so I have changed to Yahoo-json.

I'm using Gnucash 3.10 on Fedora 32.

Regards
Bob Dean

On 07/07/2020 12:01, Chris Good wrote:
> Hi Adrian, how are you getting quotes from excel? Have you got your 
> alphavantage API key specified in GnuCash preferences?
> 
> I suggest the next stage would be to test each of the stocks you want 
> to use Alphavantage for, with gnc-fq-dump.
> 
> Regards, Chris Good
> 
> On Tue., 7 Jul. 2020, 7:39 pm Adrian Holbrook, 
> 
> wrote:
> 
>> Thanks Chris, I think my installation of Finance;;Quote is working 
>> fine as I get quotes from other sources such as Morningstar and Yahoo 
>> JSON without any problem. I think it must be an Alphavantage problem 
>> and the next stage is to try and get quotes using excel and see if 
>> that works.  In the short term I have changed my source to Yahoo JSON 
>> and that is working. I would just like to be able to get Alphavantage 
>> working as well so that if one fails I have a backup source.
>>
>> Regards
>>
>> Adrian
>>
>>
>>
>> On Tue, Jul 7, 2020 at 9:10 AM Chris Good  wrote:
>>
>>> Message: 3
>>> Date: Tue, 7 Jul 2020 07:58:33 +0100
>>> From: Adrian Holbrook 
>>> To: gnucash-user@gnucash.org
>>> Subject: [GNC] Alpha Vantage problems
>>> Message-ID:
>>>  >> a...@mail.gmail.com>
>>> Content-Type: text/plain; charset="UTF-8"
>>>
>>> I have been using Alphvantage for about a year now to get quotes 
>>> without any problems - I had to add in the 15 second delay that was 
>>> suggested to stop it failing - but since then it has been 100% 
>>> reliable. I normally download around 50 prices at a time about once 
>>> a week. The last successful download was on June 12th and since then 
>>> all attempts have failed.
>>>
>>> All my shares are on the LSE. I have not checked trying to get 
>>> quotes from NYSE but that would be my next test.
>>> I am using Gnucash 4.0 and Finance::Quote 1.49
>>>
>>> Regards
>>>
>>> Adrian
>>>
>>> Hi Adrian,
>>>
>>> Please follow instructions at
>>> https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting
>>>
>>> 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: [GNC] Alpha Vantage problems

2020-07-08 Thread Chris Good
Hi Adrian,

I'm afraid I have no idea if AlphaVantage can now or has ever been able to
supply prices for stocks on the London Stock Exchange. It would be good to
know an example stock?

Maybe some-one else can help?
I have never been able to figure out a way to get prices for stocks on the
Australian Stock Exchange either.
Using the yahoo_json .AX suffix doesn't seem to work for AlphaVantage.

If there is a way to do either of these things, it would be good to know and
I could document it in the wiki.

Regards, Chris Good

Message: 11
Date: Tue, 7 Jul 2020 14:58:27 +0100
From: Adrian Holbrook 
To: Chris Good 
Cc: GnuCash User Mailing List 
Subject: Re: [GNC] Alpha Vantage problems
Message-ID:

Content-Type: text/plain; charset="UTF-8"

Thanks fo the advice. I was going to download the alpphvantage addon for
Excel but instead used gnc-fq-dump. I can get all the NYSE stocks but
nothing off the LSE using the suffix .L. Fails every time;.


Adrian


On Tue, Jul 7, 2020 at 12:01 PM Chris Good  wrote:

> Hi Adrian, how are you getting quotes from excel? Have you got your 
> alphavantage API key specified in GnuCash preferences?
>
> I suggest the next stage would be to test each of the stocks you want 
> to use Alphavantage for, with gnc-fq-dump.
>
> Regards, Chris Good
>
> On Tue., 7 Jul. 2020, 7:39 pm Adrian Holbrook, 
> 
> wrote:
>
>> Thanks Chris, I think my installation of Finance;;Quote is working 
>> fine as I get quotes from other sources such as Morningstar and Yahoo 
>> JSON without any problem. I think it must be an Alphavantage problem 
>> and the next stage is to try and get quotes using excel and see if 
>> that works.  In the short term I have changed my source to Yahoo JSON and
that is working.
>> I would just like to be able to get Alphavantage working as well so 
>> that if one fails I have a backup source.
>>
>> Regards
>>
>> Adrian
>>
>>
>>
>> On Tue, Jul 7, 2020 at 9:10 AM Chris Good  wrote:
>>
>>> Message: 3
>>> Date: Tue, 7 Jul 2020 07:58:33 +0100
>>> From: Adrian Holbrook 
>>> To: gnucash-user@gnucash.org
>>> Subject: [GNC] Alpha Vantage problems
>>> Message-ID:
>>> >> a...@mail.gmail.com>
>>> Content-Type: text/plain; charset="UTF-8"
>>>
>>> I have been using Alphvantage for about a year now to get quotes 
>>> without any problems - I had to add in the 15 second delay that was 
>>> suggested to stop it failing - but since then it has been 100% 
>>> reliable. I normally download around 50 prices at a time about once 
>>> a week. The last successful download was on June 12th and since then 
>>> all attempts have failed.
>>>
>>> All my shares are on the LSE. I have not checked trying to get 
>>> quotes from NYSE but that would be my next test.
>>> I am using Gnucash 4.0 and Finance::Quote 1.49
>>>
>>> Regards
>>>
>>> Adrian
>>>
>>> Hi Adrian,
>>>
>>> Please follow instructions at
>>> https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting
>>>
>>> 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.