date:20171112

On Sun, 12 Nov 2017 21:27:47 -0600
listreader  wrote:

> > >> me "0.0200".  Should I NOT be using alphavantage for the currency
> > >> quotes in gc?
> > > 
> > > I have no idea.  I don't know how gnucash actually gets the quote
> > > for currencies from F::Q.  It might i.e. use another method...
> > > Maybe a developper from GnuCash can help here?
> > 
> > We use the Finance::Quote currency method, see
> > https://github.com/Gnucash/gnucash/blob/maint/src/quotes/gnc-fq-helper.in#L346
> > and
> > https://github.com/Gnucash/gnucash/blob/maint/src/quotes/gnc-fq-dump#L165.
> > 
> > When using the scripts directly one must use source currency, e.g.
> > 
> > gnc-fq-dump currency USD GBP  
> 
> I just ran through the gc Price Editor quote-source options again.
> The new gc f::q option for "single=>Yahoo as JSON", which wasn't
> there when I ran thru the options on an earlier rev of f::q, does
> apparently *work* for the metals.
> 
> For "Yahoo as JSON" the symbol for XAG into USD is XAGUSD=X and XAU is
> XAUUSD=X. 
> 
> The quotes are delayed by some undetermined amount of time whereas the
> alphavantage currency quotes are real time but this is VERY good to
> have (for as long as yahoo allows it to exist). 
> 
> Thanks very much for your work, Erik. (And thanks also, John, for gc).
> 

Poor form for me to reply to my own message but... 

I just re-enabled XAG and XAU quotes in the 'National Securities' list
of Security Editor in gnucash and, suprise, they are now working.  I
have no idea where gc sources those quotes from, the Security Editor
does not say/offer that info (nor can it be changed) but the quotes do
appear to be real time so I'm guessing it's your alphavantage module.

I have no clue.  But it appears to be working.  So I now have *2*
working f:q / gc sources of currency/metals quotes.

Thanks.

Ralph
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: F::Q changes

2017-11-12 Thread Dale Alspach

This is a perl module. To update in a terminal window follow these steps
from a recent post:

sudo perl -MCPAN -e shell

Then in the perl shell:

reload index

upgrade Finance::Quote

Dale

On 11/12/2017 08:02 PM, David Carlson wrote:
> I cannot find Finance::Quote on my Ubuntu 16.04 computer that has GnuCash
> 6.12 installed.  How can I update it?  I have tried using Synaptic and even
> searching with files.
> 
> David C
> 
> On Sun, Nov 12, 2017 at 4:30 PM, John Ralls  wrote:
> 
>>
>>> On Nov 12, 2017, at 1:57 PM, Liz  wrote:
>>>
>>> I've put a small piece on the FAQ about this, with the intention that
>>> the information gets picked up by the search engines.
>>> I don't actually use F::Q, so could someone with wiki edit privileges
>>> who understands what has and is happening enlarge on this - perhaps a
>>> wiki page linked to the FAQ.
>>>
>>> If you could write this, but don't have wiki write privileges, an email
>>> direct to me will allow me to make the edits.
>>>
>>> We are getting many requests about this, and while it is good to see
>>> there are so many users, it isn't good to see so many without the
>>> needed information.
>>>
>>
>> Liz,
>>
>> I put an item in the FAQ about this a week ago and it's been refined a
>> couple of times since: https://wiki.gnucash.org/wiki/
>> index.php?title=FAQ=1288=13067=13021#Q:
>> _Why_doesn.27t_online_quoting_work.3F
>>
>> If you or anyone else can think of ways to improve the search engine
>> indexing of it that would be great. In the meantime it covers what your
>> item did in more detail so I rolled back your addition.
>>
>> Regards,
>> John Ralls
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: gnc-fq-dump doesn't work for most sources

2017-11-12 Thread gnucash3

I added the alphavantage key to my environment, and now gnc-fq-dump work fine
from the command line.  However, when I run Gnucash, it still fails.  I did add
the key to /etc/gnucash/environment.  Any ideas?

(1.45 on Ubuntu)

On Sun, Nov 12, 2017 at 05:32:24PM +0100, Erik Colson wrote:
> 
> Brian M. Sutin  writes:
> 
> > $ gnc-fq-dump -v vanguard VTSAX
> > No results found for stock VTSAX.
> >
> > $ gnc-fq-dump -v nasdaq ibm
> > No results found for stock ibm.
> >
> > $ gnc-fq-dump -v nyse ATGE
> > No results found for stock ATGE.
> 
> These won't work ass vanguard, nasdaq and nyse are not supported in the
> alphavantage module.  They should however be added in a future
> release.. Use alphavantage instead.
> 
> best
> --
> erik colson

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: F::Q changes

2017-11-12 Thread nvsoar


On 11/12/17 18:02, David Carlson wrote:

I cannot find Finance::Quote on my Ubuntu 16.04 computer that has GnuCash
6.12 installed.  How can I update it?  I have tried using Synaptic and even
searching with files.

David C

snip
Try GetDeb to update - http://www.getdeb.net/updates/Ubuntu/16.04/?q=gnucash
nvsoar
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Currency/metals quotes with new f::q 1.45?


> >> me "0.0200".  Should I NOT be using alphavantage for the currency
> >> quotes in gc?  
> > 
> > I have no idea.  I don't know how gnucash actually gets the quote
> > for currencies from F::Q.  It might i.e. use another method...
> > Maybe a developper from GnuCash can help here?  
> 
> We use the Finance::Quote currency method, see
> https://github.com/Gnucash/gnucash/blob/maint/src/quotes/gnc-fq-helper.in#L346
> and
> https://github.com/Gnucash/gnucash/blob/maint/src/quotes/gnc-fq-dump#L165.
> 
> When using the scripts directly one must use source currency, e.g.
> 
> gnc-fq-dump currency USD GBP

I just ran through the gc Price Editor quote-source options again.  The
new gc f::q option for "single=>Yahoo as JSON", which wasn't there when
I ran thru the options on an earlier rev of f::q, does apparently
*work* for the metals.

For "Yahoo as JSON" the symbol for XAG into USD is XAGUSD=X and XAU is
XAUUSD=X. 

The quotes are delayed by some undetermined amount of time whereas the
alphavantage currency quotes are real time but this is VERY good to
have (for as long as yahoo allows it to exist). 

Thanks very much for your work, Erik. (And thanks also, John, for gc).

Ralph
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: gnucash-user Digest, Vol 176, Issue 31

>No tests should fail if you set following environment variable:
>>export ONLINE_TEST=0
>>By default ONLINE_TEST should not be defined, which is basically the
>same.  I guess you might have this variable set somewhere?

>best
>--
>erik colson


I set that in both the GNC and system environment per your suggestion.  Don't 
know where it would have been set in the system before.  Maybe one of the 
manual installations I had to do in the beginning when the updated F-Q modules 
were only available at Sourceforge did it behind the scenes on me.  Have to 
wait on the next latest and greatest F-Q to test whether the variable works.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: F::Q 1.45 AlphaVantage quote failure

Yeah it's not a key problem for me, it's in my environment file and I
source it in the shell. Without the key, I get a different specific error
about the key being absent.

Greg
917-664-0083
http://gregetling.com
--
"The credit belongs to the man who is actually in the arena, whose face is
marred by dust and sweat and blood; who strives valiantly; who errs, who
comes short again and again, because there is no effort without error and
shortcoming" -Theodore Roosevelt

On Sun, Nov 12, 2017 at 8:58 PM, D  wrote:

> AlphaVantage.
>
> Be sure to get the key in the right places. There are two, one for the
> app, one for command line. See the FAQ.
>
> David
>
>
> On November 13, 2017, at 6:50 AM, Greg Etling  wrote:
>
>
> David, using alphavantage, or yahoo_json? The latter still works for me
> with 1.47.
>
> Greg
> 917-664-0083 <(917)%20664-0083>
> http://gregetling.com
> --
> "The credit belongs to the man who is actually in the arena, whose face is
> marred by dust and sweat and blood; who strives valiantly; who errs, who
> comes short again and again, because there is no effort without error and
> shortcoming" -Theodore Roosevelt
>
> On Sun, Nov 12, 2017 at 8:46 PM, D  wrote:
>
>> For what it's worth, my Mac is using 5.18 without problem with F::Q 1.45.
>>
>> David
>>
>> On November 13, 2017, at 3:15 AM, Erik Colson  wrote:
>>
>>
>> Greg Etling  writes:
>>
>> > I'm on OSX Sierra, and I'd prefer not to try to overlay a new perl if at
>> > all possible as I've already had to blow away one profile over the years
>> > due to too much tinkering with perl. I'll take it under consideration,
>> but
>> > for now I'll just have to leave this broken. Thanks anyway.
>>
>> It is indeed a wrong idea to mess with system Perl.  You should however
>> install your own Perl with brew or another tool like that.  Meantime,
>> I'll try F::Q with perl v5.18 on a test system to see if I can figure
>> this out.
>>
>> best
>> --
>> erik colson
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: How to install an updated Finance-Quote module in Linux

> On Nov 12, 2017, at 5:51 PM, David Carlson  
> wrote:
> 
> I thought I saw instructions somewhere on how to update the Finance-Quote
> module, but now I cannot find it.  The instructions in the GnuCash FAQ are
> not sufficiently complete for dummies like me.  I get an error
> gnc-fq-update command not found then I do not know what to do next.

There are more complete instructions at 
https://wiki.gnucash.org/wiki/Online_Quotes and for Windows users in 
https://wiki.gnucash.org/wiki/Windows#Finance::Quote.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: F::Q 1.45 AlphaVantage quote failure

2017-11-12 Thread D via gnucash-user

AlphaVantage.

Be sure to get the key in the right places. There are two, one for the app, one 
for command line. See the FAQ.

David

On November 13, 2017, at 6:50 AM, Greg Etling  wrote:

David, using alphavantage, or yahoo_json? The latter still works for me with 
1.47.

Greg
917-664-0083
http://gregetling.com
--
"The credit belongs to the man who is actually in the arena, whose face is 
marred by dust and sweat and blood; who strives valiantly; who errs, who comes 
short again and again, because there is no effort without error and 
shortcoming" -Theodore Roosevelt

On Sun, Nov 12, 2017 at 8:46 PM, D  wrote:

For what it's worth, my Mac is using 5.18 without problem with F::Q 1.45.

David

On November 13, 2017, at 3:15 AM, Erik Colson  wrote:

Greg Etling  writes:

> I'm on OSX Sierra, and I'd prefer not to try to overlay a new perl if at
> all possible as I've already had to blow away one profile over the years
> due to too much tinkering with perl. I'll take it under consideration, but
> for now I'll just have to leave this broken. Thanks anyway.

It is indeed a wrong idea to mess with system Perl.  You should however
install your own Perl with brew or another tool like that.  Meantime,
I'll try F::Q with perl v5.18 on a test system to see if I can figure
this out.

best
--
erik colson

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: files

> On Nov 12, 2017, at 4:27 PM, Christine via gnucash-user 
>  wrote:
> 
> Hello
> All my files are on the desktop where I saved them. So I put them in a
> folder and now when I try to open one of the pages, it asks me to save it,
> if I click on save it wants a new path, how can I work from a main folder
> pls?
> Christine 
> 

Please don't reply to messages when you want to start a new thread, it doesn't 
work.

Was GnuCash running when you moved the files?

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

How to install an updated Finance-Quote module in Linux

2017-11-12 Thread David Carlson

I thought I saw instructions somewhere on how to update the Finance-Quote
module, but now I cannot find it.  The instructions in the GnuCash FAQ are
not sufficiently complete for dummies like me.  I get an error
gnc-fq-update command not found then I do not know what to do next.

David C
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: F::Q 1.45 AlphaVantage quote failure

2017-11-12 Thread D via gnucash-user

For what it's worth, my Mac is using 5.18 without problem with F::Q 1.45.

David

On November 13, 2017, at 3:15 AM, Erik Colson  wrote:

Greg Etling  writes:

> I'm on OSX Sierra, and I'd prefer not to try to overlay a new perl if at
> all possible as I've already had to blow away one profile over the years
> due to too much tinkering with perl. I'll take it under consideration, but
> for now I'll just have to leave this broken. Thanks anyway.

It is indeed a wrong idea to mess with system Perl.  You should however
install your own Perl with brew or another tool like that.  Meantime,
I'll try F::Q with perl v5.18 on a test system to see if I can figure
this out.

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Finance-Quote 1.45 released!

2017-11-12 Thread prl


Thanks, Erik.

Peter

On 13/11/2017 10:27, Erik Colson wrote:

prl  writes:


my $suffix = uc($1);

yes, I've already committed it for the next version.

best
--
erik colson



___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

RE: files

2017-11-12 Thread Christine via gnucash-user

Hello
All my files are on the desktop where I saved them. So I put them in a
folder and now when I try to open one of the pages, it asks me to save it,
if I click on save it wants a new path, how can I work from a main folder
pls?
Christine 

-Original Message-
From: gnucash-user
[mailto:gnucash-user-bounces+cmaloney4=talktalk@gnucash.org] On Behalf
Of Erik Colson
Sent: 13 November 2017 00:21
To: Cam Ellison
Cc: gnucash-user@gnucash.org
Subject: Re: Finance-Quote 1.47 released!

Cam Ellison  writes:

> On 12/11/17 08:27 AM, Erik Colson wrote:
>> New version 1.47 of Finance-Quote is available with the following
changes:
>>
>>  * Use AlphaVantage for currency quotes instead of Yahoo (Mike
Alexander)
>>
>>
> FYI: USD->CAD now works, but not GBP->CAD.

it does here:

~/DEVELOPMENT/finance-quote >>> perl -Ilib Examples/currency-lookup.pl GBP
CAD
GBP->CAD = 1.66540274
~/DEVELOPMENT/finance-quote >>> perl -Ilib Examples/currency-lookup.pl CAD
GBP
CAD->GBP = 0.60045536
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Finance-Quote 1.47 released!


Cam Ellison  writes:

> On 12/11/17 08:27 AM, Erik Colson wrote:
>> New version 1.47 of Finance-Quote is available with the following changes:
>>
>>  * Use AlphaVantage for currency quotes instead of Yahoo (Mike 
>> Alexander)
>>
>>
> FYI: USD->CAD now works, but not GBP->CAD.

it does here:

~/DEVELOPMENT/finance-quote >>> perl -Ilib Examples/currency-lookup.pl GBP CAD
GBP->CAD = 1.66540274
~/DEVELOPMENT/finance-quote >>> perl -Ilib Examples/currency-lookup.pl CAD GBP
CAD->GBP = 0.60045536
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Finance-Quote 1.47 released!

2017-11-12 Thread Cam Ellison


On 12/11/17 08:27 AM, Erik Colson wrote:

New version 1.47 of Finance-Quote is available with the following changes:

 * Use AlphaVantage for currency quotes instead of Yahoo (Mike 
Alexander)



FYI: USD->CAD now works, but not GBP->CAD.

Cheers

Cam

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Currency/metals quotes with new f::q 1.45?


listreader  writes:

> I had to find the source of currency-lookup.pl via google but did and
> "perl -Ilib currency-lookup.pl XAG USD" works: "XAG->USD = 16.87475774"
> (price varying from yours because the market is now open for the day)
> but "gnc-fq-dump alphavantage XAG" still gives me "0.0200".  Should I
> NOT be using alphavantage for the currency quotes in gc?

I have no idea.  I don't know how gnucash actually gets the quote for
currencies from F::Q.  It might i.e. use another method...  Maybe a
developper from GnuCash can help here?

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Currency/metals quotes with new f::q 1.45?


> > 1.47 - No errors but returns the wrong price data, i.e. for gold:
> >  
> > :~> gnc-fq-dump alphavantage XAU  
> >
> > Finance::Quote fields Gnucash uses:
> > symbol: XAU  <=== required
> >   date: 11/10/2017   <=== recommended
> >   currency: USD  <=== required
> >   last: 6.5100   <=\  
> 
> From the F::Q Examples I get following data:

> and for XAG
> ~/DEVELOPMENT/finance-quote >>> perl -Ilib
> Examples/currency-lookup.pl XAG USD XAG->USD = 16.89097601
> 
> Can you check those on your system ?

I had to find the source of currency-lookup.pl via google but did and
"perl -Ilib currency-lookup.pl XAG USD" works: "XAG->USD = 16.87475774"
(price varying from yours because the market is now open for the day)
but "gnc-fq-dump alphavantage XAG" still gives me "0.0200".  Should I
NOT be using alphavantage for the currency quotes in gc?

Ralph
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Finance-Quote 1.45 released!

2017-11-12 Thread rmcasali

Hi,

Em sex, 2017-11-10 às 18:50 +0100, Erik Colson escreveu:
> rmcas...@gmail.com writes:
> 
> > Hi,
> > 
> > I changed the YahooJSON module to use the new API variables and the
> > new
> > URL. It is attached for anyone who wants to test. It's not a very
> > clean
> > code, it's just an adaptation.
> > 
> > Unfortunately, I do not know how to update the finance-quote.
> > 
> > I hope it helps.
> 
> Hi!
> 
> Thank you for your code!  Is the new url/api documented somewhere?  I
> can't find it anywhere...

I couldn't find too, but I found some scripts in python with the new
URL.

>   Also, do you know if yahoo committed to keep
> this api working?

Well, It's not the first time that yahoo change their URL and API,
so...

I adapted the Quote.pm to get the currency from yahoo_json, where the
changes:


diff Quote.pm Quote.pm.orig
=
39d38
< use JSON qw( decode_json );
53c52
< $YAHOO_CURRENCY_URL = "https://query1.finance.yahoo.com/v7/finance/qu
ote?symbols=";
---
> $YAHOO_CURRENCY_URL = "http://finance.yahoo.com/d/quotes.csv?e=.csv
=l1=";
253,254c253,254
<   my $json_result = JSON::decode_json $data;
<   my $exchange_rate = $json_result->{'quoteResponse'}{'result'}[0]-
>{'regularMarketPrice'};
---
>   my $exchange_rate = $data;
> 
==

> best
> --
> erik colson


Rafael Casali

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Credit card online banking setup stopped working

On 11/12/2017 05:25 PM, John Ralls wrote:

On Nov 12, 2017, at 2:13 PM, Chris Szilagyi wrote:

On 11/12/2017 04:02 PM, John Ralls wrote:

On Nov 12, 2017, at 10:36 AM, Chris Szilagyi wrote:

On 11/12/2017 11:01 AM, John Ralls wrote:

On Nov 12, 2017, at 4:38 AM, Chris Szilagyi wrote:

Hello:

Recently our Discover credit card online banking stopped working. It seems to be caused
by our credit card number being changed, I think, as the time it stopped was around the
time they changed it. Originally I went in to the AQBanking setup and just changed the
account # there, and tried to download transactions and get the "no transactions for
the selected time period" message. I then tried deleting the online account in the
AQBanking setup, and re-created it, but still get the same error. I did notice that at
the end of the AQBanking setup wizard where you select the associated GNUCash account,
the GNUCash account has the old credit card # on it under the Account ID column, but I am
not sure if that really matters, I haven't been able to find any way to change the
Account ID. If it doesn't matter anyway, then I'm not concerned with it as long as it
works.

Am I doing this correctly and does anybody have any ideas of something else I
can try? I appreciate the help. Thank you.

Check the download period in the first dialog box that comes up when you select
Actions>Online Actions>Get Transactions. GnuCash resets the “last retrieved
date” to today even when the retrieval is unsuccessful, so on subsequent attempts one
must set the beginning date to the date of the last sucessful retrieval.

The name of the target account doesn’t matter as long as it’s the account you
want to use.

Regards,
John Ralls

I have tried setting the dates to as far back as 6 months, and up to the past
30 days' worth... and still receive the same message. Thank you for clarifying
the account name.

If there is anything else I can try please let me know, thank you!

I trust that you can see the transactions on the website and that you've
re-checked the account number a couple of dozen times by now. Does the
AQBanking log window show anything unexpected?

Yes, I have checked everything over several times. I have tried to find a log
from AQbanking, and I am not sure where exactly it would be located. I've
checked various directories under the ~/.aqbanking folder and am not seeing
anything. I did find a gnucash.trace file in /tmp, it does have the line below:

* 17:02:48 CRIT provider.c: 837: Error exchanging
getStatements-request (403)

This corresponds to the time I tried to download the transactions.

If there's a better log to look at please let me know, thank you for your help!

When you run a download AQBanking puts up a dialog box containing a session log. There's a
checkbox in the lower left to leave it open after the session finishes; it has an inverse
counterpart, "Close log window when finished" in Preferences>Online Banking.
Clear that checkbox then try again to retrieve and see if there are any useful messages in
the log.

Regards,
John Ralls

Ah... got it, thank you. Looks like I'm getting an HTTP 403 error
back. This definitely helps me a lot, thank you. Now I will have to
figure out what Discover has done to their OFX setup.

Connecting to "ofx.discovercard.com"
Connected to "ofx.discovercard.com"
TLS: SSL-Cipher priority list: SECURE256:SECURE128
TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
Connected.
Sending message...
Message sent.
Waiting for response...
Receiving response...
HTTP-Status: 403 (Forbidden)
Error parsing server response
Unlocking user (my username)
Postprocessing jobs
Job Get Transactions: finished
Resetting provider queues
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Finance-Quote 1.45 released!


prl  writes:

> my $suffix = uc($1);

yes, I've already committed it for the next version.

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: gnucash-user Digest, Vol 176, Issue 30


Keith Myers  writes:

> I've had nothing but failed builds ever since I think 1.45. Most of
> the test builds fail with errors. But at least the alphavantage test
> successfully completes.  What I do now is to use the --force and
> --notest options when I upgrade the F:Q module. At least then it
> successfully builds the latest

No tests should fail if you set following environment variable:

  export ONLINE_TEST=0

By default ONLINE_TEST should not be defined, which is basically the
same.  I guess you might have this variable set somewhere?

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Has anyone been able to get F:Q to pull quotes for FT Portfolios symbols?


Keith Myers  writes:

> Thanks for the reply Erik. I kept missing that source way down at the
> bottom of the list a couple of times. Changed to yahoo_json and was able
> to get the FT Portfolios symbols to pull.  But didn't you say that that
> source is questionable for the future?

Yes, but as the symbols doesn't seem to be supported through
alphavantage, I can't offer you another alternative.

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: GnuCash Version 2.6.17 No Longer Downloads Quotes

2017-11-12 Thread Robert L. Kief


Gentlemen:

I'm running Linux Mint 18.1.

I've installed Finance::Quote 1.45 and acquired an ALPHAVANTAGE key.  
I've tested 1.45 by using this string "export 
ALPHAVANTAGE_API_KEY=" in terminal (using my new key, of 
course).  1.45 returns the proper quote information.  I found the 
"environment" file at "etc/gnucash/environment" and added two lines to 
the bottom of that file:


# ALPHAVANTAGE_API_KEY

ALPHAVANTAGE_API_KEY=


Replacing "" with my new key.

I'm unable to download quotes using the GnuCash Price Editor with 
Vanguard as my source.  After a system restart (because it couldn't 
hurt), and changing my source to "T. Rowe Price, US", I am still unable 
to download quotes using the GnuCash Price Editor.  ALPHAVANTAGE isn't 
one of my choices in Security Editor/Source Quote Information.  
Obviously, I'm doing something wrong, but I don't know what.


Any help will certainly be appreciated.

Thank you,

Robert L. Kief

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: gnucash-user Digest, Vol 176, Issue 30

> Lots of output follows, most tests failed:

hmmm... I'm out of ideas for now.  Your Perl is pretty old.  Although it
should be working AFAIK, would you mind upgrading to a recent version ?

best
--
erik colson
I've had nothing but failed builds ever since I think 1.45.  Most of the test 
builds fail with errors.  But at least the alphavantage test successfully 
completes.
What I do now is to use the --force and --notest options when I upgrade the F:Q 
module.  At least then it successfully builds the latest  
   
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re:Has anyone been able to get F:Q to pull quotes for FT Portfolios symbols?

Keith Myers  writes:

> I used to be able to pull quotes for FT Portfolios symbols FOEMJX and
> FDNWFX from Yahoo. I have not been able to get F:Q to pull these
> symbols from either alphavantage, ftportfolios or
> ftportfolios_direct. These are the only securities that I have not
> been able to get the reworked F:Q releases to pull quotes. Has anyone
> else been successful?

both symbols work with yahoo_json on F::Q v1.47.

best
--
erik colson

Thanks for the reply Erik.  I kept missing that source way down at the bottom 
of the list a couple of times.  Changed to yahoo_json and was able to get the 
FT Portfolios symbols to pull.
But didn't you say that that source is questionable for the future?   
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: F::Q changes

> On Nov 12, 2017, at 1:57 PM, Liz  wrote:
> 
> I've put a small piece on the FAQ about this, with the intention that
> the information gets picked up by the search engines.
> I don't actually use F::Q, so could someone with wiki edit privileges
> who understands what has and is happening enlarge on this - perhaps a
> wiki page linked to the FAQ.
> 
> If you could write this, but don't have wiki write privileges, an email
> direct to me will allow me to make the edits.
> 
> We are getting many requests about this, and while it is good to see
> there are so many users, it isn't good to see so many without the
> needed information.
> 

Liz,

I put an item in the FAQ about this a week ago and it's been refined a couple 
of times since: 
https://wiki.gnucash.org/wiki/index.php?title=FAQ=1288=13067=13021#Q:_Why_doesn.27t_online_quoting_work.3F

If you or anyone else can think of ways to improve the search engine indexing 
of it that would be great. In the meantime it covers what your item did in more 
detail so I rolled back your addition.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Credit card online banking setup stopped working


> On Nov 12, 2017, at 2:13 PM, Chris Szilagyi  wrote:
> 
> On 11/12/2017 04:02 PM, John Ralls wrote:
>>> On Nov 12, 2017, at 10:36 AM, Chris Szilagyi  
>>> wrote:
>>> 
>>> On 11/12/2017 11:01 AM, John Ralls wrote:
> On Nov 12, 2017, at 4:38 AM, Chris Szilagyi  
> wrote:
> 
> Hello:
> 
> Recently our Discover credit card online banking stopped working. It 
> seems to be caused by our credit card number being changed, I think, as 
> the time it stopped was around the time they changed it. Originally I 
> went in to the AQBanking setup and just changed the account # there, and 
> tried to download transactions and get the "no transactions for the 
> selected time period" message.  I then tried deleting the online account 
> in the AQBanking setup, and re-created it, but still get the same error.  
> I did notice that at the end of the AQBanking setup wizard where you 
> select the associated GNUCash account, the GNUCash account has the old 
> credit card # on it under the Account ID column, but I am not sure if 
> that really matters, I haven't been able to find any way to change the 
> Account ID.  If it doesn't matter anyway, then I'm not concerned with it 
> as long as it works.
> 
> Am I doing this correctly and does anybody have any ideas of something 
> else I can try?  I appreciate the help.  Thank you.
 Check the download period in the first dialog box that comes up when you 
 select Actions>Online Actions>Get Transactions. GnuCash resets the “last 
 retrieved date” to today even when the retrieval is unsuccessful, so on 
 subsequent attempts one must set the beginning date to the date of the 
 last sucessful retrieval.
 
 The name of the target account doesn’t matter as long as it’s the account 
 you want to use.
 
 Regards,
 John Ralls
 
>>> I have tried setting the dates to as far back as 6 months, and up to the 
>>> past 30 days' worth... and still receive the same message. Thank you for 
>>> clarifying the account name.
>>> 
>>> If there is anything else I can try please let me know, thank you!
>> I trust that you can see the transactions on the website and that you've 
>> re-checked the account number a couple of dozen times by now. Does the 
>> AQBanking log window show anything unexpected?
>> 
> 
> Yes, I have checked everything over several times.  I have tried to find a 
> log from AQbanking, and I am not sure where exactly it would be located.  
> I've checked various directories under the ~/.aqbanking folder and am not 
> seeing anything.  I did find a gnucash.trace file in /tmp, it does have the 
> line below:
> 
> * 17:02:48  CRIT  provider.c:  837: Error exchanging 
> getStatements-request (403)
> 
> This corresponds to the time I tried to download the transactions.
> 
> If there's a better log to look at please let me know, thank you for your 
> help!

When you run a download AQBanking puts up a dialog box containing a session 
log. There's a checkbox in the lower left to leave it open after the session 
finishes; it has an inverse counterpart, "Close log window when finished" in 
Preferences>Online Banking. Clear that checkbox then try again to retrieve and 
see if there are any useful messages in the log.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: F::Q 1.45 AlphaVantage quote failure

Greg Etling  writes:

> I'm on OSX Sierra, and I'd prefer not to try to overlay a new perl if at
> all possible as I've already had to blow away one profile over the years
> due to too much tinkering with perl. I'll take it under consideration, but
> for now I'll just have to leave this broken. Thanks anyway.

It is indeed a wrong idea to mess with system Perl.  You should however
install your own Perl with brew or another tool like that.  Meantime,
I'll try F::Q with perl v5.18 on a test system to see if I can figure
this out.

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Credit card online banking setup stopped working


On 11/12/2017 04:02 PM, John Ralls wrote:

On Nov 12, 2017, at 10:36 AM, Chris Szilagyi  wrote:

On 11/12/2017 11:01 AM, John Ralls wrote:

On Nov 12, 2017, at 4:38 AM, Chris Szilagyi  wrote:

Hello:

Recently our Discover credit card online banking stopped working. It seems to be caused 
by our credit card number being changed, I think, as the time it stopped was around the 
time they changed it. Originally I went in to the AQBanking setup and just changed the 
account # there, and tried to download transactions and get the "no transactions for 
the selected time period" message.  I then tried deleting the online account in the 
AQBanking setup, and re-created it, but still get the same error.  I did notice that at 
the end of the AQBanking setup wizard where you select the associated GNUCash account, 
the GNUCash account has the old credit card # on it under the Account ID column, but I am 
not sure if that really matters, I haven't been able to find any way to change the 
Account ID.  If it doesn't matter anyway, then I'm not concerned with it as long as it 
works.

Am I doing this correctly and does anybody have any ideas of something else I 
can try?  I appreciate the help.  Thank you.

Check the download period in the first dialog box that comes up when you select 
Actions>Online Actions>Get Transactions. GnuCash resets the “last retrieved 
date” to today even when the retrieval is unsuccessful, so on subsequent attempts one 
must set the beginning date to the date of the last sucessful retrieval.

The name of the target account doesn’t matter as long as it’s the account you 
want to use.

Regards,
John Ralls


I have tried setting the dates to as far back as 6 months, and up to the past 
30 days' worth... and still receive the same message. Thank you for clarifying 
the account name.

If there is anything else I can try please let me know, thank you!

I trust that you can see the transactions on the website and that you've 
re-checked the account number a couple of dozen times by now. Does the 
AQBanking log window show anything unexpected?



Yes, I have checked everything over several times.  I have tried to find 
a log from AQbanking, and I am not sure where exactly it would be 
located.  I've checked various directories under the ~/.aqbanking folder 
and am not seeing anything.  I did find a gnucash.trace file in /tmp, it 
does have the line below:


* 17:02:48  CRIT  provider.c:  837: Error exchanging 
getStatements-request (403)


This corresponds to the time I tried to download the transactions.

If there's a better log to look at please let me know, thank you for 
your help!

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: F::Q 1.45 AlphaVantage quote failure

I'm on OSX Sierra, and I'd prefer not to try to overlay a new perl if at
all possible as I've already had to blow away one profile over the years
due to too much tinkering with perl. I'll take it under consideration, but
for now I'll just have to leave this broken. Thanks anyway.

Greg
917-664-0083
http://gregetling.com
--
"The credit belongs to the man who is actually in the arena, whose face is
marred by dust and sweat and blood; who strives valiantly; who errs, who
comes short again and again, because there is no effort without error and
shortcoming" -Theodore Roosevelt

On Sun, Nov 12, 2017 at 4:58 PM, Erik Colson  wrote:

>
> Greg Etling  writes:
>
> > Lots of output follows, most tests failed:
>
> hmmm... I'm out of ideas for now.  Your Perl is pretty old.  Although it
> should be working AFAIK, would you mind upgrading to a recent version ?
>
> best
> --
> erik colson
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: F::Q 1.45 AlphaVantage quote failure


Greg Etling  writes:

> Lots of output follows, most tests failed:

hmmm... I'm out of ideas for now.  Your Perl is pretty old.  Although it
should be working AFAIK, would you mind upgrading to a recent version ?

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

F::Q changes

2017-11-12 Thread Liz

I've put a small piece on the FAQ about this, with the intention that
the information gets picked up by the search engines.
I don't actually use F::Q, so could someone with wiki edit privileges
who understands what has and is happening enlarge on this - perhaps a
wiki page linked to the FAQ.

If you could write this, but don't have wiki write privileges, an email
direct to me will allow me to make the edits.

We are getting many requests about this, and while it is good to see
there are so many users, it isn't good to see so many without the
needed information.


Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Request of help


> On Nov 12, 2017, at 10:57 AM, Ettore Scalese  
> wrote:
> 
> Dear Sirs,
> 
> I am getting an error message from GnuCash, when I am trying to update online 
> shares' prices in my porfolio.
> 
> 
> The message I get is in Italian (I use GnuCash in that language version), and 
> the translation in English would be as follows:
> 
> 
>  *   An unknown error happened while updating the prices of your shares.
> 
> Consequently, the shares' prices are not automatically updated (and I should 
> do it manually).
> 
> I am using:
> 
> 
>  *   MS Windows 10;
>  *   GnuCash 2.6.18;
>  *   when I update Perl and the other software stuff necessary to get online 
> quotes, I see what here below:
> 
> [cid:a187ecea-b88a-4913-bed3-ab7ed04946fa]
> 
> Could you please help?
> 
> Many thanks for your attention and kind regards.

Please read the list archives for the last week. There has been an abundance of 
discussion about this.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Request of help

you need to get yourself an api key on alphavantage.co, set it as an
environment variable and then change the datasource in gnucash to
'alphavantage'.  That seems to be documented somewhere on gnucash
website, check the mailing list archive for the link.
Also upgrade to F::Q v1.46.

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Currency/metals quotes with new f::q 1.45?


listreader  writes:

> On Sun, 12 Nov 2017 17:37:50 +0100
> Erik Colson  wrote:
>
>> listreader  writes:
>>
>> > I am using GnuCash 2.6.16 and Finance-Quote 1.45 (linux).  US stock
>> > quotes work fine for me but I am not getting how to get precious
>> > metals quotes to work through the gnucash frontend.  I think I've
>> > tried every possible combo of settings in gnucash.  Is this
>> > available yet?
>>
>> please check F::Q version 1.47 (untested).
>
> Hello Erik.
>
> 1.47 - No errors but returns the wrong price data, i.e. for gold:
>
> :~> gnc-fq-dump alphavantage XAU
>
> Finance::Quote fields Gnucash uses:
> symbol: XAU  <=== required
>   date: 11/10/2017   <=== recommended
>   currency: USD  <=== required
>   last: 6.5100   <=\

>From the F::Q Examples I get following data:

~/DEVELOPMENT/finance-quote >>> perl -Ilib Examples/currency-lookup.pl XAU USD
XAU->USD = 1275.81939501

and for XAG
~/DEVELOPMENT/finance-quote >>> perl -Ilib Examples/currency-lookup.pl XAG USD
XAG->USD = 16.89097601

Can you check those on your system ?

> On another note: on my system (openSUSE Leap 42.3) AlphaVantage.pm got
> installed with eXecute permissions while all the other .pm have only
> Read permissions.  Was that intended?

nope... Have to check that, but that won't hurt.

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: F::Q 1.45 AlphaVantage quote failure


Greg Etling  writes:

>>   perl -MFinance::Quote -e 'print $Finance::Quote::VERSION'
>>
>
> 1.47
>
>
>> and
>>
>>   perl -v
>>
>
> This is perl 5, version 18, subversion 2 (v5.18.2) built for
> darwin-thread-multi-2level
> (with 2 registered patches, see perl -V for more detail)

That should be OK.
Can you test following lines? also from the same directory.  and post
the returned info.

  export ONLINE_TEST=1
  prove -lvof t/alphavantage.t

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Request of help

2017-11-12 Thread Ettore Scalese

Dear Sirs,

I am getting an error message from GnuCash, when I am trying to update online 
shares' prices in my porfolio.


The message I get is in Italian (I use GnuCash in that language version), and 
the translation in English would be as follows:


  *   An unknown error happened while updating the prices of your shares.

Consequently, the shares' prices are not automatically updated (and I should do 
it manually).

I am using:


  *   MS Windows 10;
  *   GnuCash 2.6.18;
  *   when I update Perl and the other software stuff necessary to get online 
quotes, I see what here below:

[cid:a187ecea-b88a-4913-bed3-ab7ed04946fa]

Could you please help?

Many thanks for your attention and kind regards.

Ettore Scalese
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: F::Q 1.45 AlphaVantage quote failure

On Sun, Nov 12, 2017 at 4:05 PM, Erik Colson  wrote:

>
> Greg Etling  writes:
>
> > Same result when I cd into that directory and run as either:
> > perl -Ilib ~/.cpan/build/Finance-Quote-1.47-IUv7sO/Examples/stockdump.pl
> > alphavantage SCHB
> > or
> > perl -Ilib Examples/stockdump.pl alphavantage SCHB
>
> Well, that is weird...
>
> Can you send the response to following command ?
>
>   perl -MFinance::Quote -e 'print $Finance::Quote::VERSION'
>

1.47


> and
>
>   perl -v
>

This is perl 5, version 18, subversion 2 (v5.18.2) built for
darwin-thread-multi-2level
(with 2 registered patches, see perl -V for more detail)


> best
> --
> erik colson
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: F::Q 1.45 AlphaVantage quote failure


Greg Etling  writes:

> Same result when I cd into that directory and run as either:
> perl -Ilib ~/.cpan/build/Finance-Quote-1.47-IUv7sO/Examples/stockdump.pl
> alphavantage SCHB
> or
> perl -Ilib Examples/stockdump.pl alphavantage SCHB

Well, that is weird...

Can you send the response to following command ?

  perl -MFinance::Quote -e 'print $Finance::Quote::VERSION'

and

  perl -v

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Credit card online banking setup stopped working


> On Nov 12, 2017, at 10:36 AM, Chris Szilagyi  wrote:
> 
> On 11/12/2017 11:01 AM, John Ralls wrote:
>> 
>>> On Nov 12, 2017, at 4:38 AM, Chris Szilagyi  wrote:
>>> 
>>> Hello:
>>> 
>>> Recently our Discover credit card online banking stopped working. It seems 
>>> to be caused by our credit card number being changed, I think, as the time 
>>> it stopped was around the time they changed it. Originally I went in to the 
>>> AQBanking setup and just changed the account # there, and tried to download 
>>> transactions and get the "no transactions for the selected time period" 
>>> message.  I then tried deleting the online account in the AQBanking setup, 
>>> and re-created it, but still get the same error.  I did notice that at the 
>>> end of the AQBanking setup wizard where you select the associated GNUCash 
>>> account, the GNUCash account has the old credit card # on it under the 
>>> Account ID column, but I am not sure if that really matters, I haven't been 
>>> able to find any way to change the Account ID.  If it doesn't matter 
>>> anyway, then I'm not concerned with it as long as it works.
>>> 
>>> Am I doing this correctly and does anybody have any ideas of something else 
>>> I can try?  I appreciate the help.  Thank you.
>> Check the download period in the first dialog box that comes up when you 
>> select Actions>Online Actions>Get Transactions. GnuCash resets the “last 
>> retrieved date” to today even when the retrieval is unsuccessful, so on 
>> subsequent attempts one must set the beginning date to the date of the last 
>> sucessful retrieval.
>> 
>> The name of the target account doesn’t matter as long as it’s the account 
>> you want to use.
>> 
>> Regards,
>> John Ralls
>> 
> 
> I have tried setting the dates to as far back as 6 months, and up to the past 
> 30 days' worth... and still receive the same message. Thank you for 
> clarifying the account name.
> 
> If there is anything else I can try please let me know, thank you!

I trust that you can see the transactions on the website and that you've 
re-checked the account number a couple of dozen times by now. Does the 
AQBanking log window show anything unexpected?

Regards,
John Ralls


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Currency/metals quotes with new f::q 1.45?

On Sun, 12 Nov 2017 17:37:50 +0100
Erik Colson  wrote:

> listreader  writes:
> 
> > I am using GnuCash 2.6.16 and Finance-Quote 1.45 (linux).  US stock
> > quotes work fine for me but I am not getting how to get precious
> > metals quotes to work through the gnucash frontend.  I think I've
> > tried every possible combo of settings in gnucash.  Is this
> > available yet?  
> 
> please check F::Q version 1.47 (untested).

Hello Erik.

1.47 - No errors but returns the wrong price data, i.e. for gold:

:~> gnc-fq-dump alphavantage XAU

Finance::Quote fields Gnucash uses:
symbol: XAU  <=== required
  date: 11/10/2017   <=== recommended
  currency: USD  <=== required
  last: 6.5100   <=\   
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

I'm not sure where it's getting the "6.51" from because the actual data
is:

"Realtime Currency Exchange Rate": 
"1. From_Currency Code": "XAU",
"2. From_Currency Name": "Gold Ounce",
"3. To_Currency Code": "USD",
"4. To_Currency Name": "United States Dollar",
"5. Exchange Rate": "1275.85195014",
"6. Last Refreshed": "2017-11-12 20:31:17",
"7. Time Zone": "UTC"

Likewise, XAG (silver) returns 0.0200 instead of the expected
16.89899689.

On another note: on my system (openSUSE Leap 42.3) AlphaVantage.pm got
installed with eXecute permissions while all the other .pm have only
Read permissions.  Was that intended?

Thanks.

Ralph
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Finance-Quote 1.45 released!


prl  writes:

> Hi, Eric.
>
> Thanks for getting back to me.
>
> I reported in my original email that using tls.ax shows no currency:

you need to uppercase at least the suffix.

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Alphavantage quotes working through F::Q, not through Gnucash

After the release of F:Q 1.47, I was able to update to in on my LInux 
Mint 18.2 and now I am able to update stocks and currencies via Price 
Editor's Get Quotes!


Now waiting for F:Q 1.47 to migrate to my Mac where running the script I 
get FQ is up to date at 1.45.


Three chears for Eric!


On 11/12/2017 11:24 AM, D wrote:


Ok. In terminal, have you set ALPHAVANTAGE_API_KEYusing an export 
command? That must be set *in the terminal session* in order to 
retrieve quotes in terminal.


David

On November 12, 2017, at 10:10 PM, Les  wrote:

>Yes, that is the path I used.  In the terminal, I changed to the path
>you indicated and now that part works but does not return any useful
>data (No price quote, date or currency).
>But progress just the same.  Thanks David.
>On 11/12/2017 08:33 AM, David T. wrote:
>> I’ll assume that you mean 
/Applications/Gnucash.app/Contents/Resources/environment (note the 
lower case ‘e’; case matters in MacOS). If not, then that will be the 
problem.

>>
>> To run gnc-fq-dump, you need to be in 
/Applications/Gnucash.app/Contents/Resources/bin

>>
>> David
>>
>>> On Nov 12, 2017, at 7:10 PM, Les  wrote:
>>>
>>> I added Alphavantage API key to the end of 
/Applications/Gnucash.app/Contents/Resources/Environment, which is 
where I was informed it needed to be.  Is this no correct?

>>>
>>> As for command line, I have tried running changing directories to 
/Applications/Gnucash.app .

>>>
>>>
>>> On 11/12/2017 07:30 AM, David T. wrote:
 My question to both Les and Robert is *which* environment file 
have you updated? ~/.bash_profile, or 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment?


 F::Q will not work in the Mac bundle with Alphavantage if you 
modify ...bash_profile (but will work at the command line), and vice 
versa.


 Les, also, from what folder are you trying to run gnc-fq-dump? 
You need to be inside the Gnucash bundle for it to work.


 David


> On Nov 12, 2017, at 5:32 PM, Les  wrote:
>
> I have had GC installed on my Mac for a very long time, and 
until Yahoo pulled the plug everything worked great!  So, I would have 
to believe that Perl is already in the path.  The only changes I have 
made were to add the Alphavantage key to the end of the environment 
file and updating GC to 2.6.18 after upgrading MacOS to 10.13.

>
> But I will check since I don't recall ever running F:Q in the 
terminal before. How would I check the path?

>
> Thanks,
>
> On 11/12/2017 06:21 AM, Michael Fross wrote:
>> One thing to check is that perl is in the path so GNC can find 
the executable.

>>
>> Michael
>>
>> On Sun, Nov 12, 2017 at 6:09 AM Dave H > wrote:

>>
>> Hi Les,
>>
>> Have you tried running it with the -v (verbose) option to get a
>> bit more
>> information back ?
>>
>> Running F:Q directly in Terminal works OK on MacOS 10.13 
here but only
>> after I first issue a "export 
ALPHAVANTAGE_AKI_KEY="

>> command so you might find that's what is needed when running it
>> directly.
>> Remember the environment file you added the key to is used by
>> GnuCash and
>> presumably passes the api key into F::Q so if you run F:Q 
directly

>> you have
>> to let it know what your api key is ?
>>
>> Cheers Dave H.
>>
>>
>> On 12 November 2017 at 20:28, Les > > wrote:
>>
>> > When I run the same command from my Linux Mint 18.2 I get
>> >
>> > Finance::Quote fields Gnucash uses:
>> > symbol: NYSE:TGT (deduced)   <=== required
>> >   date: ** missing **    <=== recommended
>> >   currency: ** missing **    <=== required
>> > last:  <=\
>> > nav:  <=== one of these
>> > price:  <=/
>> > timezone:  <=== optional
>> >
>> > ** This stock quote cannot be used by GnuCash!
>> >
>> > When I go to Price Editor and run Get Quotes I get a long 
list:

>> "unable to
>> > receive these quotes".
>> >
>> > When I run ./gnc-fq-dump from my MacOS 10.13, I get "no 
such file or
>> > directory".  When I try Get Quotes I get  "There was an 
unknown

>> error while
>> > retrieving the price quotes".
>> >
>> > So, I still have something missing.
>> >
>> > Les
>> >
>> >
>> >
>> > On 11/11/2017 10:21 PM, Robert Shimmin wrote:
>> >
>> >> Curious what I might be doing wrong.
>> >>
>> >> MacOS 10.11.6
>> >> GnuCash 2.6.15

Re: Finance-Quote 1.45 released!

2017-11-12 Thread prl


Hi, Eric.

Thanks for getting back to me.

I reported in my original email that using tls.ax shows no currency:

gnc-fq-dump -valphavantage tls.ax
Finance::Quote fields Gnucash uses:
    symbol: tls.ax   <=== required
  date: 11/09/2017   <=== recommended
*currency: ** missing **    <=== required*
  last: 3.4600   <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!


All fields returned by Finance::Quote for stock tls.ax

stock   field  value
-   -  -
tls.ax  close: 3.4600
tls.ax currency_set_by_fq: 1
tls.ax   date: 11/09/2017
tls.ax   high: 3.4700
tls.ax    isodate: 2017-11-09
tls.ax   last: 3.4600
tls.ax    low: 3.4400
tls.ax method: alphavantage
tls.ax   open: 3.4600
tls.ax    success: 1
tls.ax symbol: tls.ax
tls.ax volume: 22162836

Cheers,
Peter

On 13/11/2017 01:29, Erik Colson wrote:

prl  writes:


F::Q 1.45 seems to be returning the wrong currency (or none) for
Australian Stock Exchange (ASX) stocks.

For example, for Telstra (ASX:TLS), if I run:
gnc-fq-dump alphavantage asx:tls

I get:
currency: USD

Currencies are deduced based on suffix.  So, try TLS.AX instead of
ASX:TLS.  Please report if this solves your issue.

best
--
erik colson



___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Alphavantage Not Showing Up In List Sources

2017-11-12 Thread Dale Alspach

Did you add the line containing your key to /etc/gnucash/environment as
described in the wiki
and restart gnucash?
If so is gnucash actually using the new Finance::Quote package?

I am running linux mint 18.2 and just followed the directions in the wiki.
Alphavantage showed up on the list.
Dale

On Nov 12, 2017 12:32 PM, "Catscrash"  wrote:

> Same issue here... Any ideas?
>
> thanks :-)
>
> Am 11.11.2017 um 00:46 schrieb Jim Sculley:
> > I'm using Linux Mint 18.2, GnuCash 2.6.12 and Finance::Quote 1.45.  I
> > have my API key in place and when testing via gnc-fq-dump everything
> > seems to be working:
> >
> > 
> >
> > jim@clifford ~ $ gnc-fq-dump alphavantage GOOGL
> > Finance::Quote fields Gnucash uses:
> > symbol: GOOGL<=== required
> >   date: 11/10/2017   <=== required
> >   currency: USD  <=== required
> >   last: 1044.1500<=\
> >nav:  <=== one of these
> >  price:  <=/
> >   timezone:  <=== optional
> > ===
> >
> > However, when I try to set up quote retrieval in GnuCash, alphavantage
> > is not listed as a quote source.  When I switch the type of quote
> > source to 'Unknown' as described in the FAQ, the drop down list has
> > only the following 9 entries:
> >
> > adig
> >
> > bet
> >
> > fetch_live_currencies
> >
> > fidelityfixed
> >
> > hufund
> >
> > hungary
> >
> > hustock
> >
> > known_currencies
> >
> > yahoo_yql
> >
> >
> > Using gnc-fq-check, there are many more listed, including alphavantage:
> >
> > 
> >
> > jim@clifford ~ $ gnc-fq-check
> > ("1.45" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia"
> > "asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil"
> > "bse" "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse"
> > "deka" "dutch" "dwsfunds" "europe" "fetch_live_currencies" "fidelity"
> > "fidelity_direct" "fidelityfixed" "financecanada" "finanzpartner"
> > "finland" "fool" "france" "ftfunds" "ftportfolios"
> > "ftportfolios_direct" "fundlibrary" "goldmoney" "greece" "hex" "hu"
> > "hufund" "hungary" "hustock" "indiamutual" "known_currencies"
> > "lerevenu" "maninv" "morningstar" "morningstarjp" "mstaruk" "nasdaq"
> > "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" "sixfunds"
> > "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse"
> > "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp"
> > "tsx" "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds"
> > "vanguard" "vwd" "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil"
> > "yahoo_europe" "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts")
> > 
> >
> > What did I miss?
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: F::Q 1.45 AlphaVantage quote failure

On Sun, Nov 12, 2017 at 1:58 PM, Erik Colson  wrote:

>
> Greg Etling  writes:
>
> > #perl -Ilib ~/.cpan/build/Finance-Quote-1.47-IUv7sO/Examples/stockdump.
> pl
> > alphavantage SCHB
>
> you need to run this command from the directory
> ~/.cpan/build/Finance-Quote-1.47-IUv7sO
>
> otherwise the -Ilib won't use the correct library
>

Same result when I cd into that directory and run as either:
perl -Ilib ~/.cpan/build/Finance-Quote-1.47-IUv7sO/Examples/stockdump.pl
alphavantage SCHB
or
perl -Ilib Examples/stockdump.pl alphavantage SCHB

Greg
917-664-0083
http://gregetling.com
--
"The credit belongs to the man who is actually in the arena, whose face is
marred by dust and sweat and blood; who strives valiantly; who errs, who
comes short again and again, because there is no effort without error and
shortcoming" -Theodore Roosevelt

On Sun, Nov 12, 2017 at 1:58 PM, Erik Colson  wrote:

>
> Greg Etling  writes:
>
> > #perl -Ilib ~/.cpan/build/Finance-Quote-1.47-IUv7sO/Examples/stockdump.
> pl
> > alphavantage SCHB
>
> you need to run this command from the directory
> ~/.cpan/build/Finance-Quote-1.47-IUv7sO
>
> otherwise the -Ilib won't use the correct library
>
> best
> --
> erik colson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Has anyone been able to get F:Q to pull quotes for FT Portfolios symbols?


Keith Myers  writes:

> I used to be able to pull quotes for FT Portfolios symbols FOEMJX and
> FDNWFX from Yahoo. I have not been able to get F:Q to pull these
> symbols from either alphavantage, ftportfolios or
> ftportfolios_direct. These are the only securities that I have not
> been able to get the reworked F:Q releases to pull quotes. Has anyone
> else been successful?

both symbols work with yahoo_json on F::Q v1.47.

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Has anyone been able to get F:Q to pull quotes for FT Portfolios symbols?

I used to be able to pull quotes for FT Portfolios symbols FOEMJX and FDNWFX 
from Yahoo.  I have not been able to get F:Q to pull these symbols from either 
alphavantage, ftportfolios or ftportfolios_direct.  These are the only 
securities that I have not been able to get the reworked F:Q releases to pull 
quotes.  Has anyone else been successful?
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: gnucash-user Digest, Vol 176, Issue 27

2017-11-12 Thread Elmar


On 11/12/2017 01:37 PM, gnucash-user-requ...@gnucash.org wrote:
On Nov 12, 2017, at 4:38 AM, Chris Szilagyi  
wrote:

Hello:

Recently our Discover credit card online banking stopped working.

I have tried setting the dates to as far back as 6 months, and up to the
past 30 days' worth... and still receive the same message. Thank you for
clarifying the account name.

If there is anything else I can try please let me know, thank you!

This seems to be variable.  LGFCU (local government federal credit 
union) has a visa card that aqbanking seems to handle OK, but RBFCU 
(Randolph-Brooks Federal Credit Union) consistently fails the same way 
(no transactions).  Part of the difference seems to be the way the banks 
handle the credit card accounts vs. their checking/savings accounts - 
LGFCU lets you get there directly via the website, while RBFCU generates 
a new page from the account list on the website to a site called 
ezcardinfo.  BTW, IRA accounts - both Roth and regular - also seem to 
fail, but money market accounts held in the same bank succeed.  There 
may be no solution, although while I was running Quicken, they all 
worked OK in that program. - Elmar


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: F::Q 1.45 AlphaVantage quote failure


Greg Etling  writes:

> #perl -Ilib ~/.cpan/build/Finance-Quote-1.47-IUv7sO/Examples/stockdump.pl
> alphavantage SCHB

you need to run this command from the directory 
~/.cpan/build/Finance-Quote-1.47-IUv7sO

otherwise the -Ilib won't use the correct library

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Credit card online banking setup stopped working


On 11/12/2017 11:01 AM, John Ralls wrote:



On Nov 12, 2017, at 4:38 AM, Chris Szilagyi  wrote:

Hello:

Recently our Discover credit card online banking stopped working. It seems to be caused 
by our credit card number being changed, I think, as the time it stopped was around the 
time they changed it. Originally I went in to the AQBanking setup and just changed the 
account # there, and tried to download transactions and get the "no transactions for 
the selected time period" message.  I then tried deleting the online account in the 
AQBanking setup, and re-created it, but still get the same error.  I did notice that at 
the end of the AQBanking setup wizard where you select the associated GNUCash account, 
the GNUCash account has the old credit card # on it under the Account ID column, but I am 
not sure if that really matters, I haven't been able to find any way to change the 
Account ID.  If it doesn't matter anyway, then I'm not concerned with it as long as it 
works.

Am I doing this correctly and does anybody have any ideas of something else I 
can try?  I appreciate the help.  Thank you.

Check the download period in the first dialog box that comes up when you select 
Actions>Online Actions>Get Transactions. GnuCash resets the “last retrieved 
date” to today even when the retrieval is unsuccessful, so on subsequent attempts one 
must set the beginning date to the date of the last sucessful retrieval.

The name of the target account doesn’t matter as long as it’s the account you 
want to use.

Regards,
John Ralls



I have tried setting the dates to as far back as 6 months, and up to the 
past 30 days' worth... and still receive the same message. Thank you for 
clarifying the account name.


If there is anything else I can try please let me know, thank you!
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Alphavantage Not Showing Up In List Sources

2017-11-12 Thread Catscrash

Same issue here... Any ideas?

thanks :-)

Am 11.11.2017 um 00:46 schrieb Jim Sculley:
> I'm using Linux Mint 18.2, GnuCash 2.6.12 and Finance::Quote 1.45.  I
> have my API key in place and when testing via gnc-fq-dump everything
> seems to be working:
>
> 
>
> jim@clifford ~ $ gnc-fq-dump alphavantage GOOGL
> Finance::Quote fields Gnucash uses:
> symbol: GOOGL<=== required
>   date: 11/10/2017   <=== required
>   currency: USD  <=== required
>   last: 1044.1500<=\
>nav:  <=== one of these
>  price:  <=/
>   timezone:  <=== optional
> ===
>
> However, when I try to set up quote retrieval in GnuCash, alphavantage
> is not listed as a quote source.  When I switch the type of quote
> source to 'Unknown' as described in the FAQ, the drop down list has
> only the following 9 entries:
>
> adig
>
> bet
>
> fetch_live_currencies
>
> fidelityfixed
>
> hufund
>
> hungary
>
> hustock
>
> known_currencies
>
> yahoo_yql
>
>
> Using gnc-fq-check, there are many more listed, including alphavantage:
>
> 
>
> jim@clifford ~ $ gnc-fq-check
> ("1.45" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia"
> "asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil"
> "bse" "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse"
> "deka" "dutch" "dwsfunds" "europe" "fetch_live_currencies" "fidelity"
> "fidelity_direct" "fidelityfixed" "financecanada" "finanzpartner"
> "finland" "fool" "france" "ftfunds" "ftportfolios"
> "ftportfolios_direct" "fundlibrary" "goldmoney" "greece" "hex" "hu"
> "hufund" "hungary" "hustock" "indiamutual" "known_currencies"
> "lerevenu" "maninv" "morningstar" "morningstarjp" "mstaruk" "nasdaq"
> "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" "sixfunds"
> "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse"
> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp"
> "tsx" "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds"
> "vanguard" "vwd" "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil"
> "yahoo_europe" "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts")
> 
>
> What did I miss?
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: F::Q 1.45 AlphaVantage quote failure

Erik,

Thanks for the quick reply. The error message is gone with 1.47, although
I'm still unsuccessful in retrieving any quotes from what looks like an
issue on the AlphaVantage site:

#perl /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump
alphavantage SCHB
Finance::Quote fields Gnucash uses:
symbol: SCHB (deduced)   <=== required
  date: ** missing **<=== recommended
  currency: ** missing **<=== required
  last:  <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!

#perl -Ilib ~/.cpan/build/Finance-Quote-1.47-IUv7sO/Examples/stockdump.pl
alphavantage SCHB
$VAR1 = {
  'SCHBsuccess' => 0,
  'SCHBerrormsg' => 'Internal Server Error'
};

Is this the expected behavior/response from Alphavantage when receiving an
"empty" quote?

Greg
917-664-0083
http://gregetling.com
--
"The credit belongs to the man who is actually in the arena, whose face is
marred by dust and sweat and blood; who strives valiantly; who errs, who
comes short again and again, because there is no effort without error and
shortcoming" -Theodore Roosevelt

On Sun, Nov 12, 2017 at 12:43 PM, Erik Colson  wrote:

>
> Greg Etling  writes:
>
> > Commands:
> > export ALPHAVANTAGE_API_KEY=XXX...
> > perl /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v
> > alphavantage SCHB.US
> >
> > Note: same exact behavior happens with 'SCHB' and 'US:SCHB' formulations
> > and other ticker symbols.
> >
> > Output:
> > malformed JSON string, neither array, object, number, string or atom, at
> > character offset 0 (before "Can't connect to www...") at
> > /Library/Perl/5.18/Finance/Quote/AlphaVantage.pm line 138.
> >
> > For reference, line 138:
> > my $json_data = JSON::decode_json $body;
>
> The page returned by alphavantage is sometimes empty.  On my system the
> SCHB works correctly from F::Q.
>
> ~/DEVELOPMENT/finance-quote >>> perl -Ilib Examples/stockdump.pl
> alphavantage SCHB
>
> ±[master]
> $VAR1 = {
>   'SCHBopen' => '62.2500',
>   'SCHBcurrency_set_by_fq' => 1,
>   'SCHBisodate' => '2017-11-10',
>   'SCHBdate' => '11/10/2017',
>   'SCHBvolume' => '234359',
>   'SCHBcurrency' => 'USD',
>   'SCHBlow' => '62.1800',
>   'SCHBsuccess' => 1,
>   'SCHBclose' => '62.3200',
>   'SCHBhigh' => '62.3700',
>   'SCHBsymbol' => 'SCHB',
>   'SCHBmethod' => 'alphavantage',
>   'SCHBlast' => '62.3200'
> };
>
> This is with version 1.47.  Please try with at least 1.46.
>
> best
> --
> erik colson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: F::Q 1.45 AlphaVantage quote failure


Greg Etling  writes:

> Commands:
> export ALPHAVANTAGE_API_KEY=XXX...
> perl /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v
> alphavantage SCHB.US
>
> Note: same exact behavior happens with 'SCHB' and 'US:SCHB' formulations
> and other ticker symbols.
>
> Output:
> malformed JSON string, neither array, object, number, string or atom, at
> character offset 0 (before "Can't connect to www...") at
> /Library/Perl/5.18/Finance/Quote/AlphaVantage.pm line 138.
>
> For reference, line 138:
> my $json_data = JSON::decode_json $body;

The page returned by alphavantage is sometimes empty.  On my system the
SCHB works correctly from F::Q.

~/DEVELOPMENT/finance-quote >>> perl -Ilib Examples/stockdump.pl alphavantage 
SCHB
±[master]
$VAR1 = {
  'SCHBopen' => '62.2500',
  'SCHBcurrency_set_by_fq' => 1,
  'SCHBisodate' => '2017-11-10',
  'SCHBdate' => '11/10/2017',
  'SCHBvolume' => '234359',
  'SCHBcurrency' => 'USD',
  'SCHBlow' => '62.1800',
  'SCHBsuccess' => 1,
  'SCHBclose' => '62.3200',
  'SCHBhigh' => '62.3700',
  'SCHBsymbol' => 'SCHB',
  'SCHBmethod' => 'alphavantage',
  'SCHBlast' => '62.3200'
};

This is with version 1.47.  Please try with at least 1.46.

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

F::Q 1.45 AlphaVantage quote failure

Like many others, I'm trying to get AlphaVantage up and running, but
running into an error I haven't seen discussed yet. I followed the FAQ
instructions (
https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F) to
add an ALPHAVANTAGE_API_KEY to
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment. Prior
to Yahoo deactivation, F::Q worked fine for me.

Software:
OSX Sierra 10.12.6, Finance::Quote 1.45, Gnucash 2.6.18

Commands:
export ALPHAVANTAGE_API_KEY=XXX...
perl /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v
alphavantage SCHB.US

Note: same exact behavior happens with 'SCHB' and 'US:SCHB' formulations
and other ticker symbols.

Output:
malformed JSON string, neither array, object, number, string or atom, at
character offset 0 (before "Can't connect to www...") at
/Library/Perl/5.18/Finance/Quote/AlphaVantage.pm line 138.

For reference, line 138:
my $json_data = JSON::decode_json $body;

Any assistance would be greatly appreciated!

Greg
http://gregetling.com
--
"The credit belongs to the man who is actually in the arena, whose face is
marred by dust and sweat and blood; who strives valiantly; who errs, who
comes short again and again, because there is no effort without error and
shortcoming" -Theodore Roosevelt
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

F::Q 1.45 AlphaVantage quote failure

Like many others, I'm trying to get AlphaVantage up and running, but
running into an error I haven't seen discussed yet. I followed the FAQ
instructions (https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_
online_quoting_work.3F) to add an ALPHAVANTAGE_API_KEY to /
Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment. Prior
to Yahoo deactivation, F::Q worked fine for me.

Software:
OSX Sierra 10.12.6, Finance::Quote 1.45, Gnucash 2.6.18

Commands:
export ALPHAVANTAGE_API_KEY=XXX...
perl /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v
alphavantage SCHB.US

Note: same exact behavior happens with 'SCHB' and 'US:SCHB' formulations
and other ticker symbols.

Output:
malformed JSON string, neither array, object, number, string or atom, at
character offset 0 (before "Can't connect to www...") at
/Library/Perl/5.18/Finance/Quote/AlphaVantage.pm line 138.

For reference, line 138:
my $json_data = JSON::decode_json $body;

Any assistance would be greatly appreciated!
--
Greg
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Alphavantage quotes working through F::Q, not through Gnucash

2017-11-12 Thread D via gnucash-user

Ok. In terminal, have you set ALPHAVANTAGE_API_KEY using an export command? 
That must be set *in the terminal session* in order to retrieve quotes in 
terminal.

David

On November 12, 2017, at 10:10 PM, Les  wrote:

>Yes, that is the path I used.  In the terminal, I changed to the path 
>you indicated and now that part works but does not return any useful 
>data (No price quote, date or currency).
>But progress just the same.  Thanks David.
>On 11/12/2017 08:33 AM, David T. wrote:
>> I’ll assume that you mean 
>> /Applications/Gnucash.app/Contents/Resources/environment (note the lower 
>> case ‘e’; case matters in MacOS). If not, then that will be the problem.
>>
>> To run gnc-fq-dump, you need to be in 
>> /Applications/Gnucash.app/Contents/Resources/bin
>>
>> David
>>
>>> On Nov 12, 2017, at 7:10 PM, Les  wrote:
>>>
>>> I added Alphavantage API key to the end of 
>>> /Applications/Gnucash.app/Contents/Resources/Environment, which is where I 
>>> was informed it needed to be.  Is this no correct?
>>>
>>> As for command line, I have tried running changing directories to 
>>> /Applications/Gnucash.app .
>>>
>>>
>>> On 11/12/2017 07:30 AM, David T. wrote:
 My question to both Les and Robert is *which* environment file have you 
 updated? ~/.bash_profile, or 
 /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment?

 F::Q will not work in the Mac bundle with Alphavantage if you modify 
 ...bash_profile (but will work at the command line), and vice versa.

 Les, also, from what folder are you trying to run gnc-fq-dump? You need to 
 be inside the Gnucash bundle for it to work.

 David


> On Nov 12, 2017, at 5:32 PM, Les  wrote:
>
> I have had GC installed on my Mac for a very long time, and until Yahoo 
> pulled the plug everything worked great!  So, I would have to believe 
> that Perl is already in the path.  The only changes I have made were to 
> add the Alphavantage key to the end of the environment file and updating 
> GC to 2.6.18 after upgrading MacOS to 10.13.
>
> But I will check since I don't recall ever running F:Q in the terminal 
> before. How would I check the path?
>
> Thanks,
>
> On 11/12/2017 06:21 AM, Michael Fross wrote:
>> One thing to check is that perl is in the path so GNC can find the 
>> executable.
>>
>> Michael
>>
>> On Sun, Nov 12, 2017 at 6:09 AM Dave H > > wrote:
>>
>> Hi Les,
>>
>> Have you tried running it with the -v (verbose) option to get a
>> bit more
>> information back ?
>>
>> Running F:Q directly in Terminal works OK on MacOS 10.13 here but 
>>only
>> after I first issue a "export ALPHAVANTAGE_AKI_KEY="
>> command so you might find that's what is needed when running it
>> directly.
>> Remember the environment file you added the key to is used by
>> GnuCash and
>> presumably passes the api key into F::Q so if you run F:Q directly
>> you have
>> to let it know what your api key is ?
>>
>> Cheers Dave H.
>>
>>
>> On 12 November 2017 at 20:28, Les > > wrote:
>>
>> > When I run the same command from my Linux Mint 18.2 I get
>> >
>> > Finance::Quote fields Gnucash uses:
>> > symbol: NYSE:TGT (deduced)   <=== required
>> >   date: ** missing **    <=== recommended
>> >   currency: ** missing **    <=== required
>> >   last:  <=\
>> >    nav:  <=== one of these
>> >  price:  <=/
>> >   timezone:  <=== optional
>> >
>> > ** This stock quote cannot be used by GnuCash!
>> >
>> > When I go to Price Editor and run Get Quotes I get a long list:
>> "unable to
>> > receive these quotes".
>> >
>> > When I run ./gnc-fq-dump from my MacOS 10.13, I get "no such file 
>>or
>> > directory".  When I try Get Quotes I get  "There was an unknown
>> error while
>> > retrieving the price quotes".
>> >
>> > So, I still have something missing.
>> >
>> > Les
>> >
>> >
>> >
>> > On 11/11/2017 10:21 PM, Robert Shimmin wrote:
>> >
>> >> Curious what I might be doing wrong.
>> >>
>> >> MacOS 10.11.6
>> >> GnuCash 2.6.15
>> >> F::Q 1.45
>> >>
>> >> After obtaining an API key, specifying it in the environment
>> file, and
>> >> adjusting each security that uses automatics quotes to get them
>> through

Re: Alphavantage quotes working through F::Q, not through Gnucash


Ok, that works.  Thanks!!


On 11/12/2017 08:43 AM, David Reiser wrote:
If gnucash is even letting you punch the “Get Quotes” button, it 
thinks both perl and finance-quote are installed correctly.


If the environment file you edited is
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment
then it looks to me like you only need the

 ALPHAVANTAGE_API_KEY=

form of the command instead of  ‘export 
ALPHAVANTAGE_API_KEY=’


And you have relaunched gnucash since editing the environment file? 
Environment files only get automatically read once per process lifetime.


If you want to try manually, open the terminal app and type [copy and 
paste works as long as you leave out the leading $]:


$export ALPHAVANTAGE_API_KEY=zzz
$/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump 
alphavantage TGT

Finance::Quote fields Gnucash uses:
  symbol: TGT                  <=== required
    date: 11/10/2017           <=== recommended
currency: USD                  <=== required
    last: 61.4000              <=\
    nav:                      <=== one of these
  price:                      <=/
timezone:                      <=== optional


the ‘$’ is displayed by the Terminal app, not something you type.
Note that your API key is now available for as long as this particular 
terminal window is open, you don’t have to reenter it to try other 
ticker symbols


Using the Up Arrow on the keyboard at a ‘$’ prompt reenters the last 
command (without executing) so you can just edit the ticker symbol 
without having to retype the whole command.

--
Dave Reiser
dbrei...@icloud.com 





On Nov 12, 2017, at 9:10 AM, Les > wrote:


I added Alphavantage API key to the end of 
/Applications/Gnucash.app/Contents/Resources/Environment, which is 
where I was informed it needed to be.  Is this no correct?


As for command line, I have tried running changing directories to 
/Applications/Gnucash.app .







___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Alphavantage quotes working through F::Q, not through Gnucash

Yes, that is the path I used.  In the terminal, I changed to the path 
you indicated and now that part works but does not return any useful 
data (No price quote, date or currency).

But progress just the same.  Thanks David.

On 11/12/2017 08:33 AM, David T. wrote:

I’ll assume that you mean 
/Applications/Gnucash.app/Contents/Resources/environment (note the lower case 
‘e’; case matters in MacOS). If not, then that will be the problem.

To run gnc-fq-dump, you need to be in 
/Applications/Gnucash.app/Contents/Resources/bin

David

On Nov 12, 2017, at 7:10 PM, Les  wrote:

I added Alphavantage API key to the end of 
/Applications/Gnucash.app/Contents/Resources/Environment, which is where I was 
informed it needed to be.  Is this no correct?

As for command line, I have tried running changing directories to 
/Applications/Gnucash.app .

On 11/12/2017 07:30 AM, David T. wrote:

My question to both Les and Robert is *which* environment file have you 
updated? ~/.bash_profile, or 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment?

F::Q will not work in the Mac bundle with Alphavantage if you modify 
...bash_profile (but will work at the command line), and vice versa.

Les, also, from what folder are you trying to run gnc-fq-dump? You need to be 
inside the Gnucash bundle for it to work.

David

On Nov 12, 2017, at 5:32 PM, Les  wrote:

I have had GC installed on my Mac for a very long time, and until Yahoo pulled 
the plug everything worked great!  So, I would have to believe that Perl is 
already in the path.  The only changes I have made were to add the Alphavantage 
key to the end of the environment file and updating GC to 2.6.18 after 
upgrading MacOS to 10.13.

But I will check since I don't recall ever running F:Q in the terminal before. 
How would I check the path?

Thanks,

On 11/12/2017 06:21 AM, Michael Fross wrote:

One thing to check is that perl is in the path so GNC can find the executable.

Michael

On Sun, Nov 12, 2017 at 6:09 AM Dave H > wrote:

Hi Les,

Have you tried running it with the -v (verbose) option to get a
bit more
information back ?

Running F:Q directly in Terminal works OK on MacOS 10.13 here but only
after I first issue a "export ALPHAVANTAGE_AKI_KEY="
command so you might find that's what is needed when running it
directly.
Remember the environment file you added the key to is used by
GnuCash and
presumably passes the api key into F::Q so if you run F:Q directly
you have
to let it know what your api key is ?

Cheers Dave H.

On 12 November 2017 at 20:28, Les > wrote:

> When I run the same command from my Linux Mint 18.2 I get
>
> Finance::Quote fields Gnucash uses:
> symbol: NYSE:TGT (deduced)   <=== required
>   date: ** missing **<=== recommended
>   currency: ** missing **<=== required
>   last:  <=\
>nav:  <=== one of these
>  price:  <=/
>   timezone:  <=== optional
>
> ** This stock quote cannot be used by GnuCash!
>
> When I go to Price Editor and run Get Quotes I get a long list:
"unable to
> receive these quotes".
>
> When I run ./gnc-fq-dump from my MacOS 10.13, I get "no such file or
> directory".  When I try Get Quotes I get  "There was an unknown
error while
> retrieving the price quotes".
>
> So, I still have something missing.
>
> Les
>
>
>
> On 11/11/2017 10:21 PM, Robert Shimmin wrote:
>
>> Curious what I might be doing wrong.
>>
>> MacOS 10.11.6
>> GnuCash 2.6.15
>> F::Q 1.45
>>
>> After obtaining an API key, specifying it in the environment
file, and
>> adjusting each security that uses automatics quotes to get them
through
>> Alphavantage, if I use Price Editor > Get Quotes, I get an
error, "Unable
>> to retrieve quotes for these items: NYSE:TGT, NYSE:DWDP, etc."
(long list
>> of symbols, list extends off the bottom of my screen, maybe
I've set up
>> too
>> many securities for online quoting. If the error message
concludes with
>> whether I'd like to continue anyway with the quotes that could be
>> obtained,
>> the buttons are off the bottom of my screen and I don't
actually get the
>> choice.
>>
>> However, I must have set up things mostly right, because when
testing it
>> from the text helper utility, I'm getting alphavantage data
back from F::Q
>>
>> $ ./gnc-fq-dump alphavantage NYSE:TGT
>> Finance::Quote fields Gnucash uses:
>>symbol: NYSE:TGT
>>date: 11/10/2017
>>currency: USD
>>last: 61.4000
>>nav:
>>

Re: Currency/metals quotes with new f::q 1.45?


listreader  writes:

> I am using GnuCash 2.6.16 and Finance-Quote 1.45 (linux).  US stock
> quotes work fine for me but I am not getting how to get precious metals
> quotes to work through the gnucash frontend.  I think I've tried every
> possible combo of settings in gnucash.  Is this available yet?

please check F::Q version 1.47 (untested).

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: gnc-fq-dump doesn't work for most sources

Brian M. Sutin  writes:

> $ gnc-fq-dump -v vanguard VTSAX
> No results found for stock VTSAX.
>
> $ gnc-fq-dump -v nasdaq ibm
> No results found for stock ibm.
>
> $ gnc-fq-dump -v nyse ATGE
> No results found for stock ATGE.

These won't work ass vanguard, nasdaq and nyse are not supported in the
alphavantage module.  They should however be added in a future
release.. Use alphavantage instead.

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Finance-Quote 1.47 released!

New version 1.47 of Finance-Quote is available with the following changes:

* Use AlphaVantage for currency quotes instead of Yahoo (Mike Alexander)

Authors:
  - Dj Padzensky , PadzNet, Inc.
  - Linas Vepstas 
  - Yannick LE NY 
  - Paul Fenwick 
  - Brent Neal 
  - Volker Stuerzl 
  - Keith Refson 
  - Rob Sessink 
  - Leigh Wedding 
  - Tobias Vancura 
  - James Treacy 
  - Bradley Dean 
  - Erik Colson 
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

F::Q releases 1.46 and 1.47

Hello users,

I released versions 1.46 and 1.47 to cpan.

Version 1.46 is to be considered with increased stability and a modified
yahoo_json module which apparently seems to have moved to a new URL.
The module might stop working soon depending on Yahoo's decision.

Version 1.47 is considered untested.  It adds support for currency
lookup through AlphaVantage and passes the currency.t test and maybe it
won't break other stuff.

If you need currency conversions and feel confident enough, please use
1.47 and report issues to F::Q mailing list or through github issues.
Otherwise use 1.46 and wait for currency issues to be solved.

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Finance-Quote 1.46 released!

New version 1.46 of Finance-Quote is available with the following changes:

* Drop long-obsolete debian directory (Florian Schlichting)
* AlphaVantage:
  - added support for .IL => USD currency and division (Adriano Baldi)
  - graceful error catchup (Mike Alexander)
* Yahoojson:
  - module adapted to new URL and returned json (Rafael Casali)

Authors:
  - Dj Padzensky , PadzNet, Inc.
  - Linas Vepstas 
  - Yannick LE NY 
  - Paul Fenwick 
  - Brent Neal 
  - Volker Stuerzl 
  - Keith Refson 
  - Rob Sessink 
  - Leigh Wedding 
  - Tobias Vancura 
  - James Treacy 
  - Bradley Dean 
  - Erik Colson 
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: gnc-fq-dump doesn't work for most sources

2017-11-12 Thread Derek Atkins

Your /etc/gnucash/environment file does not affect your shell which is why 
gnc-fq-dump isn't working for alphavantage.


-derek
Sent using my mobile device. Please excuse any typos.



On November 12, 2017 10:20:10 AM "Brian M. Sutin"  wrote:


I am unable to get gnc-fq-dump to work on almost everything.  I am running
v1.45 on Ubuntu.  I did get a hit off of TIAA-CREF, so it works in general.

$ gnc-fq-dump -v vanguard VTSAX
No results found for stock VTSAX.

$ gnc-fq-dump -v nasdaq ibm
No results found for stock ibm.

$ gnc-fq-dump -v nyse ATGE
No results found for stock ATGE.

$ gnc-fq-dump -v alphavantage ibm
Finance::Quote fields Gnucash uses:
symbol: ibm (deduced)<=== required
  date: ** missing **<=== recommended
  currency: ** missing **<=== required
  last:  <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!


All fields returned by Finance::Quote for stock ibm

stock   field  value
-   -  -
ibm  errormsg: Expected ALPHAVANTAGE_API_KEY to be set; get an API 
key at https://www.alphavantage.co

ibm  last: **missing**
ibm   nav: **missing**
ibm price: **missing**
ibm   success: 0

I *did* add the alphavantage key to /etc/gnucash/environment:

#<...snip...>
# LANG=nl_BE
# LANGUAGE={LANG}
# added for quote retrieval
ALPHAVANTAGE_API_KEY=O**G

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

gnc-fq-dump doesn't work for most sources

2017-11-12 Thread Brian M. Sutin

I am unable to get gnc-fq-dump to work on almost everything.  I am running
v1.45 on Ubuntu.  I did get a hit off of TIAA-CREF, so it works in general.

$ gnc-fq-dump -v vanguard VTSAX
No results found for stock VTSAX.

$ gnc-fq-dump -v nasdaq ibm
No results found for stock ibm.

$ gnc-fq-dump -v nyse ATGE
No results found for stock ATGE.

$ gnc-fq-dump -v alphavantage ibm
Finance::Quote fields Gnucash uses:
symbol: ibm (deduced)<=== required
  date: ** missing **<=== recommended
  currency: ** missing **<=== required
  last:  <=\   
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!


All fields returned by Finance::Quote for stock ibm

stock   field  value
-   -  -
ibm  errormsg: Expected ALPHAVANTAGE_API_KEY to be set; get an API 
key at https://www.alphavantage.co
ibm  last: **missing**
ibm   nav: **missing**
ibm price: **missing**
ibm   success: 0

I *did* add the alphavantage key to /etc/gnucash/environment:

#<...snip...>
# LANG=nl_BE
# LANGUAGE={LANG}
# added for quote retrieval
ALPHAVANTAGE_API_KEY=O**G

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Finance-Quote 1.45 released!

2017-11-12 Thread Adriano Baldi

Hi Erik

Some example symbol for the suffix .IL

https://finance.yahoo.com/quote/OGZD.IL?p=OGZD.IL
https://finance.yahoo.com/quote/LKOD.IL?p=LKOD.IL
https://finance.yahoo.com/quote/MNOD.IL?p=MNOD.IL
https://finance.yahoo.com/quote/VTBR.IL?p=VTBR.IL

Thanks again.

Best regards 

Adriano Baldi






--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Alphavantage quotes working through F::Q, not through Gnucash

2017-11-12 Thread David Reiser

If gnucash is even letting you punch the “Get Quotes” button, it thinks both 
perl and finance-quote are installed correctly.

If the environment file you edited is
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment
then it looks to me like you only need the 

 ALPHAVANTAGE_API_KEY=

form of the command instead of  ‘export ALPHAVANTAGE_API_KEY=’

And you have relaunched gnucash since editing the environment file? Environment 
files only get automatically read once per process lifetime.

If you want to try manually, open the terminal app and type [copy and paste 
works as long as you leave out the leading $]:

$export ALPHAVANTAGE_API_KEY=zzz
$/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump alphavantage TGT
Finance::Quote fields Gnucash uses:
symbol: TGT  <=== required
  date: 11/10/2017   <=== recommended
  currency: USD  <=== required
  last: 61.4000  <=\   
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

the ‘$’ is displayed by the Terminal app, not something you type.
Note that your API key is now available for as long as this particular terminal 
window is open, you don’t have to reenter it to try other ticker symbols

Using the Up Arrow on the keyboard at a ‘$’ prompt reenters the last command 
(without executing) so you can just edit the ticker symbol without having to 
retype the whole command.
--
Dave Reiser
dbrei...@icloud.com

> On Nov 12, 2017, at 9:10 AM, Les  wrote:
> 
> I added Alphavantage API key to the end of 
> /Applications/Gnucash.app/Contents/Resources/Environment, which is where I 
> was informed it needed to be.  Is this no correct?
> 
> As for command line, I have tried running changing directories to 
> /Applications/Gnucash.app .
> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Alphavantage quotes working through F::Q, not through Gnucash

2017-11-12 Thread David T. via gnucash-user

I’ll assume that you mean 
/Applications/Gnucash.app/Contents/Resources/environment (note the lower case 
‘e’; case matters in MacOS). If not, then that will be the problem.

To run gnc-fq-dump, you need to be in 
/Applications/Gnucash.app/Contents/Resources/bin

David

> On Nov 12, 2017, at 7:10 PM, Les  wrote:
> 
> I added Alphavantage API key to the end of 
> /Applications/Gnucash.app/Contents/Resources/Environment, which is where I 
> was informed it needed to be.  Is this no correct?
> 
> As for command line, I have tried running changing directories to 
> /Applications/Gnucash.app .
> 
> 
> On 11/12/2017 07:30 AM, David T. wrote:
>> My question to both Les and Robert is *which* environment file have you 
>> updated? ~/.bash_profile, or 
>> /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment?
>> 
>> F::Q will not work in the Mac bundle with Alphavantage if you modify 
>> ...bash_profile (but will work at the command line), and vice versa.
>> 
>> Les, also, from what folder are you trying to run gnc-fq-dump? You need to 
>> be inside the Gnucash bundle for it to work.
>> 
>> David
>> 
>> 
>>> On Nov 12, 2017, at 5:32 PM, Les  wrote:
>>> 
>>> I have had GC installed on my Mac for a very long time, and until Yahoo 
>>> pulled the plug everything worked great!  So, I would have to believe that 
>>> Perl is already in the path.  The only changes I have made were to add the 
>>> Alphavantage key to the end of the environment file and updating GC to 
>>> 2.6.18 after upgrading MacOS to 10.13.
>>> 
>>> But I will check since I don't recall ever running F:Q in the terminal 
>>> before. How would I check the path?
>>> 
>>> Thanks,
>>> 
>>> On 11/12/2017 06:21 AM, Michael Fross wrote:
 One thing to check is that perl is in the path so GNC can find the 
 executable.
 
 Michael
 
 On Sun, Nov 12, 2017 at 6:09 AM Dave H > wrote:
 
Hi Les,
 
Have you tried running it with the -v (verbose) option to get a
bit more
information back ?
 
Running F:Q directly in Terminal works OK on MacOS 10.13 here but only
after I first issue a "export ALPHAVANTAGE_AKI_KEY="
command so you might find that's what is needed when running it
directly.
Remember the environment file you added the key to is used by
GnuCash and
presumably passes the api key into F::Q so if you run F:Q directly
you have
to let it know what your api key is ?
 
Cheers Dave H.
 
 
On 12 November 2017 at 20:28, Les > wrote:
 
> When I run the same command from my Linux Mint 18.2 I get
>
> Finance::Quote fields Gnucash uses:
> symbol: NYSE:TGT (deduced)   <=== required
>   date: ** missing **<=== recommended
>   currency: ** missing **<=== required
>   last:  <=\
>nav:  <=== one of these
>  price:  <=/
>   timezone:  <=== optional
>
> ** This stock quote cannot be used by GnuCash!
>
> When I go to Price Editor and run Get Quotes I get a long list:
"unable to
> receive these quotes".
>
> When I run ./gnc-fq-dump from my MacOS 10.13, I get "no such file or
> directory".  When I try Get Quotes I get  "There was an unknown
error while
> retrieving the price quotes".
>
> So, I still have something missing.
>
> Les
>
>
>
> On 11/11/2017 10:21 PM, Robert Shimmin wrote:
>
>> Curious what I might be doing wrong.
>>
>> MacOS 10.11.6
>> GnuCash 2.6.15
>> F::Q 1.45
>>
>> After obtaining an API key, specifying it in the environment
file, and
>> adjusting each security that uses automatics quotes to get them
through
>> Alphavantage, if I use Price Editor > Get Quotes, I get an
error, "Unable
>> to retrieve quotes for these items: NYSE:TGT, NYSE:DWDP, etc."
(long list
>> of symbols, list extends off the bottom of my screen, maybe
I've set up
>> too
>> many securities for online quoting. If the error message
concludes with
>> whether I'd like to continue anyway with the quotes that could be
>> obtained,
>> the buttons are off the bottom of my screen and I don't
actually get the
>> choice.
>>
>> However, I must have set up things mostly right, because when
testing it
>> from the text helper utility, I'm getting alphavantage data
back from F::Q

Re: Finance-Quote 1.45 released!


Adriano  writes:

> Hello Erik
>
> Sorry for my English, I am Italian.
>
> As always you did a great job!
> And with a speed that does not allow me to compete ;-).

thx!

> I'm following stock markets in the USA, Canada TSX and TSXV, Milan, London,
> Oslo, Copenhagen and I can confirm that version 1.45 works very fine, even
> for London with the division for 100.
> For me I miss the (.IL)  market in London, quoted in USD / 100.
> So I made a dirty edit to your work and for me it works fine.

Can you provide an example symbol for the suffix .IL ?

[..]

> > I think changing Currencies.pm for using AlphaVantage can be solve the
> problem.
> By accident, are you already working on this?
> I asking you because you always beat me in speed and quality ;-)).

There is already a pull-request on github which I have to check out.
Hopefully I can work on this very soon :)

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Finance-Quote 1.45 released!


prl  writes:

> F::Q 1.45 seems to be returning the wrong currency (or none) for
> Australian Stock Exchange (ASX) stocks.
>
> For example, for Telstra (ASX:TLS), if I run:
> gnc-fq-dump alphavantage asx:tls
>
> I get:
> currency: USD

Currencies are deduced based on suffix.  So, try TLS.AX instead of
ASX:TLS.  Please report if this solves your issue.

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Alphavantage quotes working through F::Q, not through Gnucash

I added Alphavantage API key to the end of 
/Applications/Gnucash.app/Contents/Resources/Environment, which is where 
I was informed it needed to be.  Is this no correct?

As for command line, I have tried running changing directories to 
/Applications/Gnucash.app .

On 11/12/2017 07:30 AM, David T. wrote:

My question to both Les and Robert is *which* environment file have you 
updated? ~/.bash_profile, or 
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment?

F::Q will not work in the Mac bundle with Alphavantage if you modify 
..bash_profile (but will work at the command line), and vice versa.

Les, also, from what folder are you trying to run gnc-fq-dump? You need to be 
inside the Gnucash bundle for it to work.

David

On Nov 12, 2017, at 5:32 PM, Les  wrote:

I have had GC installed on my Mac for a very long time, and until Yahoo pulled 
the plug everything worked great!  So, I would have to believe that Perl is 
already in the path.  The only changes I have made were to add the Alphavantage 
key to the end of the environment file and updating GC to 2.6.18 after 
upgrading MacOS to 10.13.

But I will check since I don't recall ever running F:Q in the terminal before. 
How would I check the path?

Thanks,

On 11/12/2017 06:21 AM, Michael Fross wrote:

One thing to check is that perl is in the path so GNC can find the executable.

Michael

On Sun, Nov 12, 2017 at 6:09 AM Dave H > wrote:

Hi Les,

Have you tried running it with the -v (verbose) option to get a
bit more
information back ?

Running F:Q directly in Terminal works OK on MacOS 10.13 here but only
after I first issue a "export ALPHAVANTAGE_AKI_KEY="
command so you might find that's what is needed when running it
directly.
Remember the environment file you added the key to is used by
GnuCash and
presumably passes the api key into F::Q so if you run F:Q directly
you have
to let it know what your api key is ?

Cheers Dave H.

On 12 November 2017 at 20:28, Les > wrote:

> When I run the same command from my Linux Mint 18.2 I get
>
> Finance::Quote fields Gnucash uses:
> symbol: NYSE:TGT (deduced)   <=== required
>   date: ** missing **<=== recommended
>   currency: ** missing **<=== required
>   last:  <=\
>nav:  <=== one of these
>  price:  <=/
>   timezone:  <=== optional
>
> ** This stock quote cannot be used by GnuCash!
>
> When I go to Price Editor and run Get Quotes I get a long list:
"unable to
> receive these quotes".
>
> When I run ./gnc-fq-dump from my MacOS 10.13, I get "no such file or
> directory".  When I try Get Quotes I get  "There was an unknown
error while
> retrieving the price quotes".
>
> So, I still have something missing.
>
> Les
>
>
>
> On 11/11/2017 10:21 PM, Robert Shimmin wrote:
>
>> Curious what I might be doing wrong.
>>
>> MacOS 10.11.6
>> GnuCash 2.6.15
>> F::Q 1.45
>>
>> After obtaining an API key, specifying it in the environment
file, and
>> adjusting each security that uses automatics quotes to get them
through
>> Alphavantage, if I use Price Editor > Get Quotes, I get an
error, "Unable
>> to retrieve quotes for these items: NYSE:TGT, NYSE:DWDP, etc."
(long list
>> of symbols, list extends off the bottom of my screen, maybe
I've set up
>> too
>> many securities for online quoting. If the error message
concludes with
>> whether I'd like to continue anyway with the quotes that could be
>> obtained,
>> the buttons are off the bottom of my screen and I don't
actually get the
>> choice.
>>
>> However, I must have set up things mostly right, because when
testing it
>> from the text helper utility, I'm getting alphavantage data
back from F::Q
>>
>> $ ./gnc-fq-dump alphavantage NYSE:TGT
>> Finance::Quote fields Gnucash uses:
>>symbol: NYSE:TGT
>>date: 11/10/2017
>>currency: USD
>>last: 61.4000
>>nav:
>>price:
>>timezone:
>>
>> Any thoughts as to what I'm doing wrong? Is there a practical
limit to how
>> many securities can use online quoting through alphavantage?
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org 
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
> ___

Re: Finance-Quote 1.44 released!


Cam Ellison  writes:

> For anyone who has been following this thread, and especially for Erik:
>
> The problem turned out to be a couple of stocks that I no longer hold
> but are still in the table for historical reasons, whose quote
> assignments were incorrect. All good now.
>
> Thank you again, Erik, for your patience,

Hi Cam,

thx for reporting!

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Credit card online banking setup stopped working


Hello:

Recently our Discover credit card online banking stopped working. It 
seems to be caused by our credit card number being changed, I think, as 
the time it stopped was around the time they changed it. Originally I 
went in to the AQBanking setup and just changed the account # there, and 
tried to download transactions and get the "no transactions for the 
selected time period" message.  I then tried deleting the online account 
in the AQBanking setup, and re-created it, but still get the same 
error.  I did notice that at the end of the AQBanking setup wizard where 
you select the associated GNUCash account, the GNUCash account has the 
old credit card # on it under the Account ID column, but I am not sure 
if that really matters, I haven't been able to find any way to change 
the Account ID.  If it doesn't matter anyway, then I'm not concerned 
with it as long as it works.


Am I doing this correctly and does anybody have any ideas of something 
else I can try?  I appreciate the help.  Thank you.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Alphavantage quotes working through F::Q, not through Gnucash

I have had GC installed on my Mac for a very long time, and until Yahoo 
pulled the plug everything worked great!  So, I would have to believe 
that Perl is already in the path.  The only changes I have made were to 
add the Alphavantage key to the end of the environment file and updating 
GC to 2.6.18 after upgrading MacOS to 10.13.


But I will check since I don't recall ever running F:Q in the terminal 
before. How would I check the path?


Thanks,

On 11/12/2017 06:21 AM, Michael Fross wrote:
One thing to check is that perl is in the path so GNC can find the 
executable.


Michael

On Sun, Nov 12, 2017 at 6:09 AM Dave H > wrote:


Hi Les,

Have you tried running it with the -v (verbose) option to get a
bit more
information back ?

Running F:Q directly in Terminal works OK on MacOS 10.13 here but only
after I first issue a "export ALPHAVANTAGE_AKI_KEY="
command so you might find that's what is needed when running it
directly.
Remember the environment file you added the key to is used by
GnuCash and
presumably passes the api key into F::Q so if you run F:Q directly
you have
to let it know what your api key is ?

Cheers Dave H.


On 12 November 2017 at 20:28, Les > wrote:

> When I run the same command from my Linux Mint 18.2 I get
>
> Finance::Quote fields Gnucash uses:
>     symbol: NYSE:TGT (deduced)   <=== required
>       date: ** missing **        <=== recommended
>   currency: ** missing **        <=== required
>       last:                      <=\
>        nav:                      <=== one of these
>      price:                      <=/
>   timezone:                      <=== optional
>
> ** This stock quote cannot be used by GnuCash!
>
> When I go to Price Editor and run Get Quotes I get a long list:
"unable to
> receive these quotes".
>
> When I run ./gnc-fq-dump from my MacOS 10.13, I get "no such file or
> directory".  When I try Get Quotes I get  "There was an unknown
error while
> retrieving the price quotes".
>
> So, I still have something missing.
>
> Les
>
>
>
> On 11/11/2017 10:21 PM, Robert Shimmin wrote:
>
>> Curious what I might be doing wrong.
>>
>> MacOS 10.11.6
>> GnuCash 2.6.15
>> F::Q 1.45
>>
>> After obtaining an API key, specifying it in the environment
file, and
>> adjusting each security that uses automatics quotes to get them
through
>> Alphavantage, if I use Price Editor > Get Quotes, I get an
error, "Unable
>> to retrieve quotes for these items: NYSE:TGT, NYSE:DWDP, etc."
(long list
>> of symbols, list extends off the bottom of my screen, maybe
I've set up
>> too
>> many securities for online quoting. If the error message
concludes with
>> whether I'd like to continue anyway with the quotes that could be
>> obtained,
>> the buttons are off the bottom of my screen and I don't
actually get the
>> choice.
>>
>> However, I must have set up things mostly right, because when
testing it
>> from the text helper utility, I'm getting alphavantage data
back from F::Q
>>
>> $ ./gnc-fq-dump alphavantage NYSE:TGT
>> Finance::Quote fields Gnucash uses:
>>    symbol: NYSE:TGT
>>    date: 11/10/2017
>>    currency: USD
>>    last: 61.4000
>>    nav:
>>    price:
>>    timezone:
>>
>> Any thoughts as to what I'm doing wrong? Is there a practical
limit to how
>> many securities can use online quoting through alphavantage?
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org 
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org 
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org 
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this

Re: Alphavantage quotes working through F::Q, not through Gnucash

I did an export and tried running F:Q in the terminal with the -v and 
still get "no such file or directory".




On 11/12/2017 05:08 AM, Dave H wrote:

Hi Les,

Have you tried running it with the -v (verbose) option to get a bit 
more information back ?


Running F:Q directly in Terminal works OK on MacOS 10.13 here but only 
after I first issue a "export ALPHAVANTAGE_AKI_KEY=" 
command so you might find that's what is needed when running it 
directly.  Remember the environment file you added the key to is used 
by GnuCash and presumably passes the api key into F::Q so if you run 
F:Q directly you have to let it know what your api key is ?


Cheers Dave H.


On 12 November 2017 at 20:28, Les > wrote:


When I run the same command from my Linux Mint 18.2 I get

Finance::Quote fields Gnucash uses:
    symbol: NYSE:TGT (deduced)   <=== required
  date: ** missing **    <=== recommended
  currency: ** missing **    <=== required
  last:  <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!

When I go to Price Editor and run Get Quotes I get a long list:
"unable to receive these quotes".

When I run ./gnc-fq-dump from my MacOS 10.13, I get "no such file
or directory".  When I try Get Quotes I get  "There was an unknown
error while retrieving the price quotes".

So, I still have something missing.

Les



On 11/11/2017 10:21 PM, Robert Shimmin wrote:

Curious what I might be doing wrong.

MacOS 10.11.6
GnuCash 2.6.15
F::Q 1.45

After obtaining an API key, specifying it in the environment
file, and
adjusting each security that uses automatics quotes to get
them through
Alphavantage, if I use Price Editor > Get Quotes, I get an
error, "Unable
to retrieve quotes for these items: NYSE:TGT, NYSE:DWDP, etc."
(long list
of symbols, list extends off the bottom of my screen, maybe
I've set up too
many securities for online quoting. If the error message
concludes with
whether I'd like to continue anyway with the quotes that could
be obtained,
the buttons are off the bottom of my screen and I don't
actually get the
choice.

However, I must have set up things mostly right, because when
testing it
from the text helper utility, I'm getting alphavantage data
back from F::Q

$ ./gnc-fq-dump alphavantage NYSE:TGT
Finance::Quote fields Gnucash uses:
   symbol: NYSE:TGT
   date: 11/10/2017
   currency: USD
   last: 61.4000
   nav:
   price:
   timezone:

Any thoughts as to what I'm doing wrong? Is there a practical
limit to how
many securities can use online quoting through alphavantage?
___
gnucash-user mailing list
gnucash-user@gnucash.org 
https://lists.gnucash.org/mailman/listinfo/gnucash-user

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


___
gnucash-user mailing list
gnucash-user@gnucash.org 
https://lists.gnucash.org/mailman/listinfo/gnucash-user

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




___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Alphavantage quotes working through F::Q, not through Gnucash

2017-11-12 Thread Michael Fross

One thing to check is that perl is in the path so GNC can find the
executable.

Michael

On Sun, Nov 12, 2017 at 6:09 AM Dave H  wrote:

> Hi Les,
>
> Have you tried running it with the -v (verbose) option to get a bit more
> information back ?
>
> Running F:Q directly in Terminal works OK on MacOS 10.13 here but only
> after I first issue a "export ALPHAVANTAGE_AKI_KEY="
> command so you might find that's what is needed when running it directly.
> Remember the environment file you added the key to is used by GnuCash and
> presumably passes the api key into F::Q so if you run F:Q directly you have
> to let it know what your api key is ?
>
> Cheers Dave H.
>
>
> On 12 November 2017 at 20:28, Les  wrote:
>
> > When I run the same command from my Linux Mint 18.2 I get
> >
> > Finance::Quote fields Gnucash uses:
> > symbol: NYSE:TGT (deduced)   <=== required
> >   date: ** missing **<=== recommended
> >   currency: ** missing **<=== required
> >   last:  <=\
> >nav:  <=== one of these
> >  price:  <=/
> >   timezone:  <=== optional
> >
> > ** This stock quote cannot be used by GnuCash!
> >
> > When I go to Price Editor and run Get Quotes I get a long list: "unable
> to
> > receive these quotes".
> >
> > When I run ./gnc-fq-dump from my MacOS 10.13, I get "no such file or
> > directory".  When I try Get Quotes I get  "There was an unknown error
> while
> > retrieving the price quotes".
> >
> > So, I still have something missing.
> >
> > Les
> >
> >
> >
> > On 11/11/2017 10:21 PM, Robert Shimmin wrote:
> >
> >> Curious what I might be doing wrong.
> >>
> >> MacOS 10.11.6
> >> GnuCash 2.6.15
> >> F::Q 1.45
> >>
> >> After obtaining an API key, specifying it in the environment file, and
> >> adjusting each security that uses automatics quotes to get them through
> >> Alphavantage, if I use Price Editor > Get Quotes, I get an error,
> "Unable
> >> to retrieve quotes for these items: NYSE:TGT, NYSE:DWDP, etc." (long
> list
> >> of symbols, list extends off the bottom of my screen, maybe I've set up
> >> too
> >> many securities for online quoting. If the error message concludes with
> >> whether I'd like to continue anyway with the quotes that could be
> >> obtained,
> >> the buttons are off the bottom of my screen and I don't actually get the
> >> choice.
> >>
> >> However, I must have set up things mostly right, because when testing it
> >> from the text helper utility, I'm getting alphavantage data back from
> F::Q
> >>
> >> $ ./gnc-fq-dump alphavantage NYSE:TGT
> >> Finance::Quote fields Gnucash uses:
> >>symbol: NYSE:TGT
> >>date: 11/10/2017
> >>currency: USD
> >>last: 61.4000
> >>nav:
> >>price:
> >>timezone:
> >>
> >> Any thoughts as to what I'm doing wrong? Is there a practical limit to
> how
> >> many securities can use online quoting through alphavantage?
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >>
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Alphavantage quotes working through F::Q, not through Gnucash

2017-11-12 Thread Dave H

Hi Les,

Have you tried running it with the -v (verbose) option to get a bit more
information back ?

Running F:Q directly in Terminal works OK on MacOS 10.13 here but only
after I first issue a "export ALPHAVANTAGE_AKI_KEY="
command so you might find that's what is needed when running it directly.
Remember the environment file you added the key to is used by GnuCash and
presumably passes the api key into F::Q so if you run F:Q directly you have
to let it know what your api key is ?

Cheers Dave H.


On 12 November 2017 at 20:28, Les  wrote:

> When I run the same command from my Linux Mint 18.2 I get
>
> Finance::Quote fields Gnucash uses:
> symbol: NYSE:TGT (deduced)   <=== required
>   date: ** missing **<=== recommended
>   currency: ** missing **<=== required
>   last:  <=\
>nav:  <=== one of these
>  price:  <=/
>   timezone:  <=== optional
>
> ** This stock quote cannot be used by GnuCash!
>
> When I go to Price Editor and run Get Quotes I get a long list: "unable to
> receive these quotes".
>
> When I run ./gnc-fq-dump from my MacOS 10.13, I get "no such file or
> directory".  When I try Get Quotes I get  "There was an unknown error while
> retrieving the price quotes".
>
> So, I still have something missing.
>
> Les
>
>
>
> On 11/11/2017 10:21 PM, Robert Shimmin wrote:
>
>> Curious what I might be doing wrong.
>>
>> MacOS 10.11.6
>> GnuCash 2.6.15
>> F::Q 1.45
>>
>> After obtaining an API key, specifying it in the environment file, and
>> adjusting each security that uses automatics quotes to get them through
>> Alphavantage, if I use Price Editor > Get Quotes, I get an error, "Unable
>> to retrieve quotes for these items: NYSE:TGT, NYSE:DWDP, etc." (long list
>> of symbols, list extends off the bottom of my screen, maybe I've set up
>> too
>> many securities for online quoting. If the error message concludes with
>> whether I'd like to continue anyway with the quotes that could be
>> obtained,
>> the buttons are off the bottom of my screen and I don't actually get the
>> choice.
>>
>> However, I must have set up things mostly right, because when testing it
>> from the text helper utility, I'm getting alphavantage data back from F::Q
>>
>> $ ./gnc-fq-dump alphavantage NYSE:TGT
>> Finance::Quote fields Gnucash uses:
>>symbol: NYSE:TGT
>>date: 11/10/2017
>>currency: USD
>>last: 61.4000
>>nav:
>>price:
>>timezone:
>>
>> Any thoughts as to what I'm doing wrong? Is there a practical limit to how
>> many securities can use online quoting through alphavantage?
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Alphavantage quotes working through F::Q, not through Gnucash