Re: [GNC] Stock quotes hung

2023-10-09 Thread Maf. King
On Monday, 9 October 2023 16:52:17 BST David Carlson wrote:
> Not sure exactly what happened in your case.  But usually, if you can put
> the focus on the "frozen" process, then Alt-F4 will kill it.
> 
> > There are other ways as well in Linux, for example with htop.

Ctrl-Alt-Escape is quite good at killing a stuck process, as long as it has a 
window open.   Quick too



> 
> On Mon, Oct 9, 2023, 10:13 AM Fred Tydeman  wrote:
> > I am back home and stock quotes is working fine.
> > So, my problem must have been a very slow internet connection.
> > It would be nice if there were some way to cancel a stock quote fetch
> > in progress.  I had to reboot the entire Linux system before.
> > 
> > On Sat, Sep 9, 2023 at 3:25 PM Fred Tydeman 
> > 
> > wrote:
> > > I was wrong.  The gnucash-cli command, after a couple of minutes, did
> > > finish.
> > > And looking at the price history, it did get the AT price for
> > 
> > yesterday.
> > 
> > > So, it looks like things are very slow for some reason.
> > > Perhaps the internet at this airbnb is causing problems.
> > > 
> > > On Sat, Sep 9, 2023 at 5:19 PM Fred Tydeman 
> > > 
> > > wrote:
> > >> I have removed Get Quotes for all of my stocks and have just GBP
> > 
> > currency
> > 
> > >> getting quotes.
> > >> Doing the gnucash-cli command works.
> > >> 
> > >> If I add in just one stock (T == AT), gnucash-cli hangs.
> > >> 
> > >> I tried adding in --debug to that gnucash-cli, but nothing stood out as
> > 
> > a
> > 
> > >> problem.
> > >> 
> > >> Suggestions?
> > 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > 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.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.


Re: [GNC] Stock quotes hung

2023-10-09 Thread David Carlson
Not sure exactly what happened in your case.  But usually, if you can put
the focus on the "frozen" process, then Alt-F4 will kill it.

There are other ways as well in Linux, for example with htop.



On Mon, Oct 9, 2023, 10:13 AM Fred Tydeman  wrote:

> I am back home and stock quotes is working fine.
> So, my problem must have been a very slow internet connection.
> It would be nice if there were some way to cancel a stock quote fetch
> in progress.  I had to reboot the entire Linux system before.
>
> On Sat, Sep 9, 2023 at 3:25 PM Fred Tydeman 
> wrote:
>
> > I was wrong.  The gnucash-cli command, after a couple of minutes, did
> > finish.
> > And looking at the price history, it did get the AT price for
> yesterday.
> > So, it looks like things are very slow for some reason.
> > Perhaps the internet at this airbnb is causing problems.
> >
> > On Sat, Sep 9, 2023 at 5:19 PM Fred Tydeman 
> > wrote:
> >
> >> I have removed Get Quotes for all of my stocks and have just GBP
> currency
> >> getting quotes.
> >> Doing the gnucash-cli command works.
> >>
> >> If I add in just one stock (T == AT), gnucash-cli hangs.
> >>
> >> I tried adding in --debug to that gnucash-cli, but nothing stood out as
> a
> >> problem.
> >>
> >> Suggestions?
> >>
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.


Re: [GNC] Stock quotes hung

2023-10-09 Thread Fred Tydeman
I am back home and stock quotes is working fine.
So, my problem must have been a very slow internet connection.
It would be nice if there were some way to cancel a stock quote fetch
in progress.  I had to reboot the entire Linux system before.

On Sat, Sep 9, 2023 at 3:25 PM Fred Tydeman  wrote:

> I was wrong.  The gnucash-cli command, after a couple of minutes, did
> finish.
> And looking at the price history, it did get the AT price for yesterday.
> So, it looks like things are very slow for some reason.
> Perhaps the internet at this airbnb is causing problems.
>
> On Sat, Sep 9, 2023 at 5:19 PM Fred Tydeman 
> wrote:
>
>> I have removed Get Quotes for all of my stocks and have just GBP currency
>> getting quotes.
>> Doing the gnucash-cli command works.
>>
>> If I add in just one stock (T == AT), gnucash-cli hangs.
>>
>> I tried adding in --debug to that gnucash-cli, but nothing stood out as a
>> problem.
>>
>> Suggestions?
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.


Re: [GNC] Stock quotes hung

2023-09-09 Thread Fred Tydeman
I was wrong.  The gnucash-cli command, after a couple of minutes, did
finish.
And looking at the price history, it did get the AT price for yesterday.
So, it looks like things are very slow for some reason.
Perhaps the internet at this airbnb is causing problems.

On Sat, Sep 9, 2023 at 5:19 PM Fred Tydeman  wrote:

> I have removed Get Quotes for all of my stocks and have just GBP currency
> getting quotes.
> Doing the gnucash-cli command works.
>
> If I add in just one stock (T == AT), gnucash-cli hangs.
>
> I tried adding in --debug to that gnucash-cli, but nothing stood out as a
> problem.
>
> Suggestions?
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.


Re: [GNC] Stock quotes hung

2023-09-09 Thread Fred Tydeman
I have removed Get Quotes for all of my stocks and have just GBP currency
getting quotes.
Doing the gnucash-cli command works.

If I add in just one stock (T == AT), gnucash-cli hangs.

I tried adding in --debug to that gnucash-cli, but nothing stood out as a
problem.

Suggestions?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.


Re: [GNC] Stock quotes hung

2023-09-09 Thread John Ralls
Unfortunately no. The Securities window can show which ones are set (click the 
arrow at the right end of the header row and check Get Quotes) but the control 
isn't sensitive so you have to double-click on each line item and change it in 
the Security Editor dialog box.

Regards,
John Ralls

> On Sep 9, 2023, at 2:41 PM, Fred Tydeman  wrote:
> 
> Is there an easy way to add or remove Get Quotes for many stocks at a time?
> 
> On Sat, Sep 9, 2023 at 11:50 AM john  wrote:
> 
> GnuCash 4.14 uses the old perl utilities gnc-fq-check and gnc-fq-dump. The 
> info and dump commands were added to gncuash-cli --quotes in 5.0.
> 
> FWIW I retrieved an AAPL quote from yahoo_json just now, so the problem isn't 
> with Yahoo! messing with their URI again. Most likely there's an issue with 
> one of your more thinly-traded securities, so repeat the triage steps from 
> when this happened a few weeks ago to figure out which one.
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.


Re: [GNC] Stock quotes hung

2023-09-09 Thread Fred Tydeman
Is there an easy way to add or remove Get Quotes for many stocks at a time?

On Sat, Sep 9, 2023 at 11:50 AM john  wrote:

>
> GnuCash 4.14 uses the old perl utilities gnc-fq-check and gnc-fq-dump. The
> info and dump commands were added to gncuash-cli --quotes in 5.0.
>
> FWIW I retrieved an AAPL quote from yahoo_json just now, so the problem
> isn't with Yahoo! messing with their URI again. Most likely there's an
> issue with one of your more thinly-traded securities, so repeat the triage
> steps from when this happened a few weeks ago to figure out which one.
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.


Re: [GNC] Stock quotes hung

2023-09-09 Thread john



> On Sep 9, 2023, at 06:37, Fred Tydeman  wrote:
> 
> I am running GnuCash 4.14 on Fedora Linux 37
> 
> Last weekend, I could get stock quotes.
> Yesterday and today, all I get is a spinning circle.
> I end up rebooting Linux to get out of a hung session.
> All of my stocks are getting prices from yahoo as json.
> 
> In looking at the online documentation in 11.3 about gnucash-cli,
> I have tried
> gnucash-cli --quotes info
> and
> gnucash-cli --quotes dump
> Both get:  Unknown quotes command 'info' and 'dump'.
> 
> Doing
> gnucash-cli --quotes get /lindata/GnuCash/tybor/tybor.gnucash
> gets: Found Finance::Quote version 1.58
> and a hung session.

GnuCash 4.14 uses the old perl utilities gnc-fq-check and gnc-fq-dump. The info 
and dump commands were added to gncuash-cli --quotes in 5.0.

FWIW I retrieved an AAPL quote from yahoo_json just now, so the problem isn't 
with Yahoo! messing with their URI again. Most likely there's an issue with one 
of your more thinly-traded securities, so repeat the triage steps from when 
this happened a few weeks ago to figure out which one.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.


[GNC] Stock quotes hung

2023-09-09 Thread Fred Tydeman
I am running GnuCash 4.14 on Fedora Linux 37

Last weekend, I could get stock quotes.
Yesterday and today, all I get is a spinning circle.
I end up rebooting Linux to get out of a hung session.
All of my stocks are getting prices from yahoo as json.

In looking at the online documentation in 11.3 about gnucash-cli,
I have tried
gnucash-cli --quotes info
and
gnucash-cli --quotes dump
Both get:  Unknown quotes command 'info' and 'dump'.

Doing
gnucash-cli --quotes get /lindata/GnuCash/tybor/tybor.gnucash
gets: Found Finance::Quote version 1.58
and a hung session.

Suggestions?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.


Re: [GNC] Stock quotes for BT.A

2020-06-06 Thread Ruaraidh Sackville Hamilton
  Perfect! Many thanks Maf. and Frank, that worked :-)

On Sat, 6 Jun 2020 at 14:44, Frank H. Ellenberger <
frank.h.ellenber...@gmail.com> wrote:

>
>
> Am 06.06.20 um 13:46 schrieb Ruaraidh Sackville Hamilton:
> > Does anyone know how to get price quotes for LSE:BT.A from Alphavantage?
> Or
> > from any other source?
>
> No, but google ;-)
> try https://www.google.com/search?q=LSE+BT.A
>
> > Following other advice on this forum, I've successfully retrieved price
> > quotes from Alphavantage for other LSE stocks by concatenating the LSE
> > ticker code with ".L" and setting that as the value of Symbol in the
> > Security Editor. For example, setting Symbol = "BP.L" successfully
> > retrieves the price quote for BP.
> >
> > The ticker code for BT Group is BT.A, so I tried "BT.A.L", but that
> failed.
> >
> > I guess that breaks their syntax rules, so, guessing wildly, I've also
> > tried "BT_A.L" and "BTA.L" and "BT.L", but all of these fail too.
>
> yes, 2 dots in one symbol confuse yahoo. On above page you see, they
> replace the first by dash.
>
> > Any other suggestions would be welcome!
>
> So I was able to get results with
> gnc-fq-dump -v yahoo_json BT-A.L
> and
> gnc-fq-dump -v alphavantage BT-A.L
> but failed with fool, but their website gave me also no quote.
>
> HTH
> Frank
>
___
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] Stock quotes for BT.A

2020-06-06 Thread Frank H. Ellenberger



Am 06.06.20 um 13:46 schrieb Ruaraidh Sackville Hamilton:
> Does anyone know how to get price quotes for LSE:BT.A from Alphavantage? Or
> from any other source?

No, but google ;-)
try https://www.google.com/search?q=LSE+BT.A

> Following other advice on this forum, I've successfully retrieved price
> quotes from Alphavantage for other LSE stocks by concatenating the LSE
> ticker code with ".L" and setting that as the value of Symbol in the
> Security Editor. For example, setting Symbol = "BP.L" successfully
> retrieves the price quote for BP.
> 
> The ticker code for BT Group is BT.A, so I tried "BT.A.L", but that failed.
> 
> I guess that breaks their syntax rules, so, guessing wildly, I've also
> tried "BT_A.L" and "BTA.L" and "BT.L", but all of these fail too.

yes, 2 dots in one symbol confuse yahoo. On above page you see, they
replace the first by dash.

> Any other suggestions would be welcome!

So I was able to get results with
gnc-fq-dump -v yahoo_json BT-A.L
and
gnc-fq-dump -v alphavantage BT-A.L
but failed with fool, but their website gave me also no quote.

HTH
Frank
___
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] Stock quotes for BT.A

2020-06-06 Thread Maf. King
Try BT-A.L  (a minus sign).  it used to work in the old days via yahoo, I no 
longer hold that stock so don't have it in the Alphavantage checks.

HTH,
Maf.


On Saturday, 6 June 2020 12:46:46 BST Ruaraidh Sackville Hamilton wrote:
> Does anyone know how to get price quotes for LSE:BT.A from Alphavantage? Or
> from any other source?
> 
> Following other advice on this forum, I've successfully retrieved price
> quotes from Alphavantage for other LSE stocks by concatenating the LSE
> ticker code with ".L" and setting that as the value of Symbol in the
> Security Editor. For example, setting Symbol = "BP.L" successfully
> retrieves the price quote for BP.
> 
> The ticker code for BT Group is BT.A, so I tried "BT.A.L", but that failed.
> 
> I guess that breaks their syntax rules, so, guessing wildly, I've also
> tried "BT_A.L" and "BTA.L" and "BT.L", but all of these fail too.
> 
> Any other suggestions would be welcome!
> ___
> 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.


-- 
Maf. King
PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542





___
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] Stock quotes for BT.A

2020-06-06 Thread Ruaraidh Sackville Hamilton
Does anyone know how to get price quotes for LSE:BT.A from Alphavantage? Or
from any other source?

Following other advice on this forum, I've successfully retrieved price
quotes from Alphavantage for other LSE stocks by concatenating the LSE
ticker code with ".L" and setting that as the value of Symbol in the
Security Editor. For example, setting Symbol = "BP.L" successfully
retrieves the price quote for BP.

The ticker code for BT Group is BT.A, so I tried "BT.A.L", but that failed.

I guess that breaks their syntax rules, so, guessing wildly, I've also
tried "BT_A.L" and "BTA.L" and "BT.L", but all of these fail too.

Any other suggestions would be welcome!
___
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] Stock quotes

2019-05-27 Thread Michael Hendry
> On 27 May 2019, at 00:02, Jean-David Beyer via gnucash-user 
>  wrote:
> 
> On 5/26/19 4:34 PM, Steve wrote:
>> That was it. I still had one set up as Alphavantage. "Unknown error"
>> is not the most helpful error message.
>> 
> 
> I wrote a big program once, and at one point in the program, I had it
> print out the error message, "WAHOO!"
> 
> It actually came out once and the user called me on the telephone to
> complain about the unhelpful message. But think about the code that
> generated the message and answer this: what error message would you have
> printed. Assembler code
> 
> TZE  C (transfer if zero)) to location C
> TPL  A (transfer if positive) to location A
> TMI  B (transfer if negative) to location B
> 
> PRINT "WAHOO!"
> 
> It must have been a machine error. There was no logical way to get to
> that PRINT statement.


Have you thought about a fault elsewhere in your program which caused a jump to 
the third line (TMI B…) with a positive or zero value in the appropriate 
register?

Michael

___
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] Stock quotes

2019-05-26 Thread Jean-David Beyer via gnucash-user
On 5/26/19 4:34 PM, Steve wrote:
> That was it. I still had one set up as Alphavantage. "Unknown error"
> is not the most helpful error message.
> 

I wrote a big program once, and at one point in the program, I had it
print out the error message, "WAHOO!"

It actually came out once and the user called me on the telephone to
complain about the unhelpful message. But think about the code that
generated the message and answer this: what error message would you have
printed. Assembler code

TZE  C (transfer if zero)) to location C
TPL  A (transfer if positive) to location A
TMI  B (transfer if negative) to location B

PRINT "WAHOO!"

It must have been a machine error. There was no logical way to get to
that PRINT statement.

-- 
  .~.  Jean-David Beyer
  /V\  PGP-Key:166D840A 0C610C8B
 /( )\ Shrewsbury, New Jersey
 ^^-^^ 18:55:01 up 3 days, 8:40, 2 users, load average: 4.42, 4.58, 4.59
___
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] Stock quotes

2019-05-26 Thread Steve
That was it. I still had one set up as Alphavantage. "Unknown error"
is not the most helpful error message.

Thanks,
Steve

On Fri, 24 May 2019 08:00:35 -0400
"Derek Atkins"  wrote:

> Are you sure that ALL your securities are set to yahoo_json?
> If only ONE is set elsewhere, it wont work and you'll get this error.
> 
> -derek
> 
> On Fri, May 24, 2019 7:24 am, Steve wrote:
> > Ever since Yahoo shut down their service, I have not been able to
> > get any stock quotes. I had been running a very old version,
> > 2.6.15, I think, so I didn't try to resolve the issue but now I
> > have updated to 3.4 and I still have the same problem.
> >
> > I have checked that I have the necessary version of Perl and
> > gnc-fq-dump installed and I changed all my securities to retrieve
> > quotes using yahoo_jason. From the command line I can get a quote:
> >
> > $ gnc-fq-dump yahoo_json googl
> > Finance::Quote fields Gnucash uses:
> > symbol: googl<=== required
> >   date: 05/17/2019   <=== recommended
> >   currency: USD  <=== required
> >   last: 1168.78  <=\
> >nav:  <=== one of these
> >  price:  <=/
> >   timezone:  <=== optional
> >
> > but when I try from inside GNC I get the "Unknown Error" popup. Are
> > there any debug logs I can look at to see what is going on? Perhaps
> > I have too many securities? Is there a way to request just one from
> > inside GNC?
> >
> > Thanks,
> > Steve
> > ___
> > 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: [GNC] Stock quotes

2019-05-24 Thread Derek Atkins
Are you sure that ALL your securities are set to yahoo_json?
If only ONE is set elsewhere, it wont work and you'll get this error.

-derek

On Fri, May 24, 2019 7:24 am, Steve wrote:
> Ever since Yahoo shut down their service, I have not been able to get
> any stock quotes. I had been running a very old version, 2.6.15, I
> think, so I didn't try to resolve the issue but now I have updated to
> 3.4 and I still have the same problem.
>
> I have checked that I have the necessary version of Perl and
> gnc-fq-dump installed and I changed all my securities to retrieve
> quotes using yahoo_jason. From the command line I can get a quote:
>
> $ gnc-fq-dump yahoo_json googl
> Finance::Quote fields Gnucash uses:
> symbol: googl<=== required
>   date: 05/17/2019   <=== recommended
>   currency: USD  <=== required
>   last: 1168.78  <=\
>nav:  <=== one of these
>  price:  <=/
>   timezone:  <=== optional
>
> but when I try from inside GNC I get the "Unknown Error" popup. Are
> there any debug logs I can look at to see what is going on? Perhaps I
> have too many securities? Is there a way to request just one from
> inside GNC?
>
> Thanks,
> Steve
> ___
> 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.
>


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


[GNC] Stock quotes

2019-05-24 Thread Steve
Ever since Yahoo shut down their service, I have not been able to get
any stock quotes. I had been running a very old version, 2.6.15, I
think, so I didn't try to resolve the issue but now I have updated to
3.4 and I still have the same problem.

I have checked that I have the necessary version of Perl and
gnc-fq-dump installed and I changed all my securities to retrieve
quotes using yahoo_jason. From the command line I can get a quote:

$ gnc-fq-dump yahoo_json googl
Finance::Quote fields Gnucash uses:
symbol: googl<=== required
  date: 05/17/2019   <=== recommended
  currency: USD  <=== required
  last: 1168.78  <=\   
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

but when I try from inside GNC I get the "Unknown Error" popup. Are
there any debug logs I can look at to see what is going on? Perhaps I
have too many securities? Is there a way to request just one from
inside GNC?

Thanks,
Steve
___
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] Stock Quotes

2019-01-14 Thread Wm via gnucash-user

On 03/01/2019 19:03, nvsoar wrote:

On 01/02/19 08:51, Dave Cooper via gnucash-user wrote:

Hi gnucash

I have returned to gnu-cash having not used it for several years so 
please bear with me.
I have reloaded the system and set it up to get some UK stock prices 
(LSE) using Alphavantage
Unfortunately I get poor results - only 25% - 50% prices are returned 
- I assume this is caused by time outs
As a temporary fix I now use yahoo - json  which gets results every 
time so far, but I have to manually adjust these prices because the 
return is in pence not pounds

Is there a parameter or easy way to fix this?

I note that yahoo are having problems due to their historical data for 
UK is in pounds - not that I am going there.


Cheers
Dave
A solution to AlphaVantage limits is in Ameet Sengar's message; 
available here.

https://lists.gnucash.org/pipermail/gnucash-user/2018-September/079698.html
It has been my experience that the AlphaVantage.pm file is read only. 
Change file properties to read write to modify;  then back to read 
only.  (Notepad++ worked well for me on a Win10 system.)


Because Quote.pm is hard coded to use Alphavantage for exchange rates it 
is also useful to put a delay in there if you have more than a few 
currencies.


..\perl\site\lib\Finance\Quote.pm

I put it in just before the call to the outside world
===
  my $ALPHAVANTAGE_API_KEY = $ENV{'ALPHAVANTAGE_API_KEY'};
  return undef unless ( defined $ALPHAVANTAGE_API_KEY );

  sleep(15);

  my $reply = $ua->request(GET "${ALPHAVANTAGE_CURRENCY_URL}"
. "_currency=" . ${from}
. "_currency=" . ${to}
. "=" . ${ALPHAVANTAGE_API_KEY} );

===

Own risk, etc.

--
Wm

___
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] Stock Quotes

2019-01-03 Thread nvsoar

On 01/02/19 08:51, Dave Cooper via gnucash-user wrote:

Hi gnucash

I have returned to gnu-cash having not used it for several years so 
please bear with me.
I have reloaded the system and set it up to get some UK stock prices 
(LSE) using Alphavantage
Unfortunately I get poor results - only 25% - 50% prices are returned 
- I assume this is caused by time outs
As a temporary fix I now use yahoo - json  which gets results every 
time so far, but I have to manually adjust these prices because the 
return is in pence not pounds

Is there a parameter or easy way to fix this?

I note that yahoo are having problems due to their historical data for 
UK is in pounds - not that I am going there.


Cheers
Dave
A solution to AlphaVantage limits is in Ameet Sengar's message; 
available here.

https://lists.gnucash.org/pipermail/gnucash-user/2018-September/079698.html
It has been my experience that the AlphaVantage.pm file is read only.  
Change file properties to read write to modify;  then back to read 
only.  (Notepad++ worked well for me on a Win10 system.)

nvsoar
___
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] Stock Quotes

2019-01-02 Thread Dave Cooper via gnucash-user

Hi gnucash

I have returned to gnu-cash having not used it for several years so 
please bear with me.
I have reloaded the system and set it up to get some UK stock prices 
(LSE) using Alphavantage
Unfortunately I get poor results - only 25% - 50% prices are returned - 
I assume this is caused by time outs
As a temporary fix I now use yahoo - json  which gets results every time 
so far, but I have to manually adjust these prices because the return is 
in pence not pounds

Is there a parameter or easy way to fix this?

I note that yahoo are having problems due to their historical data for 
UK is in pounds - not that I am going there.


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